Monday, November 14, 2011

Code to Delete Data from MYSQL using PHP



$host="localhost"; // Host name 
$db_username="root"; // Mysql username 
$db_password=""; // Mysql password 
$db_name="sarvdev"; // Database name 
$user="user"; // Table names 


mysql_connect("$host", "$db_username", "$db_password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");


$sql="Delete from user where id='" . $userid . "'";


or if you want to delete a particular field then you can use following code :
$sql="Delete name from user where id='" . $userid . "'";
$result=mysql_query($sql);




No comments:

Post a Comment