<?php 
  //-------------------------------------- 
  // s'inspirer du fichier include/mysql.inc.php pour les 5 premiers paramètres 
  $cfgBase='z0rglub_database'; 
  $cfgUser='user'; 
  $cfgPassword='pipo'; 
  $cfgHote='localhost'; 
  $prefixeTable='phpwebgallery_'; 
   
  $prefixe_thumbnail = 'TN-'; 
  $url_diapo = "http://localhost/demo/"; 
  //-------------------------------------- 
   
  function get_cat_info( $id ) 
  { 
    global $prefixeTable; 
     
    $cat = array(); 
    $cat['name'] = array(); 
     
    $query = "select nb_images,id_uppercat,comment"; 
    $query.= " from $prefixeTable"."categories"; 
    $query.= " where id = $id;"; 
    $row = mysql_fetch_array( mysql_query( $query ) ); 
    $cat['id_uppercat'] = $row['id_uppercat']; 
    $cat['comment'] = nl2br( $row['comment'] ); 
    $cat['nb_images'] = $row['nb_images']; 
     
    $cat['dir'] = ""; 
    $i = 0; 
    $is_root = false; 
    $row['id_uppercat'] = $id; 
    while ( !$is_root ) 
    { 
      $query = "select name,dir,id_uppercat "; 
      $query.= "from $prefixeTable"."categories "; 
      $query.= "where id = ".$row['id_uppercat'].";"; 
      $row = mysql_fetch_array( mysql_query( $query ) ); 
      $cat['dir'] = $row['dir']."/".$cat['dir']; 
      if ( $row['name'] == "" ) 
      { 
        $cat['name'][$i] = str_replace( "_", " ", $row['dir'] ); 
      } 
      if ( $row['id_uppercat'] == "" ) 
      { 
        $is_root = true; 
      } 
      $i++; 
    } 
    $cat['local_dir'] = substr( $cat['dir'], 0 , strlen( $cat['dir'] ) - 1 ); 
     
    return $cat; 
  } 
   
  mysql_connect( $cfgHote, $cfgUser, $cfgPassword ) or die ( "Can't connect to server" ); 
  mysql_select_db( $cfgBase ) or die ( "Can't connect to database" ); 
   
  $query = "select id,cat_id,tn_ext,file from $prefixeTable"."images order by rand() limit 0,1;"; 
  $result = mysql_query( $query ); 
  $row = mysql_fetch_array( $result ); 
  $resultat = get_cat_info( $row['cat_id'] ); 
  $file = substr ( $row['file'], 0, strrpos ( $row['file'], ".") ); 
  $lien_thumbnail .= $url_diapo."galleries/".$resultat['dir']."thumbnail/".$prefixe_thumbnail.$file.".".$row['tn_ext']; 
   
  // trouver le numéro dans la liste des images de la catégorie 
  $query = "select id from $prefixeTable"."images where cat_id = ".$row['cat_id']; 
  $query.= " order by date_available desc, file asc;"; 
  $result = mysql_query( $query ); 
  $i = -1; 
  $is_found = false; 
  while ( ( $row2 = mysql_fetch_array( $result ) ) && !$is_found ) 
  { 
    $i++; 
    if ( $row2['id'] == $row['id'] ) 
    { 
      $is_found = true; 
    } 
  } 
   
  echo "<a href="".$url_diapo."photo.php?cat=".$row['cat_id']."&num=$i">"; 
  echo "<img src="$lien_thumbnail" alt="" />"; 
  echo "</a>"; 
?>

style="border:none;