<?php
  $dbhost = '';
  $dbuser = '';
  $dbpass = '';
  $conn = mysql_connect($dbhost, $dbuser, $dbpass);

  if(! $conn ){
    die('Could not connect: ' . mysql_error());
  }
  echo 'Connected successfully.<br/>';

  $db_selected = mysql_select_db('test', $conn);
  if (!$db_selected) {
    die ('db connection failed : ' . mysql_error());
  }

  $newrecord='INSERT INTO empdata(emp_id,emp_name,email_id,designation,location,date_of_joining)'.'VALUES(495960,"John","john@gmail.com","Manager","pune","2015/1/12")';
  $retval = mysql_query($newrecord,$conn);

  $update = "UPDATE empdata ". "SET emp_name = 'sam' "."WHERE emp_id = 494656";
  $retval = mysql_query($update,$conn);
  echo mysql_errno($conn);

  $delete = 'DELETE from empdata where emp_id=494657';
  $a = mysql_query($delete,$conn);

  $sql='SELECT * FROM  empdata';
  $query= mysql_query($sql,$conn);
  while($row = mysql_fetch_array($query)){
  	echo "empid :{$row['emp_id']}  <br> ".
  	     "empname :{$row['emp_name']}  <br> ".
  	     "emailid : {$row['email_id']} <br> ".
  	     "designation : {$row['designation']} <br> ".
  	     "locatin : {$row['location']} <br> ".
  	     "joining date : {$row['date_of_joining']} <br> ".
         "<br>";
 }

// $db_selected = mysql_select_db('emp_information', $conn);
// if (!$db_selected) {
//     die ('Can not use emp_information : ' . mysql_error());
// }

mysql_close($conn);
?>