Advertisement
Guest User

Untitled

a guest
Feb 13th, 2016
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.82 KB | None | 0 0
  1. class DataAccess{
  2. private $DB_HOSTNAME = 'local';
  3. private $USERNAME = 'user';
  4. private $PASSWORD = 'pass';
  5. private $DB_NAME = 'db_name';
  6. private $mysqli;
  7.  
  8. public function connect_db() {
  9. $this -> $mysqli = new mysqli($DB_HOSTNAME, $USERNAME, $PASSWORD, $DB_NAME);
  10. if($this -> $mysqli)
  11. echo "Connection succesful";
  12. else
  13. die ("Problem with connection" . mysqli_connect_error());
  14. }
  15.  
  16. public function getAll() {
  17. $sqlQuery = 'SELECT pay FROM payment';
  18. $result = $this -> $mysqli -> query($sqlQuery);
  19. while ($row = mysqli_fetch_array($result)){
  20. echo 'Pay: ' . $row['pay'];
  21. }
  22. }
  23. }
  24.  
  25. require 'DataAccess.php';
  26.  
  27. $test = new DataAccess();
  28. $test -> connect_db();
  29.  
  30. $result = $test -> getAll();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement