$db=mysql_connect("localhost", "arpeca", "sam88uel"); if(!$db) { print "erreur connection $db"; exit; } mysql_query("SET NAMES 'UTF8'"); mysql_select_db("arpeca",$db); if (!isset($_GET['id'])) {exit();} $id = $_GET['id']; $id = mysql_real_escape_string($id); $SQL = "SELECT * FROM datazoom WHERE id='".$id."'"; $result = mysql_query($SQL); echo mysql_error(); while ($row=mysql_fetch_array($result)) { $titre = Ucfirst(strtolower($row['title'])); $alt = $row['alt']; $src = $row['src']; $descr = Ucfirst(strtolower($row['descr']." ".$row['famille']." num ".$row['id'])); } $title=$titre." ".$row['id']; $description=$descr; $keywords=""; $langue="fr"; $page="/home.html"; function convertCase($str, $case = 'upper') { //yours, courtesy of table4.com :) $str=htmlentities($str, ENT_QUOTES, "utf-8"); switch($case) { case "upper" : default: $str = upperCase($str); $pattern = '/&([A-Z])(UML|ACUTE|CIRC|TILDE|RING|'; $pattern .= 'ELIG|GRAVE|SLASH|HORN|CEDIL|TH);/e'; $replace = "'&'.'\\1'.strtolower('\\2').';'"; //convert the important bit back to lower break; case "lower" : $str = strtolower($str); break; } $str = preg_replace($pattern, $replace, $str); return $str; } //_____________________________________________________________________________________________________________________________________________ function uppercase($str, $case = 'upper') { //yours, courtesy of table4.com :) switch($case) { case "upper" : default: $str = strtoupper($str); $pattern = '/&([A-Z])(UML|ACUTE|CIRC|TILDE|RING|'; $pattern .= 'ELIG|GRAVE|SLASH|HORN|CEDIL|TH);/e'; $replace = "'&'.'\\1'.strtolower('\\2').';'"; //convert the important bit back to lower break; case "lower" : $str = strtolower($str); break; } $str = preg_replace($pattern, $replace, $str); return $str; } include "../head.php"; ?>