ok.
voici le code de la page
<?php
// nbr de rows par page
$rowsPerPage = 3;
// par default on montre le first page
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
//code est passee par la page qui fait lappelle.
$code=($_GET['code']);
// ... and here is the code that print the prev & next links
// ... the previous code
$queryCount = "SELECT COUNT(products_type) AS numrows FROM products WHERE products_type='$code'";
// WHERE products_type=". $code;
$resultCount = mysql_query($queryCount);
$row = mysql_fetch_array($resultCount, MYSQL_ASSOC);
$numrows = $row['numrows'];
// combien de pages ya til?
$maxPage = ceil($numrows/$rowsPerPage);
// print the link to access each page
$self = $_SERVER['PHP_SELF'];
$nav = '';
for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nav .= " $page "; // no need to create a link to current page
}
else
{
$nav .= " <a href=\"$self?page=$page\">$page</a> ";
}
}
// creating previous and next link
// plus the link to go straight to
// the first and last page
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 = ' '; // we're on page one, don't print previous link
$first = ' '; // nor the first page link
}
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 = ' '; // we're on the last page, don't print next link
$last = ' '; // nor the last page link
}
// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;
$query = "SELECT products_id, products_name, products_type, products_price, products_description, products_path, products_img_name FROM products WHERE products_type='$code' ";
$pagingQuery = "LIMIT $offset, $rowsPerPage";
$result = mysql_query($query.$pagingQuery) or die('Error : ' . mysql_error());
echo $first . $prev .
" Showing page $pageNum of $maxPage pages " . $next . $last;
// print the products info in table
echo '<table >';
while(list($id, $name, $type, $price, $description,$img_path, $img_name) = mysql_fetch_array($result))
{
echo "<tr><td>";
?>
<img src=<?php echo $img_path.$img_name ; ?>" />
<?php
echo "</td>";
echo "<td>Product Code: $id <br /><b> $name </b><br />$type <br /> <b>
$price </b><br /><a href='products_details.php?products_id=".$id. "'>Plus de details</a></td></tr>";
echo '<tr><td></td></tr>';
}
echo '</table>';
echo '<br>';
// print the navigation link
echo $first . $prev . $nav . $next . $last;
?>