Guest User

Untitled

a guest
Nov 26th, 2017
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. $host = '127.0.0.1';
  2. $dbname = 'test';
  3. $username = 'root';
  4. $password = '';
  5. $charset = 'utf8';
  6. $collate = 'utf8_unicode_ci';
  7. $dsn = "mysql:host=$host;dbname=$dbname;charset=$charset";
  8. $options = [
  9. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  10. PDO::ATTR_PERSISTENT => false,
  11. PDO::ATTR_EMULATE_PREPARES => false,
  12. PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  13. PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES $charset COLLATE $collate"
  14. ];
  15.  
  16. $pdo = new PDO($dsn, $username, $password, $options);
Add Comment
Please, Sign In to add comment