<?php

class SQLModel{
	
	protected $tab = array();
	
	public function __construct(){
	}
	
	public function __get($name){
		return $this->tab[$name];
	}
	
	public function __set($name, $val){
		$this->tab[$name] = $val;
	}
	
	public function insert(){
		$pdo = ConnectionFactory::makeConnection();
		
		$query = "INSERT INTO ".static::$table_name." (";
		$values = ") VALUES (";
		
		$val = array();
		
		$i = 0;
		foreach($this->tab as $k => $v){
			if($i==0) {
				$query .= $k;
				$values .= "?";
			}else{
				$query .= ", ".$k;
				$values .= ", ?";
			}
			$val[$i] = $v;
			$i++;
		}
		
		$query .= $values.");";
		
		$requete = $pdo -> prepare($query);
		$r = $requete -> execute($val);
		
		
		echo $query;
	}
	
	public function delete(){
		$pdo = ConnectionFactory::makeConnection();
		
		if(isset($this->tab["id"])){
			$query = "DELETE FROM ".static::$table_name." WHERE ".static::$column_id."=?;";
		}else{
			echo "EXCEPTION";
		}
		
		$requete = $pdo -> prepare($query);
		//$r = $requete -> execute(array($this->tab["id"]));
		
		echo $query;
	}
	
	public function update(){
	}
	
	public function find_one(){
	}
	
	public function find_many(){
	}
}