Advertisement
Guest User

Untitled

a guest
Feb 20th, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.07 KB | None | 0 0
  1. $db = new DB();
  2. $fo = new Foo($db);
  3.  
  4. print_r($db->query("SELECT * FROM tbl"));
  5.  
  6. print_r($fo->testSelect());
  7.  
  8. class Foo {
  9.  
  10. /**
  11. * Constructor
  12. * Aggregate class db object
  13. */
  14. public function __construct( DB $db ) {
  15. $this->db = $db;
  16. }
  17.  
  18. public function test() {
  19. return $this->db->query("select * from tbl");
  20. }
  21. }
  22.  
  23. if ( !class_exists( 'DB' ) ) {
  24.  
  25. class DB {
  26.  
  27. private function connect() {
  28. $mysqli = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME, DB_PORT, DB_SOCKET);
  29. if ( $mysqli->connect_error ) {
  30. die( "Connection failed: " . $mysqli->connect_errno . ' ' . $mysqli->connect_error );
  31. } else {
  32. $mysqli->set_charset(DB_CHARSET);
  33. }
  34. return $mysqli;
  35. }
  36.  
  37. public function query( $query ) {
  38. $db = $this->connect();
  39. $result = $db->query( $query );
  40. while ( $row = $result->fetch_array(MYSQLI_ASSOC) ) {
  41. $results[] = $row;
  42. }
  43. $result->free();
  44. $db->close();
  45. return $results;
  46. }
  47.  
  48. ..insert, update, delete function..
  49. }
  50. }
  51.  
  52. if ( !class_exists( 'DB' ) ) {
  53.  
  54. class DB {
  55.  
  56. private mysqli;
  57.  
  58. public function __construct() {
  59. $this->mysqli = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME, DB_PORT, DB_SOCKET);
  60. if ( $this->mysqli->connect_error ) {
  61. die( "Connection failed: " . $this->mysqli->connect_errno . ' ' . $this->mysqli->connect_error );
  62. } else {
  63. $this->mysqli->set_charset(DB_CHARSET);
  64. }
  65. return $this->mysqli;
  66. }
  67.  
  68. public function query($query) {
  69. $result = $this->mysqli->query( $query );
  70. while ( $row = $result->fetch_array(MYSQLI_ASSOC) ) {
  71. $results[] = $row;
  72. }
  73. $result->free();
  74. return $results;
  75. }
  76.  
  77. ..insert, update, delete function..
  78.  
  79. public function __destruct() {
  80. $this->mysqli->close();
  81. }
  82. }
  83. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement