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 vote203 views3 answers
Mysql Server Start
SQL
4 votes318 views6 answers
Laravel jwt
SQL
13 votes297 views2 answers
Sqlite rename table
SQL
0 vote275 views1 answer
Php insert null mysql
SQL
7 votes256 views4 answers
Mysql delete older duplicates
SQL
-1 vote212 views2 answers
Installing mysql on centos 7
SQL
21 votes219 views4 answers
Add column mssql
SQL
58 votes586 views4 answers
Mysql drop column
SQL
0 vote278 views1 answer
Sqlite schema structure of a relational database
SQL
2 votes229 views2 answers
Mysql does sentence contain word
SQL