It shows 1st page results and also number of pages are also shown. But i cant get results for the other pages. This problem was arisen after i have added new option to select table which Iam going to paginate.
here is my code
<?php
if(isset($_POST['submit']))
{
session_start();
include("config.php");
$tableName=mysql_real_escape_string($_POST['lab']);
$targetpage = "view_all_chemical.php";
$limit = 5;
$query = "SELECT COUNT(*) as num FROM $tableName";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[num];
$stages = 3;
$page = mysql_escape_string($_GET['page']);
if($page){
$start = ($page - 1) * $limit;
}else{
$start = 0;
}
// Get page data
$query1 = "SELECT * FROM $tableName LIMIT $start, $limit";
$result = mysql_query($query1);
// Initial page num setup
if ($page == 0){$page = 1;}
$prev = $page - 1;
$next = $page + 1;
$lastpage = ceil($total_pages/$limit);
$LastPagem1 = $lastpage - 1;
$paginate = '';
if($lastpage > 1)
{
$paginate .= "<div class='paginate'>";
// Previous
if ($page > 1){
$paginate.= "<a href='$targetpage?page=$prev'>previous</a>";
}else{
$paginate.= "<span class='disabled'>previous</span>"; }
// Pages
if ($lastpage < 7 + ($stages * 2)) // Not enough pages to breaking it up
{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page){
$paginate.= "<span class='current'>$counter</span>";
}else{
$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}
}
}
elseif($lastpage > 5 + ($stages * 2)) // Enough pages to hide a few?
{
// Beginning only hide later pages
if($page < 1 + ($stages * 2))
{
for ($counter = 1; $counter < 4 + ($stages * 2); $counter++)
{
if ($counter == $page){
$paginate.= "<span class='current'>$counter</span>";
}else{
$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}
}
$paginate.= "...";
$paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
$paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";
}
// Middle hide some front and some back
elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2))
{
$paginate.= "<a href='$targetpage?page=1'>1</a>";
$paginate.= "<a href='$targetpage?page=2'>2</a>";
$paginate.= "...";
for ($counter = $page - $stages; $counter <= $page + $stages; $counter++)
{
if ($counter == $page){
$paginate.= "<span class='current'>$counter</span>";
}else{
$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}
}
$paginate.= "...";
$paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
$paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";
}
// End only hide early pages
else
{
$paginate.= "<a href='$targetpage?page=1'>1</a>";
$paginate.= "<a href='$targetpage?page=2'>2</a>";
$paginate.= "...";
for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++)
{
if ($counter == $page){
$paginate.= "<span class='current'>$counter</span>";
}else{
$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}
}
}
}
// Next
if ($page < $counter - 1){
$paginate.= "<a href='$targetpage?page=$next'>next</a>";
}else{
$paginate.= "<span class='disabled'>next</span>";
}
$paginate.= "</div>";
}
// get results from database
// $result = mysql_query("SELECT * FROM members")
// or die(mysql_error());
// display data in table
echo "<table id='table1'>";
echo "<tr> <th>Name</th> <th>Code</th> <th>Quantity</th> <th>Reorder</th><th>Edit</th><th>Delete</th><th>Stock</th> </tr>";
// loop through results of database query, displaying them in the table
while($row = mysql_fetch_array( $result ))
{
// echo out the contents of each row into a table
echo "<tr>";
echo '<td><span class="class1">
<a href="chemicalprofile.php?id=' . $row['id'] . '"> '. $row['generalname'] . '</a></span></td>';
echo '<td>' . $row['Scientificname'] . '</td>';
echo '<td>' . $row['quantity'] . '</td>';
echo '<td>'. $row['reorder'] . '</td>';
echo '<td><a href="editchemical.php?id=' . $row['id'] . '">Edit</a></td>';
echo '<td><a href="delete_chemical.php?id=' . $row['id'] . '">Delete</a></td>';
echo '<td><a href="stock_chemical.php?id=' . $row['id'] . '">Stock</a></td>';
//echo '<td><a href="edituser.php?id=' . $row['id'] . '">Edit</a></td>';
//echo '<td><a href="delete_user.php?id=' . $row['id'] . '">Delete</a></td>';
echo "</tr>";
}
echo "</table>";
echo $paginate;
}
?>
<form action="view_all_chemical.php" method="post" name="view_form">
<select name="lab">
<option value="0">Select Lab</option>
<option value="chemical_advancechemistrylab">Advance Chemistry Lab</option>
<option value="chemical_biochemistrylab">Bio Chemistry Lab</option>
<option value=" chemical_elimentorylab">Elementry Lab</option>
<option value="chemical_innorganiclab">Innorganic Lab</option>
<option value="chemical_newbiochemistrylab">New Biochemistry Lab</option>
<option value="chemical_oraganiclab">Organic Lab</option>
<option value="chemical_phamacylab">Pharmacy Lab</option>
<option value="chemical_physicallab">Physical Lab</option> </select>
<input type="submit" name="submit" value="Select lab"/></form>
