[Resolved] page numbering problem!!

pcwizzzz

Hi,
I have problems with displaying the results of a search form. The first page is displayed well but the second and the rest don't appear at all. Looks like my code for numbering the pages doesn't get the search variable at the second running cause, if i cut the "where id=$_GET['id'] " from the select statement the numbering pages code works damn well. How do i fix this? Can someone gives me a hint?
Thanks

TTT

code might help us... .. i have red car how to fix it

😃

pcwizzzz

Here is " the red car ".Thanks

<body>
<?php
include("conectare_db_users.php");
//set curent page
if(!isset($GET['page']))
{
$page=1;
}
else
{
$page=$GET['page'];
}

//number of results per page
$max_result=6;

// limit for the query
$from=(($page*$max_result)-$max_result);

//mysql query
$idd=$_GET['city'];
$sql="SELECT * FROM hotels WHERE id_oras='$idd' LIMIT $from,$max_result";
$res=mysql_query($sql);
while($row=mysql_fetch_array($res))
{
?>
<div style="height:180;background-color:#F5F5F5;">

HOTEL <?php echo $row['nume_hotel']." " .$row['stele']." "." "?>  
(Address:<?php echo $row['adresa']?>)
 
<?php
$img_out=$row['poza_hotel'];
$img_in=$row['poza_cam'];
echo '<img src="'.$img_out.'" align="left" width="180" height="140" alt="'.$row['nume_hotel'].'">'?> 
Location:<?php echo " ".$row['location']?> 
Accommodation:<?php echo " ".$row['accommodation']?> 
Facilities: <?php echo " ".$row['facilities']?> 
Servicies:<?php echo " ".$row['servicies']?>
 
<img src="tabel.jpg">
 
</div>
<?php
}

//total no. of results in DB
$total_result=mysql_result(mysql_query("SELECT COUNT(*) as Num FROM hotels WHERE id_oras='$idd'"),0);

//total no. of pages
$total_page=ceil($total_result / $max_result);

//page no. links
echo"<center>Select a page ";

//previous links
if($page>1) {
$prev=($page-1);
echo "<a href=\"".$SERVER['PHP_SELF']."?page=$prev\"><<Previous</a> ";
}
for($i=1;$i<=$total_page;$i++) {
if(($page)==$i) {
echo"$i ";
} else {
echo"<a href=\"".$SERVER['PHP_SELF']."?
page=$i\">$i</a> ";
}
}

//next links
if($page<$total_page) {
$next=($page+1);
echo"<a href=\"".$_SERVER['PHP_SELF']."?page=$next\">Next>></a>";
}
echo"</center>";
?>
</body>

YappyDog

if the problem occurs when you have the "where id=$_GET['id'] " in your code, you need to show us the code with that in it.

rrijnders

And pleeeeaaaaase use put use the [ php ] and [ /php ] tags around your code so it displays correctly in the forum 😉

pcwizzzz

Ok, i'm sorry, i'm going to use

and

. I really didn't know since i haven't really posted much codes so far.

I dont have the code on this computer but the passing variable is from a form, a select menu that gets its options from a database into an array. Something like:


//select.php
$cmbCities='<select name="cityID">'; 
$options=array() 
$options[]='<option >Select a city</option>';
for($i=0;$i<$countCity;$i++){

$options[]="<option value=\"{$city[$i]['cityID']}\" > 
{$city[$i]['cityName']}</option>";
}
$cmbCities.=implode(' ',$options).'</select>';

Then i have the form :
menu.php
<form........>
<?php echo $cmbCity?>
..............</form>
When it submits it performs the file with the numbering pages code. It displays me how many pages i have, lets say 3 pages with 10 items on each of them, and when i click the link Next>> or 2 i only get "Select a page" which means it doesn't get the searcing variable $city anymore. Hope this is enough clear, if not i'm going to post all the code again when i get to the computer i work. Thanks alot guys.

PS:hope this time i wrote the code so that you will see well🙂

rrijnders

I think your problem is that your page is looking for the city id that comes from the first form, but you never pass it to the "next" page via the URL. In fact, given your code, I don't know how the city id is getting to the first page. You must be specifying METHOD="GET" in your form?

For starters, change your previous and next links to:

echo "<a href=\"" . $_SERVER['PHP_SELF'] . "?page=" . $prev . "&city=" . $idd . "\">&amp;amp;&amp;amp;Previous</a>";

echo "<a href=\"" . $_SERVER['PHP_SELF'] . "?page=" . $next . "&city=" . $idd . "\">Next&amp;amp;&amp;amp;</a>";

pcwizzzz

Yes, of course there is a METHOD="GET" in my form, as i already said, the variable is passed through the first page but the rest seem like they dont get the city id.

pcwizzzz

I dont get something. Why for the first x pages the city id is passed and for the next x pages not? Can you explain me? Thanks for that piece of code, it works now.
Thank you all for taking your time to help me🙂.

rrijnders

When the form with the selection fields is first displayed, the visitor selects their city and then presses the submit button. This causes the browser to send a GET request (remember METHOD=GET) to the web server. Embedded in the GET request is all the variable information, including the ID of the city they selected on the form. PHP make this information available to your script through the $_GET[] array.

But...

Your Previous and Next links are NOT forms; they are simply links created with the <A HREF> tags. So no variable information is passed to your script when they are clicked. Remember: every time a visitor clicks a link, your script starts all over with no knowledge or information from the last time it ran.

In order to pass the city id (or any other information) on to the next page, you have to add it to the URL in the <A HREF> tag. This is done by adding the variables in the form variable=value to the end of the URL in the link, just like you did with the page variable. Since this is a second variable added to the URL, it is seperated from the first by a &.

Now when the previous or Next link is clicked, both the page and city variables are passed to your script and available through the $_GET[] array.

pcwizzzz

Ok, now i got it. It's logic what you said, should have thought of it🙂. Thanks alot for the explinations, very clear and to the point. And thanks for the help too. I'm still learning php.
Problem solved🙂.