Skip to main content
cloef84981695
Participant
April 19, 2017
Answered

Help with the error Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead

How do I change this code to the extension msqli or pdo so that the error goes away?

This topic is closed to new replies. Start a new post to keep the conversation going.
Rob Hecker2
Rob Hecker2Correct answer
Legend
April 20, 2017

Ebay is correct.

The following would work:

try {
$dbd = new PDO($db, $user, $pw, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
$dbd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
}
catch (PDOException $e) {
     die('Connection failed: ');
}

View reply

5 replies

Nancy OShea
Community Expert
Nancy OSheaCommunity Expert
Community Expert
April 19, 2017

MySQL test connection:

<?php 

$conn = new mysqli('localhost' , 'username' , 'password' , 'database_name');

echo "<h1>Success in database connection! Happy Coding!</h1>"; 

// if no success the script would have died before this success message

?>

Translate
Nancy O'Shea— Product User & Community Expert
EbaySeller
Inspiring
April 19, 2017

https://forums.adobe.com/people/Nancy+OShea  wrote

// if no success the script would have died before this success message

Actually, without an explicit die argument the script will not die. The success message will still appear on the page. An access denied warning message will appear if the script is unable to connect to the database.

Translate
Rob Hecker2
Rob Hecker2Correct answer
Legend
April 20, 2017

Ebay is correct.

The following would work:

try {
$dbd = new PDO($db, $user, $pw, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
$dbd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
}
catch (PDOException $e) {
     die('Connection failed: ');
}

Translate
Nancy OShea
Community Expert
Nancy OSheaCommunity Expert
Community Expert
April 19, 2017

Replace Deprecated Server Behaviors with a modern commercial extension:

Nancy

Translate
Nancy O'Shea— Product User & Community Expert
Nancy OShea
Community Expert
Nancy OSheaCommunity Expert
Community Expert
April 19, 2017

Which versions of PHP & MySQL do you have on your servers -- remote and local testing?

If you don't know, you can find out by running this script.   SaveAs info.php   Upload to server and open it in your browser.

<!doctype html>

<html>

<head>

<meta charset="utf-8">

<title>PHP info</title>

</head>

<body>

<?php phpinfo() ?>

</body>

</html>

Translate
Nancy O'Shea— Product User & Community Expert
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices