/core/model.php

<?php

class model {

	static $db = 'default';
 //Serveur MySQL sur lequel se connecter
	public $table;
 //Table correspondant au modèle
	public $key = 'id';
 //Nom de la clé primaire
	public $id; //Variable utilisée

	/**
	 *
	 *
	 * */
	public function __construct() {
		$this->connect(); // Connection à la base de données
		$query = 'DESCRIBE ' . $this->table;
		$results = mysql_query($query) or die(mysql_error());
		while ($row = mysql_fetch_assoc($results)) {
			$fieldName = $row['Field'];
			unset($row['Field']);
			$this->fields[$fieldName] = $row; //Récupération des infos des champs de la table dans $this->fields
		}
	}

	/**
	 * Permet une lecture rapide d'un modèle grace à son identifiant
	 * */
	public function read($fields=null) {
		if (empty($fields)) {
			$fields = '*';
		}
		$query = 'SELECT ' . $fields . ' FROM ' . $this->table . ' WHERE ' . $this->key . ' = "' . $this->id . '"';
		$result = mysql_query($query) or die(mysql_error());
		if (mysql_num_rows($results)) {
			$data = mysql_fetch_assoc($result);
			foreach ($data as $key => $value) {
				$this->$key = $value;
			}
			return true;
		} else {
			return false;
		}
	}

	public function save($data) {
		//Si l'id est rempli, il s'agit d'un UPDATE, sinon INSERT
		if ( (!empty($data[$this->key]) && count($data) > 1) || (empty($data[$this->key]) && count($data) > 0) ) {
			if ( !empty($data[$this->key]) ) {
				$type = 'UPDATE';
			}
			else {
				$type = 'INSERT';
			}
			$query = $type;
			//Construction de la requête
			$query .= ' ' . $this->db . '.' . $this->table . ' SET ';
			foreach ( $data as $key => $value ) {
				if ( $key != $this->key && isset($this->fields[$key]) ) {
					$query.= $key . ' = ?, ';
					$values[] = $value;
				}
			}
			$query = substr($query, 0, -2);

			//Mise à jour des champs updated et created
			if ( !empty($data[$this->key]) ) {
				if ( isset($this->fields['updated']) ) {
					$query .= ', updated = ?';
					$values[] = date('Y-m-d H:i:s');
				}
				$query.=' WHERE ' . $this->key . ' = ?';
				$values[] = $data[$this->key];
			}
			else {
				if ( isset($this->fields['created']) ) {
					$query .= ', created = ?';
					$values[] = date('Y-m-d H:i:s');
				}
			}

			//Execution de la requete
			if ( $this->connection->prepare($query)->execute($values) ) {
				if ( empty($data[$this->key]) ) {
					$this->id = $this->connection->lastInsertId();
				}
				else {
					$this->id = $data[$this->key];
				}
				return array(
					'type' => $type,
					'id' => $this->id
				);
			}
			else {

				return false;
			}
		}
		else {
			return false;
		}
	}

	public function find($options = array()) {
		$conditions = '1=1';
		$fields = '*';
		if (!empty($this->fields)) {
			$fields = '';
			foreach ($this->fields as $fieldName => $informations) {
				$fields .= $this->table . '.' . $fieldName . ' as ' . get_Class($this) . '_' . $fieldName . ', ';
			}
			$fields = substr($fields, 0, -2);
		}
		$limit = '';
		$order = $this->table . '.' . $this->key . ' ASC';
		$left_outer = '';
		//
		if (!empty($this->belongsTo)) {
			foreach ($this->belongsTo as $modelName) {
				$model = $this->load($modelName);
				//E.G. : , posts.id as post_id
				$fields .= ', ' . $model->table . '.' . $model->key . ' as ' . $modelName . '_' . $model->key;
				$fields .= ', ' . $model->table . '.' . $model->displayField . ' as ' . $modelName . '_' . $model->displayField;
				$left_outer .= ' LEFT OUTER JOIN ' . $model->table . ' ON ' . $this->table . '.' . $modelName . '_id = ' . $model->table . '.id';
			}
		}
		//
		if (!empty($options['conditions'])) {
			$conditions = $options['conditions'];
		}
		if (!empty($options['fields'])) {
			$fields = $options['fields'];
		}
		if (!empty($options['limit'])) {
			$limit = ' LIMIT ' . $options['limit'];
		}
		if (!empty($options['order'])) {
			$order = $this->table . '.' . $options['order'];
		}
		$query = 'SELECT ' . $fields . ' FROM ' . $this->table . $left_outer . ' WHERE ' . $conditions . ' ORDER BY ' . $order . $limit;
		$results = mysql_query($query) or die(mysql_error());
		if (mysql_num_rows($results)) {
			$i = 0;
			while ($row = mysql_fetch_assoc($results)) {
				foreach ($row as $fieldName => $value) {
					$pos = strpos($fieldName, '_');
					$prefix = substr($fieldName, 0, $pos);
					$sufix = substr($fieldName, $pos + 1, strlen($fieldName));
					if ($prefix == get_Class($this)) {
						$data[$i][$sufix] = $value;
					} else {
						$data[$i][$prefix][$sufix] = $value;
					}
				}
				$i++;
			}
			return $data;
		} else {
			return false;
		}
	}

	public function delete($id=null) {
		if ( empty($id) ) {
			//$id = $this->current;
			return false;
		}
		$query = 'DELETE FROM ' . $this->db . '.' . $this->table . ' WHERE ' . $this->key . ' = ?';
		$values[] = $id;
		if ( $this->connection->prepare($query)->execute($values) ) {
			return true;
		}
		else {
			return false;
		}
	}

	static function load($name) {
		return new $name();
	}

	static function connect() {
		if (isset($this)) {
			$db_data = config::$databases[$this->$db];
		} else {
			$db_data = config::$databases[self::$db];
		}
		$db_data = config::$databases[self::$db];
		$connection = mysql_connect($db_data['host'], $db_data['user'], $db_data['password']);
		if (!empty($connection)) {
			if (!mysql_select_db($db_data['database'], $connection)) {
				echo "Erreur dans la sélection de la base de données";
			}
		} else {
			echo "Impossible de se connecter à MySQL.";
		}
	}

}
?>