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

9 votes200 views1 answer
No sql
SQL
8 votes153 views3 answers
Alter user root mysql
SQL
1 vote153 views1 answer
Delete row mssql
SQL
0 vote163 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
25 votes250 views6 answers
Change column name mysql
SQL
1 vote169 views1 answer
Oracle create index if not exists
SQL
1 vote155 views1 answer
Sql update table remove spaces
SQL
0 vote169 views1 answer
Cartesian product sql
SQL
0 vote159 views1 answer
Default value false mysql
SQL
0 vote158 views1 answer
Sql select most frequent value in column
SQL