mysql_escape_string（）：不推荐使用此函数; 请改用mysql_real_escape_string（）

Question

This is some strange problem I'm facing, my local machine runs php 5.6.3 while live server is running php 5.4. We recently updated our app from codeigniter 2.* to codeingiter 3.0, now while running on live server we came to know about this brand new issue (older one and still not working smtp)

A PHP Error was encountered

Severity: 8192

Message: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead.

Filename: mysql/mysql_driver.php

Line Number: 319

Now after doing some googling, I found that top solution might be for ci 2.* doesn't work as codeigniter's mysql_drivers.php file is already using mysql_real_escape_string(). One answer is suggesting that I should check database.php file. If my default connection is mysql instead of mysqli which is mysqli, now I've no way to find out what is going wrong or what I'm missing.

Answer 1

PHP mysql driver is deprecated since 5.5. See http://php.net/manual/en/intro.mysql.php

So you better not use it. Use mysqli.

Line 319 on mysql/mysql_driver.php: https://github.com/bcit-ci/CodeIgniter/blob/3fe79499c5bedb5b3bc4281821776f031f73674e/system/database/drivers/mysql/mysql_driver.php#L319

There is no mysql_escape_string(). It seems you didn't update to 3.0 correctly.