<?php

class Database {

    private $conn;
    private $result;

    function __construct(){

        //establish database connection

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

        $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 insert($data){


            foreach($data as $field => $value){

                $fields[] = $field;
                $values[] ="'" .  $value . "'";

            }

            $fieldname = join(',' , $fields);
            $newVal = join(',' , $values);

            $query = "INSERT INTO students (" . $fieldname . ") VALUES (" . $newVal . ") ";
            echo $query;
            $result = mysql_query($query) or die( mysql_error());
            echo $result;
            return $result;
    }

    function __destruct(){

        mysql_close($this->conn);

    }



}


    $d = new Database();

    $fname = $_POST['first_name'];
    $lname = $_POST['last_name'];
    $eadd = $_POST['email_address'];
    $mobile = $_POST['mobile_number'];

    $data = array(
            'first_name' => $fname,
            'last_name' => $lname,
            'email_address' => $eadd,
            'mobile_number' => $mobile
    );

    $d->insert($data);