<?php


class CustomerService {

	private $connection;

	private function connect() {
		// TODO Establish the database connection
		
		// Sample code
		
			  $this->connection = mysqli_connect("servername",  "username",  "password", "databasename") or die(mysqli_connect_error());	    
	}

	public function getAllCustomers() {
		
			  $this->connect();
			  $sql = "SELECT * FROM customers";
			  
			  $result = mysqli_query($this->connection, $sql) or die('Query failed: ' . mysqli_error($this->connection));
			  
			  $rows = array();
    	      while ($row = mysqli_fetch_object($result)) {
        	  		$rows[] = $row;
    	      }
    	      
    	      mysqli_free_result($result);
	  		  mysqli_close($this->connection);
	  		  
	          return $rows; 	
	}
}

?>