How Do I Add Constant Values To Pagination Script?

A

Anonymous

Guest
Here is a pagination script that works great with only one input
variable sent to the script via a form. However, I now have
more input variables being sent to the form. The script grabs
all the new input variables one time and the script runs fine
on page one. The problem is the new input variables are not
stored in the script like the [SeeAlso] variable and thus the
new input variables lose their value after the script runs one
time on page one. When the script processes to page 2 and higher,
the only value available to the script is the [SeeAlso] variable
value because the [SeeAlso] value has been preserved in the
script. What I need to know is how to preserve the other input
values sent to the script from the form.

Code: 
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
</HEAD>
<BODY>
<form>
<font size="2" face="Arial"><b>
</form>

<?p>

//sample input if all checkboxes are checked and EEE is the search 
//term in the input box
//Array ( [TR] => ON [ES] => ON [NV] => ON [TH] => ON [SM] => ON [EN] => ON [ALL] => ON [SeeAlso] => EEE )

//here are the variables containing values 
//sent to the script from the form
$ES = $_GET['ES']; 
$NV = $_GET['NV']; 
$TR = $_GET['TR']; 
$TH = $_GET['TH']; 
$SM = $_GET['SM']; 
$EN = $_GET['EN']; 
$ALL = $_GET['ALL']; 
$SeeAlso = $_GET['SeeAlso']; 


    $username = "theusual";
    $password = "herewego";
    $dbname = "ouchouchouch";
    $global_db = mysql_connect('localhost', $username, $password);
    mysql_select_db($dbname, $global_db);


$query = "SELECT * FROM `View2` WHERE `Topic` REGEXP '[[:<:]]($SeeAlso)[[:>:]]'";

//These code lines append to the $query


//On page two and higher these values are
//wiped out and the SELECT statement no longer
//has the Source appended to the SELECT statement

//I want to preserve these values in the script like
//the script preserves the [SeeAlso] value

  if(!empty($ES)){ 
   $ES = "'ES'"; 
   $query = $query . " AND `Source`={$ES}"; 
   } 

  if(!empty($TH)){ 
  $TH = "'TH'"; 
  $query = $query . " AND `Source`={$TH}"; 
  } 
  
  if(!empty($SM)){ 
  $SM = "'SM'"; 
  $query = $query . " AND `Source`={$SM}"; 
  } 

  if(!empty($NV)){ 
  $NV = "'NV'"; 
  $query = $query . " AND `Source`={$NV}"; 
  } 

  if(!empty($TR)){ 
  $TR = "'TR'"; 
  $query = $query . " AND `Source`={$TR}"; 
  } 

  if(!empty($EN)){ 
  $EN = "'EN'"; 
  $query = $query . " AND `Source`={$EN}"; 
  } 

    
    $result = mysql_query($query) or die("ERROR63");
    $num_record = mysql_num_rows($result);
    if($num_record > $display) { // Only show 1,2,3,etc. when //there are more records found that fit on 1 page
    // when the page is loaded first...
    if(empty($pagenr)) { 
    $pagenr = 1;
    }
    // some variables
    $display = 10; // number of records to display per page
    $max_pages_to_print = 7; // number of pages to show, if you change this you also have to change the variable 'middlenumber', for example:increase this one with two, increase middlenumber with one
    $startrecord = $pagenr * $display; // f$displayirst record to show from the queryresult
    $num_pages = (ceil($num_record/$display)); //set number of pages
    $loopcounter = 0; // counter for whileloop
    $currentpage = $pagenr; // Page where we are at the moment
    $middlenumber = 3; // Number will be decreased from variable currentpage in order to get the currentpage always in the middle
    $colourcounter = 0; // Variable to change the background-color of the <td>
    $i = 1; // variable that will print 1,2,3,etc..
    $x = 0; // variable i use to put always the current, marked page in the middle

echo "<div align=\"center\">\n";
echo "  <center>\n";
echo "  <table border=\"1\" width=\"700\" height=\"25\" cellspacing=\"1\" bgcolor=\"#D8E0F0\">\n";
echo "    <tr>\n";
echo "      <td colspan=\"2\" valign=\"middle\" align=\"center\" bgcolor=\"#0000c8\" width=\"690\">\n";
echo "        <p align=\"center\"><font face=\"Arial\" color=\"#FFFFFF\">Retrieval Data</font></td>\n";
echo "    </tr>\n";
echo "    <tr>\n";
echo "      <td width=\"248\"><font face=\"Arial\" size=\"2\">Search Term:</font></td>\n";
echo "      <td width=\"436\"><font face=\"Arial\" size=\"2\">$SeeAlso</font></td>\n";
echo "    </tr>\n";
echo "    <tr>\n";
echo "      <td width=\"248\"><font face=\"Arial\" size=\"2\">Current Page</font></td>\n";
echo "      <td width=\"436\"><font face=\"Arial\" size=\"2\">$currentpage</font></td>\n";
echo "    </tr>\n";
echo "    <tr>\n";
echo "      <td width=\"248\"><font face=\"Arial\" size=\"2\">Total Pages Retrieved:</font></td>\n";
echo "      <td width=\"436\"><font face=\"Arial\" size=\"2\">$num_pages</font></td>\n";
echo "    </tr>\n";
echo "    <tr>\n";
echo "      <td width=\"248\"><font face=\"Arial\" size=\"2\">Total Citations Retrieved:</font></td>\n";
echo "      <td width=\"436\"><font face=\"Arial\" size=\"2\">$num_record</font></td>\n";
echo "    </tr>\n";
echo "  </table>\n";
echo "  </center>\n";
echo "</div>\n";

    // actual stuff starts here
    print("<table border=0 align=center><tr>");
    if($currentpage >= $max_pages_to_print) {
print '<td><a href="' . $_SERVER['PHP_SELF'] . '?pagenr=' . $i . '&SeeAlso=' . $_GET['SeeAlso'] . '">' . $i . '</a> &nbsp</td>' ; // print pagenumbers 
        }
    //BEGIN LOOP
    while($loopcounter < $max_pages_to_print) { 
    if($currentpage >= $max_pages_to_print) { // If user clicks om page higher than $max_pages_to_print
    // Mark current page
    if($currentpage == $i) {
    print '<td><a href="' . $_SERVER['PHP_SELF'] . '?pagenr=' . $i . '&SeeAlso=' . $_GET['SeeAlso'] . '">' . $i . '</a> &nbsp</td>' ; // print pagenumbers 
    $i += 1; //increase pagenr
    $loopcounter += 1; // increase loopcounter
    }
    // End marking
    if($i > $num_pages) { // if last page has been printed, exit loop
    break;
    }
    if($x == 0) {
    $i = $currentpage - $middlenumber; // current page will always be printed in the middle
    }
    print '<td><a href="' . $_SERVER['PHP_SELF'] . '?pagenr=' . $i . '&SeeAlso=' . $_GET['SeeAlso'] . '">' . $i . '</a> &nbsp</td>' ; // print pagenumbers 
    $x = $x + 1;
    $i += 1; //increase pagenr
    $loopcounter += 1; // increase loopcounter
    }
    else { // Else user clicks on a pagenumber lower $max_pages_to_print
    // Mark current page
    if($currentpage == $i) {
    print '<td><a href="' . $_SERVER['PHP_SELF'] . '?pagenr=' . $i . '&SeeAlso=' . $_GET['SeeAlso'] . '">' . $i . '</a> &nbsp</td>' ; // print pagenumbers 
    $i += 1; //increase pagenr
    $loopcounter += 1; // increase loopcounter
    }
    // End marking
    if($i > $num_pages) { // if less than $max_mages_to_print, exit loop
    break;
    }
    print '<td><a href="' . $_SERVER['PHP_SELF'] . '?pagenr=' . $i . '&SeeAlso=' . $_GET['SeeAlso'] . '">' . $i . '</a> &nbsp</td>' ; // print pagenumbers 
    $i += 1; //increase pagenr
    $loopcounter += 1; // increase loopcounter
    } // End if
    } 
    // END LOOP
    if(($num_pages > $max_pages_to_print AND // notice the user that there are more pages
        $i <= $num_pages)) {
    print '<td><a href="' . $_SERVER['PHP_SELF'] . '?pagenr=' . $i . '&SeeAlso=' . $_GET['SeeAlso'] . '">' . $i . '</a> &nbsp</td>' ; // print pagenumbers 
    }
    print("</tr></table>");
    $startrecord = $startrecord - $display; // Set startrecord to the right position
    // Some calculation for the lastrecord
    if($currentpage == $num_pages) { // Last page...
    $lastrecord = $num_record; // so $lastrecord = $num_record
    }
    else {
    $lastrecord = ($currentpage * $display);
    }
    } // End of the first if-statement


    // actual query, watch the end($startrecord, $display)
  

$query2 = "$query1 LIMIT $startrecord, $display";



 $result2 = mysql_query($query2) or die("ERROR148");
    
    
    // print results on screen

      print("<table border=1 align=center width=700 bgcolor=#0000c8 style=\"font-family: Arial; font-weight: bold\" cellpadding=\"1\" cellspacing=\"1\" font face=Arial><tr><td align=center><font color=#FFFFFF><b>Source</b></font></td><td align=center><font color=#FFFFFF><b>Topic</b></font></td><td align=center><font color=#FFFFFF><b>Subtopic</b></font></td><td align=center><font color=#FFFFFF><b>References</b></font></td></tr>");

    $Source="Source";
    $Topic="Topic";
    $Subtopic="Subtopic";
    $References="References";
    while(list($Source, $Topic,$Subtopic,$References)= mysql_fetch_row($result2)) {
    if ($colorcounter == 0) {
    $colorbg = "#d8e0f0";    
    }
    else {
    $colorbg = "#e6eaf4";
    $colorcounter = $colorcounter - 2;
    }
    //<td><font size="1">cat</font></td>

      print("<tr><td bgcolor=$colorbg><font size=\"1\">$Source</font></td><td align=left bgcolor=$colorbg><font size=\"1\">$Topic</font></td><td align=left bgcolor=$colorbg><font size=\"1\">$Subtopic</font></td><td align=left bgcolor=$colorbg><font size=\"1\">$References</font></td></tr>");

    //print("<tr><td bgcolor=$colorbg><font size=\"1\">$Topic</font></td><td align=left     bgcolor=$colorbg><font size=\"1\">$Subtopic</td><td align=left bgcolor=$colorbg><font size=\"1\">$References</td></tr>");


    $colorcounter = $colorcounter + 1;
    }
    print("</table>");

  ?>

</body>

</HTML>
 
i'vent read your script, but in general, a paging script must forward all the GET variables, and if there are any post variables, there should be a way to propogate them as well..
Now check that with your script !!!
probably you've got the solution... :-D
 
Solution found:

$sql = "SELECT *
FROM `View2`
WHERE `Topic` REGEXP 'AAA'
AND (
`Source` = 'ES'
OR `Source` = 'NV'
OR `Source` = 'TH'
OR `Source` = 'SM'
OR `Source` = 'TR'
OR `Source` = 'EN'
)";
 
You must log in or register to reply here.
Back
Top