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

0 vote205 views1 answer
Sql if clause within where clause
SQL
0 vote288 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
15 votes141 views5 answers
Select all tables sql
SQL
1 vote128 views1 answer
Xampp import sql file command line
SQL
0 vote175 views1 answer
Sql server is not
SQL
12 votes128 views2 answers
Delete entries in postgresql
SQL
2 votes115 views2 answers
How to get capital letter first in sql
SQL
0 vote119 views1 answer
How to find unique key in sql
SQL
0 vote163 views1 answer
Tsql cte in a transaction
SQL
23 votes114 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL