后台开发时,涉及到多个数据库的调用,遇到一个很妖的问题,更新数据时会把主键自动变成0;
原因是查询的时候是通过 getBy键名(值) 的方式查询数据,此键值不是主键的原因,更新数据时就出现了这个问题
解决方案:查询时要通过where查询或通过主键查询
有问题的写法:
可能会导致id变成0
$openid = $this->request->param('openid'); //openid不是主键
//调用多数据库的方法,具体请看我的另一篇博客
$db = Base::team();
$table = $this->request->param('table');
$result = $db->table($table)->getByOpenid($openid);
$id = $result['id']
$data['pick'] = $result['pick'];
$data['spread'] = $result['spread'];
$data['speak'] = $result['speak'];
$data['contest'] = $result['contest'];
$db->table($table)->where('id',$id)->update($data);
查询时要通过where查询或通过主键查询
$openid = $this->request->param('openid'); //openid不是主键
$db = Base::team();
$table = $this->request->param('table');
$result = $db->table($table)->where('openid',$openid)->select();
$id = $result[0]['id']
$data['pick'] = $result[0]['pick'];
$data['spread'] = $result[0]['spread'];
$data['speak'] = $result[0]['speak'];
$data['contest'] = $result[0]['contest'];
$db->table($table)->where('id',$id)->update($data);
调用其他数据库做select()查询时只能触发第一条查询,后面的触发不了,所以要多条一起查
//多个id
$db->table($table->where('id','in',"1,3,7")->select();