<?php
	class CoreSql{

		private static $PDO;

		public static function connect()
		{
			try {
				self::$PDO = new PDO(_SERVER, _USER, _PASS, array(
    				PDO::ATTR_PERSISTENT => true,
    				PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8",
    				PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
				));
			}catch(Exception $e){
				die("Impossible de se connecter: " . $e->getMessage());
			}
		}

		/*exec query select secure inputs avant !!!!!*/
		public static function query($query)
		{
			try{
				if($res = self::$PDO->query($query)){
					return $res->fetchAll(PDO::FETCH_ASSOC);
				}
			}catch(Exception $e){
				die("Erreur Query : " . $e->getMessage());
			}
		}

		/*return true if insert or false if not*/
		public static function exec($query)
		{
			try{
				self::$PDO->prepare($query);
				return self::$PDO->exec();
			}catch(Exception $e){
				die("Erreur exec : " . $e->getMessage());
			}
		}

		public static function delete($id, $table){
        	$query = "DELETE FROM $table WHERE id = $id";
        	self::$PDO->query($query);
   	 	}

   	 	public static function save($data, $table){
        	if(isset($data->id) && $data->id != ''){
        		//update
        		$dataTab = get_object_vars($data);
        		$lastKey = end((array_keys($dataTab)));
        		$query = "UPDATE $table SET ";
        		foreach ($data as $key => $value) {
        				if($key != 'id')
        					$query .= "$key = '$value' , ";
        		}
        		$query = substr($query, 0, -2);
        		$query .= "WHERE id = $data->id; ";
				self::$PDO->prepare($query);
				self::exec();
        	}else{
        		//insert
        		$dataTab = get_object_vars($data);
        		$lastKey = end((array_keys($dataTab)));
        		$query = "INSERT INTO $table (";
        		foreach ($data as $key => $value) {
        				if($key != 'id')
        					$query .= "$key , ";
        		}
        		$query = substr($query, 0, -3);
        		$query .= ") VALUES (";
        		foreach ($data as $key => $value) {
        				if($key != 'id')
        					$query .= "'$value' , ";
        		}
        		$query = substr($query, 0, -3);
        		$query .= ");";
				//echo $query;
				self::exec();
        	}
        }
    }

?>