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 vote324 views1 answer
Primary key multiple colums
SQL
0 vote319 views1 answer
Create function in microsoft sql server
SQL
0 vote299 views1 answer
Events not working db
SQL
0 vote348 views1 answer
Oracle pl/sql check if file exists
SQL
0 vote297 views1 answer
Enable Rabbitmq management plugin
SQL
2 votes291 views2 answers
Oracle multiple insert
SQL
2 votes282 views2 answers
Select multiple tables mysql
SQL
2 votes350 views2 answers
Mysql write into table
SQL
-1 vote335 views1 answer
Create view in mysql workbench
SQL
9 votes337 views3 answers
Find all tables with column name
SQL