I'm trying to create a login function while learning CodeIgniter. I've validated that both the username and password are correct. The passwords are encrypted using Phppass codeigniter password library.
This is the error I get after I login with the correct information.
A Database Error Occurred
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near
'(`session_id`, `ip_address`, `user_agent`, `last_activity`)
VALUES ('826f937fed9' at line 1
INSERT INTO (`session_id`, `ip_address`, `user_agent`,
`last_activity`) VALUES ('826f937fed9185e2c121ec06b1b44b6a', '::1',
'Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/53', 1442454002)
Filename: libraries/Session.php
Line Number: 327
INSERT ... [INTO] tbl_name ...It's staring you right in the face. - Jared Farrishsession_id`" with " 'session' " and try. i.e. with quotes - ankur140290