+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=11)
+--- Thread: query builder class update (/showthread.php?tid=77993)
query builder class update - richb201 - 11-16-2020
I am having a problem with the code below which uses the query builder class.
$userid=(string) $result->successResponse->user->id;
$this->db->set('fusion_userid', $userid);
$this->db->where('email', $email);
$this->db->update('employees');
I have checked the $email and the $userid and they appear fine. But after the update (which has no error code) I look at the mysql table and the $fusion_userid field is blank. I looked in the log but don't see anything wrong.
Any idea how to solve this?
RE: query builder class update - InsiteFX - 11-16-2020
Try using this afterward to see what the query looks like.
PHP Code:
echo $this->db->getLastQuery();
exit();