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 vote215 views2 answers
Update all columns in one update
SQL
0 vote221 views1 answer
Liquibase update row
SQL
12 votes213 views4 answers
Import mysql database command line linux
SQL
8 votes218 views1 answer
Oracle current date plus 1 month
SQL
0 vote220 views1 answer
Ubuntu connect to mssql database
SQL
0 vote223 views1 answer
Mysql dump everythign
SQL
0 vote230 views1 answer
Sqlalchemy query sql compiled
SQL
0 vote259 views1 answer
Kimball data warehouse sql calendar
SQL
2 votes216 views1 answer
Wait delay in sql server
SQL
0 vote172 views1 answer
Sql count how many times a value appears
SQL