[SOLVED] checked Mysql work back "ok" or..

[belphegor]

hi,

sorry abut my English.

 

how can i make custom page to checked if Mysql is connect/work/online and if it is ok back "ON" if not back "OFF"?

 

thanks for help.

[belphegor]

Guys please this is very urgent me  :'(

 

[janim]

$connect=mysql_connect($database,$username,$password);

if(!$connect){
echo "OFF";
}else{
echo "ON";
}

is that what you searching for  ?

 

[belphegor]

i think....

 

so i need to do like this?

 

<?php
$connect=mysql_connect($database,$username,$password);

if(!$connect){
echo "OFF";
}else{
echo "ON";
}
?>

 

and change $database $username and $password..... ?

the "$" need to be example for $username: $belphegor

 

thanks for your help!!

 

 

 

edit;

 

or:

 

<?php
$dbms = 'mysql';
$dbhost = '';
$dbport = '';
$dbname = 'XXXX';
$dbuser = 'XXXX';
$dbpasswd = 'XXXX';
$connect=mysql_connect($database,$username,$password);

if(!$connect){
echo "OFF";
}else{
echo "ON";
}
?>

[belphegor]

ok, be arranged:

 

<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

 

thanks.