Mysqli or pdo

Using mysqli and pdo

$dsn = "mysql:host=localhost;dbname=myDatabase;charset=utf8mb4";
$options = [
  PDO::ATTR_EMULATE_PREPARES   => false, // turn off emulation mode for "real" prepared statements
  PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION, //turn on errors in the form of exceptions
  PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, //make the default fetch be an associative array
];
try {
  $pdo = new PDO($dsn, "username", "password", $options);
} catch (Exception $e) {
  error_log($e->getMessage());
  exit('Something weird happened'); //something a user can understand
}
Copy

Source: websitebeaver.com

Similar codes

24 votes122 views4 answers
Postgres remove database
SQL
0 vote117 views1 answer
How much table store postgres
SQL
0 vote119 views1 answer
Mysql concatenate select results
SQL
1 vote133 views1 answer
T-SQL / AZURE Reseed
SQL
1 vote123 views1 answer
Mysql show database size in mb
SQL
0 vote121 views1 answer
Delete first row in sql
SQL
19 votes115 views5 answers
Date between in mysql
SQL
38 votes172 views6 answers
Alter table mysql
SQL
1 vote125 views1 answer
Mysql decimal allow negative values?
SQL
0 vote126 views1 answer
Mysql default tls v1.3 ciphersuites
SQL