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 vote191 views1 answer
How to increase the width of the screen in oracle
SQL
0 vote226 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote213 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
0 vote221 views1 answer
Sql get count without group by
SQL
1 vote194 views1 answer
Set statiscis on in sql server
SQL
1 vote217 views1 answer
Regular expression in sql server
SQL
0 vote208 views1 answer
Postgresql using reserved word as column name
SQL
1 vote239 views1 answer
Backup mysql schema only
SQL
4 votes208 views3 answers
NOT NULL SQL
SQL
0 vote247 views1 answer
Plpgsql create function
SQL