Question

thinkphp在数据库中增加和修改失败

<?phpnamespace Home\Controller;use Think\Controller;class IndexController extends Controller {public function index(){ $Users=D("users"); $attr=$Users->select(); $this->assign("canshu",$attr); $this->display(); dump($Users->select()); } function delete($user_id) { $Users=D("Users"); $r=$Users->delete($user_id); if($r) { $this->success("删除成功",U("index")); } else { $this->error("删除失败"); } } function insert(){ $Users = D('Users'); if($Users->create()) { $result = $Users->add(); if($result) { $this->success("数据添加成功！",U("index")); }else{ $this->error('数据添加错误！'); } }else{ $this->error($Users->getError()); } } function edit($id=0){ $Users = M('Users'); $this->assign('vo',$Users->find($user_id)); $this->display(); } function update(){ $Users = D('Users'); if($Users->create()) { $result = $Users->save(); if($result) { $this->success('操作成功！',U("index")); }else{ $this->error('写入错误！'); } }else{ $this->error($Users->getError()); } }}





Answer 1

你是要将查询出的数据中为空的字段补充信息，这样可能有好几个空字段，所以理想的方法是先找出需要更新的字段，最后再一次性更新。

foreach($arr[0] as $k => $val){ $data['id'] = $arr[0]['id']; if($val == null) $data[$k] = '写入这句'; $m->save($data); }

Answer 2

代码好好贴大兄弟