Menu
Community /Pin to ProfileBookmark
@NogDogJun 05.2021 — #Note, I edited your post to wrap the code in this forum's What gets output after "Connection failed:" -- or does it even reach that line? @NogDogJun 06.2021 — #Looks like neither the MySQL nor the MySQLi extension is installed/enabled on your web server. You only need one or the other, with MySQLi being the preferred, more modern version -- or you could use the PDO extension with its MySQL driver if available. (I personally much prefer to use PDO.) You could test PDO with something like:
@NogDogJun 07.2021 — #Are you working on a web server under someone else's control (in which case you need to talk with them), or are you just working in a local environment on your own computer, or...? The environment being used and how PHP is installed there will drive what needs to be done (and I'm not an installation expert). @NogDogJun 07.2021 — #If Ubuntu Linux, you could try:
...and then restart the web server. No promises. If it's a Centos flavor of Linux, you'd usehttps://www.howtoforge.com/apache_php_mysql_on_centos_6.5_lamp for some possibly useful info.
PHP Version 5.6.40, internal error for connect mysql
According to I have a project need to use PHP 5.6.40 connect to mysql version 5.7.34
This URL for phpinfo()
[
when I try to connect it by below coding
[code]$servername = “localhost”;
$username = “user”;
$password = “pass”;
$db_database = ‘db_unelr’;
$db_port = ‘3306’;
// Create connection
$conn = mysqli_connect($servername, $username, $password,$db_database,$db_port);
// Check connection
if ($conn->connect_error) {
die(“Connection failed: ” . $conn->connect_error);
}
echo “Connected successfully”;
Sign in
to post a comment12 Comments(s) ↴
0
@NogDogJun 05.2021 — #Note, I edited your post to wrap the code in this forum's ...0
@NogDogJun 05.2021 — #0
@NogDogJun 06.2021 — #Looks like neither the MySQL nor the MySQLi extension is installed/enabled on your web server. You only need one or the other, with MySQLi being the preferred, more modern version -- or you could use the PDO extension with its MySQL driver if available. (I personally much prefer to use PDO.) You could test PDO with something like:[code=php]
$servername = "localhost";
$username = "user";
$password = "pass";
$db_database = 'db_unelr';
$db_port = '3306';
$dsn = "mysql:host=$servername;port=$db_port;dbname=$db_database";
try {
$pdo = new PDO($dsn, $username, $password);
} catch (PDOExeception $e) {
error_log($e->getMessage());
die("DB Connection failed");
}
[/code]0
@NogDogJun 07.2021 — #0
@NogDogJun 07.2021 — #If Ubuntu Linux, you could try:<i>
</i>sudo apt-get install php5-mysql
# omit the "sudo" if logged in as root
...and then restart the web server. No promises. If it's a Centos flavor of Linux, you'd use
yumapt-get