PHP not able to connect to MySQL

[Leanneschlueter]

Hi,

 

Installed Apache, PHP and MySQL in Windows 10, all working fine and running.

But, when testing PHP to connect to MySQL (using mysqli and PDO), both aren't working.

Checked phpinfo, there have mysqlnd installed.
 

 

Please help, thanks!

 

[benanamen]

How about posting the code you are having a problem with. "aren't working" doesn't tell us anything. What is the error message? You do have error reporting turned on right?

Edited December 1, 2017 by benanamen

[baldwindavidrye]

For PDO you have to use follow to open the connection

 

<?php
$servername = "localhost";
$username = "username";
$password = "password";

try {
    $conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    echo "Connected successfully"; 
    }
catch(PDOException $e)
    {
    echo "Connection failed: " . $e->getMessage();
    }
?>

 

[Barand]

You also need to

• define the charset for the connection
• set it so it uses proper prepared statements instead of emulating them

It's also a good idea to set your favoured fetch method too.

$dsn = "mysql:dbname=$database; host=$host; charset=utf8";

$db = new pdo($dsn, $username,$password, 
    [
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_EMULATE_PREPARES => false,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
    ]);

 

[cyberRobot]

Note that the original post was made several months ago. The OP stopped logging in a few days after the original post.

Edited August 17, 2018 by cyberRobot

[Barand]

I know. Baldwindavidrye seems to have made it his mission to go through old posts and add his "pearls of wisdom".