Thursday, April 16, 2009

Database delete operation using PHP

TABLE STRUCTURE

Product

id integer primary key auto_increment,name varchar(50),price decimal(10,2),category_id integer,imagepath varchar(100),updateDay date

PHP CODE

<?php
$idStr=$_POST["idStrVal"];
$idVal=strtok($idStr,'|');
$con=mysql_connect("localhost","root","");
mysql_select_db("phpDB",$con);
while($idVal!==FALSE)
{
mysql_query("delete from product where id=".$idVal);
$idVal=strtok("|");
}
mysql_query("commit");
mysql_close($con);
?>

No comments:

Post a Comment