Voici ma page avec la liste :
<?php require_once('../../Connections/InFolio.php'); ?>
<?php
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_listing = 20;
$pageNum_listing = 0;
if (isset($_GET['pageNum_listing'])) {
$pageNum_listing = $_GET['pageNum_listing'];
}
$startRow_listing = $pageNum_listing * $maxRows_listing;
mysql_select_db($database_InFolio, $InFolio);
$query_listing = "SELECT id_fiche, auteur, titre, editeur, Genre FROM tb_type_doc LEFT JOIN educa ON educa.id_fiche_doc=tb_type_doc.id ORDER BY educa.id_fiche DESC";
$query_limit_listing = sprintf("%s LIMIT %d, %d", $query_listing, $startRow_listing, $maxRows_listing);
$listing = mysql_query($query_limit_listing, $InFolio) or die(mysql_error());
$row_listing = mysql_fetch_assoc($listing);
if (isset($_GET['totalRows_listing'])) {
$totalRows_listing = $_GET['totalRows_listing'];
} else {
$all_listing = mysql_query($query_listing);
$totalRows_listing = mysql_num_rows($all_listing);
}
$totalPages_listing = ceil($totalRows_listing/$maxRows_listing)-1;
$queryString_listing = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_listing") == false &&
stristr($param, "totalRows_listing") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_listing = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_listing = sprintf("&totalRows_listing=%d%s", $totalRows_listing, $queryString_listing);
?>
<link href="../../CSS/style.css" rel="stylesheet" type="text/css">
</head>
<?php include('../includes/head.inc.php');?>
<table width="100%" align="center">
<tr>
<td><table width="100%" class="cadre2" >
<tr>
<td class="titre">Bibliothèque Infolio</td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" class="cadre">
<tr>
<td><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><table width="100%" >
<tr>
<td width="3%" height="27" class="titre_tableau">N° </td>
<td width="8%" class="titre_tableau">Doc.</td>
<td width="55%" class="titre_tableau">Titre</td>
<td width="35%" class="titre_tableau">Auteur(s)</td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" cellpadding="0" cellspacing="0">
<?php do { ?>
<tr>
<td width="3%" class="txt_tab"><?php echo $row_listing['id_fiche']; ?></td>
<td width="8%" class="txt_tab"><?php echo $row_listing['Genre']; ?></td>
<td width="57%" class="txt_tab"><a href="../detail/detail.php?id_fiche=<?php echo $row_listing['id_fiche']; ?>"><?php echo $row_listing['titre']; ?></a></td>
<td width="30%" class="txt_tab"><?php echo $row_listing['auteur']; ?> </td>
<td class="ICO"><a href="../update/update.php?id_fiche=<?php echo $row_listing['id_fiche']; ?>"><img src="../../img/edit.gif" alt="Modifier la fiche" width="18" height="13" border="0"></a> </td>
<td width="16" class="ICO"><a href="../confirm/confirm.php?id_fiche=<?php echo $row_listing['id_fiche']; ?>"><img src="../../img/corbeille.png" alt="Supprimer la fiche" width="16" height="16" border="0"></a> </td>
</tr>
<tr>
<td colspan="6"><hr noshade class="marge"></td>
</tr>
<?php } while ($row_listing = mysql_fetch_assoc($listing)); ?>
</table></td>
</tr>
<tr>
<td><table width="50%" border="0" align="center">
<tr>
<td width="23%" align="center"><?php if ($pageNum_listing > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_listing=%d%s", $currentPage, 0, $queryString_listing); ?>"><img src="../../img/First.gif" width="16" height="17" border=0></a>
<?php } // Show if not first page ?>
</td>
<td width="31%" align="center"><?php if ($pageNum_listing > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_listing=%d%s", $currentPage, max(0, $pageNum_listing - 1), $queryString_listing); ?>"><img src="../../img/Previous.gif" width="16" height="17" border=0></a>
<?php } // Show if not first page ?>
</td>
<td width="31%" align="center"><span class="txt_tab"> Fiche <?php echo ($startRow_listing + 1) ?> à <?php echo min($startRow_listing + $maxRows_listing, $totalRows_listing) ?> sur <?php echo $totalRows_listing ?></span></td>
<td width="23%" align="center"><?php if ($pageNum_listing < $totalPages_listing) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_listing=%d%s", $currentPage, min($totalPages_listing, $pageNum_listing + 1), $queryString_listing); ?>"><img src="../../img/Next.gif" width="16" height="17" border=0></a>
<?php } // Show if not last page ?>
</td>
<td width="23%" align="center"><?php if ($pageNum_listing < $totalPages_listing) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_listing=%d%s", $currentPage, $totalPages_listing, $queryString_listing); ?>"><img src="../../img/Last.gif" width="16" height="17" border=0></a>
<?php } // Show if not last page ?>
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<tr>
<?php
mysql_free_result($listing);
?>
<?php include('../includes/foot.inc.php');
?>
</body>
</html>