Question

菜鸟请教PHP写入数据库\问题！!

$str = '{"abc":[{"id":1,"exp":45},{"id":2,"exp":0},{"id":3,"exp":100}]}';
$arr = json_decode($str,true);
foreach ($arr['aaa'] as $key => $value)
{
if ($value['id'] == $_REQUEST['id']){
$_SGLOBAL['db']->query( "UPDATE ".tname( "plug_a" )." set abc= where uid=".$_SGLOBAL['supe_uid'] );
}
}

目前格式如上，

如果我想在abc字段内容的id为$_REQUEST['id']

的exp + 10的话，以上面的PHP代码改如何写？

Answer 1

$str = '{"abc":[{"id":1,"exp":45},{"id":2,"exp":0},{"id":3,"exp":100}]}';
$arr = json_decode($str,true);
foreach ($arr['abc'] as $key => $value)
{
if ($value['id'] == $_REQUEST['id']) $arr['abc'][$key]['exp']+=10;
}