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
|
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" lang="fr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<link rel="stylesheet" href="css/admin.css" type="text/css" media="screen" />
</head>
<body>
<div id="carrousel">
<?php
include('params.inc.php');
$connect=mysql_connect(MYHOST,MYUSER,MYPASS) or die ('erreur de connexion');
mysql_select_db(MYDB) or die ('erreur de connexion à la base');
$requeteselect = 'SELECT id,lienimage,url FROM images';
$result = mysql_query($requeteselect, $connect);
$tableau = array();
$i = 0;
while($image_courante = mysql_fetch_array($result,MYSQL_ASSOC)){
//on met toutes les infos dans un tableau
$tableau[$image_courante['id']]['url'] = $image_courante['url'];
$tableau[$image_courante['id']]['lienimage'] = $image_courante['lienimage'];
if($i == 0){ //si il s'agit de la première image on l'affiche
echo '<div><a href='.$tableau[$image_courante['id']]['url'].'><img src='.$tableau[$image_courante['id']]['lienimage'].'> </a></div>';
}
++$i;
}
mysql_close($connect);
?>
</div>
</form>
</body>
</html> |
Partager