Deprecated: mysql_connect() [duplicate]

Question

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

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

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

Answer 1

There are a few solutions to your problem.

The way with MySQLi would be like this:

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

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

<?php // 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_*:

<?php 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);

Answer 2

You can remove the warning by adding a '@' before the mysql_connect.

@mysql_connect('localhost','root',''); 

but as the warning is telling you, use mysqli or PDO since the mysql extension will be removed in the future.