Php connect using pdo

PHP
1

I am newbie in php

err
err792Ă—366 11.7 KB
I get this error message kindly help.

my connect.php

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "user_login";

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

Could you post your connect.php where the error is happening?

5

My connect.php

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "user_login";

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

There is no variable $localhost defined in your script. There is however a variable $servername.

1 Like
7

Thanks bro…It worked changed the variable $servername to $localhost and it worked!! Much thanks!!!

8

If would have changed $localhost to $servername as that makes more sense, but yeah, the other way around works too :slight_smile:

1 Like
9

Sure it does…Thanks for the help!:smiley:

10

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.