Advertisement
Guest User

Untitled

a guest
Jun 29th, 2017
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.52 KB | None | 0 0
  1.  
  2. function imTranslite($ru_text)
  3. {
  4. static $tbl = array(
  5. "а" => "a", "б" => "b", "в" => "v", "г" => "g", "д" => "d", "е" => "e", "ж" => "g", "з" => "z",
  6. "и" => "i", "й" => "y", "к" => "k", "л" => "l", "м" => "m", "н" => "n", "о" => "o", "п" => "p",
  7. "р" => "r", "с" => "s", "т" => "t", "у" => "u", "ф" => "f", "ы" => "y", "э" => "e", "А" => "A",
  8. "Б" => "B", "В" => "V", "Г" => "G", "Д" => "D", "Е" => "E", "Ж" => "G", "З" => "Z", "И" => "I",
  9. "Й" => "Y", "К" => "K", "Л" => "L", "М" => "M", "Н" => "N", "О" => "O", "П" => "P", "Р" => "R",
  10. "С" => "S", "Т" => "T", "У" => "U", "Ф" => "F", "Ы" => "Y", "Э" => "E", "ё" => "yo", "х" => "h",
  11. "ц" => "ts", "ч" => "ch", "ш" => "sh", "щ" => "shch", "ъ" => "", "ь" => "", "ю" => "yu", "я" => "ya",
  12. "Ё" => "YO", "Х" => "H", "Ц" => "TS", "Ч" => "CH", "Ш" => "SH", "Щ" => "SHCH", "Ъ" => "", "Ь" => "",
  13. "Ю" => "YU", "Я" => "YA"
  14. );
  15.  
  16. return strtr($ru_text, $tbl);
  17. }
  18.  
  19. $username = 'anticorm';
  20. $password = 'che6Ywga';
  21. $servername = 'localhost';
  22.  
  23. try {
  24. $conn = new PDO("mysql:host=$servername;dbname=wwwanticormru;charset=cp1251", $username, $password);
  25. // set the PDO error mode to exception
  26. $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  27. echo "Connected successfully";
  28. $stmt = $conn->prepare("SELECT id, name FROM production");
  29. $stmt->execute();
  30.  
  31. // set the resulting array to associative
  32. $result = $stmt->setFetchMode(PDO::FETCH_ASSOC);
  33. $result = $stmt->fetchAll();
  34. $toReplace = array(" / ", "+ ", "+", "_", " ", "%20", '/');
  35. echo "<pre>";
  36. foreach ($result as $key => $value) {
  37.  
  38. $alias = $value['name'];
  39. $alias = str_replace(array("(", ")", "+", ",", ".", "\\"), "", $alias);
  40.  
  41. $alias = mb_strtolower($alias, 'windows-1251');
  42. $alias = iconv('windows-1251', 'UTF-8', $alias);
  43.  
  44. $alias = imTranslite($alias);
  45. $alias = iconv('UTF-8', 'windows-1251', $alias);
  46. $alias = str_replace($toReplace, "-", $alias);
  47. $alias = preg_replace("#^(.*?)-$#iu", "$1", $alias);
  48. $alias = preg_replace("#^-(.*?)$#iu", "$1", $alias);
  49. $alias = preg_replace('#\-+#', '-', $alias);
  50.  
  51. echo "<br/>";
  52. $stmt = $conn->prepare("UPDATE production
  53. SET alias='$alias'
  54. WHERE id='{$value['id']}'");
  55. $stmt->execute();
  56. }
  57.  
  58. }
  59. catch(PDOException $e)
  60. {
  61. echo "Connection failed: " . $e->getMessage();
  62. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement