<?php
   $dbhost = '';
   $dbuser = '';
   $dbpass = '';
   $connection = mysql_connect($dbhost, $dbuser, $dbpass);
   if(! $connection ){
     die('Could not connect: ' . mysql_error());
   }
   echo 'Connected successfully';
   echo "<br><br><br><br><br><br><br>";
   $selected_one = mysql_select_db('test', $connection);
   if (!$selected_one) {
                die ('Can' . mysql_error());
                }
                $enter='INSERT into mytab'.'(empid,name,location,emailid)'.'VALUES("752","raj","kolkatta","raj@cognizant.com")';
                $retieve =mysql_query( $enter, $connection );
                $delete='DELETE from mytab where location="pune" ';
                $delete_this=mysql_query($delete,$connection);
                $update = "UPDATE mytab SET location='Delhi' WHERE empid=1234";
                $update_sql=mysql_query($update,$connection);
                $table='SELECT * FROM  mytab';
                $k= mysql_query($table,$connection);

                while($row = mysql_fetch_array($k)){

                 echo
                "empid :{$row['empid']}  <br> ".
                "name : {$row['name']} <br> ".
                "location: {$row['location']} <br> ".
                "emailid: {$row['emailid']} <br> ".
                "<br><br><br><br>";
                                }
  mysql_close($connection);
?>