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 vote244 views1 answer
Sql server python connection
SQL
0 vote248 views1 answer
Inner join distinct
SQL
0 vote231 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
0 vote196 views1 answer
Mysql workbench procedure
SQL
13 votes175 views6 answers
Restart postgresql
SQL
0 vote188 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
0 vote177 views1 answer
Restart sql server command line linux
SQL
1 vote189 views1 answer
Stored procedure return value
SQL
1 vote188 views1 answer
Sql server list locks
SQL
0 vote159 views2 answers
Avg() sql
SQL