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 vote286 views1 answer
Mysql count with two joins
SQL
1 vote308 views3 answers
Union SQL
SQL
0 vote336 views1 answer
Sql basic commands
SQL
0 vote270 views1 answer
Save single sql query result boolean spring boot
SQL
0 vote354 views1 answer
Intellij mysql set timezone
SQL
1 vote276 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
5 votes303 views2 answers
Sql server port number
SQL
42 votes364 views6 answers
Sql query duplicate rows
SQL
0 vote287 views1 answer
PSQL qith variables
SQL
0 vote300 views1 answer
Mysql page segment
SQL