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 vote112 views1 answer
Sql select where more than one record exists
SQL
0 vote161 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
1 vote96 views2 answers
Mysql trim whitespace
SQL
3 votes122 views1 answer
Oracle function return
SQL
57 votes262 views5 answers
How to create a new user in postgresql
SQL
2 votes92 views1 answer
Sql update alias
SQL
7 votes100 views2 answers
Phpmyadmin change password
SQL
0 vote95 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
0 vote92 views1 answer
Tsql generate rows
SQL
0 vote104 views1 answer
Mysql trim characters
SQL