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
| function translate($chaine) {
$in = array("À", "Á", "Â", "Ã", "Ä", "Å", "à", "á", "â", "ã", "ä", "å", "Ò", "Ó", "Ô", "Õ", "Ö", "Ø", "ò", "ó", "ô", "õ", "ö", "ø", "È", "É", "Ê", "Ë", "è", "é", "ê", "ë", "Ç", "ç", "Ì", "Í", "Î", "Ï", "ì", "í", "î", "ï", "Ù", "Ú", "Û", "Ü", "ù", "ú", "û", "ü", "ÿ", "Ñ", "ñ", "ß", "Ą", "ą", "Ę", "ę", "Ł", "ł", "Ż", "ż");
$out = array("À", "Á", "Â", "Ã", "Ä", "Å", "à", "á", "â", "ã", "ä", "å", "Ò", "Ó", "Ô", "Õ", "Ö", "Ø", "ò", "ó", "ô", "õ", "ö", "ø", "È", "É", "Ê", "Ë", "è", "é", "ê", "ë", "Ç", "ç", "Ì", "Í", "Î", "Ï", "ì", "í", "î", "ï", "Ù", "Ú", "Û", "Ü", "ù", "ú", "û", "ü", "ÿ", "Ñ", "ñ", "ß", "Ą", "ą", "Ę", "ę", "Ł", "ł", "Ż", "ż");
foreach($in as $key => $value) {
$chaine = str_replace($in[$key], $out[$key], $chaine);
}
return $chaine;
}
// on recupere toute la base article
$reqArticles = "SELECT id_article2, nom_article, resume_article, desc_article, conseil_utilisation_article, caracteristiques_article, point_fort_article, avis_article, supplement_article FROM articles_FR";
$resArticles = mysql_query($reqArticles);
while(list($id, $nom, $resume, $desc, $conseil, $carac, $pointfort, $avis, $supplement) = mysql_fetch_row($resArticles)) {
$nom = translate($nom);
$resume = translate($resume);
$desc = translate($desc);
$conseil = translate($conseil);
$carac = translate($carac);
$pointfort = translate($pointfort);
$avis = translate($avis);
$supplement = translate($supplement);
$reqUpArticle = "UPDATE articles_FR SET nom_article='$nom', resume_article='$resume', desc_article='$desc', conseil_utilisation_article='$conseil', caracteristiques_article='$carac', point_fort_article='$pointfort', avis_article='$avis' supplement_article='$supplement' WHERE id_article2='$id'";
//$resUpArticle = mysql_query($reqUpArticle);
} |
Partager