View difference between Paste ID: N5Hmrcw5 and PjtGTUzC

-<?php
+G<?php
-
+
-abstract class baseDAO{
+abstract class baseDAO{
-	private $__connection;
+	private $__connection;
-
+
-	public function __construct(){
+	public function __construct(){
-		$this->_connectToDB(DB_USER, DB_PASS, DB_HOST, DB_DATABASE);
+		$this->_connectToDB(DB_USER, DB_PASS, DB_HOST, DB_DATABASE);
-	}
+	}
-
+
-	private function __connectToDB($user, $pass, $host, $database){
+	private function __connectToDB($user, $pass, $host, $database){
-		$this->__connection = mysql_connect($host, $user, $pass);
+		$this->__connection = mysql_connect($host, $user, $pass);
-		mysql_select_db($database, $this->__connection);
+		mysql_select_db($database, $this->__connection);
-	}
+	}
-
+
-	public function fetch($value, $key = NULL){
+	public function fetch($value, $key = NULL){
-		if (is_null($key)){
+		if (is_null($key)){
-			$key = $this- > primaryKey;
+			$key = $this- > primaryKey;
-		}
+		}
-
+
-		$sql = "select * from {$this->tableName} where {$key}='{$value}'";
+		$sql = "select * from {$this->tableName} where {$key}='{$value}'";
-		$results = mysql_query($sql, $this- >__connection);
+		$results = mysql_query($sql, $this- >__connection);
-		$rows = array();
+		$rows = array();
-
+
-		while ($result = mysql_fetch_array($results)) {
+		while ($result = mysql_fetch_array($results)) {
-			$rows[] = $result;
+			$rows[] = $result;
-		}
+		}
-		return $rows;
+		return $rows;
-	}
+	}
-
+
-	public function update($keyedArray){
+	public function update($keyedArray){
-		$sql = "update {$this->tableName} set ";
+		$sql = "update {$this->tableName} set ";
-		$updates = array();
+		$updates = array();
-
+
-		foreach ($keyedArray as $column=> $value) {
+		foreach ($keyedArray as $column=> $value) {
-			$updates[] = "{$column}='{$value}'";
+			$updates[] = "{$column}='{$value}'";
-		}
+		}
-
+
-		$sql .= implode(',', $updates);
+		$sql .= implode(',', $updates);
-		$sql .= "where {$this->primaryKey}='{$keyedArray[$this->primaryKey]}'";
+		$sql .= "where {$this->primaryKey}='{$keyedArray[$this->primaryKey]}'";
-		mysql_query($sql, $this->__connection);
+		mysql_query($sql, $this->__connection);
-	}
+	}
-}
+}
-
+
-class userDAO extends baseDAO{
+class userDAO extends baseDAO{
-	protected $_tableName = 'userTable';
+	protected $_tableName = 'userTable';
-	protected $_primaryKey = 'id';
+	protected $_primaryKey = 'id';
-
+
-	public function getUserByFirstName($name){
+	public function getUserByFirstName($name){
-		$result = $this->fetch($name, 'firstName');
+		$result = $this->fetch($name, 'firstName');
-		return $result;
+		return $result;
-	}
+	}
-}
+}
-
+
-
+
-define('DB_USER', 'user');
+define('DB_USER', 'user');
-define('DB_PASS', 'pass');
+define('DB_PASS', 'pass');
-define('DB_HOST', 'localhost');
+define('DB_HOST', 'localhost');
-define('DB_DATABASE', 'test');
+define('DB_DATABASE', 'test');
-
+
-$user = new userDAO();
+$user = new userDAO();
-$userDetailsArray = $user->fetch(1);
+$userDetailsArray = $user->fetch(1);
-$updates = array('id' => 1, 'firstName' => 'aaron');
+$updates = array('id' => 1, 'firstName' => 'aaron');
-$user->update($updates);
+$user->update($updates);
-$allAarons = $user->getUserByFirstName('aaron');
+$allAarons = $user->getUserByFirstName('aaron');
 ?>