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
| $sql="SELECT * FROM evenement,album,photo
where album.id_even=evenement.id_even
and photo.idAlbum=album.id_Album
";
$result=mysql_query($sql);//on execute la requette
while ($row=MySQL_Fetch_Array($result))//je fait une boucle pour que $row prenne la valeur de chaque champ
{
echo "
<tr>
<td>
<h3>";
echo "<a href=\"require/albumPhotos.php?id_album=$row[id_album]&nom=$row[nomA]\">$row[nomA]</a>";echo"</h3>
</td>
<td>
<h3>";echo $row['titre']; echo"</h3>
</td>
<td>";
echo "<a href=\"require/albumPhotos.php?id_album=$row[id_album]&nom=$row[nomA]\"><img src=\"album/$row[nomA]/$row[adr_photo]\"
class=\"apercu_photo\"
onmouseover=\"display_images('album/$row[nomA]/$row[adr_photo]|','$row[id_photo]','i')\"
onmouseout=\"no_display_images\">";
echo"</td>
</tr>";
et la fonction javascript
<script type="text/javascript">
var t;
function display_images(values1, imageId, i){
images = values1.split('|');
i++;
document.getElementById('image'+imageId).src = images[i];
t = setInterval("display_images1('"+values1+"', '"+imageId+"')", 800);
}
var i = 1;
function display_images1(values1, imageId){
images = values1.split('|');
i++;
if(i == images.length){
i = 0;
}
document.getElementById('image'+imageId).src = images[i];
}
function no_display_images(defaulImage, imageId){
clearInterval(t);
document.getElementById('image'+imageId).src = defaulImage;
}
</script> |