1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70
| <?php
// par défaut
$doc_par_page = 4;
$num_page = 1;
$sql =
<<<SQL
SELECT
COUNT(*) AS nb
FROM
document
SQL;
$qry = mysql_query($sql);
if ($qry === false) {
die(mysql_error());
}
$nb_total = mysql_result($qry, 0);
$nb_pages = ceil($nb_total/$doc_par_page);
if (isset($_GET['nbre_document'])) {
$num_page = intval($_GET['nbre_document']);
$num_page = ($num_page > $nb_pages) ? $nb_pages : 1;
}
// clause limit du sql
$offset = ($num_page - 1) * $doc_par_page;
$sql =
<<<SQL
SELECT
c.id_categorie,
c.nom_categorie,
d.titre_document,
d.descrition_document,
d.url_feature_image
FROM
categorie AS c
INNER JOIN document d ON c.id_categorie = d.fkid_categorie
ORDER BY
d.id_document DESC
LIMIT
$offset, $doc_par_page
SQL;
$qry = mysql_query($sql);
if ($qry === false) {
die(mysql_error());
}
while ($row = mysql_fetch_assoc($qry)) {
echo
<<<HTML
<table width="50%" height="33.33%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td>
<a href="page.php?param={$row['id_categorie']}">
<img alt="{$row['id_categorie']}" class="feature_img" src="{$row['url_feature_image']}" />
<p class="titre_document">{$row['titre_document']}</p><br />
<p class="description_document">{$row['descrition_document']}<br />
<img class="view" src="./img/lire.gif" />
</a>
</td>
</tr>
</table>
HTML;
}
?> |
Partager