1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
| <?
class DB_STAGE{
/************************************************************************/
// Connexion à la base
/************************************************************************/
function connect(){
$connexion=pg_connect("user=romain password=sql host=localhost dbname=romain") or die ("erreur de la requete");
return $connexion;
}
/***************************************************************/
// SELECT generique sur une table quelconque
/***************************************************************/
function select2($req){
$tab=array();
$connexion=DB_STAGE::connect();
$row = 0;
$reponse = pg_query($connexion, $req) or die("requete impossible !\n");
while ($tuple = pg_fetch_object($reponse)){
$tab[$row]=$tuple;
$row++;
}
return $tab;
DB_STAGE::close($connexion);
}
/***************************************************************/
// MAJ generique sur une table quelconque
/***************************************************************/
function maj($req){
$connexion=DB_STAGE::connect();
pg_query($connexion, $req) or die("requete impossible !\n");
DB_STAGE::close($connexion);
}
/***************************************************************/
// Fermeture de la connexion
/***************************************************************/
function close($connexion){
pg_close($connexion);
}
function select($requete){
$connexion = DB_STAGE::connect();
$reponse = pg_query($connexion, $requete) or die("requete impossible !");
return $reponse;
DB_STAGE::close($connexion);
}
}
?> |
Partager