CodeIgniter Forums
codeigniter show error adding time - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Development (https://forum.codeigniter.com/forum-6.html)
+--- Forum: Issues (https://forum.codeigniter.com/forum-19.html)
+--- Thread: codeigniter show error adding time (/thread-66710.html)



codeigniter show error adding time - midriffinfosolution - 11-24-2016

when we add data in table. flowing error show given below.
[attachment=740]




RE: codeigniter show error adding time - Avenirer - 11-25-2016

How did you insert the data? I see that it is not escaped.


RE: codeigniter show error adding time - XtreemDeveloper - 12-21-2017

Try to get last query and direct hit mysql query in database than you can easily get what exact problem in that.

function getUserDataById($user_id)
{
$this->db->where('id',$user_id);
$query = $this->db->get('tbl_users');
$result = $query->row();
echo $this->db->last_query(); die;
return $result;
}


RE: codeigniter show error adding time - dave friend - 12-21-2017

You need to escape the single-quote character in doesn't as found in "...cancun doesn't release..." It is messing up your string.