mysql_connect 废弃,已弃用：mysql_connect（）

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?

解决方案

There are few solutions for 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);