<?php
/*
 * Class : db
 * Connexion à la base de données
 */
class db
{
    private $host = '127.0.0.1';
    private $user = 'root';
    private $pass = '';
    private $base = 'test';

    public function __construct()
    {
        $link = @mysql_connect($this->host, $this->user, $this->pass);
        $db_selected = @mysql_select_db($this->base, $link);

        if(!$link)
        {
            die('<pre>Acc&egrave;s : Connexion &agrave; la base de donn&eacute;es impossible</pre>');
        }
        elseif(!$db_selected)
        {
            die('<pre>db : Connexion &agrave; la base de donn&eacute;es impossible</pre>');
        }
        else
        {
            return $link;
        }
    }

    public function close()
    {
        mysql_close(self::__construct());
    }
}

/*
 * Class : sql
 */
class sql extends db
{
    /* Les variables */
    public $table;
    public $field;
    public $value;

    public $datas = array();
    public $conditions = array();

    /* Enregistre, retourne true en cas de succès, sinon false */
    public function insert($table, $datas)
    {
        $requete = "INSERT INTO $table ";
        $fields = $values = '';

        foreach($datas as $field => $value)
        {
            $fields .= "$field, ";
            $values .= "'$value', ";
        }

        $fields = substr($fields, 0, strlen($fields) - 2);
        $values = substr($values, 0, strlen($values) - 2);
        $requete .= "($fields) VALUES ($values)";
        $query = mysql_query($requete);

        return (!$query) ? false : true;
    }

    /* Modifie, retourne true en cas de succès, sinon false */
    public function update($table, $datas, $conditions)
    {
        $requete = "UPDATE $table ";
        $i = 0;

        foreach($datas as $field => $value)
        {
            $requete .= ($i < 1) ? "SET $field = '$value', " : "$field = '$value', ";
            $i++;
        }

        $requete = substr($requete, 0, strlen($requete) - 2);
        $requete .= " ".$this->conditions($conditions);
        $query = mysql_query($requete);

        return (!$query) ? false : true;
    }

    /* Supprime, retourne true en cas de succès, sinon false */
    public function delete($table, $conditions)
    {
        $requete = "DELETE FROM $table ".$this->conditions($conditions);
        $query = mysql_query($requete);

        return (!$query) ? false : true;
    }

    /* Sélectionne des informations, retourne les informations en cas de succès, sino false */
    public function select($table, $datas, $conditions)
    {
        $requete = $fields = '';

        foreach($datas as $field)
        {
            $fields .= "$field, ";
        }

        $fields = substr($fields, 0, strlen($fields) - 2);
        $requete .= "SELECT ".$fields." FROM $table ".$this->conditions($conditions);
        $query = mysql_query($requete);

        if($query)
        {
            $datas = mysql_fetch_array($query);

            return $datas;
        }
        else
        {
            return false;
        }
    }

    /* Vérifie si une valeur existe dans un champ, retourne la valeur du premièr champ du tableau $condition */
    public function existe($table, $conditions)
    {
        $fields = array_keys($conditions);
        $requete = "SELECT ".$fields[0]." FROM $table ".$this->conditions($conditions);
        $query = mysql_query($requete);

        if(mysql_num_rows($query) < 1)
        {
            return false;
        }
        else
        {
            $data = mysql_fetch_assoc($query);

            return $data[$fields[0]];
        }
    }

    /* Génère le WHERE et les AND si ils existent */
    private function conditions($conditions)
    {
        $requete = $fields = $values = '';
        $i = 0;

        foreach($conditions as $field => $value)
        {
            $requete .= ($i < 1) ? " WHERE $field = '$value'" : " AND $field = '$value' ";
            $i++;
        }

        return $requete;
    }
}
/*
echo "<pre>";

$db = new db;
$sql = new sql;

$table = 'membres';

$fields = array(
'id',
'prenom',
'nom',
'email'
);

$datas = array(
'prenom'    => 'jean',
'nom'   => 'dupond',
'email' => 'jean.dupond@email.com'
);

$conditions = array(
'prenom'    => 'jean',
'nom'   => 'dupond'
);

$insert = $sql->insert($table, $datas);
echo ($insert) ? "Enregistrement r&eacute;ussit<br />" : "Enregistrement &eacute;chou&eacute;<br />";

$update = $sql->update($table, $datas, $conditions);
echo ($update) ? "Modification r&eacute;ussit<br />" : "Modification &eacute;chou&eacute;<br />";

$delete = $sql->delete($table, $conditions);
echo ($delete) ? "Suppression r&eacute;ussit<br />" : "Suppression &eacute;chou&eacute;<br />";

$existe = $sql->existe($table, $conditions);
echo ($existe) ? "<strong>$existe</strong> existe d&eacute;j&agrave;<br />" : "Cette valeur n'existe pas<br />";

$datas = $sql->select($table, $fields, $conditions);
if($datas)
{
    echo "S&eacute;lection r&eacute;ussit<br />";
    print_r($datas);
}
else
{
    echo "S&eacute;lection &eacute;chou&eacute;<br />";
}

$db->close();

echo "</pre>";
*/
?>