Manage products / students with records for page limited, Pagenation script with manage products, PHP pagination, PHP paging, PHP pagination.

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']."&nbsp;</td>";   
 echo "<td align='left'>".$formvalue['productname']."&nbsp;</td>";
echo "<td align='left'>".$formvalue['title']."&nbsp;</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>