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 vote335 views1 answer
Power bi dax add related shows column but not working
SQL
8 votes342 views4 answers
Mysql update one table from another table multiple columns
SQL
6 votes348 views2 answers
If not exists insert sql
SQL
0 vote356 views1 answer
What does leave do in mysql
SQL
2 votes355 views1 answer
Set auto increment from 1
SQL
0 vote344 views1 answer
Call rest api from postgresql
SQL
1 vote366 views1 answer
Drop table if exists oracle
SQL
1 vote329 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
36 votes357 views3 answers
Finding duplicate column values in table with sql
SQL
17 votes396 views3 answers
Postgresql list users
SQL