The mysql extension is deprecated and will be removed

Question

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/u195296372/public_html/include/header.php on line 21

I had this error in my header.

This is the code (line 21 and 22):

mysql_connect("$host", "$username", "$password")or die("cannot connect to the database."); 
mysql_select_db("$db_name")or die("cannot select the database.");

and you're not mixing different mysql apis such as mysqli_ and/or pdo, right? — Funk Forty Niner, Mar 27 '17 at 18:51
As the message says - [`mysql_*`](http://php.net/manual/en/ref.mysql.php) functions are now deprecated and should be avoided. Use either [`mysqli`](http://php.net/manual/en/book.mysqli.php) or [`PDO`](http://php.net/manual/en/book.pdo.php). — dokgu, Mar 27 '17 at 18:54
The [deprecation followed by removal](http://php.net/manual/en/function.mysql-connect.php) (in PHP 7.0) of the old mysql PHP extension is a known and documented event for [more than 3 years](http://php.net/supported-versions.php). — axiac, Mar 27 '17 at 18:54

Aloso · Answer 1 · 2017-03-27T18:56:44.443

0

Use mysqli instead.

Your code would look like this:

mysqli_connect("$host", "$username", "$password")or die("cannot connect to the database.");
mysqli_select_db("$db_name")or die("cannot select the database.");

Or, in object-oriented style:

$mysqli = new mysqli("$host", "$username", "$password", "$db_name");
if ($mysqli->connect_errno) {
    die("database connection failed.");
}

Then you can do queries like this:

$result = $mysqli->query("[SQL query]");

MySqli documentation

edited Mar 27 '17 at 18:56

answered Mar 27 '17 at 18:51

Aloso

5,123
4
24
41

3

While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. – Jay Blanchard Mar 27 '17 at 18:53
1

I added more details. – Aloso Mar 27 '17 at 18:57
1

Why not return the actual errors? Your `die()` statements won't be helpful if something fails. – Jay Blanchard Mar 27 '17 at 19:35

The mysql extension is deprecated and will be removed

1 Answers1