<?php

class Database {

    private $conn;
    private $result;

    function __construct(){

        //establish database connection

        $dbHost = 'localhost';
        $dbUser = 'root';
        $dbPass = '';
        $dbName = 'test';

        $this->conn = mysql_connect("$dbHost", "$dbUser", "$dbPass") or die (mysql_error('Error connecting to the database'));
        mysql_select_db("$dbName") or die(mysql_error('Error in Selecting Database'));

        return $this->conn;
    }

    function execute(){
        $query = $this->sql;
        $this->result = mysql_query($query) or die(mysql_error('error in retrieving records'));
    }

    function fetch_array(){

        //retrieve records
        $this->execute();
        while($fetch = mysql_fetch_array($this->result)){

                print_r($fetch);
        }

    }

    function fetch_row(){

        $this->execute();

        while($rows = mysql_fetch_row($this->result)){

            print_r($rows);

        }
    }

    //close database connection

    function __destruct(){

        mysql_close($this->conn);

    }

}


    $data = new Database();
    $data->sql = "SELECT * FROM employees ORDER BY id";
    $data->fetch_array();
    echo "</br>";
    $data->fetch_row();