MySql Connection with PHP example

<?php
$host="MySql Host Address";
$username="localhost";
$password="password";

$connection= mysql_connect ($host, $username, $password);
if (! $connection) {
die ("A connection to the Server could not be established!");
} else {
echo "User root logged into to MySQL server ",$host," successfully.";
}
?>

Thanks
T.Varghese

Use mysql_result function to get query result

<?php

mysql_connect($host,$username,$password);
mysql_select_db("DBNAME");


$query = "SELECT id, firstname FROM Employee";
$result = mysql_query($query);

$id = mysql_result($result, 0, "id");
$name = mysql_result($result, 0, "firstname");
echo "The first returned id is $id and the name is $name";
?>

Thanks
T.Varghese

mysql_ping()
$conn = mysql_connect('localhost', 'root', '');
$db = mysql_select_db('test');

/* Assuming this query will take a long time */
$sql = "select userid from google;
$result = mysql_query($sql);
if (!$result) {
echo 'Query #1 failed, exiting.';
exit;
}

/* Make sure the connection is still alive, if not, try to reconnect */
if (!mysql_ping($conn)) {
echo 'Lost connection, exiting after query #1';
exit;
}
mysql_free_result($result);

/* So the connection is still alive, let's run another query */
$result2 = mysql_query($sql2);

__________________
Nasee
True Faith never Fails