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 vote361 views1 answer
Find usage of table in sql server
SQL
0 vote410 views1 answer
Postgres - Login and connect as default user
SQL
3 votes360 views1 answer
Async await mysql nodejs
SQL
0 vote337 views1 answer
TSQL function split string
SQL
-2 votes343 views1 answer
Remove root password mysql
SQL
1 vote354 views2 answers
How to add amount between date in sql
SQL
0 vote374 views2 answers
Pop sql insert value into
SQL
0 vote379 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
1 vote330 views1 answer
Autocommit mysql
SQL
1 vote329 views1 answer
MySQL AND Operator
SQL