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 vote222 views2 answers
How to select the lowest values from table per client sql
SQL
4 votes220 views1 answer
Oracle user tables
SQL
0 vote216 views1 answer
Sql select all tables from database change url
SQL
1 vote222 views1 answer
Postgres get month name from date
SQL
16 votes254 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
0 vote223 views1 answer
Sql mod even odd
SQL
0 vote248 views1 answer
Primary key start from number
SQL
2 votes229 views1 answer
While loop sql
SQL
5 votes228 views1 answer
Oracle ORA-00054 origin
SQL
0 vote275 views1 answer
Generate a random otp in sql server
SQL