<?php
   $dbhost = '';
   $dbuser = 'root';
   $dbpass = '';
   $conn = mysql_connect($dbhost, $dbuser, $dbpass);
   if(! $conn )
   {
     die('Could not connect: ' . mysql_error());
   }
   echo 'Connected successfully.......';
   $db_selected = mysql_select_db('firstphpdb', $conn);
   if (!$db_selected) {
	die ('Can\'t use foo : ' . mysql_error());
	}
	$query= mysql_query("select * from snehil");
	print_r($query);
	while ($row = mysql_fetch_assoc($query)) {
		echo $row['emp_id'];
		echo $row['name'];
		echo $row['skills'];
	}
	$query1=mysql_query("select name from snehil where emp_id=123456");
	print_r($query1);
	while ($row = mysql_fetch_assoc($query1)) {
		echo $row['name'];
	}
	$query2=mysql_query("Insert into snehil values(1233,'Aish-','-Javascript')");
	var_dump($query2);
	if(!$query2){
		echo"Insertion failed";
	}
	else{
		echo"Row inserted successfully";
	}
	$query3=mysql_query("Delete from snehil where emp_id=123456");
	print_r($query3);
	$query4=mysql_query("update snehil set skills='mysql' where emp_id=123457");
	print_r(mysql_affected_rows());
	print_r($query4);
	$query5=mysql_query("Delete from snehil where emp_id=123457");
	print_r(mysql_affected_rows());
	$query6=mysql_query("update snehil set skills='mysql' where emp_id=1233");
	print_r(mysql_affected_rows());

  mysql_close($conn);

?>