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

1 vote205 views2 answers
Create table if not exist
SQL
0 vote201 views1 answer
Excel export from sql using python
SQL
1 vote215 views1 answer
Default
SQL
1 vote197 views1 answer
How to drop function in sql
SQL
3 votes196 views1 answer
Set default today mysql
SQL
0 vote217 views1 answer
Sql server for loop
SQL
1 vote199 views1 answer
Order by oracle
SQL
14 votes200 views5 answers
Sql oracle limit
SQL
0 vote223 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
37 votes191 views3 answers
Postgresql insert column
SQL