Pagination problem

[viddz]

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 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>

[abduraooft]

PHP Code:

$tableName=mysql_real_escape_string($_POST['lab']); 


Why do you need to get the table name from user input?

PHP Code:

$page = mysql_escape_string($_GET['page']); 


How do you assume you page would have both POST and GET at the same time?

[viddz]

because there are 10 labs for each and every lab there is a table. User need to choose a lab table to view edit delete items in that table

[abduraooft]

There's a security issue in your current code logic to read the table name from user input.

Anyway, regarding your pagination, when the user click on the next/prev link in your page, there won't be any POST data present in the page. You might need to change the form's method to GET and then include the lab parameter in the links, along with page number.

[viddz]

I have make post method to get method. But i cannot understand what are saying here.

Originally Posted by abduraooft

then include the lab parameter in the links, along with page number.

This is my 1st php project. not familier with it very much. Can u pls tell me where should i include lab parameter in the links, along with page number.

Is it here

PHP Code:

          <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>;