deprecated: mysql_connect():_Deprecated: mysql_connect()

This warning is displayed because a new extension has appeared.

It suppouse that you still can use the old one but in some cases it´s impossible.

I show you how I do the connection with database. You need just change the values of the variables.

My connection file: connection.php

$host='IP or Server Name (usually "localhost") ';

$user='Database user';

$password='Database password';

$db='Database name';

//PHP 5.4 o earlier (DEPRECATED)

$con = mysql_connect($host,$user,$password) or exit("Connection Error");

$connection = mysql_select_db($db, $con);

//PHP 5.5 (New method)

$connection = mysqli_connect($host,$user,$password,$db);

?>

The extension changes too when performing a query.

Query File: "example.php"

//First I call for the connection

require("connection.php");

// ... Here code if you need do something ...

$query = "Here the query you are going to perform";

//QUERY PHP 5.4 o earlier (DEPRECATED)

$result = mysql_query ($query) or exit("The query could not be performed");

//QUERY PHP 5.5 (NEW EXTENSION)

$result = mysqli_query ($query) or exit("The query could not be performed");

?>

This way is using MySQL Improved Extension, but you can use PDO (PHP Data Objects).

First method can be used only with MySQL databases, but PDO can manage different types of databases.

I'm going to put an example but it´s necessary to say that I only use the first one, so please correct me if there is any error.

My PDO connection file: "PDOconnection.php"

$hostDb='mysql:host= "Here IP or Server Name";dbname="Database name" ';

$user='Database user';

$password='Database password';

$connection = new PDO($hostDb, $user, $password);

?>

Query File (PDO): "example.php"

$query = "Here the query you are going to perform";

$result=$connection->$query;

?>

To finish just say that of course you can hide the warning but it´s not a good idea because can help you in future save time if an error happens (all of us knows the theory but if you work a lot of hours sometimes... brain is not there ^^ ).