+- 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=77992)
query builder class update - richb201 - 11-16-2020
I am also 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.
Any idea how to solve thid?
RE: query builder class update - php_rocs - 11-17-2020
@richb201,
What version of CI are you using? Also, did you check to see what the generated SQL looks like?
RE: query builder class update - richb201 - 11-17-2020
thanks php. I solved this. How? Well, I do about a thousand of trial and error attempts and it just went away. Not the best way to work.
RE: query builder class update - InsiteFX - 11-17-2020
If you solved it then please write [SOLVED] in your topic title.