Advertisement
Guest User

how to get variable $handler inside the function

a guest
Nov 28th, 2014
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. <?php
  2. require '../settings.php';
  3.  
  4. class Db {
  5.  
  6. protected static $instance = null;
  7.  
  8. public static function getInstance()
  9. {
  10. if (is_null(self::$instance)) {
  11. self::$instance = new self();
  12. }
  13.  
  14. return self::$instance;
  15. }
  16.  
  17.  
  18. }
  19.  
  20. // Tada galime naudoti
  21.  
  22. try
  23. {
  24. $handler = new PDO('mysql:host=localhost;dbname=mistic_rpe', login, password);
  25. $handler ->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  26. }catch (PDOException $e) {
  27. echo "pagavo";
  28. }
  29. //$result = Db::getInstance()->query($sql);
  30. /*
  31. function execute($sql){
  32.  
  33. $result = mysql_query($sql);
  34. return true;
  35. if (!$result) {
  36. return false;
  37. }
  38.  
  39.  
  40.  
  41. }
  42.  
  43. execute('CREATE DATABASE my_db;');
  44. */
  45.  
  46. function execute($sql)
  47. {
  48.  
  49. $query = $handler->query('SELECT * FROM Bandymas');
  50. while ($r = $query->fetch()) {
  51. echo $r['name'], "<br>";
  52. }
  53. };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement