Jump to content
Leanneschlueter

PHP not able to connect to MySQL

Recommended Posts

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!

 

Share this post


Link to post
Share on other sites

:psychic: 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 by benanamen

Share this post


Link to post
Share on other sites

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();
    }
?>

 

Share this post


Link to post
Share on other sites

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
    ]);

 

Share this post


Link to post
Share on other sites
Posted (edited)

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

Edited by cyberRobot

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.