Advertisement
Guest User

MySQL utf-8

a guest
Nov 19th, 2018
156
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.79 KB | None | 0 0
  1. <?php
  2. //>=php 5.3.6
  3. try {
  4.     $user = '';
  5.     $pass ='';
  6.     $db = 'my_nick';
  7.     $dbh = new PDO("mysql:host=localhost;dbname=$db;charset=utf8", $user, $pass);
  8.     $dbh->exec("CREATE TABLE IF NOT EXISTS `$db`.`tabella2` (
  9.    `campo` varchar(6) NOT NULL
  10.    ) ENGINE=MyISAM DEFAULT CHARSET=utf8");
  11.     $stmt = $dbh->prepare("INSERT INTO `$db`.`tabella2` (`campo`) VALUES (:value)");
  12.     $stmt->bindParam(':value', $value, PDO::PARAM_STR, 6);
  13.     $value = "\xC3\xA0".'bc';
  14.     $stmt->execute();
  15.     foreach($dbh->query("SELECT `campo` from `$db`.`tabella2`",PDO::FETCH_ASSOC) as $row) {
  16.         header('Content-type: text/plain; charset=utf-8');
  17.         print_r($row);
  18.     }
  19.     $dbh = null;
  20. } catch (PDOException $e) {
  21.     print "Error!: " . $e->getMessage() . "\n";
  22.     die();
  23. }
  24. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement