Advertisement
Guest User

Untitled

a guest
Sep 24th, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.66 KB | None | 0 0
  1. <?php
  2.  
  3. class Database {
  4.  
  5.     public function __construct(){
  6.         $dbHost = "localhost";
  7.         $dbUser = "root";
  8.         $dbPass = "";
  9.         $dbName = "test";
  10.        
  11.         $conn = mysql_connect("$dbHost", "$dbUser", "$dbPass") or die (mysql_error());
  12.         mysql_select_db("$dbName", $conn) or die(mysql_error());
  13.  
  14.         return $this->conn;
  15.     }
  16.    
  17.     function retrieve(){
  18.         $query = $this->sql;
  19.         $result = mysql_query($query) or die(mysql_error());
  20.        
  21.         while($fetch = mysql_fetch_array($result)){
  22.  
  23.             print_r($fetch);
  24.        
  25.         }
  26.        
  27.        
  28.    
  29.     }
  30.    
  31.     function __destruct(){
  32.         mysql_close();
  33.     }
  34.    
  35.  
  36.  
  37.  
  38. }
  39.     $data = new Database();
  40.     $data->sql = "SELECT * FROM employees";
  41.     $data->retrieve();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement