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:20 AM
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?
proof that an old dog can learn new tricks
Reply
php_rocs
Administrator
Posts:
1,416
Threads:
104
Joined:
Jun 2016
Reputation:
73
#2
11-17-2020, 06:26 AM
@
richb201
,
What version of CI are you using? Also, did you check to see what the generated SQL looks like?
Reply
richb201
Posting Freak
Posts:
1,004
Threads:
300
Joined:
Sep 2017
Reputation:
0
#3
11-17-2020, 08:25 AM
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.
proof that an old dog can learn new tricks
Reply
InsiteFX
Super Moderator
Posts:
6,708
Threads:
341
Joined:
Oct 2014
Reputation:
245
#4
11-17-2020, 12:45 PM
If you solved it then please write [SOLVED] in your topic title.
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