![]() |
![]() |
![]() |
![]() |
|
|
include("diary/bdd.php");
$bgcol= 0;
$action= 0;
//affiche 10 resultats par page
$nombr = 10;
if ($action="select"){
$connect_string = @mysql_connect("$host","$user","$pass") or die("Connection impossible au serveur MYSQL");
@mysql_select_db("$bdd",$connect_string) or die("Trouve pas la base CDDB");
if(empty($page)) $page = 1;
$debut = ($page - 1) * $nombr;
if(empty($total)){ // nombre total de résultats
$requet = "select count(*) as qte from ar_diary ORDER BY 'date'";
$pquery = @mysql_query($requet,$connect_string);
$total = @mysql_result($pquery,"0","qte");
}
// on determine debut du limit
$debut = ($page - 1) * $nombr;
// requete sql
$sql = "SELECT * FROM ar_diary WHERE status ='1' ORDER BY 'date' Desc LIMIT $debut,$nombr";
if($pquery = @mysql_query($sql,$connect_string)){
while($r = @mysql_fetch_array($pquery)){
//Regexp pour le parsage de la date..
ereg("([0-9]{4})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})", $r[date],$regs);
$date = $r[date];
$r[date] = $regs[1]."/".$regs[2]."/".$regs[3]." ".$regs[4].":".$regs[5];
echo "
"; } echo " ";
// calcul du nombre de pages
$nbpages = ceil($total / $nombr); // arrondi a l'entier superieur
for($i = 1;$i <= $nbpages;$i ++){
echo "$i";
if($i < $nbpages) echo " ";
}
}
//echo " ";
@mysql_close($connect_string);
}
?>
|