Connection.php
Sample connection file
<?php
$servername="localhost"; //
host name here
$databaseusername=" "; //
database username here
$databasepassword=""; //
database name here
mysql_connect($servername,$databaseusername,$databasepassword); $databasename=mysql_select_db(“database name
here”); // database name here
?>
Delete product based on category, after product delete
redirect to particular products category, Product delete / record delete,
delete record after redirect to particular category
<?php include('includes/session.php'); ?>
<?php
include("includes/connection.php");
$id=$_GET['id'];
$deletedatarec="delete from
students where id='$id'";
$productdata="select * from
students where id='$id'";
$productdatab=mysql_query($productdata);
$rec=mysql_fetch_assoc($productdatab);
$delrecord=mysql_query($deletedatarec);
// 5th Class
if($rec['productname'] == "5th Class")
{
echo
"<script language='javascript'>window.location='5th
Class-manage.php';</script>";
}
// 6th Class
if($rec['productname'] == "6th Class"){
echo
"<script language='javascript'>window.location='6th
Class-manage.php';</script>";
}
// 7th Class
if($rec['productname'] == "7th Class")
{
echo
"<script language='javascript'>window.location='7th
Class-manage.php';</script>";
}
// 8th Class
if($rec['productname'] == "8th Class")
{
echo
"<script language='javascript'>window.location='8th
Class-manage.php';</script>";
}
else { echo
"error"; } ?>
Manage products / students with records for page limited,
Pagenation script with manage products, PHP pagination, PHP paging, PHP
pagination.
<!-- save this script in example page:
manageproducts.php for page numbers
area (4 areas below use same page name) -->
<table
width="100%" border="0" align="center"
cellpadding="5" cellspacing="0">
<tr><td colspan="5"
align="center" valign="middle" class="product-title">This
is Product heading</td> </tr>
<tr class="sub-head-tr">
<td width="16%"
align="center" valign="middle" ><strong>Part
Number</strong></td>
<td width="30%"
align="center" valign="middle"><strong>Product
Category</strong></td>
<td width="35%" align="center"
valign="middle"><strong>Title</strong></td>
<td width="11%"
align="center"
valign="middle"><strong>Edit</strong></td>
<td width="8%" align="center" valign="middle"><strong>Delete</strong></td>
</tr>
<?php
include('includes/connection.php'); //
this is database connection file
$pages_query = mysql_query("SELECT COUNT('id') FROM students where
productname='productcategoryname' order by id desc");//get the number of
contents
$pages = ceil(mysql_result($pages_query, 0) / $per_page);// get the number of
pages
$page = (isset($_GET['page'])) ? (int)$_GET['page'] : 1;
$start = ($page - 1) * $per_page; //get
the starting content id of each page
$query = mysql_query("SELECT * FROM students where
productname='productcategoryname' order by id desc LIMIT $start,
$per_page");
while($formvalue
= mysql_fetch_assoc($query))
{
echo "<tr class='general-tr'>";
echo "<td
align='left'>".$formvalue['value1']." </td>";
echo "<td
align='left'>".$formvalue['productname']." </td>";
echo "<td
align='left'>".$formvalue['title']." </td>";
echo "<td align='center'><a
href='product-edit.php?id=".$formvalue['id']."'
target='_parent'>Edit</a></td>";echo "<td
align='center' class='lasttd'><a
href='product-delete.php?id=".$formvalue['id']."'
target='_parent'
onclick='return
confirm(\"Are You Sure?\");'>Delete</a></td></tr>";
}
$pagenum=mysql_num_rows($query);
if($pagenum==0)
{
echo "<tr class='data'><td
align='center' colspan='3'><div class='nodata'>No
Products</div></td></tr>";
}
/////////////////////////////////////////////////////////
echo
"<tr><td colspan='5'><div class='pagenumbers'>";
$prev
= $page - 1; $next = $page + 1;
if(!($page<=1)){
echo
"<a href='manageproducts.php?page=$prev'>Prev</a> ";
}
if($pages>=1
&& $page<=$pages){
for($x=1;$x<=$pages;$x++){
echo
($x == $page) ? '<strong><a
href="manageproducts.php?page='.$x.'">'.$x.'</a></strong>
' : '<a href="manageproducts.php?page='.$x.'">'.$x.'</a>
'; }
}
if(!($page>=$pages)){
echo "<a
href='manageproducts.php?page=$next'>Next</a>";
}
echo "</div></td></tr>";
?>
</table>
