Advertisement
kozdiabka

Establishing a MySQL connection using PHP 5 PDO driver

Jul 8th, 2014
232
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.01 KB | None | 0 0
  1. <?php
  2.  
  3. mb_internal_encoding("UTF-8");
  4. setlocale(LC_ALL, "ru_RU.UTF-8");
  5.  
  6. $user = "alex";
  7. $password = "alex";
  8. $port = 3306;
  9. $host = "localhost";
  10. $db_name = "encoding_test";
  11. $pdo_options = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8");
  12. $dsn = "mysql:host=".$host.";dbname=".$db_name.";charset=utf8";
  13.  
  14. try
  15. {
  16.     $db_connect = new PDO($dsn, $user, $password, $pdo_options);
  17.  
  18.     //insert data
  19.     $some_utf8_data = "Нет, всё в порядке, никаких проблем нет. Работает!";
  20.     $statement = $db_connect->prepare("INSERT INTO `utf8_table` (`info`) values(:my_inf_value)");
  21.     $statement->bindParam(":my_inf_value", $some_utf8_data, PDO::PARAM_STR);
  22.     $statement->execute();
  23.  
  24.     //select some data
  25.     $statement = $db_connect->prepare("SELECT * FROM `utf8_table`");
  26.     $statement->execute();
  27.     $results = $statement->fetchAll(PDO::FETCH_ASSOC);
  28.     print_r($results);
  29. }
  30. catch (PDOException $e)
  31. {
  32.     echo "Connection failed: ".$e->getMessage();
  33. }
  34.  
  35. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement