PHP - Php Data Pagination Issue

I want to add the result of a query to another table but every time i click on it, it only saves the first record, please help me check out my code   thanks    <?php
               // hide errors
 error_reporting(0);
               
               /* Include the Pear::Pager file */
 include('mysql_connect.php');   //include of db config file
include ('paginate.php'); //include of paginat page
 
$per_page = 5;         // number of results to show per page
$result = mysql_query("SELECT * FROM users");
$total_results = mysql_num_rows($result);
$row=mysql_fetch_assoc($result);
$total_pages = ceil($total_results / $per_page);//total pages we going to have
 //while ($row=mysql_fetch_assoc($result)){

//-------------if page is setcheck------------------//
if (isset($_GET['page'])) {
    $show_page = $_GET['page'];             //it will telles the current page
    if ($show_page > 0 && $show_page <= $total_pages) {
        $start = ($show_page - 1) * $per_page;
        $end = $start + $per_page;
    } else {
        // error - show first set of results
        $start = 0;              
        $end = $per_page;
    }
} else {
    // if page isn't set, show first set of results
    $start = 0;
    $end = $per_page;
}
// display pagination
$page = intval($_GET['page']);

$tpages=$total_pages;
if ($page <= 0)
    $page = 1;
?>

 <?php
// hide errors
 error_reporting(0);
                    $reload = $_SERVER['PHP_SELF'] . "?tpages=" . $tpages;
                    echo '<div class="pagination"><ul>';
                    if ($total_pages > 1) {
                        echo paginate($reload, $show_page, $total_pages);
                    }
                    echo "</ul></div>";
                    // display data in table
                    echo "<table class='table table-bordered'>";
                    echo "<thead><tr><th>First Name</th> <th>Last Name</th> <th>Department</th> <th>Status</th></tr></thead>";
                    // loop through results of database query, displaying them in the table
                    for ($i = $start; $i < $end; $i++) {
                        // make sure that PHP doesn't try to show results that don't exist
                        if ($i == $total_results) {
                            break;
                        }
                   
                        // echo out the contents of each row into a table
                        echo "<tr> ";
                        echo '<td>' . mysql_result($result, $i, 'firstname') . '</td>';
                        echo '<td>' . mysql_result($result, $i, 'lastname') . '</td>';
                         echo '<td>' . mysql_result($result, $i, 'department') . '</td>';
                        
                         echo ' <td><a   href="add_team.php?id='.$row['id'].'"> Add Team Member </a></td>';
                      }
                        echo "</tr>";
                    
            //        }       
                    // close table>
                echo "</table>";
            // pagination
            
        
            ?>

Greetings All!  New to PHP, and trying to learn as much as I can as quickly as I can for a client.  I have been following some of  Tutorials i understand most of it, but I still don't understand a few of the functions. 

Anyways, here is my problem.  I am trying to combined the two tutorials (Pagination and Search Internal)  but I seem to have myself in a loop...

Code is as follows:
Code: [Select]
    <?php

$connect = mysql_connect("localhost","root","~~~~");
$db = mysql_select_db("~~~");

$button = $_GET['submit'];
$search = $_GET['search'];

if ($button)

{
if (strlen($search)<=0)
echo "Please enter a keyword";

else
{
//explode our search terms
$search_exploded = explode(" ",$search);
foreach($search_exploded as $search_each)
{
//construct query
$x++;
if ($x==1)
$construct .= "keywords LIKE '%$search_each%' OR vid_state LIKE '%$search_each%' OR users LIKE '%$search_each%' OR title LIKE '%$search_each%'";
else
$construct .= " OR keywords LIKE '%$search_each%' OR vid_state LIKE '%$search_each%' OR users LIKE '%$search_each%' OR title LIKE '%$search_each%'";
}

//eco out construct

$construct = "SELECT * FROM video_url WHERE $construct";
$run = mysql_query($construct);

$foundnum = mysql_num_rows($run);

//max display per page
        $per_page = 3;
        
        //get start variable
        $start = $_GET['start'];
        
        //count records
        $record_count = $foundnum;
        
        //count max pages
        $max_pages = $record_count / $per_page; //may come out as decimal
$pagenumbers = intval($max_pages) + 1;

if (!$start)
            $start = 0;
            
        //setup previous and next variables
        $prev = $start - $per_page;
        $next = $start + $per_page;
        
        //show prev button
        if (!($start<=0))
            echo "<a href='searchvideos.php?start=$prev'><img src='../images/texts/previous.png' border='0'></a> ";
        
//show next button
        if (!($start>=$record_count-$per_page))
            echo " <a href='searchvideos.php?start=$next'><img src='../images/texts/next.png' border='0'></a>";
        
        
        //set variable for first page
        $i=1;
        
        for ($y=0;$y<$record_count;$y=$y+$per_page)
        {
            if($start!=$y)
                echo " <a href='searchvideos.php?start=$y'><span class='searchtext'>$i</span></a>";
            else
                echo " <a href='searchvideos.php?start=$y'><span class='searchtext'> <font size='+1'><b>$i</b></font></span></a>";
$i++; 
        }
//show page numbers
        echo " / <font color='#FF6600' size='-1'>$pagenumbers</font>
  </td>
<td align='right' width='50%'>
<form action='../pages/searchvideos.php' method='get'>
<span class='searchtext'>Search Videos</span> <input name='search' type='text' value='by Keywords, Title, Name, or State' size='35' /><input type='submit' name='submit' value='search' />
</form>
</td>
</tr>
</table>
</div>
<br /><br /><div class='videotitle'><span class='createtext'>&nbsp;&nbsp;Videos </span></div>
<br /><br />";

if ($foundnum==0)
echo "No results found.";

else
{
echo "$foundnum results found!<br><br>";

$query = mysql_query("SELECT * FROM video_url ORDER BY RAND() LIMIT $start, $per_page");

while($row = mysql_fetch_array($query))
//while ($numrows = mysql_fetch_assoc($run))
{
$title = $row['title'];
$url = $row['url'];
$state = $row['vid_state'];
$users = $row['users'];

echo "
<table bgcolor='#191919' cellpadding='0' cellspacing='0' background='../images/videobgs.png' align='center'>
<tr>
<td width='10px'></td>
<td width='440px' height='370px' rowspan='6'>
$url
</td>
<td width='340px' align='left'>
&nbsp;&nbsp;<span class='createtext'>$title</span><hr />
&nbsp;&nbsp;$users<br />
&nbsp;&nbsp;$state
</td>
<td width='5px'></td>
</tr>
<tr><td>&nbsp;</td></tr>
<tr><td>&nbsp;</td></tr>
</table><br />";
}
}
}
}
?>
   

I know my code is dirty, and I have a lot to learn, and that I should probably be doing this a different way, but please try to correct the way I have it. 

Anyways..first page loads great, the search works great, the pagination works as it should (correct pages, correct page numbers, etc.).  However, once I click on the "next" or the next "number" the next page is blank because the very first if statement throws a kink in my code...

if ($button) - when continuing to the next page, a "$button" is not pressed and therefore doesn't continue the code, leaving the page blank.

Any clues on how to fix this?  I have tried combining the two in many different ways, this is the best i got so far...

Thanks in advance,
Phantaz

I have a basic pagination class, I have used on several pages of a site I am working on. It works fine on 3 of the pages, but when I try to use it on any other pages, or even a new blank page I wrote, it does not work.

class Pagination {

    public $current_page;
    public $per_page;
    public $total_count;

    public function  __construct($page=1, $per_page=20, $total_count=0) {
        $this->current_page = (int)$page;
        $this->per_page = (int)$per_page;
        $this->total_count = (int)$total_count;
    }

    public function offset(){
        return ($this->current_page - 1) * $this->per_page;
    }

    public function total_pages(){
        return ceil($this->total_count/$this->per_page);
    }

    public function previous_page(){
        return $this->current_page - 1;
    }

    public function next_page(){
        return $this->current_page + 1;
    }

    public function has_prev_page(){
        return $this->previous_page() >= 1 ? true : false;
    }

    public function has_next_page(){
        return $this->next_page() <= $this->total_pages() ? true : false;
    }
That is the pagination class, and this is the code I use to call it, along with some debugging information I am using.
      
        if(isset($_GET['order'])){ $order = $_GET['order']; } else { $order = "id"; }
        if(isset($_GET['orderby'])){ $order_by = $_GET['orderby']; } else { $order_by = "ASC"; }      
            $page = !empty($_GET['page']) ? (int)$_GET['page'] : 1;
            $per_page = 2;
            $sql = mysql_query("SELECT * FROM orders WHERE customerid = 4");
            $result = mysql_fetch_array($sql);
            $total_count = mysql_num_rows($sql);
            //$total_count = Order::count_by_cust(4);
            $pagination = new Pagination($page, $per_page, $total_count);
            $sql = "SELECT * FROM orders WHERE customerid = 4 ORDER BY {$order} {$order_by} ";
            $sql .= "LIMIT {$per_page} ";
            $sql .= "OFFSET {$pagination->offset()}";  
            $orders = Order::find_by_sql($sql); 
            echo "Page:" . $page . "<br />PerPage:" . $per_page . "<br />Total:" . $total_count . "<br />Total Pages:" . $pagination->total_pages();
?>

SOME FOREACH INFORMATION HERE

<?php 
echo "Has Prev Page:" . $pagination->has_prev_page() . "<br />";
echo "Total Pages:" . $pagination->total_pages() . "<br />";
echo "Has Next Page:" . $pagination->has_next_page() . "<br />";

?>
<div id="pagination" style="clear: both; text-align: center;">
    <?php
    if ($pagination->total_pages() > 1){
        if ($pagination->has_prev_page() == 1){
            echo "<a href=\"orders.php?search&uid={$order->customerid}&order={$order}&orderby={$order_by}&page=";
            echo $pagination->previous_page();
            echo "\">&laquo; Previous</a>";
        }

        for($i=1; $i<=$pagination->total_pages(); $i++){
            if($i == $page){
               echo " <span class=\"selected\">{$i}</span> ";
            } else {
            echo " <a href=\"orders.php?search&uid={$order->customerid}&order={$order}&orderby={$order_by}&page={$i}\">{$i}</a> ";
            }
        }

        if ($pagination->has_next_page() == 1){
            echo "<a href=\"orders.php?search&uid=" . $order->customerid . "&order=" . $order . "&orderby=" . $order_by . "&page=";
            echo $pagination->next_page();
            echo "\">Next &raquo;</a>";
        }
    }
    ?>
    </div>


The customer ID is dynamic, but for debugging sake I am using the customer ID of 4. The output of the page has the following informaton:
Page:1
PerPage:2
Total:15
Total Pages:8

Has Prev Page:
Total Pages:8
Has Next Page:1

So i know all the variables are right, the problem is, it only prints a bold "1". Thats all, no numbers, or Next Page option.
However i use the EXACT same code in another couple pages, and it works fine, but with this current page and a few others. It does not work.

I have also tryed extracting just this information into a blank file to just get the page numbers, taking out all the pages other code, and it still only gives me "1".

Any ideas?

Hello everyone.     I have some code that I need some assistance with. By the way I am using CentOS 6.5 on my Linux server.   Here is my current code:  

<html>
  <head></head>
  <body>
  <?php if (!isset($_POST['q'])) { ?>


<img src="/wvb-logo-slogen.png" border="0" /> //code for logo
    <h2>Search</h2>
    <form method="post" action="<?php echo htmlentities($_SERVER['PHP_SELF']); ?>">
      <input type="text" name="q" size="30" />
    </form>

  <?php } else { ?>

<img src="/wvb-logo-slogen.png" border="0" /> //code for logo
    <h2>Search Results</h2>


  <?php
    try {
      // create object
     // $swish = new Swish('/usr/local/apache/htdocs/swish/index.swish-e');
        $swish = new Swish('/var/www/html/pdf2/index.swish-e');


      // get and run query from command-line
      $queryStr = htmlentities($_POST['q']);
      $result = $swish->query($queryStr);
  ?>

   Found <?php echo $result->hits; ?> match(es) for '<?php echo $queryStr; ?>'.

  <?php
      // iterate over result set
      // print details for each match
      while($r = $result->nextResult()) {
   ?>

  <p>
    <?php echo $r->swishreccount; ?>
      <strong>
      <a href="<?php echo '/pdf2', ltrim($r->swishdocpath, '.') ;  ?>">
         <?php echo $r->swishdocpath; ?>
      </a>
   </strong> (sco  <?php echo $r->swishrank; ?>) <br/>
<?php echo $r->swishdocpath; ?><br />

<?php

$file = '/var/www/html/active_colist.csv';
$fh = fopen($file, 'r');
$companies = array();
$row = fgetcsv($fh, 1024); // ignore header
while ($row = fgetcsv($fh, 1024)) {
    $companies[$row[0]] = array('company' => $row[1], 'country' => $row[3]); //changed line
   }
fclose($fh);


//Split a filename  by .
$filenames = explode(".", $r->swishdocpath);
//get 3 chars from $filenames to $country
$wvb_number = substr($filenames[1],1,12);
$country = substr($filenames[1],1,3);
echo 'Country: '.$companies[$wvb_number]['country']."<br />";
//echo 'Country Name: '.$country."<br />";
//$filenames[2] = explode(".", $r->swishdocpath);
$year = substr($filenames[2],0,4);
echo 'Year: '.$year."<br />";
//$filenames = explode(".", $r->swishdocpath);
//$wvb_number = substr($filenames[1],1,12);
echo 'WVB Number: '.$wvb_number."<br />";
echo 'Company Name: '.$companies[$wvb_number]['company'];


?>
 
  </p>


//Suggested Pagination code.

    <?php  
    ///////////////FILLING ARRAY WITH DUMMY DATA////////////////////  
    $key = array();  
    for($i=0; $i<200; $i++)  
    {  
     //fill array data  
     $key[] = "num = ".$i;  
    }  
    ////////////////////////////////////////////////////////////////  
      
    /////////////////////START OF ARRAY PAGINATION CODE/////////////////////  
    $ptemp="http://".$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI'];  
    $pt=explode('&',$ptemp);  
    if (strpos($ptemp,'pageno'))  
     array_pop($pt);  
    $pt=implode('&',$pt);  
    $ptemp=$pt;  
    $array=$key; // REPLACE $KEY WITH YOUR ARRAY VARIABLE  
    $page = $_REQUEST['pageno'];  
      
    $currentpage = isset($page) ? (integer)$page : 1;  
    $numperpage = 10; //NUMBER OF RECORDS TO BE DISPLAYED PER PAGE  
      
    $total = count($array);  
    $numofpages = ceil($total / $numperpage); //TOTAL NUMBER OF PAGES  
      
    if(isset($array))  
    {  
        if (($currentpage > 0) && ($currentpages <= $numofpages))  
     {  
            //STARTING LOOP FOR ARRAY DATA  
            $start = ($currentpage-1) * $numperpage;  
            for($i=$start;$i<=($numperpage+$start-1);$i++)   
      {  
                ///////////PLACE YOUR CODE HERE//////////////////////////  
                echo $array[$i] .'  
    ';  
       ////////////////////////////////////////////////////////  
            }  
     }  
    }  
    if ($currentpage != 1)   
    { //GOING BACK FROM PAGE 1 SHOULD NOT BET ALLOWED  
     $previous_page = $currentpage - 1;  
     $previous = '<a href="'.$ptemp.'?pageno='.$previous_page.'"> <</a> ';      
    }      
    $pages = '';  
    for ($a=1; $a<=$numofpages; $a++)  
    {  
      if ($a == $currentpage)   
     $pages .= $a .'</u> ';  
      else   
     $pages .= '<a href="'.$ptemp.'?pageno='.$a.'" >'. $a .'</a> ';  
    }  
    $pages = substr($pages,0,-1); //REMOVING THE LAST COMMA (,)  
      
    if ($currentpage != $numofpages)   
    { //GOING AHEAD OF LAST PAGE SHOULD NOT BE ALLOWED  
     $next_page = $currentpage + 1;  
     $next = ' <a href="'.$ptemp.'?pageno='.$next_page.'"> ></a>';  
    }  
    echo '  
      
    '. $previous . $pages . $next; //PAGINATION LINKS  
    /////////////////////END OF ARRAY PAGINATION CODE/////////////////////  
    ?>  






  <?php
      }
    } catch (Exception $e) {
      die('ERROR: ' . $e->getMessage());
    }
  }
  ?>

  </body>
</html>

  As you can see from the code above when I implemented that code into my script I was able to get it to display but only after the </p> marker. When I did that I got the following results.   Results:

Found 736 match(es) for 'test'. 1   ./ITA000030192.2013.A.00.L.12.31.PDF   (sco  1000)
./ITA000030192.2013.A.00.L.12.31.PDF
Country: Italian Republic (Italy)
Year: 2013
WVB Number: ITA000030192
Company Name: BEGHELLI
num = 0 num = 1 num = 2 num = 3 num = 4 num = 5 num = 6 num = 7 num = 8 num = 9 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20  > 2   ./ITA000030164.2013.A.00.L.12.31.PDF   (sco  976)
./ITA000030164.2013.A.00.L.12.31.PDF
Country: Italian Republic (Italy)
Year: 2013
WVB Number: ITA000030164
Company Name: CREDITO EMILIANO
num = 0 num = 1 num = 2 num = 3 num = 4 num = 5 num = 6 num = 7 num = 8 num = 9 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20  >

127   ./IND000102048.2012.A.00.E.03.31.PDF   (sco  457)
./IND000102048.2012.A.00.E.03.31.PDF
Country:
Year: 2012
WVB Number: IND000102048
Company Name:
num = 0 num = 1 num = 2 num = 3 num = 4 num = 5 num = 6 num = 7 num = 8 num = 9 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20  > 128   ./NLD000030064.2013.A.00.E.12.28.PDF   (sco  457)
./NLD000030064.2013.A.00.E.12.28.PDF

  The results page shows that there are 736 matches. There are currently 5000 PDF files in the /var/www/html/pdf2 directory.

What I am trying to accomplish in terms of pagination is twofold.

First get the above page links to display on the top and bottom of the page and only display 10 results at a time on each page. Second have the links working correctly so that they can go to the correct results.

Can this be accomplished with the above pagination code where it states //Suggested pagination code? Do I need to change my layout?   Furthermore I was also told that I should focus on the following lines of code:  

    <?php  
    ///////////////FILLING ARRAY WITH DUMMY DATA////////////////////  
    $key = array();  
    for($i=0; $i<200; $i++)  
    {  
     //fill array data  
     $key[] = "num = ".$i;  
    }

  as well as the result variable

      $queryStr = htmlentities($_POST['q']);
      $result = $swish->query($queryStr);

  What would I need to change in these two areas in order to get what it is that I am trying to accomplish. Sorry for the large post. Any assistance would be greatly appreciated.  

Hi Eveyone,

Is it possible in php to remember form data when scrolling through pages set up using pagination?

Usually i use value="<?php echo $_POST['field_name']; ?>" to remember the form data if the submit button has been pressed.

Im trying to get it so that if i fill out a field on page 1, then i go to page 2, if i come back top page 1 the field is still populated. Scrolling through the pages nothing is actually posted so the fields are becoming empty when returning to them.

All help is greatly appreciated.

Thanks