<?php
$username = "328_tahir";
$password = "tahir";
$hostname = "localhost";
//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
echo "Connected to MySQL now you can create Table new one <br>";
//select database
mysql_select_db("328_tahir",$dbhandle);
echo "data Base Selected";
if($_POST['delete']) // from button name="delete"
{
$checkbox = $_POST['checkbox']; //from name="checkbox[]"
$countCheck = count($_POST['checkbox']);
for($i=0;$i<$countCheck;$i++)
{
$del_id = $checkbox[$i];
$sql = "DELETE from products where id = $del_id";
$result =mysql_query($sql,$dbhandle) or die("cannot delete");
}
if($result){
header('Location: index3.php');
}
else
{
echo "Error: ".mysql_error();
}
}
?>
$username = "328_tahir";
$password = "tahir";
$hostname = "localhost";
//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
echo "Connected to MySQL now you can create Table new one <br>";
//select database
mysql_select_db("328_tahir",$dbhandle);
echo "data Base Selected";
if($_POST['delete']) // from button name="delete"
{
$checkbox = $_POST['checkbox']; //from name="checkbox[]"
$countCheck = count($_POST['checkbox']);
for($i=0;$i<$countCheck;$i++)
{
$del_id = $checkbox[$i];
$sql = "DELETE from products where id = $del_id";
$result =mysql_query($sql,$dbhandle) or die("cannot delete");
}
if($result){
header('Location: index3.php');
}
else
{
echo "Error: ".mysql_error();
}
}
?>
No comments:
Post a Comment