} ?>
require_once "config.php"; // On logge l'accès à la page $IP = $_SERVER["REMOTE_ADDR"]; $REF = toSQL($_SERVER["HTTP_REFERER"]); $ART = toSQL($_REQUEST["id"]); $sql = "INSERT into LOGS values (getdate(), '$IP', '$REF', 3, '$ART')"; odbc_exec($connection, $sql); // On récupère les 5 derniers articles $sql = "SELECT top 5 convert(varchar(10), art_date,103) as D, * from ARTICLES order by ART_ID DESC"; $que = odbc_exec($connection, $sql); while (odbc_fetch_row($que)) { $d = odbc_result($que, "D"); $id[] = odbc_result($que, "ART_ID"); $date[] = right(left($d, 5),2) . "/" . left($d,2) . right($d,5); $titre[] = utf8_encode(odbc_result($que, "ART_TITRE")); $chapo[] = utf8_encode(odbc_result($que, "ART_CHAPO")); $texte[] = utf8_encode(odbc_result($que, "ART_TEXTE")); $visuel[] = utf8_encode(odbc_result($que, "ART_VISUEL")); $views[] = utf8_encode(odbc_result($que, "ART_VIEWS")); } // On incrémente le nombre de vue de l'article en cours $sql = "UPDATE articles set ART_VIEWS=ART_VIEWS + 1 where ART_ID=" . $_REQUEST["id"]; odbc_exec($connection, $sql); // On récupère l'article demandé $sql = "SELECT convert(varchar(10), art_date,103) as D, * from ARTICLES where ART_ID=" . $_REQUEST["id"]; $que = odbc_exec($connection, $sql); while (odbc_fetch_row($que)) { $d = odbc_result($que, "D"); $a_id = odbc_result($que, "ART_ID"); $a_date = right(left($d, 5),2) . "/" . left($d,2) . right($d,5); $a_titre = utf8_encode(odbc_result($que, "ART_TITRE")); $a_chapo = utf8_encode(odbc_result($que, "ART_CHAPO")); $a_texte = utf8_encode(odbc_result($que, "ART_TEXTE")); $a_visuel = utf8_encode(odbc_result($que, "ART_VISUEL")); $a_views = utf8_encode(odbc_result($que, "ART_VIEWS")); } // On ferme la connexion odbc_close($connection); ?>