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 vote209 views1 answer
Sql pivot without aggregate
SQL
0 vote183 views1 answer
Pgsql is not permitted to log in
SQL
1 vote163 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
5 votes174 views2 answers
Oracle find all tables with column name
SQL
24 votes167 views4 answers
How to add column sql
SQL
3 votes171 views4 answers
Mysql decimal
SQL
0 vote185 views1 answer
Python mysql query to dataframe
SQL
2 votes150 views5 answers
Alter table primary key postgresql
SQL
0 vote164 views1 answer
MySQL error code 2068
SQL
31 votes162 views3 answers
Sql count(*)
SQL