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 vote301 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote254 views1 answer
Create sqlite database in laravel
SQL
0 vote275 views1 answer
Selecting all columns from table sql database
SQL
18 votes258 views6 answers
Drop table if exists
SQL
3 votes269 views2 answers
How to modify rows in SQL Server
SQL
0 vote280 views1 answer
Get last three characters in mysql column
SQL
-1 vote248 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote263 views1 answer
Postgres declare variable
SQL
0 vote286 views1 answer
Oracle webcenter content search enginer
SQL
3 votes274 views1 answer
Select count from table mysql
SQL