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 vote315 views1 answer
Database springboot
SQL
0 vote344 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
0 vote328 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote314 views1 answer
Search db for table name
SQL
0 vote319 views1 answer
Mysql workbench primary key
SQL
0 vote351 views1 answer
Create a sql server database programmatically
SQL
0 vote327 views1 answer
Plsql check for string in numeric
SQL
0 vote345 views1 answer
Convert excel into sqllite db using python
SQL
0 vote359 views2 answers
Select a row include list of array with join two table SQL
SQL
5 votes338 views5 answers
Find max number in sql
SQL