Welcome Guest, Not a member yet? Register   Sign In
query builder class update
#1

(This post was last modified: 11-16-2020, 09:24 AM by richb201.)

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? 
proof that an old dog can learn new tricks
Reply
#2

(This post was last modified: 11-16-2020, 12:31 PM by InsiteFX.)

Try using this afterward to see what the query looks like.

PHP Code:
echo $this->db->getLastQuery();
exit(); 
What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )
Reply




Theme © iAndrew 2016 - Forum software by © MyBB