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

2 votes340 views3 answers
Postgres create view
SQL
3 votes305 views1 answer
Oracle wait
SQL
2 votes294 views1 answer
Oracle sql drop column if exists
SQL
0 vote352 views1 answer
Oracle current timestamp insert statement
SQL
2 votes333 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
1 vote321 views1 answer
Trigger in postgresql to change incoming entry
SQL
1 vote326 views1 answer
Postgresql delete cascade
SQL
0 vote347 views1 answer
Selecting Multiple Columns in SQL
SQL
6 votes304 views1 answer
SQL insert all columns
SQL
0 vote280 views1 answer
Kannst du deine finger trainieren
SQL