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 vote216 views1 answer
How to alter length character varying postgres
SQL
11 votes219 views3 answers
Sql line numbers
SQL
7 votes185 views3 answers
How ot change name of column mysql
SQL
0 vote193 views1 answer
Postgres populate table from another table
SQL
1 vote249 views1 answer
Psql search table
SQL
0 vote219 views2 answers
Call to undefined function mysql_query()
SQL
3 votes208 views2 answers
How to start mysql in terminal
SQL
0 vote206 views1 answer
Create table with float datatype in sql server
SQL
4 votes191 views2 answers
Mysql how to change default charset
SQL
0 vote192 views1 answer
Equi joins in oracle
SQL