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 vote246 views1 answer
ORACLE PARSE STRING
SQL
0 vote213 views1 answer
Mysql dump with table query
SQL
0 vote238 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
0 vote218 views1 answer
Search column name sql
SQL
9 votes199 views4 answers
Mysql show table fields
SQL
6 votes189 views1 answer
Oracle list primary key
SQL
2 votes189 views2 answers
Mysql user access to database
SQL
-2 votes199 views1 answer
Modify column name in tsql
SQL
0 vote202 views1 answer
Excel export from sql using python
SQL
1 vote210 views2 answers
Find nth highest salary of an employee
SQL