G<?php

abstract class baseDAO{
    private $__connection;

    public function __construct(){
        $this->_connectToDB(DB_USER, DB_PASS, DB_HOST, DB_DATABASE);
    }

    private function __connectToDB($user, $pass, $host, $database){
        $this->__connection = mysql_connect($host, $user, $pass);
        mysql_select_db($database, $this->__connection);
    }

    public function fetch($value, $key = NULL){
        if (is_null($key)){
            $key = $this- > primaryKey;
        }

        $sql = "select * from {$this->tableName} where {$key}='{$value}'";
        $results = mysql_query($sql, $this- >__connection);
        $rows = array();

        while ($result = mysql_fetch_array($results)) {
            $rows[] = $result;
        }
        return $rows;
    }

    public function update($keyedArray){
        $sql = "update {$this->tableName} set ";
        $updates = array();

        foreach ($keyedArray as $column=> $value) {
            $updates[] = "{$column}='{$value}'";
        }

        $sql .= implode(',', $updates);
        $sql .= "where {$this->primaryKey}='{$keyedArray[$this->primaryKey]}'";
        mysql_query($sql, $this->__connection);
    }
}

class userDAO extends baseDAO{
    protected $_tableName = 'userTable';
    protected $_primaryKey = 'id';

    public function getUserByFirstName($name){
        $result = $this->fetch($name, 'firstName');
        return $result;
    }
}


define('DB_USER', 'user');
define('DB_PASS', 'pass');
define('DB_HOST', 'localhost');
define('DB_DATABASE', 'test');

$user = new userDAO();
$userDetailsArray = $user->fetch(1);
$updates = array('id' => 1, 'firstName' => 'aaron');
$user->update($updates);
$allAarons = $user->getUserByFirstName('aaron');
?>