CODEWITHSUNDEEP
phpmysql
Karthik Malla
Karthik Malla

Reputation: 5800

PHP MySQL Database test

I am able to connect to the database by using the following code.

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
  echo "Connected...!";
?>

But, the above code is just to check whether the connection from PHP to MySQL server is established or not but its no way checking whether the database user is connected with the database name.

Well, I was trying to connect to the database in my project I am unable to connect to it. I have customized error report for that which is not clear but I am able to connect to the database server from PHP using 

mysql_connect(servername,username,password);

So, can anybody suggest me some code to test whether the database user is authorized to connect to the database or not?

Upvotes: 1

Views: 15887

Answers (1)

hek2mgl
hek2mgl

Reputation: 157967

It can be done like this (using the mysqli extension) :

<?php

$link = @mysqli_connect('host', 'user', 'secret');
if(!$link) {
    die('failed to connect to the server: ' . mysqli_connect_error());
}

if(!@mysqli_select_db($link, 'dbname')) {
    die('failed to connect to the database: ' . mysqli_error($link));
}

In my example I used the functional api to mysqli. This works the same way as in the older mysql extension.

Upvotes: 4

Related Questions