<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Delete Multiple Rows using PHP and MySQL</title>
<link href="css/styles.css" rel="stylesheet" type="text/css" />
</head>
<body>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js%22%3E%3C/script>
<script>
$(document).ready(function() {
$("tr:nth-child(even)").addClass("even");
});
</script>
<div id="container">
<div id="listing">
<h1>Delete Multiple Rows Example</h1>
<!-- now we need to loop throguh and display our fields -->
<?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";
$query = "SELECT * FROM products";
// run the query and store the results in the $result variable.
$result =mysql_query($query,$dbhandle) or die("cannot do the query");
if ($result) {
// create a new form and then put the results
// indto a table.
echo "<form method='post' action='delete.php'>";
echo "<table cellspacing='0' cellpadding='15'>
<th width='15%'>Image</th>
<th width='55%'>Title</th>
<th width='15%'>Price</th>
<th width='15%'>Delete</th>
";
while ($row = mysql_fetch_array($result)) {
$title = $row['product_title'];
$price = $row['product_price'];
$image = $row['product_img'];
$id = $row['id'];
//put each record into a new table row with a checkbox
echo "<tr>
<td><img src='$image' /></td>
<td>$title</td><td>$price</td>
<td><input type='checkbox' name='checkbox[]' id='checkbox[]' value=$id />
</tr>";
}
// when the loop is complete, close off the list.
echo "</table><p><input id='delete' type='submit' class='button' name='delete' value='Delete Selected Items'/></p></form>";
}
?>
</div>
</div><!-- end container -->
</body>
</html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Delete Multiple Rows using PHP and MySQL</title>
<link href="css/styles.css" rel="stylesheet" type="text/css" />
</head>
<body>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js%22%3E%3C/script>
<script>
$(document).ready(function() {
$("tr:nth-child(even)").addClass("even");
});
</script>
<div id="container">
<div id="listing">
<h1>Delete Multiple Rows Example</h1>
<!-- now we need to loop throguh and display our fields -->
<?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";
$query = "SELECT * FROM products";
// run the query and store the results in the $result variable.
$result =mysql_query($query,$dbhandle) or die("cannot do the query");
if ($result) {
// create a new form and then put the results
// indto a table.
echo "<form method='post' action='delete.php'>";
echo "<table cellspacing='0' cellpadding='15'>
<th width='15%'>Image</th>
<th width='55%'>Title</th>
<th width='15%'>Price</th>
<th width='15%'>Delete</th>
";
while ($row = mysql_fetch_array($result)) {
$title = $row['product_title'];
$price = $row['product_price'];
$image = $row['product_img'];
$id = $row['id'];
//put each record into a new table row with a checkbox
echo "<tr>
<td><img src='$image' /></td>
<td>$title</td><td>$price</td>
<td><input type='checkbox' name='checkbox[]' id='checkbox[]' value=$id />
</tr>";
}
// when the loop is complete, close off the list.
echo "</table><p><input id='delete' type='submit' class='button' name='delete' value='Delete Selected Items'/></p></form>";
}
?>
</div>
</div><!-- end container -->
</body>
</html>
No comments:
Post a Comment