Home
Forums
Members
Search
Help
New topics
Todays topics
Website
Welcome Guest, Not a member yet?
Register
Sign In
Login
Username:
Password:
Remember me
Lost Password?
CodeIgniter Forums
Using CodeIgniter
Libraries & Helpers
query builder class update
Share on Google
Share on Facebook
Share on Twitter
View a Printable Version
Subscribe to this thread
Add Poll to this thread
Send thread to a friend
Linear Mode
Threaded Mode
query builder class update
richb201
Posting Freak
Posts:
1,004
Threads:
300
Joined:
Sep 2017
Reputation:
0
#1
11-16-2020, 09:22 AM
(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
InsiteFX
Super Moderator
Posts:
6,334
Threads:
291
Joined:
Oct 2014
Reputation:
235
#2
11-16-2020, 12:30 PM
(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?
W
hat did you Expect?
Joined CodeIgniter Community 2009. ( Skype: insitfx )
Reply
--------------------
Private Messages
User Control Panel
Who's Online
Search
Forum Home
General
-- News & Discussion
-- Events
-- Lounge
-- Regional User Groups
Using CodeIgniter
-- Installation & Setup
-- Model-View-Controller
-- Libraries & Helpers
-- Best Practices
-- Choosing CodeIgniter
-- General Help
CodeIgniter 4
-- CodeIgniter 4 Roadmap
-- CodeIgniter 4 Development
-- CodeIgniter 4 Feature Requests
-- CodeIgniter 4 Support
-- CodeIgniter 4 Discussion
-- CodeIgniter 4 Addins
Development
-- CodeIgniter 3.x
-- CodeIgniter 2.x
-- Issues
-- NetBeans Plugin
External Resources
-- Spotlight
-- Learn More
-- Jobs
-- Addins
Archived Discussions
-- Archived Libraries & Helpers
-- Archived Development & Programming
Theme © iAndrew 2016 -
Forum software by © MyBB