<?php
// class_sql.php

class sql
  {
     /*
	  Début des variables de class
	 */
	private $error = TRUE; // Si TRUE alors affichage des erreurs
	private $lang = array();
	private $connection;
	private $resultat; // Variable contenant le résultat d'une fonction MySQL
	/*
	 Fin des variables de class
	 */
	 
    function __construct($server,$username,$password,$database,$lang_er)
	  {
	     $this->lang = $lang_er;
         if ( $this->connection = @mysql_connect($server,$username,$password) )
		   {
             if ( !@mysql_select_db($database,$this->connection) )
			   {
				 throw new Exception($this->lang['error_db']);
			   }
		   }
		 else
		   {
			 throw new Exception($this->lang['error_connect']);
		   }
	  }
	
	public function set_error($val)
	  {
        $this->error = $val;
      }
	 
	public function aff_error($error)
	  {
	    if ( $this->error )
		  {
			throw new Exception($this->lang[$error]);
		  }
	  }
	public function query($requete,$buffered=TRUE)
	  {
		$this->resultat = ( $buffered ) ? @mysql_query($requete,$this->connection) : @mysql_unbuffered_query($requete,$this->connection);
		if ( !$this->resultat )
		  {
		    $this->aff_error('error_query');
		    return FALSE;
		  }
		else
		  {
			return $this->resultat;
		  }
	  }
	  
	public function assoc($query)
	  {
		if ( !($this->resultat = @mysql_fetch_assoc($query)) )
		  {
		    $this->aff_error('error_assoc');
		    return FALSE;
		  }
	    else
		  {
		    return $this->resultat;
		  }
	  }
	  
	function __destruct()
	  {
	     mysql_close($this->connection);
	  }
  }
?>

<?php
// class_membres.php

class membres
  {
     /*
	  Début des variables de class
	 */
	private $infos;
	private $sql;
	/*
	 Fin des variables de class
	 */
	function __construct(sql $sql)
	  {
		$this->sql = $sql;
	  }
	  
	public function obt_infos($cle,$type='id')
	  {
		$requete = $this->sql->query('SELECT * FROM ' . MEMBRES_TABLE . ' WHERE '.$type.' = "'.$cle.'"',FALSE);
		$this->infos = $this->sql->assoc($requete);
		return $this->infos;
	  }
	  
	public function add_membre(array $colonnes,array $valeurs)
	  {
	    $colonnes = implode(",", $colonnes);
		for ( $i=0;$i<count($valeurs);$i++ )
		  {
		    $valeurs[$i] = '"'.$valeurs[$i].'"';
		  }
		$valeurs = implode(",", $valeurs);
		$this->sql->query('INSERT INTO ' . MEMBRES_TABLE . ' ('.$colonnes.') VALUES ('.$valeurs.');',FALSE);		
	  }
	  
	public function del_membre($cle,$type='id')
	  {
		$this->sql->query('DELETE FROM ' . MEMBRES_TABLE . ' WHERE '.$type.' = "'.$cle.'"');
	  }
  }
?>

 if ( $this->connect )