(my/postgre)Sql
Présentation
J'ai conçu cette classe afin de pouvoir écrire du code php ayant besoin d'accéder à un serveur de type Sql sans avoir le besoin de pré-définir si le serveur sera MySQL ou PostgreSQL.
De ce fait, en utilisant ma classe, il devient possible d'utiliser l'un ou l'autre serveur sans pour autant avoir besoin de réécrire son code.
La seule nécessité, bien évidement, c'est d'avoir utiliser ma classe et ses fonctions dès le début de la création de son code php ^^.
Détail des fonctions
-
Creation :
$object = new SpdSql(type[,host[,user[,pass[,base]]]]);
Parameters :
- "type" must be "my" in order to be used with MySQL or "postgre" in order to be used with PostgreSQL.
- If "host" is specified it will be the host of the server
- If "user" is specified it will be the username
- If "pass" is specified it will be the password
- If "base" is specified it will be the base which to use
Return :
- an instance of the class on success
- false on error
-
Indicate server host :
$object->SetHost(host);
Parameters :
- "host" is the hostname of the server (including port if needed)
Return :
-
Indicate username :
$object->SetUser(user);
Parameters :
- "user" is the username which is used to connect to the server
Return :
-
Indicate password :
$object->SetPass(pass);
Parameters :
- "pass" is the password which is used to connect to the server
Return :
-
Indicate database :
$object->SetBase(base);
Parameters :
- "base" is the database which will be selected on connection
Return :
-
Display Errors :
$object->ErrorShow(show);
Parameters :
- if "show" is exactly false : disable showing errors
- if "show" is false (like 0 or null ) : show the current state
- if "show" is true : enable showing errors
Return :
-
Die on Errors :
$object->ErrorHalt(halt);
Parameters :
- if "halt" is exactly false : disable dieing on errors
- if "halt" is false (like 0 or null ) : show the current state
- if "halt" is true : enable dieing on errors
Return :
-
Connection :
$object->Connect();
Parameters :
Return :
- true on sucess
- false on error
-
Query :
$object->Query(query);
Parameters :
- "query" must be the sql query to execute
Return :
- sql ressource on sucess
- false on error
-
Number of rows returned by a query :
$object->Rows(ressource);
Parameters :
- "ressource" must be a ressource returned by the Query command
Return :
- numer of rows on sucess
- false on error
-
Grab a line in an associated array :
$object->Fetch(ressource);
Parameters :
- "ressource" must be a ressource returned by the Query command
Return :
- array on sucess
- false on error
-
Last inserted index created by an INSERT or REPLACE query :
$object->LastId(ressource);
Parameters :
- "ressource" must be a ressource returned by the Query command
Return :
- last index on sucess
- false on error
-
Number of rows affected by a query :
$object->Affect(ressource);
Parameters :
- "ressource" must be a ressource returned by the Query command
Return :
- numer of rows affected on sucess
- false on error
-
Small Protection of sql strings :
$object->Str(query);
Parameters :
- "query" can be an sql query
Return :
- the "query" with some character escaped
Téléchargement