Show query result one by one

[ricroma]

Hi,

lately I've found a great help in this board, and my site is coming along preatty well. So well, that a friend of mine asked me to do HIS website! 🙂 I'm really happy for that since it gives me the opportunity to keep practicing and learning... but I've run into a problem!
I want to show the usual list of products from the database, but i don't want them all to show on a single page. I'd like to show only one, and then with a "next" button I would like to have the possibility to sort trought them all. How can I do that?
This is the code I have that shows me all the products in a single page:

<?php
include ("dbCC/CC.inc");

$cxn = mysqli_connect($host,$user,$password,$database)
or die ("Impossibile connettersi al server.");

$tipo = $_GET['tipo'];

$query = "SELECT * FROM prodotti WHERE tipo='$tipo'";

$result = mysqli_query($cxn,$query)
or die ("Impossibile eseguire la richiesta.");

echo "<table align='center' width='80%' cellspacing='0' border='0' cellpadding='0'>";

while($row = mysqli_fetch_assoc($result))
{
echo "<td align='center'><img src='img/{$row['pix']}'></td></tr></table>\n";
}

?>

Hope somebody can help! And by the way, thanks for all the former help!

Ricroma

[leatherback]

What you are looking for is pagination.

It uses the limit clause of a mysql query:
select * from table limit $offset, $numrecords

In your next link, you include the current last record or page number or.. anything with which you can reconstruct the offset.

[ricroma]

Hi,

thanks for the help, again!
Following your suggestion I've made a little research, and now it works perfectly... but... :-) [I'm sorry I'm tedious] well, I didn't really get how when you get to the last page of the result you won't see any "next" button.
Here's the code I've did for no "previous" button on the first page:

if($pagina == 0)
{
echo "<h3>&nbsp;</h3>";
}
else
{
echo '<h3 style="text-align: left"><a href="'.$_SERVER['PHP_SELF'].'?tipo='.($tipo).'&pagina='.($pagina-1).'">Indietro</a></h3>';
}

I guess for the no "next" button on the last page I need another if statement... but i cannot figure out the conditions... I mean, I cannot figure out how to obtain something like: $pagina == $lastpage, or something...

Should I add "thank you for your help"? Well, I guess so! Thank you a lot, really!

Ricroma

PS. oh! Another thing.... 🙂 I'm experiencing a problem with regular html and firefow... well, I've set this margin-left parameter that firefox for some reason cannot figure out, while I.E. works perfectly. Never experienced this before... anyway, the problem is that it seems that firefox consider the left margin to be the one of the previous <div> layer, and not the layer where the <h3> paragraph is. I've checked all the syntax and everything seems fine (no open tags)... well, here comes my usual code:

<div id="left">
<h3 style="margin-top:125px">
<img src="img/02menuproducts.gif" width="161" height="32" />
<br />
<br />
<a style="margin-left:20px" href="lista.php?tipo=crema">Creme</a>
<br />
<br />
<a style="margin-left:20px" href="lista.php?tipo=profumo">Profumi</a>
</h3>
</div>

<div id="content">
<center>
<img src="img/vetro.jpg" width="320" height="240" />
</center>
<h3 style="margin-left: 110px; margin-top:10px;">ciao ciao ciao ciao ciao ciao ciao ciao ciao ciao ciao</h3>
</div>

Well... super thanks!

[leatherback]

What you need to do is get the number of records in the dataset, and use that to decide whether the current page is the last page (e.g., $offset + $number_of_records_per_set >= Total_number_of_pages).