<?php
   $dbhost = '';
   $dbuser = '';
   $dbpass = '';
   $conn = mysql_connect($dbhost, $dbuser, $dbpass);
   if(! $conn )
   {
     die('Could not connect: ' . mysql_error());
   }
   echo 'Connected successfully';


mysql_select_db('test');
 echo 'xasc';


   $sql = 'INSERT INTO abhinav2 '.'(id,name,designation,mobile)'.
'VALUES (13532,"narsingh", "PA", 956789)';

$sql = "UPDATE abhinav2 SET mobile='78745646' WHERE name='Abhishek' AND designation='pa'";

    $sql = 'CREATE Database test_db';

$sql = "DELETE FROM abhinav2
        WHERE name='narsingh'";


 $sql = 'INSERT INTO abhinav2 '.'(id,name,designation,mobile)'.
'VALUES (494746,"Abhinav", "PA", 445789)';


 // $retval = mysql_query( $sql, $conn );


  $sql='SELECT * FROM  abhinav2';
	$query= mysql_query($sql,$conn);
		while($row = mysql_fetch_array($query)){
			echo "id :{$row['id']}  <br> ".
	        "name : {$row['name']} <br> ".
	        "designation: {$row['designation']} <br> ".
			"mobile: {$row['mobile']} <br>" .
	        "**********************<br>";
		}




    mysql_close($conn);



?>