\n \n \n
\n"; $champ = $_POST["field_1"]; $DateOjo = date("d.M.Y"); $HeureOjo = date ("H:i:s"); /* Début de la page html */ echo "\n \n Liste Divx d'eskimo ©\n"; echo "
"; echo "
le $DateOjo , il est $HeureOjo
"; echo $form; echo "Votre derniere recherche: "; echo "".$_POST["field_1"]."

"; /* fonction javascript pour le popup */ echo ""; echo "\n"; echo "\n "; echo "\n \n \n \n \n \n"; /* déclaration des parametres de connection */ include "connection_sql.php"; /* définition des select a executer */ $select_list = "originaltitle , translatedtitle , director , actors , picturename , rating, url, year, num"; /* définition des limites */ if (!isset($limit_min)) {$limit_min = 0;} if (!isset($limit_max)) {$limit_max = 30;} /* creation et envoi de la requete */ $query_search = "SELECT $select_list FROM eskimo WHERE originaltitle LIKE '%$champ%' OR actors LIKE '%$champ%' OR year LIKE '%$champ%' OR translatedtitle LIKE '%$champ%' OR director LIKE '%$champ%' ORDER BY originaltitle LIMIT $limit_min, $limit_max"; $query_last_entry = "SELECT num FROM divx_list ORDER BY num ASC"; $result_search = mysql_query($query_search); /* boucle pour récuperer les valeurs dans le tableau */ while($row_select = mysql_fetch_array($result_search)){ $Titre = $row_select["originaltitle"]; $Acteur = $row_select["actors"]; $Image = $row_select["picturename"]; $Rating = $row_select["rating"]; $Url = $row_select["url"]; $Year = $row_select["year"]; $pathimg = "./images/".$Image; $Id = $row_select["num"]; /* on affiche les valeurs dans les cadres */ echo "\n \n \n \n"; } /* k sert a récuperer les elements du tableau qui sert a avoir le n° du premier et dernier film */ $k=0; $result_last_entry = mysql_query($query_last_entry); $Dernier_film = mysql_num_rows($result_last_entry); while($row_last_entry = mysql_fetch_array($result_last_entry)){ $Tableau_num_film[$k] = $row_last_entry["0"]; $k++; } $min = 0; $max = $Tableau_num_film[$Dernier_film-1]; /* deconnection de la bdd */ mysql_close(); echo "\n
Movie TitleRatingYearINFOS
$Titre
$Rating
$Year
Fiche
\n"; echo ""; echo ""; echo ""; /* gestion des limites pour les liens des pages (pas aller en dessous de 0 et pas au dessus du nbre du film le plus haut */ $limit_min_next = $limit_min+30; $limit_max_next = $limit_max; $limit_min_previous = $limit_min-30; $limit_max_previous = $limit_max; if ($limit_min<=$min) {$limit_min=$min;} if ($limit_max>=$max) {$limit_max=$max;} if ($limit_min_previous<=$min) {$limit_min_previous=$min;} if ($limit_min_previous>=$max) {$limit_min_previous=$max;} if ($limit_max_next<=$min) {$limit_max_next=$min;} if ($limit_max_next>=$max) {$limit_max_next=$max;} if ($limit_min_previous<$min) {$limit_min_previous=$min;} if ($limit_min_previous>$max) {$limit_min_previous=$max;} if ($limit_max_next<$min) {$limit_max_next=$min;} if ($limit_max_next>$max) {$limit_max_next=$max;} /* création des liens dynamiques et affichage */ $nextpage = "NexT PagE"; $previouspage = "PreviouS PagE"; echo "

$previouspage .»¬=æ?º²°`¯_¯`°²º?æ=¬«. $nextpage

"; /* affichage du nombre de personnes connectées sur le site */ echo "

"; echo("

"); //echo "Nbre de connectés en ce moment sur le site:"; // include "../includes/live_counter.php"; /* affichage de la derniere modification de la page */ echo "
"; echo ("Dernière modification le "); echo (date("d/m/Y à H:i", filemtime($SCRIPT_FILENAME))); echo "
"; /* affichage de l'uptime de la base sql $link = mysql_connect($host,$user,$passwd); $status = explode(' ', mysql_stat($link)); $uptime = $status["0"]; echo "
"; echo "SQL database "; echo($uptime); */ /* Uptime systeme */ // include "../includes/uptime.php"; echo "
Pour toute idée de correction de bug: "; echo "contact@esquimo.org"; /* balisage de fin de la page */ echo "
"; echo "

"; echo "\n \n"; ?>