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
| <?php
error_reporting(E_ALL);
ini_set("display_errors", 1);
// Connexion à la base de données
$link = mysqli_connect("localhost", "root", "motdepasse", "mabase");
if (!$link) {
echo "Error: Unable to connect to MySQL." . PHP_EOL;
echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
exit;
}
function replaceSpaces($field, $conn) {
$UTF8_NBSP = "\xC2\xA0";
$sql = "UPDATE exemples SET {$field} = REPLACE({$field}, ' ;', '{$UTF8_NBSP};')";
$sql .= ", {$field} = REPLACE({$field}, ' :', '{$UTF8_NBSP}:')";
$sql .= ", {$field} = REPLACE({$field}, ' !', '{$UTF8_NBSP}!')";
$sql .= ", {$field} = REPLACE({$field}, ' ?', '{$UTF8_NBSP}?')";
// guillemets français ouvrant et fermant
$sql .= ", {$field} = REPLACE({$field}, '«', '«{$UTF8_NBSP}')";
$sql .= ", {$field} = REPLACE({$field}, '»', '{$UTF8_NBSP}»')";
global $link;
if (mysqli_query($link, $sql)) {
echo "Record updated successfully for field '{$field}'";
} else {
echo "Error updating record for field '{$field}': " . mysqli_error($link);
}
}
replaceSpaces("champ1", $link);
replaceSpaces("champ2", $link);
mysqli_close($link); |
Partager