Guest User

pdo

a guest
Oct 9th, 2019
158
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.01 KB | None | 0 0
  1. /* Function */
  2. function connectDatabase($host, $db, $user, $pass, $charset) {
  3.  
  4. $dsn = 'mysql:host=$host;dbname=$db;charset=$charset';
  5. $opt = [
  6.     \PDO::ATTR_ERRMODE            => \PDO::ERRMODE_EXCEPTION,
  7.     \PDO::ATTR_DEFAULT_FETCH_MODE => \PDO::FETCH_ASSOC,
  8.     \PDO::ATTR_EMULATE_PREPARES   => false,
  9. ];
  10.  
  11. try
  12. {
  13.    $pdo = new \PDO($dsn, $user, $pass, $opt);
  14. }
  15. catch (PDOException $e)
  16. {
  17.    echo $e->getMessage();
  18. }
  19.  
  20. }
  21.  
  22. /* Variables */
  23. $_base['host'] = 'localhost';
  24. $_base['db'] = 'dbname';
  25. $_base['user'] = 'username';
  26. $_base['pass'] = 'password';
  27. $_base['charset'] = 'utf8';
  28.  
  29. /* Execute */
  30. connectDatabase($_base['host'], $_base['db'], $_base['user'], $_base['pass'], $_base['charset']);
  31.  
  32. Error:
  33. SQLSTATE[HY000] [2005] Unknown MySQL server host '$host' (2)
  34. Fatal error: Uncaught Error: Call to a member function prepare() on null in /public_html/functions/file:11 Stack trace: #0 /public_html/settings.php(10): functionusingpdo('4') #1 {main} thrown in /public_html/functions/is_teacher.php on line 11
Advertisement
Add Comment
Please, Sign In to add comment