Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function imTranslite($ru_text)
- {
- static $tbl = array(
- "а" => "a", "б" => "b", "в" => "v", "г" => "g", "д" => "d", "е" => "e", "ж" => "g", "з" => "z",
- "и" => "i", "й" => "y", "к" => "k", "л" => "l", "м" => "m", "н" => "n", "о" => "o", "п" => "p",
- "р" => "r", "с" => "s", "т" => "t", "у" => "u", "ф" => "f", "ы" => "y", "э" => "e", "А" => "A",
- "Б" => "B", "В" => "V", "Г" => "G", "Д" => "D", "Е" => "E", "Ж" => "G", "З" => "Z", "И" => "I",
- "Й" => "Y", "К" => "K", "Л" => "L", "М" => "M", "Н" => "N", "О" => "O", "П" => "P", "Р" => "R",
- "С" => "S", "Т" => "T", "У" => "U", "Ф" => "F", "Ы" => "Y", "Э" => "E", "ё" => "yo", "х" => "h",
- "ц" => "ts", "ч" => "ch", "ш" => "sh", "щ" => "shch", "ъ" => "", "ь" => "", "ю" => "yu", "я" => "ya",
- "Ё" => "YO", "Х" => "H", "Ц" => "TS", "Ч" => "CH", "Ш" => "SH", "Щ" => "SHCH", "Ъ" => "", "Ь" => "",
- "Ю" => "YU", "Я" => "YA"
- );
- return strtr($ru_text, $tbl);
- }
- $username = 'anticorm';
- $password = 'che6Ywga';
- $servername = 'localhost';
- try {
- $conn = new PDO("mysql:host=$servername;dbname=wwwanticormru;charset=cp1251", $username, $password);
- // set the PDO error mode to exception
- $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- echo "Connected successfully";
- $stmt = $conn->prepare("SELECT id, name FROM production");
- $stmt->execute();
- // set the resulting array to associative
- $result = $stmt->setFetchMode(PDO::FETCH_ASSOC);
- $result = $stmt->fetchAll();
- $toReplace = array(" / ", "+ ", "+", "_", " ", "%20", '/');
- echo "<pre>";
- foreach ($result as $key => $value) {
- $alias = $value['name'];
- $alias = str_replace(array("(", ")", "+", ",", ".", "\\"), "", $alias);
- $alias = mb_strtolower($alias, 'windows-1251');
- $alias = iconv('windows-1251', 'UTF-8', $alias);
- $alias = imTranslite($alias);
- $alias = iconv('UTF-8', 'windows-1251', $alias);
- $alias = str_replace($toReplace, "-", $alias);
- $alias = preg_replace("#^(.*?)-$#iu", "$1", $alias);
- $alias = preg_replace("#^-(.*?)$#iu", "$1", $alias);
- $alias = preg_replace('#\-+#', '-', $alias);
- echo "<br/>";
- $stmt = $conn->prepare("UPDATE production
- SET alias='$alias'
- WHERE id='{$value['id']}'");
- $stmt->execute();
- }
- }
- catch(PDOException $e)
- {
- echo "Connection failed: " . $e->getMessage();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement