LoginSignup
8
9

More than 5 years have passed since last update.

PHP、MySQLで4バイトのUTF8を使うとき

Posted at

MySQLでデータベースの作成

CREATE DATABASE データベース名 CHARACTER SET uff8mb4;

PHPでPDOの初期化

<?php
try{
    $dbh = new PDO('mysql:dbname=データベース名;host=localhost;charset=utf8mb4;');
}
catch(PDOException $e){
    dir('エラーメッセージ: ' . $e->GetCode());
}
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
8
9
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
8
9