thinkphp分割逗号读取数据库值

[lidaoying]

Config表的actions2字段里按逗号隔开0，0，0，0，0，0，0，0....

我想把数据保存到指定0中，比如我想把user3的值保存到actions2字段的第二个0中；

$data['actions2'][1] = I('post.user3');

//var_dump($datadb1);die; 我VAR出来的结果是array(1) { ["actions2"]=> array(1) { [1]=> string(5) "46800" } }


M('accounts')->where(array('id' => 1 ))->save($data);

这样老是保存不了,求求指导

[wodebaobei12611]

<?php
$action2 = M('accounts')->where(array('id' => 1 ))->getfield('action2');

$user3 = I('post.user3');

$action2_arr = explode(",", $action2);//转换为数组

$action2_arr[1] = $user3;//将第二个0替换为$user3

$action2 = implode(",", $action2_arr);//转化为字符串 以“,”隔开

$data['action2'] = $action2;

M('accounts')->where(array('id' => 1 ))->save($data);
?>

[果酱很好吃]

你这样保存的 actions2 字段是个数组，怎么可能保存得起呢，它应该是个字符串格式才对 你应该这样 $actions2 = '0,0,0,0,0,0,0'; $tmpactions2 = explode(',',$actions2); $tmpactions2[1] = 46800; $data['actions2'] = join(',',$tmpactions2);