Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- mb_internal_encoding("UTF-8");
- setlocale(LC_ALL, "ru_RU.UTF-8");
- $user = "alex";
- $password = "alex";
- $port = 3306;
- $host = "localhost";
- $db_name = "encoding_test";
- $pdo_options = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8");
- $dsn = "mysql:host=".$host.";dbname=".$db_name.";charset=utf8";
- try
- {
- $db_connect = new PDO($dsn, $user, $password, $pdo_options);
- //insert data
- $some_utf8_data = "Нет, всё в порядке, никаких проблем нет. Работает!";
- $statement = $db_connect->prepare("INSERT INTO `utf8_table` (`info`) values(:my_inf_value)");
- $statement->bindParam(":my_inf_value", $some_utf8_data, PDO::PARAM_STR);
- $statement->execute();
- //select some data
- $statement = $db_connect->prepare("SELECT * FROM `utf8_table`");
- $statement->execute();
- $results = $statement->fetchAll(PDO::FETCH_ASSOC);
- print_r($results);
- }
- catch (PDOException $e)
- {
- echo "Connection failed: ".$e->getMessage();
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement