
Php DBDrivers Class (MySQL)
By:
ncarbon_develop on
Jul 31st, 2012 | syntax:
PHP | size: 1.15 KB | hits: 35 | expires: Never
<?php
// Designed by NCase
namespace local\drivers; // espace de nom permet de proteger la class d'un appel exterieur a lespace de nom
interface DBRequests{
Public function Query($Request); // utilisation de la classe $DBDrivers = new DBDrivers;
Public function CloseSocket(); // $ResultsVar = $DBDrivers->Query("la requete"); ne pas oublier de fetch
}
class DBDrivers implements DBRequests{
Protected Static $ServerConfig;
Protected Static $ActiveCon;
Protected function __construct(){
require_once(__CONFIG__); // on admet que la constante est definie dans la page appelante
self::$ServerConfig = $ServerArray; // array du fichier de config pour la config SQL
}
Protected function OpenSocket(){
self::$ActiveCon =
@mysql_connect(
self::$ServerConfig['HOST'],
self::$ServerConfig['USR'],
self::$ServerConfig['PWD']
) or die("Could not connect to database");
}
Public function Query($Request){
$this->OpenSocket();
$Results = mysql_query($Request);
return $Results;
}
Public function CloseSocket(){
@mysql_close(self::$ActiveCon) or die("An error occured while closing connection to database");
}
}
?>