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

5 votes231 views2 answers
Postgresql insert select
SQL
-1 vote213 views1 answer
Capitole toulouse
SQL
1 vote221 views1 answer
Hangfire clear all jobs
SQL
0 vote318 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
0 vote190 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
1 vote213 views1 answer
Denied
SQL
1 vote183 views3 answers
Java.sql.sqlexception: access denied for user
SQL
4 votes268 views1 answer
Postgresql list sequences
SQL
0 vote219 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
1 vote203 views1 answer
How to group by month using sql server
SQL