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
| <?php
require 'config.php';
mysql_connect(DB_HOST,DB_LOGIN,DB_PASS);
mysql_select_db(DB_BDD);
$page = basename($_SERVER["SCRIPT_NAME"]);
$nombre_news = mysql_query('SELECT COUNT(*) AS total FROM news WHERE categorie="'.$page.'"');
$retour = mysql_fetch_assoc($nombre_news);
$news_par_page = 1;
if(isset($_GET['num_page'])){
$num_page = $_GET['num_page'];
}
else{
$num_page = 0;
}
$lecture = mysql_query('SELECT * FROM news WHERE categorie="'.$page.'" ORDER BY date DESC LIMIT '.$num_page.','.$news_par_page.'');
while($row = mysql_fetch_assoc($lecture)){
$tableau_date = explode('-',$row['date']);
$timestamp = mktime(0,0,0,$tableau_date[1],$tableau_date[2],$tableau_date[0]);
$date = date('l j F Y',$timestamp);
$cible = array('Monday','Tuesday','Wednesday','Thursday','Friday','Saturday','Sunday','January','February','March','April','May','June','July','August','September','October','November','December');
$rempl = array('Lundi','Mardi','Mercredi','Jeudi','Vendredi','Samedi','Dimanche','janvier','février','mars','avril','mai','juin','juillet','août','septembre','octobtre','novembre','décembre',);
$date = str_replace($cible,$rempl,$date);
?>
// Partie HTML [...]
<?php
if($num_page >= 0 && $num_page < $retour['total']-1){
$suivant = $num_page+1;
echo '<a href="'.$page.'?num_page='.$suivant.'" class="fleche_gauche"><img src="Boutons/Icone/pre.png" border="0" /></a>';
}
if($num_page > 0 && $num_page < $retour['total']){
$precedent = $num_page-1;
echo '<a href="'.$page.'?num_page='.$precedent.'" class="fleche_droite"><img src="Boutons/Icone/sui.png" border="0" /></a>';
}
?>
// Partie HTML [...]
<?php
}
?> |
Partager