PHP - Extra Pagination Links Don't Show Query Results

Hi,

my page is currently up at brewhas.org/transactions.php.  When I retrieve a set of results > the defined # per page (such as entering 'WI' for last name), I see the first page correctly, and see the links to next pages, but when I go to the next page there are no results displayed.  Same for p.3, etc.

So I've looked around enough to know that I need to pass a variable to the subsequent pages, either via a session variable or the URL.  I have 2 fields input on the form, as well as a limit and offset.  My questions are 1) do I need to pass all 4 and if so then should I use a session variable so the URL does not get too long, and 2) can anyone provide any help with setting session variables and including them to be passed?

I'm a newbie and have grabbed some code where I can but this is where i'm stuck.  thanks in advance.
Code: [Select]
         <?php
               include 'config.php';
               include 'opendb.php';
               $rows_per_page = 20;

                  //Get the values from the text boxes         
                  $fnamesearch = $_POST["fnamesearch"];
                  $lnamesearch = $_POST["lnamesearch"];

                  //These trim and convert the name fields to upper case.
                  $fnamesearch=strtoupper($fnamesearch);
                  $lnamesearch=strtoupper($lnamesearch);
                  $fnamesearch=trim($fnamesearch);
                  $lnamesearch=trim($lnamesearch);
            
                  // Count how many rows are coming back for the query
                  //This checks to see if there are at least 2 chars in the last name.
                  if (strlen($lnamesearch)<2)
                     {
                        echo "<p class='style7'>Please enter at least 2 letters of the last name.</p>";
                        exit;
                     }
                  else  //sets the query to get the number of rows
                     {
                        $query = "SELECT COUNT(*) FROM BKL_TRANSACTIONS WHERE((PLAYER_LNAME LIKE '$lnamesearch%')& (PLAYER_FNAME LIKE '$fnamesearch%'))";
                     }

                  $result = mysql_query($query) or die ("Could not execute the query");   //executes the get count query
                  $query_data = mysql_fetch_row($result);
                  $numrows = $query_data[0];
                  echo "count: ".$numrows;   
                  $lastpage = ceil($numrows/$rows_per_page);      //determines how many pages based on rows divided by rows per page
                  echo "pages: ".$lastpage;

                  // Get required page number.  If not present, default to 1.
                  if (isset($_GET['pageno']) && is_numeric($_GET['pageno'])) 
                     {$pageno = $_GET['pageno'];
                     } 
                  else 
                     {$pageno = 1;
                     } 
                  
                  //Checks that the value of $pageno is an integer between 1 and $lastpage.
                  $pageno = (int)$pageno;
                  if ($pageno > $lastpage) 
                     {$pageno = $lastpage;
                     } 
                  if ($pageno < 1) 
                     {$pageno = 1;
                     }                  
               
                  //constructs OFFSET for the sql SELECT statement
                  $offset = ($pageno - 1) * $rows_per_page;
                  
                  //This checks to see if there are at least 2 chars in the last name.
                  if (strlen($lnamesearch)<2)
                     {
                        echo "<p class='style7'>Please enter at least 2 letters of the last name.</p>";
                        exit;
                     }
                  else  //sets the query to get the number of rows
                     {
                        $query = "SELECT * FROM BKL_TRANSACTIONS WHERE((PLAYER_LNAME LIKE '$lnamesearch%')& (PLAYER_FNAME LIKE '$fnamesearch%')) LIMIT $offset, $rows_per_page";
                     }
      
                  $result = mysql_query($query) or die ("Could not execute the query");   //executes the query
                  //Count the number of results 
                  $numrows=mysql_num_rows($result);
                  
                  echo "<p class='style7'>Your search: &quot;".$fnamesearch." ".$lnamesearch."&quot; returned <b>".$numrows."</b> results.</p>";
                  
                  if ($numrows == 0)  //if no matches, don't display the table 
                        exit;
                  else            //build the table and insert rows 
                     {
                              echo "<table border=1 cellspacing=0 cellpadding=1 width='77%' align=left bordercolor=#666666>";
                              echo "<tr bgcolor=#cccc99 class='style5'><th width='10%' class='style5'>Date</th>";
                              echo "<th width='10%' class='style5'>Action</th>";
                              echo "<th width='12%' class='style5'>From</th>";
                              echo "<th width='12%' class='style5'>To</th>";
                              echo "<th width='5%' class='style5'>Pos</th>";
                              echo "<th width='18%' class='style5'>Name</th>";      
                              echo "<th width='5%' class='style5'>Round</th></tr>";                     
      
                           while ($row = mysql_fetch_array($result))
                           {
                              echo "<tr><td width='10%' class='style6'>".$row['TRANS_DT']."</td>";
                              echo "<td width='10%' class='style6'>".$row['TRANS_ACTION']."</td>";
                              echo "<td width='12%' class='style6'>".$row['FROM_OWNER']."</td>";
                              echo "<td  width='12%' class='style6'>".$row['TO_OWNER']."</td>";
                              echo "<td  width='5%' class='style6'>".$row['POSITION']."</td>";
                              echo "<td  width='18%' class='style6'>".$row['PLAYER_FNAME']." ".$row['PLAYER_LNAME']."</td>";
                              echo "<td  width='5%' class='style6'>".$row['DRAFT_RND']."</td></tr>";
                           }
               
                           /******  build the pagination links ******/   
                           // if not on page 1, don't show back links
                           if ($pageno > 1) {
                              // show << link to go back to page 1
                              echo " <a href='{$_SERVER['PHP_SELF']}?pageno=1'><<</a> ";
                              // get previous page num
                              $prevpage = $pageno - 1;
                              // show < link to go back to 1 page
                              echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$prevpage'><</a> ";
                           }
                           // range of num links to show
                           $range = 3;

                           // loop to show links to range of pages around current page
                           for ($x = ($pageno - $range); $x < (($pageno + $range)  + 1); $x++) {
                              // if it's a valid page number...
                              if (($x > 0) && ($x <= $lastpage)) {
                                // if we're on current page...
                                if ($x == $pageno) {
                                  // 'highlight' it but don't make a link
                                  echo " [<b>$x</b>] ";
                                // if not current page...
                                } else {
                                  // make it a link
                                  echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$x'>$x</a> ";
                                } // end else
                              } // end if 
                           }
                           // if not on last page, show forward and last page links        
                        if ($pageno != $lastpage) {
                           // get next page
                           $nextpage = $pageno + 1;
                           // echo forward link for next page 
                           echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$nextpage'>></a> ";
                           // echo forward link for lastpage
                           echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$lastpage'>>></a> ";
                        } // end if
                        /******  end build pagination links ******/               
                        echo "</table>";
                     }      
                  mysql_free_result($result);    //release the result set from the table
                  mysql_close($conn);          //close the connection to the db
               ?>

MOD EDIT: [code] . . . [/code] tags added.

Hi, thanks for reading this!

I need some help with my pagination, maybe the answer is very simple but I've tried a lot of coding including work with tables but it didn't work

It's about my page (in Dutch) where I show images of collections. A page looks like this: http://www.verzamelaars.net/mobach/index.php
Now I want the name of the collector under the image, but every time I get this:
http://www.verzamelaars.net/mobach/index2.php

The code I use now is:

<?php
while($row = mysql_fetch_array($result))
{
echo "<table><tr><td><a href='{$row['mijnlink']}'><img src={$row['thumb']} hspace=1 vspace=4></a></td></tr>";
echo "<tr><td><a href='{$row['verzamelaarlink']}'>{$row['verzamelaar']}</a></td></tr></table>";
}
?>

I've been playing with the table but so far no good, hope you can help me with this!

Kind regards,
Arjen van Dorsten

HI,

Please forgive my inexperience I am new to php and any help is most apreciated.

I have a database called liveproj and a table named olde_history.

Within the table, Project history is stored. Each project has a unique number ie 10383 etc.
I am trying to display the results for an individual project once the project has been selected.

The structure of the table is as such:

$sql = 'CREATE TABLE IF NOT EXISTS `liveproj`.`olde_history` (
  `History_Id` int(6) NOT NULL AUTO_INCREMENT,
  `History_Project_Id` varchar(10) NOT NULL,
  `History_Department_Id` varchar(25) NOT NULL,
  `History_By` varchar(25) DEFAULT NULL,
  `History_Contact` varchar(25) DEFAULT NULL,
  `History_Date` varchar(10) NOT NULL,
  `History_Description` varchar(500) DEFAULT NULL,
  `History_Action_Owner` varchar(25) DEFAULT NULL,
  `History_Status_Id` varchar(10) DEFAULT NULL,
  `History_Action_Date` varchar(10) DEFAULT NULL,
  `History_Action_Description` varchar(500) DEFAULT NULL,
  `History_Date_Resolved` varchar(10) DEFAULT NULL,
  `History_Email` varchar(150) DEFAULT NULL,
  `History_Minutes` varchar(150) DEFAULT NULL,
  `History_Visit` varchar(150) DEFAULT NULL,
   PRIMARY KEY (`History_Id`)
)';

A snippet of the table structure
I can View all information based on all projects and this works fine althoughh I only wish to display the relevent info for a selected project.

The error code I get is as follows:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-10,10' at line 1

My code is:


Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Live Project List</title>
<link href="../css/Style.css" rel="stylesheet" type="text/css" />
<style type="text/css"></style>
</head>
<body id="body">

<div align="center" id="Section">Project History List
  <div id="apDiv1">
    <form id="form1" name="form1" method="post" action="">
      <input type="text" name="Search" id="Search" size="20" />
      <img src="../Images/search.png" width="24" height="24" align="middle" />
    </form>
  </div>
</div>
<table class="hovertable">
  <tr>
    <th width="10%">Date:</th>
    <th width="10%">By:</th>
    <th width="30%">History Description:</th>
    <th width="5%">Action Status:</th>
    <th width="5%">Action Owner:</th>
    <th width="10%">Action Rqd Date</th>
    <th width="10%">Action Description:</th>
    <th width="10%">Date Resolved:</th>
    <th width="5%">View:</th>
    <th width="5%">Edit:</th>
  </tr>

<?php
###############################################################################
# Start of pagination script
###############################################################################

IF (ISSET($_GET['pageno'])) {
   $pageno = $_GET['pageno'];
} ELSE {
   $pageno = 1;
} // if

###############################################################################
# 2. Identify how many database rows are available
############################################################################### 

# This code will count how many rows will satisfy the current query.

session_start();
include "../scripts/connect.php";
include "../scripts/Inc/db_lp.php";
//$disc = $_SESSION['Disc'];
$quote='"';
$projno2 = $_SESSION['Project'];
$projno = "$quote$projno2$quote";

$query = "SELECT count(*) FROM `liveproj` . `olde_history` WHERE `History_Id` = '$projno'";
//$query = "SELECT count(*) FROM `liveproj` . `olde_history` WHERE `History_Id` <> ''"; //WORKING LINE

$result = mysql_query($query) or die(mysql_error());
$query_data = MYSQL_FETCH_ROW($result);
$numrows = $query_data[0];

PRINT "NUMROWS: $numrows<br>";

###############################################################################
# 3. Calculate number of $lastpage
############################################################################### 
 
# This code uses the values in $rows_per_page and $numrows in order to identify the number of the last page.
 
$rows_per_page = 10; ######## Set the ammount of rows you wish to display per page #########
$lastpage = CEIL($numrows/$rows_per_page);

###############################################################################
# 4. Ensure that $pageno is within range
###############################################################################  

# This code checks that the value of $pageno is an integer between 1 and $lastpage.
 
$pageno = (int)$pageno;
IF ($pageno < 1) {
   $pageno = 1;
} ELSEIF ($pageno > $lastpage) {
   $pageno = $lastpage;
} // if
 
###############################################################################
# 5. Construct LIMIT clause
###############################################################################   

# This code will construct the LIMIT clause for the sql SELECT statement.
 
$limit = 'LIMIT ' .($pageno - 1) * $rows_per_page .',' .$rows_per_page;
 
###############################################################################
# 6. Issue the database query
###############################################################################  

# Now we can issue the database query and process the result.

$query = "SELECT * FROM `liveproj` . `olde_history` $limit";

$result = mysql_query($query) or die(mysql_error()); 

#... process contents of $result ...
 
     WHILE ($row = MYSQL_FETCH_ARRAY($result)) {
 
echo '<tr onmouseover="this.style.backgroundColor=\'#CCCCCC\';" onmouseout="this.style.backgroundColor=\'#ffffff\';"><td width="10%">';
echo $row["History_Date"]; 
echo "</td>";
echo '<td width="10%" >';
echo $row["History_By"];
echo "</td>";
echo '<td width="30%">';
echo "" . substr($row['History_Description'],0,20) . ".....[Select View To Read More]" ; 
//echo $row["History_Description"];
echo "</td>";
echo '<td width="5%">'; 
echo $row["History_Status_Id"];
echo "</td>";
echo '<td width="5%">'; 
echo $row["History_Action_Owner"];
echo "</td>";
echo '<td width="10%">'; 
echo $row["History_Action_Date"];
echo "</td>";
echo '<td width="10%">'; 
//echo $row["History_Action_Description"]; 
echo "" . substr($row['History_Action_Description'],0,20) . ".....[Select View To Read More]" ; 
echo "</td>";
echo '<td width="10%">';
echo $row["History_Date_Resolved"]; 
echo "</td>";
echo '<td width="5%">'; 
echo "<div class=form>"; 
echo '<form id="form" name="form" method="post" action="Doc_History_Desc.php" onSubmit="return confirm(';
echo '">';
echo '<input type="hidden" name="histid" value="';
echo $row["History_Id"];
echo '"><input type="image"SRC="../Images/Icons/List-View.png" Height="22" Width="22" value="View" alt="submit" class="hidebutton" name="B1">';
//echo '"><input type="submit" value="View" name="B1">';
echo "</form>";
echo "</td>";
echo '<td width="5%">'; 
echo "<div class=form>"; 
echo '<form id="form" name="form" method="post" action=".php" onSubmit="return confirm(';
echo '">';
echo '<input type="hidden" name="histid" value="';
echo $row["History_Id"];
echo '"><input type="image"SRC="../Images/Icons/List-Edit.png" Height="22" Width="22" value="View" alt="submit" class="hidebutton" name="B1">';
//echo '"><input type="submit" value="View" name="B1">';
echo "</form>";
echo "</td>";
echo "</tr>";

} 

?>
 
</table>
<p><br />
  <br />
</p>

<?php
###############################################################################
# 7. Construct pagination hyperlinks
###############################################################################  

# Finally we must construct the hyperlinks which will allow the user to select 
# other pages. We will start with the links for any previous pages.

echo '<div align="center" id="SectionEnd">'; 
IF ($pageno == 1) {
   echo "<font size='1' color='#FFFFFF'>FIRST | PREV</font>";

} ELSE {
   echo " <a href='{$_SERVER['PHP_SELF']}?pageno=1'>FIRST</a>";

   $prevpage = $pageno-1;
   echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$prevpage'>PREV</a>";
} // if
 
 
# Next we inform the user of his current position in the sequence of available pages.
 
echo " <font size='1' color='#FFFFFF'>( Page $pageno of $lastpage )</font> ";
 
# This code will provide the links for any following pages.
 
IF ($pageno == $lastpage) {
   echo "<font size='1' color='#FFFFFF'>NEXT | LAST</font>";
} ELSE {
   $nextpage = $pageno+1;
   echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$nextpage'>NEXT</a>";
   echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$lastpage'>LAST</a>";
} // if
echo'<br/>'; 
echo'<br/>'; 
echo'</div>'; 

###############################################################################
# End of pagination script
###############################################################################
?>

</body>
</html>




Thankyou in advance.

Hello

I was wondering if anyone could help me.
 


I have bought a script that are encoded is something that i cant change or read, and i have ask the owner how to put a {user} at the end of every hyperlink
so are going to a other site, but he said you need a external script to do that. So was wondering if anyone could help me.

Im using a database where all the user are etc

But If i go to google.com and login as Bobmartin

I will be at google.com/home

Then i click on a hyperlink inside google.com/home that will bring me to a other side

Lets say the hyperlink (other site) is www.phpfreaks.com/profile/

So when i begining to redirect to www.phpfreaks.com/profile/ the script will add {user} from the database

So at the end i will be redirect to www.phpfreaks.com/profile/Bobmartin


The hyperlink is generated in a unique code so i cant just add {user} it must be a external script i need to use.


So to say it fast

I want to add /{user} for every hyperlink that is redirect to another site without add {user} direct to the hyperlink for example www.google.com/{user}, the hyperlink must me www.google.com



Well i hope you guys understand  this, im not the best person to explain things so

Also my english suck so dont judge me