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 vote280 views1 answer
Mysql select field if condition
SQL
0 vote185 views1 answer
Mssql + bit + in python orm
SQL
1 vote169 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
1 vote154 views1 answer
Deleting database in sql
SQL
1 vote163 views1 answer
Postgres grant read only access to database
SQL
0 vote237 views3 answers
How to find all role in mysql
SQL
7 votes168 views1 answer
Oracle pagination query offset
SQL
7 votes162 views1 answer
Sql management studio display line numbers
SQL
0 vote163 views1 answer
Python sqlalchemy orm to select null values
SQL
0 vote295 views1 answer
Provera dupliranih konatakata
SQL