Our Training Programs

All contents are copyright of their authors.

error in databse connection

error in databse connection

Hema Sundar

10yAsked Dec 10, 2015, 5:38 AM1.1kPHP

$servername = "localhost";

$username = "madhuri_abc";

$password = "happy123";

$dbname = "madhuri_789";

// Create connection

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

this is my code it was workin in local host but not working in real time . Guys pls hepl me im begineer in php

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Hema Sundar10y ago
thanks for all for giving solution
Raja T10y ago
Hello Sundar, Try like

$servername = "localhost"; //your server name
$username = "root"; //your db user name
$password = "root"; // your db password
// Create connection
$conn = mysql_connect($servername, $username, $password);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";
?>
Jithil John10y ago
Change your server name that you mentioned in the query string.

If you find anything useful please accept my answer
Manas Mohapatra10y ago
Make sure that you are putting correct Database name, Host, password etc.

Secondly when you say it was working host not working real time - what does it mean. Please define.