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

3 votes274 views2 answers
Mysql select database
SQL
4 votes236 views1 answer
Sql list users and roles
SQL
0 vote290 views3 answers
Sql parenthetical expression examples
SQL
0 vote267 views1 answer
Postgresql import a database of gzip
SQL
0 vote261 views1 answer
Reading from right to left from string find first special characters in sql
SQL
0 vote274 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
5 votes267 views1 answer
Sql check if date is between 2 dates
SQL
0 vote255 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote288 views2 answers
How to take recent row without limit in mysql
SQL
0 vote255 views1 answer
Sql select column names starting with
SQL