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

17 votes378 views3 answers
Postgresql list users
SQL
0 vote355 views1 answer
Min:sec datediff mssql
SQL
31 votes344 views2 answers
Grant all priviledges to mysql user
SQL
0 vote350 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
0 vote332 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote329 views1 answer
QUERY JPQL
SQL
0 vote380 views1 answer
Min varias colunas spark sql
SQL
0 vote316 views1 answer
What is mysql_pconnect
SQL
12 votes338 views3 answers
Install sqlite driver ubuntu
SQL
0 vote307 views1 answer
How to connect to mysql in ef 6
SQL