<?php
   $localhost = '';
   $username = '';
   $password = '';
   $conn = mysql_connect($localhost, $username, $password);
   if(! $conn )
   {
     die('Could not connect: ' . mysql_error());
   }
   echo 'Connected successfully.......';
   echo "<br/>";

   //insert record
	$sql = 'INSERT INTO Archana '.'(Emp_id,Emp_name,Emp_mailid,Emp_loc)'.'VALUES (101,"Ashish", "ashish@gmail", "Pune")';
	mysql_select_db('test');


	//update record
	$sql = "UPDATE Archana SET Emp_name='ujju' WHERE Emp_id=123";



	//delete record
	$sql = "DELETE FROM Archana WHERE Emp_id=2";

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

   //display table
	$sql='SELECT * FROM Archana';
	$query= mysql_query($sql,$conn);
	while($row = mysql_fetch_array($query))
	{

         echo "Employee Id-".$row['Emp_id'];
		 echo "<br>";
		 echo "Employee name-".$row['Emp_name'];
		 echo "<br>";
		 echo "Employee email-".$row['Emp_mailid'];
		 echo "<br>";
		 echo "Employee location-".$row['Emp_loc'];
		 echo "<br>";

	}
	mysql_close($conn);
?>