Jump to content

How do i retain the value when i press the next page of the paging page?

bilis_money

By bilis_money
in PHP Coding Help

 Share

Recommended Posts

bilis_money Advanced Member

bilis_money

Posted
Posted

Hi guys

could you assist me.

 

I'm trying to fix this page below,

http://www dot golem dot cc/big-list2.php

 

as you can see there is a form below the page.

which you can select Filter by Team or Division.

 

now let say i select by division, now how it will retain that value "Filter by Division"

specially if i click the next page then the next page etc... etc...

 

It should display only the "Filter page by division" records with the chosen value consistently at any page. how?

 

any detailed but simple explanation?

 

thank you very much.

 

 

 

Link to comment
Share on other sites
bilis_money Advanced Member

bilis_money

Posted
  • Author
Posted 

<?php
###################
#          Display big photos          #
###################
include "opendb.php";


//function for popup image.


####################################################
#  					 P   A  G  I   N  G    start						    #
####################################################			
// how many rows to show per page

//Do this expression only if row not set
/*
if(!isset($_POST['row'])) {
	$rowsPerPage = 25;
	$xpose_Rec = $rowsPerPage;
	}
*/

	$rowsPerPage = 25;
	$xpose_Rec = $rowsPerPage;

$i = 1;
// by default we show first page
$pageNum = 1;
$cnt=1;

#$tmp_row = ($_POST['row']);	
$tmp_row = (int)($_POST['row']);
$_SESSION['tmp_row2'] = $tmp_row;

//storing session variables from form to session if submitted from form
//Do this if from form submit
/*
if(isset($_POST['row'])) {
	$_SESSION['row2'] = $_POST['row'];
	//retrieving from session.                     
	$tmp_row = $_POST['row2'];
}
*/

#	if($tmp_row==25) {
	if($_SESSION['tmp_row2']==25) {
		$rowsPerPage=25;
		$xpose_Rec = $rowsPerPage;
		}

# if($tmp_row==50) {
		if($_SESSION['tmp_row2']==50) {
		$rowsPerPage=50;
		$xpose_Rec = $rowsPerPage;
		}


echo "rowsPerPage: " . $rowsPerPage;
echo " xpose_Rec: " . $xpose_Rec;

//row per page
#if( $_GET['rowsPerPage'] )
#$rowsPerPage = (int)($_GET['rowsPerPage']);

// if $_GET['page'] very important baby
if(isset($_GET['page']))
{
	$pageNum = $_GET['page'];
}	

// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;
$ctr=0;

$query  = "SELECT * FROM cclp_players LIMIT $offset, $xpose_Rec";
$result = mysql_query($query) or die('Error, query failed');
// print the student info in table
echo "<div align='center'>";	
echo "<p>";

//get default directories
//www.golem.cc/dev/tmt/images/teams
//echo ('<a href="img_info.php?current_file='.$current_file.'"><img src="'.$current_img.'" border="1"><h1> </h1></a>');
$images_dir = 'http://' . $_SERVER['HTTP_HOST'] . '/dev/tmt/images/teams/';
$images_dir2 = 'http://' . $_SERVER['HTTP_HOST'] . '/dev/tmt/images/';
$images_pic2 = $images_dir2 . "golemavatar.gif";	
$cnt2=0;	

echo "<table border='0' width='700px' cellspacing='0' cellpadding='0' bgcolor=''>";	
while(list($id, $lname, $fname, $birthday, $email, $hphone, $wphone, $address, $teamid, $position, $number, $info, $taglia, $sport1, $sport2, $sport3, $citta, $likedin, $photo) = mysql_fetch_array($result)) {
		$images_pic = $images_dir . $photo;
		if($cnt2==5) { 
			echo "<tr>"; 
			}
			echo "<td width='20px' valign='top'>";
				//display the image
				//<a href="'.$images_pic[""].'" onmouseover="alert("'.$images_pic["what_ever"].'")>
				if($photo!=""){
					echo ('

					<a href="'.$images_pic[""].'">
					<img src="'.$images_pic.'" alt="testing" width="118" height="118" border="2"/></a>');
					}
				//display temporary image if $photo is empty.
				if($photo==""){
					echo ('<img src="'.$images_pic2.'" width="118" height="118" border="2"/>');
					}
			echo "<b><br>$lname</b>";
			echo "</td>";
			$cnt2++;
		if($cnt2==5) { 
			echo "</tr>"; 
			$cnt2=0;
			}
	}
echo "</table>";
echo "</div>";
echo "</p>";	
echo "<br>";


#######################
#   Displaying previous and next links  #
#######################

// how many rows we have in database
$query   = "SELECT COUNT(id) AS numrows FROM cclp_players";
$result  = mysql_query($query) or die('Error, query failed');
$row     = mysql_fetch_array($result, MYSQL_ASSOC);
$numRows = $row['numrows'];

// how many pages we have when using paging?
$maxPage = ceil($numRows/$xpose_Rec);
$self = $_SERVER['PHP_SELF'];

// creating 'previous' and 'next' link
// plus 'first page' and 'last page' link
// print 'previous' link only if we're not
// on page one
if ($pageNum > 1)
{
	$page = $pageNum - 1;
	$prev = " <a href=\"$self?page=$page\">[Prev]</a> ";
	$first = " <a href=\"$self?page=1\">[First Page]</a> ";
}
else
{
	$prev  = ' [Prev] ';       // we're on page one, don't enable 'previous' link
	$first = ' [First Page] '; // nor 'first page' link
}
// print 'next' link only if we're not
// on the last page
if ($pageNum < $maxPage)
{
	$page = $pageNum + 1;
	$next = " <a href=\"$self?page=$page\">[Next]</a> ";
	$last = " <a href=\"$self?page=$maxPage\">[Last Page]</a> ";
}
else
{
	$next = ' [Next] ';      // we're on the last page, don't enable 'next' link
	$last = ' [Last Page] '; // nor 'last page' link
	}
// print the page navigation link
echo "<center>";
echo $first . $prev . " Page <strong>$pageNum</strong> of <strong>$maxPage</strong> " . $next . $last;
echo "</center>";
####################################################
#					P   A   G   I   N   G   stop						    #
####################################################
echo "<br>";

?>


<form method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>">
  <table align="center" border="0" width="650">
    <tr>
      <td width="475" colspan="4" bgcolor="#00FF00"><b>Browse by number of rows.</b></td>
    </tr>
    <tr>
      <td width="118" bgcolor="#FFFF00">
        <p align="center"><input type="radio" value="25" name="row">
	5 rows
  </td>
      <td width="119" bgcolor="#FFFF00">
        
  </td>
      <td width="119" bgcolor="#FFFF00">
        <p align="center"><input type="radio" value="50" name="row">
	10 rows
  </td>
      <td width="119" bgcolor="#FFFF00">
        
  </td>
    </tr>
    <tr>
      <td width="475" colspan="4" bgcolor="#00FF00"><b>Filter</b></td>
    </tr>
    <tr>
      <td width="118" bgcolor="#FFFF00">
        <p align="center">
	<select size="1" name="team">
		<option value="admin">admin</option>
		<option value="Alcatel-Lucent">Alcatel-Lucent</option>			
		<option value="astray stars">astray stars</option>			
		<option value="Hp">Hp</option>			
		<option value="Ibm">Ibm</option>			
		<option value="Scc">Scc</option>			
		<option value="Sun">Sun</option>			
		<option value="Etnoteam">Etnoteam</option>						
		<option value="T-Systems">T-Systems</option>						
		<option value="Yahoo!">Yahoo!</option>
		<option value="Fastweb">Fastweb</option>						
		<option value="Hyperion">Hyperion</option>			
		<option value="Arinso">Arinso</option>			
		<option value="Bosch">Bosch</option>			
		<option value="Google">Google</option>			
		<option value="Atos Origin NY">Ato Origin NY</option>			
		<option value="Sap">Sap</option>			
		<option value="Getronics">Getronics</option>						
		<option value="Esprinet">Esprinet</option>						
		<option value="3talia">Sas</option>
		<option value="Dell">Dell</option>						
		<option value="Acer">Acer</option>			
		<option value="Microsoft">Microsoft</option>			
		<option value="Symantec">Symantec</option>			
		<option value="Nortel">Nortel</option>			
		<option value="3ltalia Roma">3ltalia Roma</option>			
		<option value="Sas Roma">Sas Roma</option>			
		<option value="Reply">Reply</option>						
		<option value="Novartis">Novartis</option>						
		<option value="Atos Origin Roma">Atos Origin Roma</option>
		<option value="Microsoft Roma">Microsoft Roma</option>			
		<option value="Wind">Wind</option>
		<option value="Cisco Roma">Cisco Roma</option>			
		<option value="Computer Associates">Computer Associates</option>						
		<option value="divadmin">divadmin</option>
		<option value="CocaCola">CocaCola</option>			
		<option value="Nivea">Nivea</option>
		<option value="JpMorgan">JpMorgan</option>			
		<option value="Peugeot">Peugeot</option>						
		<option value="Henkel">Henkel</option>
		<option value="Henkel L.A.">Henkel L.A.</option>			
		<option value="Heineken">Heineken</option>
		<option value="Hacette Rusconi">Hacette Rusconi</option>			
		<option value="Warner Bros">Warner Bros</option>
		<option value="Saratoga Sforza">Saratoga Sforza</option>			
		<option value="Mondadori Multicenter">Mondadori Multicenter</option>
		<option value="Continental">Continental</option>			
		<option value="Sony BMG">Sony BMG</option>						
		<option value="LaFeltrinelli">LaFeltrinelli</option>
		<option value="General Electric">General Electric</option>			
		<option value="Vigili">Vigili</option>
		<option value="UBM">UBM</option>			
		<option value="Fullsix">Fullsix</option>						
		<option value="Bourse de Lux">Bourse de Lux</option>
		<option value="BPM">BPM</option>			
		<option value="Banca Intesa">Banca Intesa</option>
		<option value="Pwc">Pwc</option>			
		<option value="Vodafone">Vodafone</option>						
		<option value="Edison">Edison</option>
		<option value="Kraft">Kraft</option>
		<option value="McDonald s">McDonalds</option>
		<option value="Aurora Assicurazioni">Aurora Assicurazioni</option>			
		<option value="Nestle">Nestle</option>			
		<option value="Kyneste">Kyneste</option>			
		<option value="Mc Donald Roma">Mc Donald Roma</option>
		<option value="Reply Roma">Reply Roma</option>
		<option value="Ibm Software">Ibm Software</option>
		<option value="Enel">Enel</option>			
		<option value="Cisco Systems">Cisco Systems</option>
		<option value="Maks Finance IT Finesco">Maks Finance IT Finesco</option>
		<option value="Heinz">Heinz</option>
		<option value="Emc">Emc</option>			
		<option value="Agos">Agos</option>			
		<option value="Galbani">Galbani</option>			
		<option value="Mc Donald">Mc Donald</option>
		<option value="Integra">Integra</option>
		<option value="Guardamagna">Guardamagna</option>
		<option value="HSBC">HSBC</option>			
		<option value="Danske Bank">Danke Bank</option>
		<option value="Natixis">Natixis</option>
		<option value="UBP">UBP</option>
		<option value="Mc Donalds A">Mc Donalds A</option>			
		<option value="Mc Donalds B">Mc Donalds B</option>			
		<option value="Mc Donalds C">Mc Donalds C</option>			
		<option value="Mc Donalds D">Mc Donalds D</option>
		<option value="Saramaldi [bW]">Saramaldi [bW]</option>
		<option value="l14 dell Apocalisse [bW]">l14 dell Apocalisse [bW]</option>
		<option value="l Cacciatori [bW]">l Cacciatori [bW]</option>			
		<option value="Bassotti Sassi">Bassotti Sassi</option>
		<option value="Saramaldi [DB]">Saramaldi [DB]</option>			
		<option value="l14 dell Apocalisse [DB]">l14 dell Apocalisse [DB]</option>
		<option value="l Cacciatori [DB]">l Cacciatori [DB]</option>			
		<option value="Bassotti Sassi [DB]">Bassotti Sassi [DB]</option>
		<option value="Saramaldi [GK]">Saramaldi [GK]</option>			
		<option value="l 14 dell Apocalisse [GK]">l 14 dell Apocalisse [GK]</option>
		<option value="Cacciatori [GK]">Cacciatori [GK]</option>			
		<option value="Bassotti Sassi [GK]">Bassotti Sassi</option>
		<option value="Saramaldi [bV]">Saramaldi [bV]</option>
		<option value="l 14 dell Apocalisse [bV]">l 14 dell Apocalisse [bV]</option>
		<option value="l Cacciatori [bV]">l Cacciatori [bV]</option>			
		<option value="Bassotti Sassi [bV]">Bassotti Sassi [bV]</option>
		<option value="Saramaldi [C]">Saramaldi [C]</option>			
		<option value="l 14 dell Apocalisse [C]">l 14 dell Apocalisse [C]</option>
		<option value="l Cacciatori [C]">l Cacciatori [C]</option>			
		<option value="Bassotti Sassi [C]">Bassotti Sassi [C]</option>
		<option value="Alcatel-Lucent Volley">Alcatel-Lucent Volley</option>			
		<option value="Yahoo! Volley">Yahoo! Volley</option>
		<option value="Fullsix Volley">Fullsix Volley</option>
		<option value="Etnoteam Volley">Etnoteam Volley</option>			
		<option value="Affinion International">Affinion International</option>
		<option value="Danone">Danone</option>			
		<option value="l 14 dell\'Apocalisse (GK)">l 14 dell\'Apocalisse (GK)</option>
		<option value="l Cacciatori (GK)">l Cacciatori (GK)</option>			
		<option value="Bassotti Sassi (GK)">Bassotti Sassi (GK)</option>
		<option value="Saramaldi (GK)">Saramaldi (GK)</option>			
		<option value="Radio Italia">Radio Italia</option>
		<option value="Rtl 102.5">Rtl 102.5</option>
		<option value="Mtv">Mtv</option>
		<option value="Radio Deejay">Radio Deejay</option>			
		<option value="Secondamano.it">Secondamano.it</option>
		<option value="Philip Morris">Philip Morris</option>			
		<option value="Ibm Software">Ibm Software</option>
		<option value="Emc2">Emc2</option>			
		<option value="Exprivia">Exprivia</option>
		<option value="All Music">All Music</option>			
		<option value="Cutaway">Cutaway</option>
		<option value="Autogrill">Autogrill</option>


	</select>
	</p>		
  </td>
      <td width="119" bgcolor="#FFFF00">
        <p align="left">By Team</td>	  
  </td>
      <td width="119" bgcolor="#FFFF00">
        <p align="center">
	<select size="1" name="division">
		<option value="Girone A">Girone A</option>
		<option value="CHIP Mi-Japan">CHIP Mi-Japan</option>
		<option value="Golem">Golem</option>
		<option value="cestino">cestino</option>
		<option value="CHIP Mi-Emea">CHIP Mi-Emea</option>
		<option value="CHIP Roma">CHIP Roma</option>
		<option value="CHIP Mi-F">CHIP Mi-F</option>
		<option value="MAC OS X">MAC OS X</option>
		<option value="IBM OS/2">IBM OS/2</option>
		<option value="VISTA">VISTA</option>
		<option value="chip Mi-D">chip Mi-D</option>
		<option value="CHIP Mi-E">CHIP Mi-E</option>
		<option value="CHIP Mi-H">CHIP Mi-H</option>
		<option value="Girone C">Girone C</option>
		<option value="Girone D">Girone D</option>
		<option value="CHIP Mi-G">CHIP Mi-G</option>
		<option value="CLIGA-MI Spring">CLIGA-MI Spring</option>
		<option value="Corporate Liga Play Off">Corporate Liga Play Off</option>
		<option value="Play Off Roma">Play Off Roma</option>
		<option value="Champions Chip 07">Champions Chip 07</option>
		<option value="CorporateLiga7">CorporateLiga7</option>
		<option value="Corporate Liga Roma 07">Corporate Liga Roma 07</option>
		<option value="Champion\'s Chip Roma 07">Champion\'s Chip Roma 07</option>
		<option value="CorporateLiga5">CorporateLiga5</option>
		<option value="CLIGA 5A">CLIGA 5A</option>
		<option value="CLIGA 5B">CLIGA 5B</option>
		<option value="CHIP Roma-A">CHIP Roma-A</option>
		<option value="CHIP Roma-B">CHIP Roma-B</option>
		<option value="CLIGA 7A">CLIGA 7A</option>
		<option value="CLIGA 7B">CLIGA 7B</option>
		<option value="Olimpix-MC">Olimpix-MC</option>
		<option value="Finance 4 Lux">Finance 4 Lux</option>
		<option value="CHIP Mi-G">CHIP Mi-G</option>
		<option value="CHIP Mi-H">CHIP Mi-H</option>
		<option value="Olimpix-Beach">Olimpix-Beach</option>
		<option value="Olimpix-DodgeBall">Olimpix-DodgeBall</option>
		<option value="Olimpix-Calcetto">Olimpix-Calcetto</option>
		<option value="Olimpix-Kart MI">Olimpix-Kart MI</option>
		<option value="Olimpix-Bowling">Olimpix-Bowling</option>
		<option value="Silicon Volley">Silicon Volley</option>
		<option value="GolemCup A">GolemCup A</option>
		<option value="GolemCup B">GolemCup B</option>			
		<option value="PlayOff Chip Milano">PlayOff Chip Milano</option>
		<option value="PlayOff Cliga5">PlayOff Cliga5</option>			
		<option value="PlayOff Roma 07">PlayOff Roma 07</option>
		<option value="PlaOff GolemCup">PlaOff GolemCup</option>			
		<option value="Olimpix-Kart RO">Olimpix-Kart RO</option>
		<option value="Music Cup">Music Cup</option>						
		<option value="FoodBall">FoodBall</option>						
		<option value=""></option>												
	</select>		
	</p>		
  </td>
      <td width="119" bgcolor="#FFFF00">
        <p align="left">By Division</td>
  </td>
    </tr>
    <tr>
      <td width="118" bgcolor="#FFFF00"> </td>
      <td width="119" bgcolor="#FFFF00"> </td>
      <td width="119" bgcolor="#FFFF00"> </td>
      <td width="119" bgcolor="#FFFF00"> </td>
    </tr>
  </table>
  <p align="center"><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>

 

 

those are the codes.

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.