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
| <?php
session_start();
if (!isset($_SESSION['images_list'])) $_SESSION['images_list'] = array();
if
(
!mysql_connect('localhost', 'darian', 'mdp') ||
!mysql_select_db('base') ||
!$res = mysql_query('SELECT `image_id`, `image_lien` FROM `images`')
)
die(mysql_error());
mysql_close();
$images_count = mysql_num_rows($res);
$images_remaining = $images_count-count($_SESSION['images_list']);
if ($images_remaining >= 3) $x = 3;
else if ($images_remaining != 0) $x = $images_remaining;
else exit('Il n\'y a plus d\images à afficher!');
$images_id = array();
$images_lien = array();
$images_choice = array();
while (list($image_id, $image_lien) = mysql_fetch_row($res))
{
$images_id[] = $image_id;
$images_lien[$image_id] = $image_lien;
}
for ($i = 0; $i < $x; $i++)
{
shuffle($images_id);
for ($n = 0; $n < $images_count; $n++)
{
$image_id = $images_id[$n];
if (!in_array($image_id, $_SESSION['images_list']))
{
$_SESSION['images_list'][] = $image_id;
$images_choice[] = array('id' => $image_id, 'lien' => $images_lien[$image_id]);
break;
}
}
}
foreach ($images_choice as $image)
echo 'Affiche l\'image "'.$image['lien'].'" ayant pour id : '.$image['id'].'.<br />';
?> |
Partager