Tuesday, 21 February 2017

php - Deprecated: mysql_connect()

Answer


Answer




I am getting this warning, but the program still runs correctly.




The MySQL code is showing me a message in PHP:




Deprecated: mysql_connect(): The mysql extension is deprecated and
will be removed in the future: use mysqli or PDO instead in
C:\xampp\htdocs\task\media\new\connect.inc.php on line 2




My connect.inc.php page is




  $connect = mysql_connect('localhost','root','');
mysql_select_db('dbname');
?>


What does this mean and how can I eliminate the message?


Answer



There are a few solutions to your problem.




The way with MySQLi would be like this:



$connection = mysqli_connect('localhost', 'username', 'password', 'database');


To run database queries is also simple and nearly identical with the old way:




// Old way
mysql_query('CREATE TEMPORARY TABLE `table`', $connection);
// New way
mysqli_query($connection, 'CREATE TEMPORARY TABLE `table`');


Turn off all deprecated warnings including them from mysql_*:



error_reporting(E_ALL ^ E_DEPRECATED);



The Exact file and line location which needs to be replaced is "/System/Startup.php > line: 2 " error_reporting(E_All); replace with error_reporting(E_ALL ^ E_DEPRECATED);


No comments:

Post a Comment

c++ - Does curly brackets matter for empty constructor?

Those brackets declare an empty, inline constructor. In that case, with them, the constructor does exist, it merely does nothing more than t...