Coder Forum

PHP Quellcode

abstract class Model {
	protected $primarykey = 'id';
	protected $data = array();
 
	abstract public function getColumns();
 
	function __construct($data = array()) {
		$this->data = $data;
	}
 
	public static function findById($id, $className) {
		$sql = "SELECT	 *
			FROM	 ".$this->getTablename()."
			WHERE	 ".$this->primarykey." = :id ";
		$stmt = MyDB::getInstance()->prepare($sql);
		$stmt->execute(array(
			':id' => $id
		));
		return new $className($stmt->fetch());	
	}
 
	protected function _findById() {
	}
 
	public function __set($name, $value) {
		$this->data[$name] = $value;
	}
 
	public function __get($name) {
		return $this->data[$name];
	}
 
	/**
	 * empty() on a __get function will not work as expected if isset has not been overriden
	 */
	public function __isset($key) {
		if (isset($this->data[$key])) {
			return (false === empty($this->data[$key]));
		} else {
			return null;
		}
	}
 
	public function validate() {
 
	}
 
	public function getTablename() {
		return get_class($this);
	}
 
	public function delete() {
		$primaryval = $this->{$this->primarykey};
 
		$sql = 'DELETE FROM '.$this->getTablename().' WHERE '.$this->primarykey.' = :primaryval';
		$stmt = MyDB::getInstance()->prepare($sql);
		$stmt->execute(array(
			':primaryval' => $primaryval
		));
	}
 
	public function save($override = null) {
		if($override !== null) {
			$this->data = array_merge($this->data, $override);
		}
 
		$this->validate();
		$params = array();
		$primaryval = $this->{$this->primarykey};
 
		// insert or update		
		if($primaryval === null) {
			$sql = 'INSERT INTO '.$this->getTablename().' ('.implode(',', $this->getColumns()).') VALUES (';
			foreach($this->getColumns() as $key) {
				$sql .= ':'.$key.',';
				$params[':'.$key] = $this->$key;
			}
			$sql = rtrim($sql,',').')';
			if(count($params)) {
				$stmt = MyDB::getInstance()->prepare($sql);
				$stmt->execute($params);
 
				// remember auto increment key
				$this->{$this->primarykey} = MyDB::getInstance()->lastInsertId();
			}
		} else {
			$sql = 'UPDATE '.$this->getTablename().' SET ';
			foreach($this->getColumns() as $key) {
				$sql .= $key.' = :'.$key.',';
				$params[':'.$key] = $this->$key;
			}
			$sql = rtrim($sql,',').' WHERE '.$this->primarykey.' = :primaryval';
			if(count($params)) {
				$params[':primaryval'] = $primaryval;
				$stmt = MyDB::getInstance()->prepare($sql);
				$stmt->execute($params);
			}
		}
	}
}

PHP Quellcode

class User extends Model {
	public function getTablename() {
		return get_class($this); // user
	}
	public function getColumns() {
		return array('email', 'password');
	}
 
	public function validate() {
		if(...) {
			throw new ValidateException('message');
		}
	}
}

PHP Quellcode

<form method="post">
	email: <input type="text" name="email" /><br/>
	password: <input type="password" name="password" /><br/>
	<input type="submit">
</form>
<?php
if(count($_POST)) {
	$user = new User($_POST);
	$user->save();
}
?>

PHP Quellcode

<form method="post" action="edit.php?userid=123">
	email: <input type="text" name="email" /><br/>
	password: <input type="password" name="password" /><br/>
	<input type="submit">
</form>
<?php
if(count($_POST) && isset($_GET['userid'])) {
	$user = User::findById($_GET['userid']);
	$user->save($_POST);
}
?>