I took over a project that is on CI 1.7.2 and have been attempting to update a bunch of rows but get the following error.
A PHP Error was encountered
Message: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead.
Line Number: 304
The CI code I have is below with the $data variable being an associative array of FieldName => Value. I’ve read other posts that I should change the dbdriver to mysqli which I tried and still get the same error.
What can I to allow the update to work with escaping? I’m new to CI and was wondering if a newer version would solve this issue how easy is it to update to the newest version?
foreach ($alldata as $data)
// I had to comment out this line as it was causing another issue. I'll be monitoring the DB connections to make sure this doesn't cause zombies.