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 71 72
|
session_start();
$_SESSION['rech'] = $_POST['rech'];
$rech = $_SESSION['rech'];
$resultat=$connexion->query("SELECT count(*) FROM ori_images WHERE `desc` LIKE '%$rech%'");
$nb_total = $resultat->fetch_array();
if (($nb_total = $nb_total[0]) == 0) {
echo 'Aucun<br>';
}
else {
if (!isset($_GET['debut'])) $_GET['debut'] = 0;
$nb_affichage_par_page = 2;
$ledebut=intval($_GET['debut']);
$resultat = "SELECT * FROM ori_images WHERE `desc` LIKE '%$rech%' ORDER BY id DESC LIMIT $ledebut,$nb_affichage_par_page";
$result = mysqli_query($connexion,$resultat);
while ($ligne = mysqli_fetch_assoc($result)){
$size = getimagesize('imges/'.$ligne['images']);
$letitre=stripslashes(Coupure($ligne['titre'],50));
$ladesc=stripslashes(Coupure($ligne['desc'],280));
echo '
<table cellpadding="0" cellspacing="1" width="100%" height="90" bgcolor="#F7FAF3">
<tr>
<td width="90" height="90" rowspan="3" valign="top" align="left" style="border:1px inset #000000;">
<A HREF="#" title="Cliquez pour ouvrir" onClick="window.open(\'imges/'.$ligne['images'].'\',\''.$ligne['id'].'\',\'toolbar=0, location=0, directories=0, status=0, scrollbars=0, resizable=0, copyhistory=0, menuBar=0, width='.$size[0].', height='.$size[1].', left=11, top=11\'); return(false)"><img alt="" src="imges/thumb_'.$ligne['images'].'"border="0" width="90" height="90"></a>
</td>
<td width="*" height="16" colspan="2" valign="middle" align="center" bgcolor="#5F7939">
<div style="color:white;font-size:12px;font-family:Verdana;">'.$letitre.'</div>
</td>
</tr>
<tr>
<td width="*" height="61" valign="top" align="left">
<div style="color:green;font-size:11px;font-family:Arial;padding:5px;">'.$ladesc.'</div>
</td>
</tr>
<tr>
<td width="*" height="10" valign="bottom" align="right" style="font-size:10px">
Image NO '.$ligne['id'].' ajouté/modifié le '.$ligne['date'].' [ <A class="idimg" HREF="#" onClick="window.open(\'coment.php?id='.$ligne['id'].'\',\'_blank\',\'toolbar=0, location=0, directories=0, status=0, scrollbars=0, resizable=0, copyhistory=0, menuBar=0, width=830, height=460\');return(false)">'.$ligne['img_id'].' COMMENTAIRES</A> ]
</td>
</tr>
</table>
';
}
echo '<div class="base" style="color:#889E68;">'.barre_navigation($nb_total,$nb_affichage_par_page,$_GET['debut'],15).'</div>';
$comptei=$connexion->query("SELECT * FROM ".constant('BDD').".`ori_images`");
echo $comptei->num_rows.' Images enregistrées';
$comptec=$connexion->query("SELECT * FROM ".constant('BDD').".`ori_comen`");
echo ' avec un total de '.$comptec->num_rows.' commentaires des visiteurs!<br>';
}
}
var_dump($rech);
?>
<form method="POST" action="">
<input type="text" name="rech" value="<?php echo $_SESSION['rech']; ?>">
<input type="submit" value="rechercher">
</form> |
Partager