<?php
	class rType extends appControl {
		
		private $m_nAccessBD;
		
		protected $table;
		protected $code;
		protected $libelle; 
		
		function __construct(){
			//$this->table = $table;
			//$this->champ = $champ;
			$this->m_nAccessBD = new connexionBD();
		}
		
		public function __setTable($table){ $this->table = $table; }
		public function __setCode($code){ $this->code = $code; }
		public function __setLibelle($libelle){ $this->libelle = $libelle; }
		
		public function __getTable(){ return $this->table; }
		public function __getCode(){ return $this->code; }
		public function __getLibelle(){ return $this->libelle; }
	
		public function __toString(){
			return 'ToString : [ table : ' . $this->__getTable() . 
					' - Code : ' . $this->__getCode() .' - ' .
					' - Libelle : ' . $this->__getLibelle() .' ]';
		}
		
		function __destruct(){
			unset($this);
		}
		
		function affichTable(){
			try{
				$this->m_nAccessBD->connexion();
				
				$sql = "SELECT 
							" . $this->__getCode() . " as code, 
							" . $this->__getLibelle() . " as libelle
						FROM " . $this->__getTable() . " 
						ORDER BY ".$this->__getLibelle()." ASC";
				
				if(DEBUG == 2) echo '<br />' . $sql;
				$this->req = $this->m_nAccessBD->requete($sql);
				$this->tab = $this->m_nAccessBD->recupDonnesRequete($this->req);
				$tabFinal = array();
				foreach($this->tab as $key => $tab){
					$tabFinal[$tab->code] = $tab->libelle;
				}
				if(DEBUG == 1){
					echo '<pre>';
					print_r($tabFinal);
					echo '</pre>';
				}
				$this->m_nAccessBD->deconnexion();
				return $tabFinal;
			}catch(MyException $e){
				echo $e->getError();
			}
		}
}
?>

<?php
/**
 * Cette page retourne dans un tableau chaque contenu de table r_type_maTable
 */
try{
	//Instance de l'objet' 
	 $oRType = new rType();
	
	//Pour les charset
	$oRType->__setTable('r_type_charset');
	$oRType->__setCode('code_charset');
	$oRType->__setLibelle('lib_charset');
	$aListeCharset = $oRType->affichTable();
	
	//Pour les theme
	
	if(DEBUG == 1) echo $oRType;
	
}catch(MyException $e){
	echo $e->getError();
}
?>

DROP FUNCTION lister_table(character varying);

CREATE OR REPLACE FUNCTION lister_table(IN nom_table character varying, OUT code integer, OUT libelle character varying)
 RETURNS SETOF record AS
$BODY$
SELECT * FROM $1;
$BODY$
  LANGUAGE 'sql' VOLATILE
  COST 100
  ROWS 1000;

select * from lister_table('ma_table');

 	function listeTable($table){
 		
 		$tabTable = "";
 		
 		//traitement requete sql
 		$this->m_nAccessBD->connexion();
 		$sql = "SELECT * FROM $table";
 		 /**
 		  * select req.COLUMN_NAME as code FROM(
	select c.COLUMN_NAME
	from INFORMATION_SCHEMA.TABLE_CONSTRAINTS pk ,
	INFORMATION_SCHEMA.KEY_COLUMN_USAGE c
	where pk.TABLE_NAME = 'r_type_charset'
	and CONSTRAINT_TYPE = 'PRIMARY KEY'
	and c.TABLE_NAME = pk.TABLE_NAME
	and c.CONSTRAINT_NAME = pk.CONSTRAINT_NAME)req 
 		  * 
 		  * 
 		  */
 		
 		$this->req = $this->m_nAccessBD->requete($sql);
 		$this->m_nAccessBD->deconnexion();
 		
 		//recuperation des données
 		$tabTable = array();
 		$tabFinal = array();
 		
 		$tabTable = $this->m_nAccessBD->recupDonnesRequete($this->req);
		
 		foreach($tabTable as $key => $tab){
                            //traitement en attente
 		}

 		return $tabFinal;
 	}

$tab = $this->listeTable('ma_table');

$tab = array(1 => 'truc', 2 => 'test'...);

SELECT * FROM nom_de_ta_table

SHOW CREATE TABLE nom_de_ta_table