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

1 vote392 views1 answer
Update foreign key value in mysql
SQL
1 vote355 views1 answer
How to make a select in sql
SQL
-1 vote388 views1 answer
Concat two columns in sql server
SQL
10 votes348 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote387 views1 answer
Selecting Multiple Columns in SQL
SQL
2 votes357 views1 answer
Sql server conection string
SQL
0 vote364 views1 answer
Executescalar in sql server
SQL
0 vote369 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
103 votes586 views1 answer
Like sql
SQL
3 votes410 views1 answer
Oracle undo tablespace schema
SQL