Deprecated: mysql_connect()

[bielikMM]

Hi 

 

Am getting this error in my php code

 

 Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\wamp\www\matu\connect.php on line 9

 

the line is $con=mysql_connect("$host", "$username", "$password")or die("cannot connect");

[PravinS]

mysql_connect() function is not supported in PHP 5.5.0 and your PHP version may have been upgraded to 5.5.0

 

check this url: http://php.net/manual/en/function.mysql-connect.php

[gristoi]

ok, it is telling you what you need to know. mysql is no longer used in later php versions, you need to start using PDO

[cyberRobot]

ok, it is telling you what you need to know. mysql is no longer used in later php versions, you need to start using PDO

 

While PDO is probably a better choice...you could also use MySQLi. More information about the two options can be found here:

http://php.net/manual/en/mysqlinfo.api.choosing.php

[bielikMM]

Tthanks guys am getting to figure out using PDO and MYSQLI.....perhaps you could help me with this string of code. how will the new string look like ?

 

 

 

<?php

 

$host="127.0.0.1"; // Host name 

$username="root"; // mysql username 

$password=""; // mysql password 

$db_name="marketapp"; // Database name 

 

// Connect to server and select databse.

$con=mysql_connect("$host", "$username", "$password")or die("cannot connect"); 

mysql_select_db("marketapp",$con ) or die(mysql_error());

?> 

[cyberRobot]

how will the new string look like ?

 

The link I provided earlier (http://php.net/manual/en/mysqlinfo.api.choosing.php) shows how to connect to a database with PDO, MySQLi, and MySQL.

[bielikMM]

Alright thanks for the help @Guru

[Tom10]

Hi 

 

Am getting this error in my php code

 

 Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\wamp\www\matu\connect.php on line 9

 

the line is $con=mysql_connect("$host", "$username", "$password")or die("cannot connect");

Yes like cyberRobot said, mysql functions are now deprecated (out of date) they may be removed from PHP in the future, you are using mysql_connect()

Here's a mysqli example:

$host = "localhost";
$username = "dbUser";
$password = "NULL";
$db_name = "dbName";

$conn = mysqli_connect($host, $username, $password, $db);

if($conn->connect_error()) { //If there is an error while connecting to SQL server

//Execute code ie:

echo $conn->connect_errono(); //Display Error Number

} else {

//Do Nothing

}

Or like cyberRobot also said you can use PDO

[brotherZ]

Looks like a warning. You should fine if you disable php warnings.

[CroNiX]

Looks like a warning. You should fine if you disable php warnings.

Why would you want to turn off a deprecation notice? Its kind of important to not use things that are going to be removed from PHP if you want things to work in the future.