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 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74
| // on cree la requete SQL
$sql = "SELECT * from Tbl_page_pdf order by id_page";
// on envoie la requete
$req = mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
// on boucle
while($data = mysql_fetch_assoc($req))
{
// On écrit le requete
$sqle = "UPDATE Tbl_page_pdf set texte_fr = REPLACE(texte_fr, 'é', 'é') where id_page = ".$data['id_page'];
mysql_query($sqle) or die('Erreur SQL !'.$sqle.'<br>'.mysql_error());
$sqle = "UPDATE Tbl_page_pdf set texte_fr = REPLACE(texte_fr, 'ê', 'ê') where id_page = ".$data['id_page'];
mysql_query($sqle) or die('Erreur SQL !'.$sqle.'<br>'.mysql_error());
$sqle = "UPDATE Tbl_page_pdf set texte_fr = REPLACE(texte_fr, 'â', '\'') where id_page = ".$data['id_page'];
mysql_query($sqle) or die('Erreur SQL !'.$sqle.'<br>'.mysql_error());
$sqle = "UPDATE Tbl_page_pdf set texte_fr = REPLACE(texte_fr, 'è', 'è') where id_page = ".$data['id_page'];
mysql_query($sqle) or die('Erreur SQL !'.$sqle.'<br>'.mysql_error());
$sqle = "UPDATE Tbl_page_pdf set texte_fr = REPLACE(texte_fr, 'î', 'î') where id_page = ".$data['id_page'];
mysql_query($sqle) or die('Erreur SQL !'.$sqle.'<br>'.mysql_error());
$sqle = "UPDATE Tbl_page_pdf set texte_fr = REPLACE(texte_fr, 'ç', 'ç') where id_page = ".$data['id_page'];
mysql_query($sqle) or die('Erreur SQL !'.$sqle.'<br>'.mysql_error());
$sqle = "UPDATE Tbl_page_pdf set texte_fr = REPLACE(texte_fr, 'ô', 'ô') where id_page = ".$data['id_page'];
mysql_query($sqle) or die('Erreur SQL !'.$sqle.'<br>'.mysql_error());
$sqle = "UPDATE Tbl_page_pdf set texte_fr = REPLACE(texte_fr, 'Ã', '') where id_page = ".$data['id_page'];
mysql_query($sqle) or die('Erreur SQL !'.$sqle.'<br>'.mysql_error());
$sqle = 'UPDATE Tbl_page_pdf set texte_fr = REPLACE(texte_fr, "Ã ", "à") where id_page = '.$data['id_page'];
mysql_query($sqle) or die('Erreur SQL !'.$sqle.'<br>'.mysql_error());
$sqle = "UPDATE Tbl_page_pdf set texte_fr = REPLACE(texte_fr, 'ù', 'û') where id_page = ".$data['id_page'];
mysql_query($sqle) or die('Erreur SQL !'.$sqle.'<br>'.mysql_error());
$sqle = "UPDATE Tbl_page_pdf set texte_fr = REPLACE(texte_fr, 'û', 'û') where id_page = ".$data['id_page'];
mysql_query($sqle) or die('Erreur SQL !'.$sqle.'<br>'.mysql_error());
$sqle = "UPDATE Tbl_page_pdf set texte_fr = REPLACE(texte_fr, 'ú', 'ù') where id_page = ".$data['id_page'];
mysql_query($sqle) or die('Erreur SQL !'.$sqle.'<br>'.mysql_error());
$sqle = "UPDATE Tbl_page_pdf set texte_fr = REPLACE(texte_fr, '°', '°') where id_page = ".$data['id_page'];
mysql_query($sqle) or die('Erreur SQL !'.$sqle.'<br>'.mysql_error());
$sqle = "UPDATE Tbl_page_pdf set texte_fr = REPLACE(texte_fr, 'â¬', ' ') where id_page = ".$data['id_page'];
mysql_query($sqle) or die('Erreur SQL !'.$sqle.'<br>'.mysql_error());
$sqle = "UPDATE Tbl_page_pdf set texte_fr = REPLACE(texte_fr, 'â', 'â') where id_page = ".$data['id_page'];
mysql_query($sqle) or die('Erreur SQL !'.$sqle.'<br>'.mysql_error());
$sqle = "UPDATE Tbl_page_pdf set texte_fr = REPLACE(texte_fr, '«', '«') where id_page = ".$data['id_page'];
mysql_query($sqle) or die('Erreur SQL !'.$sqle.'<br>'.mysql_error());
$sqle = "UPDATE Tbl_page_pdf set texte_fr = REPLACE(texte_fr, '»', '»') where id_page = ".$data['id_page'];
mysql_query($sqle) or die('Erreur SQL !'.$sqle.'<br>'.mysql_error());
$sqle = 'UPDATE Tbl_page_pdf set texte_fr = REPLACE(texte_fr, "Å\"", "oe") where id_page = '.$data['id_page'];
mysql_query($sqle) or die('Erreur SQL !'.$sqle.'<br>'.mysql_error());
$sqle = 'UPDATE Tbl_page_pdf set texte_fr = REPLACE(texte_fr, "â\"", "") where id_page = '.$data['id_page'];
mysql_query($sqle) or die('Erreur SQL !'.$sqle.'<br>'.mysql_error());
$i ++;
}
echo " MAJ réalisée nb : $i"; |
Partager