Rev 302 | Blame | Compare with Previous | Last modification | View Log | RSS feed
<html><head><title>File Source for Bdd.php</title><meta http-equiv='Content-Type' content='text/html; charset=UTF-8'/><link rel="stylesheet" type="text/css" href="../media/style.css"></head><body><table border="0" cellspacing="0" cellpadding="0" height="48" width="100%"><tr><td class="header_top">Framework</td></tr><tr><td class="header_line"><img src="../media/empty.png" width="1" height="1" border="0" alt="" /></td></tr><tr><td class="header_menu">[ <a href="../classtrees_Framework.html" class="menu">class tree: Framework</a> ][ <a href="../elementindex_Framework.html" class="menu">index: Framework</a> ][ <a href="../elementindex.html" class="menu">all elements</a> ]</td></tr><tr><td class="header_line"><img src="../media/empty.png" width="1" height="1" border="0" alt="" /></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="200" class="menu"><div id="todolist"><p><a href="../todolist.html">Todo List</a></p></div><b>Packages:</b><br /><a href="../li_Framework.html">Framework</a><br /><a href="../li_Utilitaire.html">Utilitaire</a><br /><a href="../li_Zend_OpenId.html">Zend_OpenId</a><br /><br /><br /></td><td><table cellpadding="10" cellspacing="0" width="100%" border="0"><tr><td valign="top"><h1 align="center">Source for file Bdd.php</h1><p>Documentation is available at <a href="../Framework/_Bdd.php.html">Bdd.php</a></p><div class="src-code"><ol><li><div class="src-line"><a name="a1"></a><span class="src-php"><?php</span></div></li><li><div class="src-line"><a name="a2"></a><span class="src-comm">// declare(encoding='UTF-8');</span></div></li><li><div class="src-line"><a name="a3"></a><span class="src-doc">/**</span></div></li><li><div class="src-line"><a name="a4"></a><span class="src-doc"> * Classe Bdd, d'accés au base de données.</span></div></li><li><div class="src-line"><a name="a5"></a><span class="src-doc"> * Elle fait office d'abstraction légère de base de données en utilisant diverses possibilités d'accès aux</span></div></li><li><div class="src-line"><a name="a6"></a><span class="src-doc"> * bases de données (PDO, mysql, mysqli, SQLite3).</span></div></li><li><div class="src-line"><a name="a7"></a><span class="src-doc"> * Les valeurs pour le paramètre 'bdd_abstraction' du fichier config.ini sont : pdo, mysql, mysqli, sqlite3</span></div></li><li><div class="src-line"><a name="a8"></a><span class="src-doc"> * Vous pouvez aussi utiliser : "php:Bdd::ABSTRACTION_PDO","php:Bdd::ABSTRACTION_MYSQL", "php:Bdd::ABSTRACTION_MYSQLI",</span></div></li><li><div class="src-line"><a name="a9"></a><span class="src-doc"> * "php:Bdd::ABSTRACTION_SQLITE3".</span></div></li><li><div class="src-line"><a name="a10"></a><span class="src-doc"> * Elle peut être étendue, pour ajouter le support d'autres bases de données où prendre en compte des méthodes spécifique à</span></div></li><li><div class="src-line"><a name="a11"></a><span class="src-doc"> * un type d'abstraction.</span></div></li><li><div class="src-line"><a name="a12"></a><span class="src-doc"> *</span></div></li><li><div class="src-line"><a name="a13"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@category</span><span class="src-doc"> php 5.2</span></div></li><li><div class="src-line"><a name="a14"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc"> Framework</span></div></li><li><div class="src-line"><a name="a15"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@author</span><span class="src-doc"> Aurélien PERONNET <aurelien@tela-botanica.org></span></div></li><li><div class="src-line"><a name="a16"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@author</span><span class="src-doc"> Jean-Pascal MILCENT <jpm@tela-botanica.org></span></div></li><li><div class="src-line"><a name="a17"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@copyright</span><span class="src-doc"> Copyright (c) 2010, Tela Botanica (accueil@tela-botanica.org)</span></div></li><li><div class="src-line"><a name="a18"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@license</span><span class="src-doc"> http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt Licence CECILL</span></div></li><li><div class="src-line"><a name="a19"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@license</span><span class="src-doc"> http://www.gnu.org/licenses/gpl.html Licence GNU-GPL</span></div></li><li><div class="src-line"><a name="a20"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@version</span><span class="src-doc"> $Id: Bdd.php 247 2010-12-16 16:47:52Z jpm $</span></div></li><li><div class="src-line"><a name="a21"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@link</span><span class="src-doc"> /doc/framework/</span></div></li><li><div class="src-line"><a name="a22"></a><span class="src-doc"> */</span></div></li><li><div class="src-line"><a name="a23"></a><span class="src-key">class </span><a href="../Framework/Bdd.html">Bdd</a> <span class="src-sym">{</span></div></li><li><div class="src-line"><a name="a24"></a> <span class="src-doc">/** Constante stockant le squelette du message en cas d'erreur de requête sql. */</span></div></li><li><div class="src-line"><a name="a25"></a> <span class="src-key">const </span><span class="src-id">ERREUR_REQUETE_TPL </span>= <span class="src-str">'Requête echec.\nFichier : %s.\nLigne : %s.\nMessage : %s.\nRequête : %s'</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a26"></a> </div></li><li><div class="src-line"><a name="a27"></a> <span class="src-doc">/** Constante stockant le squelette du message en cas d'erreur de connexion à la base de données. */</span></div></li><li><div class="src-line"><a name="a28"></a> <span class="src-key">const </span><span class="src-id">ERREUR_CONNEXION_TPL </span>= <span class="src-str">'Erreur de connexion à la base de données, vérifiez les paramètres du fichier de configuration.\nMessage : %S.'</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a29"></a> </div></li><li><div class="src-line"><a name="a30"></a> <span class="src-doc">/** Constante stockant le squelette du message en cas d'erreur de sélection de la base de données. */</span></div></li><li><div class="src-line"><a name="a31"></a> <span class="src-key">const </span><span class="src-id">ERREUR_SELECTION_BDD_TPL </span>= <span class="src-str">'Erreur de sélection de la base de données, vérifiez les paramètres du fichier de configuration.\nMessage : %S.'</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a32"></a> </div></li><li><div class="src-line"><a name="a33"></a> <span class="src-doc">/** Constante stockant le code pour l'abstraction de PDO. */</span></div></li><li><div class="src-line"><a name="a34"></a> <span class="src-key">const </span><span class="src-id">ABSTRACTION_PDO </span>= <span class="src-str">'pdo'</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a35"></a> </div></li><li><div class="src-line"><a name="a36"></a> <span class="src-doc">/** Constante stockant le code pour l'abstraction de mysql. */</span></div></li><li><div class="src-line"><a name="a37"></a> <span class="src-key">const </span><span class="src-id">ABSTRACTION_MYSQL </span>= <span class="src-str">'mysql'</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a38"></a> </div></li><li><div class="src-line"><a name="a39"></a> <span class="src-doc">/** Constante stockant le code pour l'abstraction de mysqli. */</span></div></li><li><div class="src-line"><a name="a40"></a> <span class="src-key">const </span><span class="src-id">ABSTRACTION_MYSQLI </span>= <span class="src-str">'mysqli'</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a41"></a> </div></li><li><div class="src-line"><a name="a42"></a> <span class="src-doc">/** Constante stockant le code pour l'abstraction de SQLite3. */</span></div></li><li><div class="src-line"><a name="a43"></a> <span class="src-key">const </span><span class="src-id">ABSTRACTION_SQLITE3 </span>= <span class="src-str">'sqlite3'</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a44"></a> </div></li><li><div class="src-line"><a name="a45"></a> <span class="src-doc">/** Constante stockant le code pour le mode tableau associatif des résultats des requêtes. */</span></div></li><li><div class="src-line"><a name="a46"></a> <span class="src-key">const </span><span class="src-id">MODE_ASSOC </span>= <span class="src-str">'ASSOC'</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a47"></a> </div></li><li><div class="src-line"><a name="a48"></a> <span class="src-doc">/** Constante stockant le code pour le mode objet des résultats des requêtes. */</span></div></li><li><div class="src-line"><a name="a49"></a> <span class="src-key">const </span><span class="src-id">MODE_OBJET </span>= <span class="src-str">'OBJECT'</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a50"></a> </div></li><li><div class="src-line"><a name="a51"></a> <span class="src-doc">/** Mode de fetch associatif */</span></div></li><li><div class="src-line"><a name="a52"></a> <span class="src-key">protected </span><a href="../Framework/Bdd.html#var$ASSOC">$ASSOC</a> = <span class="src-str">''</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a53"></a> </div></li><li><div class="src-line"><a name="a54"></a> <span class="src-doc">/** Mode de fetch objet */</span></div></li><li><div class="src-line"><a name="a55"></a> <span class="src-key">protected </span><a href="../Framework/Bdd.html#var$OBJECT">$OBJECT</a> = <span class="src-str">''</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a56"></a> </div></li><li><div class="src-line"><a name="a57"></a> <span class="src-doc">/** abstraction de base de données utilisée */</span></div></li><li><div class="src-line"><a name="a58"></a> <span class="src-key">protected </span><a href="../Framework/Bdd.html#var$abstraction">$abstraction</a><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a59"></a> </div></li><li><div class="src-line"><a name="a60"></a> <span class="src-doc">/** DSN pour accéder à la base de données */</span></div></li><li><div class="src-line"><a name="a61"></a> <span class="src-key">protected </span><a href="../Framework/Bdd.html#var$dsn">$dsn</a><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a62"></a> </div></li><li><div class="src-line"><a name="a63"></a> <span class="src-doc">/** Type de base de données (mysql, mysqli, etc ...) */</span></div></li><li><div class="src-line"><a name="a64"></a> <span class="src-key">protected </span><a href="../Framework/Bdd.html#var$type">$type</a><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a65"></a> </div></li><li><div class="src-line"><a name="a66"></a> <span class="src-doc">/** Hote herbergeant la base de données */</span></div></li><li><div class="src-line"><a name="a67"></a> <span class="src-key">protected </span><a href="../Framework/Bdd.html#var$hote">$hote</a><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a68"></a> </div></li><li><div class="src-line"><a name="a69"></a> <span class="src-doc">/** Nom de la base de données à laquelle le modèle doit se connecter */</span></div></li><li><div class="src-line"><a name="a70"></a> <span class="src-key">protected </span><a href="../Framework/Bdd.html#var$bdd_nom">$bdd_nom</a><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a71"></a> </div></li><li><div class="src-line"><a name="a72"></a> <span class="src-doc">/** Nom d'utilisateur */</span></div></li><li><div class="src-line"><a name="a73"></a> <span class="src-key">protected </span><a href="../Framework/Bdd.html#var$utilisateur">$utilisateur</a><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a74"></a> </div></li><li><div class="src-line"><a name="a75"></a> <span class="src-doc">/** Mot de passe */</span></div></li><li><div class="src-line"><a name="a76"></a> <span class="src-key">protected </span><a href="../Framework/Bdd.html#var$pass">$pass</a><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a77"></a> </div></li><li><div class="src-line"><a name="a78"></a> <span class="src-doc">/** Encodage de la base de données */</span></div></li><li><div class="src-line"><a name="a79"></a> <span class="src-key">protected </span><a href="../Framework/Bdd.html#var$encodage">$encodage</a> = <span class="src-id">null</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a80"></a> </div></li><li><div class="src-line"><a name="a81"></a> <span class="src-doc">/** Connexion à la base de données */</span></div></li><li><div class="src-line"><a name="a82"></a> <span class="src-key">protected </span><a href="../Framework/Bdd.html#var$connexion">$connexion</a> = <span class="src-id">null</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a83"></a> </div></li><li><div class="src-line"><a name="a84"></a> <span class="src-doc">/** Tableau des noms des paramètres à définir dans le fichier de config car obligatoirement nécessaire à cette classe.*/</span></div></li><li><div class="src-line"><a name="a85"></a> <span class="src-key">protected </span><a href="../Framework/Bdd.html#var$parametres_obligatoires">$parametres_obligatoires</a> = <span class="src-key">array</span><span class="src-sym">(</span><span class="src-str">'bdd_abstraction'</span><span class="src-sym">, </span><span class="src-str">'bdd_protocole'</span><span class="src-sym">, </span><span class="src-str">'bdd_serveur'</span><span class="src-sym">, </span><span class="src-str">'bdd_nom'</span><span class="src-sym">, </span></div></li><li><div class="src-line"><a name="a86"></a> <span class="src-str">'bdd_utilisateur'</span><span class="src-sym">, </span><span class="src-str">'bdd_mot_de_passe'</span><span class="src-sym">, </span><span class="src-str">'bdd_encodage'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a87"></a> </div></li><li><div class="src-line"><a name="a88"></a> <span class="src-doc">/** Constructeur par défaut, appelé à l'initialisation. */</span></div></li><li><div class="src-line"><a name="a89"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Framework/Bdd.html#method__construct">__construct</a><span class="src-sym">(</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li><li><div class="src-line"><a name="a90"></a> <span class="src-id"><a href="../Framework/Config.html">Config</a></span><span class="src-sym">::</span><a href="../Framework/Config.html#methodverifierPresenceParametres">verifierPresenceParametres</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$parametres_obligatoires">parametres_obligatoires</a><span class="src-sym">)</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a91"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$abstraction">abstraction</a> = <a href="http://www.php.net/strtolower">strtolower</a><span class="src-sym">(</span><span class="src-id"><a href="../Framework/Config.html">Config</a></span><span class="src-sym">::</span><a href="../Framework/Config.html#methodget">get</a><span class="src-sym">(</span><span class="src-str">'bdd_abstraction'</span><span class="src-sym">))</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a92"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$type">type</a> = <span class="src-id"><a href="../Framework/Config.html">Config</a></span><span class="src-sym">::</span><a href="../Framework/Config.html#methodget">get</a><span class="src-sym">(</span><span class="src-str">'bdd_protocole'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a93"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$hote">hote</a> = <span class="src-id"><a href="../Framework/Config.html">Config</a></span><span class="src-sym">::</span><a href="../Framework/Config.html#methodget">get</a><span class="src-sym">(</span><span class="src-str">'bdd_serveur'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a94"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$bdd_nom">bdd_nom</a> = <span class="src-id"><a href="../Framework/Config.html">Config</a></span><span class="src-sym">::</span><a href="../Framework/Config.html#methodget">get</a><span class="src-sym">(</span><span class="src-str">'bdd_nom'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a95"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$utilisateur">utilisateur</a> = <span class="src-id"><a href="../Framework/Config.html">Config</a></span><span class="src-sym">::</span><a href="../Framework/Config.html#methodget">get</a><span class="src-sym">(</span><span class="src-str">'bdd_utilisateur'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a96"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$pass">pass</a> = <span class="src-id"><a href="../Framework/Config.html">Config</a></span><span class="src-sym">::</span><a href="../Framework/Config.html#methodget">get</a><span class="src-sym">(</span><span class="src-str">'bdd_mot_de_passe'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a97"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$encodage">encodage</a> = <span class="src-id"><a href="../Framework/Config.html">Config</a></span><span class="src-sym">::</span><a href="../Framework/Config.html#methodget">get</a><span class="src-sym">(</span><span class="src-str">'bdd_encodage'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a98"></a> </div></li><li><div class="src-line"><a name="a99"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$dsn">dsn</a> = <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$type">type</a>.<span class="src-str">':dbname='</span>.<span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$bdd_nom">bdd_nom</a>.<span class="src-str">';host='</span>.<span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$hote">hote</a><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a100"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#methodinitialiserProtocole">initialiserProtocole</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a101"></a> <span class="src-sym">}</span></div></li><li><div class="src-line"><a name="a102"></a> </div></li><li><div class="src-line"><a name="a103"></a> <span class="src-doc">/** Initialise les constantes de classe à leur bonne valeur et déclenche une erreur si le protocole n'est pas bien défini. */</span></div></li><li><div class="src-line"><a name="a104"></a> <span class="src-key">protected </span><span class="src-key">function </span><a href="../Framework/Bdd.html#methodinitialiserProtocole">initialiserProtocole</a><span class="src-sym">(</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li><li><div class="src-line"><a name="a105"></a> <span class="src-key">switch </span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$abstraction">abstraction</a><span class="src-sym">) </span><span class="src-sym">{</span></div></li><li><div class="src-line"><a name="a106"></a> <span class="src-key">case </span><span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_PDO </span>:</div></li><li><div class="src-line"><a name="a107"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$ASSOC">ASSOC</a> = <span class="src-id">PDO</span><span class="src-sym">::</span><span class="src-id">FETCH_ASSOC</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a108"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$OBJECT">OBJECT</a> = <span class="src-id">PDO</span><span class="src-sym">::</span><span class="src-id">FETCH_CLASS</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a109"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a110"></a> <span class="src-key">case </span><span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_MYSQL </span>:</div></li><li><div class="src-line"><a name="a111"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$ASSOC">ASSOC</a> = <span class="src-str">'mysql_fetch_assoc'</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a112"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$OBJECT">OBJECT</a> = <span class="src-str">'mysql_fetch_object'</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a113"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a114"></a> <span class="src-key">case </span><span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_MYSQLI </span>:</div></li><li><div class="src-line"><a name="a115"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$ASSOC">ASSOC</a> = <span class="src-str">'fetch_assoc'</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a116"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$OBJECT">OBJECT</a> = <span class="src-str">'fetch_object'</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a117"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a118"></a> <span class="src-key">case </span><span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_SQLITE3 </span>:</div></li><li><div class="src-line"><a name="a119"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$ASSOC">ASSOC</a> = <span class="src-str">'SQLITE3_ASSOC'</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a120"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$OBJECT">OBJECT</a> = <span class="src-str">'SQLITE3_OBJECT'</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a121"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li><li><div class="src-line"><a name="a122"></a> <span class="src-key">default</span>:</div></li><li><div class="src-line"><a name="a123"></a> <span class="src-var">$m </span>= <span class="src-str">"</span><span class="src-str">Erreur : l'abstraction '{<span class="src-var">$this</span></span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$abstraction">abstraction</a><span class="src-sym">}</span>' n'est pas prise en charge</span><span class="src-str"><span class="src-str">"</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a124"></a></span><span class="src-str"> <span class="src-id">trigger_error</span><span class="src-sym">(</span><span class="src-var">$m</span><span class="src-sym">,</span> <span class="src-id">E_USER_WARNING</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a125"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a126"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a127"></a></span><span class="src-str"> </span></div></li><li><div class="src-line"><a name="a128"></a></span><span class="src-str"> /**</span></div></li><li><div class="src-line"><a name="a129"></a></span><span class="src-str"> * Connection à la base de données en utilisant les informations fournies par</span></div></li><li><div class="src-line"><a name="a130"></a></span><span class="src-str"> * le fichier de configuration.</span></div></li><li><div class="src-line"><a name="a131"></a></span><span class="src-str"> * Cette méthode est private et final car elle n'a pas vocation a être appelée par l'utilisateur.</span></div></li><li><div class="src-line"><a name="a132"></a></span><span class="src-str"> */</span></div></li><li><div class="src-line"><a name="a133"></a></span><span class="src-str"> <span class="src-key">protected</span> <span class="src-key">function</span> <span class="src-id">connecter</span><span class="src-sym">(</span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a134"></a></span><span class="src-str"> <span class="src-key">if</span> <span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$connexion">connexion</a> == <span class="src-id">null</span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a135"></a></span><span class="src-str"> <span class="src-key">switch</span> <span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$abstraction">abstraction</a><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a136"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_PDO</span> :</span></div></li><li><div class="src-line"><a name="a137"></a></span><span class="src-str"> try <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a138"></a></span><span class="src-str"> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$connexion">connexion</a> = <span class="src-key">new</span> <span class="src-id">PDO</span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$dsn">dsn</a><span class="src-sym">,</span> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$utilisateur">utilisateur</a><span class="src-sym">,</span> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$pass">pass</a><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a139"></a></span><span class="src-str"> <span class="src-sym">}</span> catch <span class="src-sym">(</span><span class="src-id">PDOException</span> <span class="src-var">$e</span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a140"></a></span><span class="src-str"> <span class="src-var">$e</span> = <span class="src-id">sprintf</span><span class="src-sym">(</span><span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ERREUR_CONNEXION_TPL</span><span class="src-sym">,</span> <span class="src-var">$e</span><span class="src-sym">-></span><span class="src-id">getMessage</span><span class="src-sym">(</span><span class="src-sym">))</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a141"></a></span><span class="src-str"> <span class="src-id">trigger_error</span><span class="src-sym">(</span><span class="src-var">$e</span><span class="src-sym">,</span> <span class="src-id">E_USER_WARNING</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a142"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a143"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a144"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_MYSQL</span> :</span></div></li><li><div class="src-line"><a name="a145"></a></span><span class="src-str"> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$connexion">connexion</a> = <span class="src-id">mysql_connect</span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$hote">hote</a><span class="src-sym">,</span> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$utilisateur">utilisateur</a><span class="src-sym">,</span> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$pass">pass</a><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a146"></a></span><span class="src-str"> <span class="src-key">if</span> <span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$connexion">connexion</a> !== <span class="src-id">false</span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a147"></a></span><span class="src-str"> <span class="src-var">$selection</span> = <span class="src-id">mysql_select_db</span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$bdd_nom">bdd_nom</a><span class="src-sym">,</span> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$connexion">connexion</a><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a148"></a></span><span class="src-str"> <span class="src-key">if</span> <span class="src-sym">(</span><span class="src-var">$selection</span> === <span class="src-id">false</span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a149"></a></span><span class="src-str"> <span class="src-var">$e</span> = <span class="src-id">sprintf</span><span class="src-sym">(</span><span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ERREUR_SELECTION_BDD_TPL</span><span class="src-sym">,</span> <span class="src-id">mysql_error</span><span class="src-sym">(</span><span class="src-sym">))</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a150"></a></span><span class="src-str"> <span class="src-id">trigger_error</span><span class="src-sym">(</span><span class="src-var">$e</span><span class="src-sym">,</span> <span class="src-id">E_USER_WARNING</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a151"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a152"></a></span><span class="src-str"> <span class="src-sym">}</span> <span class="src-key">else</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a153"></a></span><span class="src-str"> <span class="src-var">$e</span> = <span class="src-id">sprintf</span><span class="src-sym">(</span><span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ERREUR_CONNEXION_TPL</span><span class="src-sym">,</span> <span class="src-id">mysql_error</span><span class="src-sym">(</span><span class="src-sym">))</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a154"></a></span><span class="src-str"> <span class="src-id">trigger_error</span><span class="src-sym">(</span><span class="src-var">$e</span><span class="src-sym">,</span> <span class="src-id">E_USER_WARNING</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a155"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a156"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a157"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_MYSQLI</span> :</span></div></li><li><div class="src-line"><a name="a158"></a></span><span class="src-str"> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$connexion">connexion</a> = <span class="src-sym">@</span><span class="src-key">new</span> <span class="src-id">mysqli</span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$hote">hote</a><span class="src-sym">,</span> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$utilisateur">utilisateur</a><span class="src-sym">,</span> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$pass">pass</a><span class="src-sym">,</span> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$bdd_nom">bdd_nom</a><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a159"></a></span><span class="src-str"> <span class="src-key">if</span> <span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$connexion">connexion</a><span class="src-sym">-></span><span class="src-id">connect_errno</span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a160"></a></span><span class="src-str"> <span class="src-var">$e</span> = <span class="src-id">sprintf</span><span class="src-sym">(</span><span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ERREUR_CONNEXION_TPL</span><span class="src-sym">,</span> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$connexion">connexion</a><span class="src-sym">-></span><span class="src-id">connect_error</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a161"></a></span><span class="src-str"> <span class="src-id">trigger_error</span><span class="src-sym">(</span><span class="src-var">$e</span><span class="src-sym">,</span> <span class="src-id">E_USER_WARNING</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a162"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a163"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a164"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_SQLITE3</span> :</span></div></li><li><div class="src-line"><a name="a165"></a></span><span class="src-str"> <span class="src-comm">// cas particulier de sqllite, on considère que le nom de la base de données correspond au fichier à ouvrir</span></span></div></li><li><div class="src-line"><a name="a166"></a></span><span class="src-str"><span class="src-comm"></span> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$connexion">connexion</a> = <span class="src-key">new</span> <span class="src-id">SQLite3</span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$bdd_nom">bdd_nom</a><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a167"></a></span><span class="src-str"> <span class="src-key">if</span> <span class="src-sym">(</span><span class="src-sym">!</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$connexion">connexion</a><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a168"></a></span><span class="src-str"> <span class="src-var">$e</span> = <span class="src-id">sprintf</span><span class="src-sym">(</span><span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ERREUR_CONNEXION_TPL</span><span class="src-sym">,</span> <span class="src-str">''</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a169"></a></span><span class="src-str"> <a href="http://www.php.net/trigger_error">trigger_error</a><span class="src-sym">(</span><span class="src-var">$e</span><span class="src-sym">,</span> <span class="src-id">E_USER_WARNING</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a170"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a171"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a172"></a></span><span class="src-str"> <span class="src-key">default</span>:</span></div></li><li><div class="src-line"><a name="a173"></a></span><span class="src-str"> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#var$connexion">connexion</a> = <span class="src-id">null</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a174"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a175"></a></span><span class="src-str"> </span></div></li><li><div class="src-line"><a name="a176"></a></span><span class="src-str"> <span class="src-key">if</span> <span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id">encodage</span> != <span class="src-id">null</span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a177"></a></span><span class="src-str"> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id">requete</span><span class="src-sym">(</span><span class="src-str">"SET names '"</span>.<span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id">encodage</span>.<span class="src-str">"'"</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a178"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a179"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a180"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a181"></a></span><span class="src-str"> </span></div></li><li><div class="src-line"><a name="a182"></a><span class="src-doc">/**</span><span class="src-str"> </span></span></div></li><li><div class="src-line"><a name="a183"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@deprecated</span><span class="src-doc"> changement de nom. Disparaîtra dans la version 0.4. Utiliser à la place : @see requeter</span></div></li><li><div class="src-line"><a name="a184"></a><span class="src-doc"> */</span><span class="src-str"></span></span></div></li><li><div class="src-line"><a name="a185"></a></span><span class="src-str"> <span class="src-key">final</span> <span class="src-key">protected</span> <span class="src-key">function</span> <a href="../Framework/Bdd.html#methodrequete">requete</a><span class="src-sym">(</span><span class="src-var">$requete</span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a186"></a></span><span class="src-str"> <span class="src-key">return</span> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#methodrequeter">requeter</a><span class="src-sym">(</span><span class="src-var">$requete</span><span class="src-sym">,</span> <span class="src-var">$mode</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a187"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a188"></a></span><span class="src-str"> </span></div></li><li><div class="src-line"><a name="a189"></a><span class="src-doc">/**</span><span class="src-str"> </span></span></div></li><li><div class="src-line"><a name="a190"></a><span class="src-doc"> * Execute une requête et retourne le résultat tel que renvoyé par l'abstraction courante.</span></div></li><li><div class="src-line"><a name="a191"></a><span class="src-doc"> *</span></div></li><li><div class="src-line"><a name="a192"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc">la requête à effectuer</span></div></li><li><div class="src-line"><a name="a193"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">mixed </span><span class="src-doc">un objet contenant le résultat de la requête</span></div></li><li><div class="src-line"><a name="a194"></a><span class="src-doc"> */</span><span class="src-str"></span></span></div></li><li><div class="src-line"><a name="a195"></a></span><span class="src-str"> <span class="src-key">public</span> <span class="src-key">function</span> <a href="../Framework/Bdd.html#methodrequeter">requeter</a><span class="src-sym">(</span><span class="src-var">$requete</span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a196"></a></span><span class="src-str"> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#methodconnecter">connecter</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a197"></a> </div></li><li><div class="src-line"><a name="a198"></a></span><span class="src-str"> <span class="src-var">$retour</span> = <span class="src-id">null</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a199"></a></span><span class="src-str"> <span class="src-key">switch</span> <span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$abstraction">abstraction</a></span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a200"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_PDO</span> :</span></div></li><li><div class="src-line"><a name="a201"></a></span><span class="src-str"> try <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a202"></a></span><span class="src-str"> <span class="src-var">$retour</span> = <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$connexion">connexion</a></span><span class="src-sym">-></span><span class="src-id">query</span><span class="src-sym">(</span><span class="src-var">$requete</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a203"></a></span><span class="src-str"> <span class="src-sym">}</span> catch <span class="src-sym">(</span><span class="src-id">PDOException</span> <span class="src-var">$e</span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a204"></a></span><span class="src-str"> <span class="src-var">$m</span> = <a href="http://www.php.net/sprintf">sprintf</a><span class="src-sym">(</span><span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ERREUR_REQUETE_TPL</span><span class="src-sym">,</span> <span class="src-var">$e</span><span class="src-sym">-></span><span class="src-id">getFile</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">,</span> <span class="src-var">$e</span><span class="src-sym">-></span><span class="src-id">getLine</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">,</span> <span class="src-var">$e</span><span class="src-sym">-></span><span class="src-id">getMessage</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">,</span> <span class="src-var">$requete</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a205"></a></span><span class="src-str"> <a href="http://www.php.net/trigger_error">trigger_error</a><span class="src-sym">(</span><span class="src-var">$m</span><span class="src-sym">,</span> <span class="src-id">E_USER_WARNING</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a206"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a207"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a208"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_MYSQL</span> :</span></div></li><li><div class="src-line"><a name="a209"></a></span><span class="src-str"> <span class="src-var">$retour</span> = <a href="http://www.php.net/mysql_query">mysql_query</a><span class="src-sym">(</span><span class="src-var">$requete</span><span class="src-sym">,</span> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$connexion">connexion</a></span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a210"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a211"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_MYSQLI</span> :</span></div></li><li><div class="src-line"><a name="a212"></a></span><span class="src-str"> <span class="src-var">$retour</span> = <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$connexion">connexion</a></span><span class="src-sym">-></span><span class="src-id">query</span><span class="src-sym">(</span><span class="src-var">$requete</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a213"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a214"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_SQLITE3</span> :</span></div></li><li><div class="src-line"><a name="a215"></a></span><span class="src-str"> <span class="src-var">$retour</span> = <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$connexion">connexion</a></span><span class="src-sym">-></span><a href="http://www.php.net/exec">exec</a><span class="src-sym">(</span><span class="src-var">$requete</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a216"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a217"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a218"></a></span><span class="src-str"> <span class="src-key">return</span> <span class="src-var">$retour</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a219"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a220"></a></span><span class="src-str"> </span></div></li><li><div class="src-line"><a name="a221"></a><span class="src-doc">/**</span><span class="src-str"> </span></span></div></li><li><div class="src-line"><a name="a222"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@deprecated</span><span class="src-doc"> changement de nom. Disparaîtra dans la version 0.4. Utiliser à la place : @see recuperer</span></div></li><li><div class="src-line"><a name="a223"></a><span class="src-doc"> */</span><span class="src-str"></span></span></div></li><li><div class="src-line"><a name="a224"></a></span><span class="src-str"> <span class="src-key">final</span> <span class="src-key">protected</span> <span class="src-key">function</span> <a href="../Framework/Bdd.html#methodrequeteUn">requeteUn</a><span class="src-sym">(</span><span class="src-var">$requete</span><span class="src-sym">,</span> <span class="src-var">$mode</span> = <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">MODE_ASSOC</span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a225"></a></span><span class="src-str"> <span class="src-key">return</span> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#methodrecuperer">recuperer</a><span class="src-sym">(</span><span class="src-var">$requete</span><span class="src-sym">,</span> <span class="src-var">$mode</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a226"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a227"></a></span><span class="src-str"> </span></div></li><li><div class="src-line"><a name="a228"></a><span class="src-doc">/**</span><span class="src-str"> </span></span></div></li><li><div class="src-line"><a name="a229"></a><span class="src-doc"> * Execute une requête et retourne le premier résultat sous forme de tableau (par défaut) ou d'objet.</span></div></li><li><div class="src-line"><a name="a230"></a><span class="src-doc"> * Les noms des champs de la base de données correspondent aux noms des clés du tableau ou aux noms des attributs de l'objet.</span></div></li><li><div class="src-line"><a name="a231"></a><span class="src-doc"> *</span></div></li><li><div class="src-line"><a name="a232"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc">la requête à effectuer</span></div></li><li><div class="src-line"><a name="a233"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc">le mode de retour ASSOC (Bdd::MODE_ASSOC) pour un tableau ou OBJECT (Bdd::MODE_OBJET) pour un objet.</span></div></li><li><div class="src-line"><a name="a234"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">mixed </span><span class="src-doc">un objet ou un tableau contenant le résultat de la requête</span></div></li><li><div class="src-line"><a name="a235"></a><span class="src-doc"> */</span><span class="src-str"></span></span></div></li><li><div class="src-line"><a name="a236"></a></span><span class="src-str"> <span class="src-key">public</span> <span class="src-key">function</span> <a href="../Framework/Bdd.html#methodrecuperer">recuperer</a><span class="src-sym">(</span><span class="src-var">$requete</span><span class="src-sym">,</span> <span class="src-var">$mode</span> = <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">MODE_ASSOC</span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a237"></a></span><span class="src-str"> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#methodconnecter">connecter</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a238"></a> </div></li><li><div class="src-line"><a name="a239"></a></span><span class="src-str"> <span class="src-var">$retour</span> = <span class="src-id">null</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a240"></a></span><span class="src-str"> <span class="src-key">switch</span> <span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$abstraction">abstraction</a></span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a241"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_PDO</span> :</span></div></li><li><div class="src-line"><a name="a242"></a></span><span class="src-str"> try <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a243"></a></span><span class="src-str"> <span class="src-var">$resultat</span> = <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$connexion">connexion</a></span><span class="src-sym">-></span><span class="src-id">query</span><span class="src-sym">(</span><span class="src-var">$requete</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a244"></a></span><span class="src-str"> <span class="src-var">$retour</span> = <span class="src-var">$resultat</span><span class="src-sym">-></span><span class="src-id">fetch</span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-var">$mode</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a245"></a></span><span class="src-str"> <span class="src-sym">}</span> catch <span class="src-sym">(</span><span class="src-id">PDOException</span> <span class="src-var">$e</span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a246"></a></span><span class="src-str"> <span class="src-var">$m</span> = <a href="http://www.php.net/sprintf">sprintf</a><span class="src-sym">(</span><span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ERREUR_REQUETE_TPL</span><span class="src-sym">,</span> <span class="src-var">$e</span><span class="src-sym">-></span><span class="src-id">getFile</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">,</span> <span class="src-var">$e</span><span class="src-sym">-></span><span class="src-id">getLine</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">,</span> <span class="src-var">$e</span><span class="src-sym">-></span><span class="src-id">getMessage</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">,</span> <span class="src-var">$requete</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a247"></a></span><span class="src-str"> <a href="http://www.php.net/trigger_error">trigger_error</a><span class="src-sym">(</span><span class="src-var">$m</span><span class="src-sym">,</span> <span class="src-id">E_USER_WARNING</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a248"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a249"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a250"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_MYSQL</span> :</span></div></li><li><div class="src-line"><a name="a251"></a></span><span class="src-str"> <span class="src-var">$res</span> = <a href="http://www.php.net/mysql_query">mysql_query</a><span class="src-sym">(</span><span class="src-var">$requete</span><span class="src-sym">,</span> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$connexion">connexion</a></span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a252"></a></span><span class="src-str"> <span class="src-var">$fonction_fetch</span> = <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-var">$mode</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a253"></a></span><span class="src-str"> <span class="src-var">$retour</span> = <span class="src-var">$fonction_fetch</span><span class="src-sym">(</span><span class="src-var">$res</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a254"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a255"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_MYSQLI</span> :</span></div></li><li><div class="src-line"><a name="a256"></a></span><span class="src-str"> <span class="src-var">$res</span> = <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$connexion">connexion</a></span><span class="src-sym">-></span><span class="src-id">query</span><span class="src-sym">(</span><span class="src-var">$requete</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a257"></a></span><span class="src-str"> <span class="src-var">$fonction_fetch</span> = <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-var">$mode</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a258"></a></span><span class="src-str"> <span class="src-var">$retour</span> = <span class="src-var">$res</span><span class="src-sym">-></span><span class="src-var">$fonction_fetch</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a259"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a260"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_SQLITE3</span> :</span></div></li><li><div class="src-line"><a name="a261"></a></span><span class="src-str"> <span class="src-var">$retour</span> = <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$connexion">connexion</a></span><span class="src-sym">-></span><span class="src-id">querySingle</span><span class="src-sym">(</span><span class="src-var">$requete</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a262"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a263"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a264"></a></span><span class="src-str"> <span class="src-key">return</span> <span class="src-var">$retour</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a265"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a266"></a></span><span class="src-str"> </span></div></li><li><div class="src-line"><a name="a267"></a><span class="src-doc">/**</span><span class="src-str"> </span></span></div></li><li><div class="src-line"><a name="a268"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@deprecated</span><span class="src-doc"> changement de nom. Disparaîtra dans la version 0.4. Utiliser à la place : @see recupererTous</span></div></li><li><div class="src-line"><a name="a269"></a><span class="src-doc"> */</span><span class="src-str"></span></span></div></li><li><div class="src-line"><a name="a270"></a></span><span class="src-str"> <span class="src-key">final</span> <span class="src-key">protected</span> <span class="src-key">function</span> <a href="../Framework/Bdd.html#methodrequeteTous">requeteTous</a><span class="src-sym">(</span><span class="src-var">$requete</span><span class="src-sym">,</span> <span class="src-var">$mode</span> = <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">MODE_ASSOC</span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a271"></a></span><span class="src-str"> <span class="src-key">return</span> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#methodrecupererTous">recupererTous</a><span class="src-sym">(</span><span class="src-var">$requete</span><span class="src-sym">,</span> <span class="src-var">$mode</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a272"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a273"></a></span><span class="src-str"> </span></div></li><li><div class="src-line"><a name="a274"></a><span class="src-doc">/**</span><span class="src-str"> </span></span></div></li><li><div class="src-line"><a name="a275"></a><span class="src-doc"> * Execute une requête et retourne un tableau de résultats. Un résultat peut être présentés sous forme</span></div></li><li><div class="src-line"><a name="a276"></a><span class="src-doc"> * de tableau (par défaut) ou d'objet.</span></div></li><li><div class="src-line"><a name="a277"></a><span class="src-doc"> * Les noms des champs de la base de données correspondent aux noms des clés du tableau résultat ou</span></div></li><li><div class="src-line"><a name="a278"></a><span class="src-doc"> * aux noms des attributs de l'objet résultat.</span></div></li><li><div class="src-line"><a name="a279"></a><span class="src-doc"> *</span></div></li><li><div class="src-line"><a name="a280"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc">la requête à effectuer</span></div></li><li><div class="src-line"><a name="a281"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc">le mode de retour des résultats : ASSOC (Bdd::MODE_ASSOC) pour un tableau ou OBJECT (Bdd::MODE_OBJET) pour un objet.</span></div></li><li><div class="src-line"><a name="a282"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">array </span><span class="src-doc">un tableau contenant les résultats sous forme d'objets ou de tableau (par défaut).</span></div></li><li><div class="src-line"><a name="a283"></a><span class="src-doc"> */</span><span class="src-str"></span></span></div></li><li><div class="src-line"><a name="a284"></a></span><span class="src-str"> <span class="src-key">public</span> <span class="src-key">function</span> <a href="../Framework/Bdd.html#methodrecupererTous">recupererTous</a><span class="src-sym">(</span><span class="src-var">$requete</span><span class="src-sym">,</span> <span class="src-var">$mode</span> = <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">MODE_ASSOC</span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a285"></a></span><span class="src-str"> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#methodconnecter">connecter</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a286"></a></span><span class="src-str"> </span></div></li><li><div class="src-line"><a name="a287"></a></span><span class="src-str"> <span class="src-var">$retour</span> = <span class="src-id">null</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a288"></a></span><span class="src-str"> <span class="src-key">switch</span> <span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$abstraction">abstraction</a></span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a289"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_PDO</span> :</span></div></li><li><div class="src-line"><a name="a290"></a></span><span class="src-str"> try <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a291"></a></span><span class="src-str"> <span class="src-var">$resultat</span> = <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$connexion">connexion</a></span><span class="src-sym">-></span><span class="src-id">query</span><span class="src-sym">(</span><span class="src-var">$requete</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a292"></a></span><span class="src-str"> <span class="src-key">if</span> <span class="src-sym">(</span><span class="src-var">$resultat</span> !== <span class="src-id">false</span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a293"></a></span><span class="src-str"> <span class="src-var">$retour</span> = <span class="src-var">$resultat</span><span class="src-sym">-></span><span class="src-id">fetchAll</span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-var">$mode</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a294"></a></span><span class="src-str"> <span class="src-sym">}</span> <span class="src-key">else</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a295"></a></span><span class="src-str"> <span class="src-var">$retour</span> = <span class="src-id">false</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a296"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a297"></a></span><span class="src-str"> <span class="src-sym">}</span> catch <span class="src-sym">(</span><span class="src-id">PDOException</span> <span class="src-var">$e</span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a298"></a></span><span class="src-str"> <span class="src-var">$m</span> = <a href="http://www.php.net/sprintf">sprintf</a><span class="src-sym">(</span><span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ERREUR_REQUETE_TPL</span><span class="src-sym">,</span> <span class="src-var">$e</span><span class="src-sym">-></span><span class="src-id">getFile</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">,</span> <span class="src-var">$e</span><span class="src-sym">-></span><span class="src-id">getLine</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">,</span> <span class="src-var">$e</span><span class="src-sym">-></span><span class="src-id">getMessage</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">,</span> <span class="src-var">$requete</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a299"></a></span><span class="src-str"> <a href="http://www.php.net/trigger_error">trigger_error</a><span class="src-sym">(</span><span class="src-var">$m</span><span class="src-sym">,</span> <span class="src-id">E_USER_WARNING</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a300"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a301"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a302"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_MYSQL</span> :</span></div></li><li><div class="src-line"><a name="a303"></a></span><span class="src-str"> <span class="src-var">$resultat</span> = <a href="http://www.php.net/mysql_query">mysql_query</a><span class="src-sym">(</span><span class="src-var">$requete</span><span class="src-sym">,</span> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$connexion">connexion</a></span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a304"></a></span><span class="src-str"> <span class="src-var">$fonction_fetch</span> = <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-var">$mode</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a305"></a></span><span class="src-str"> <span class="src-key">while</span> <span class="src-sym">(</span><span class="src-var">$ligne</span> = <span class="src-var">$fonction_fetch</span><span class="src-sym">(</span><span class="src-var">$resultat</span><span class="src-sym">))</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a306"></a></span><span class="src-str"> <span class="src-var">$retour</span><span class="src-sym">[</span><span class="src-sym">]</span> = <span class="src-var">$ligne</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a307"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a308"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a309"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_MYSQLI</span> :</span></div></li><li><div class="src-line"><a name="a310"></a></span><span class="src-str"> <span class="src-var">$resultat</span> = <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$connexion">connexion</a></span><span class="src-sym">-></span><span class="src-id">query</span><span class="src-sym">(</span><span class="src-var">$requete</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a311"></a></span><span class="src-str"> <span class="src-var">$function_fetch</span> = <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-var">$mode</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a312"></a></span><span class="src-str"> <span class="src-key">while</span> <span class="src-sym">(</span><span class="src-var">$ligne</span> = <span class="src-var">$resultat</span><span class="src-sym">-></span><span class="src-var">$function_fetch</span><span class="src-sym">(</span><span class="src-sym">))</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a313"></a></span><span class="src-str"> <span class="src-var">$retour</span><span class="src-sym">[</span><span class="src-sym">]</span> = <span class="src-var">$ligne</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a314"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a315"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a316"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_SQLITE3</span> :</span></div></li><li><div class="src-line"><a name="a317"></a></span><span class="src-str"> <span class="src-var">$resultat</span> = <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$connexion">connexion</a></span><span class="src-sym">-></span><span class="src-id">query</span><span class="src-sym">(</span><span class="src-var">$requete</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a318"></a></span><span class="src-str"> <span class="src-key">while</span> <span class="src-sym">(</span><span class="src-var">$ligne</span> = <span class="src-var">$resultat</span><span class="src-sym">-></span><span class="src-id">fetch_array</span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$ASSOC">ASSOC</a></span><span class="src-sym">))</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a319"></a></span><span class="src-str"> <span class="src-key">if</span> <span class="src-sym">(</span><span class="src-var">$mode</span> == <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">MODE_OBJET</span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a320"></a></span><span class="src-str"> <span class="src-comm">// Cas particulier de sqllite qui n'a pas de fonction fetch_object</span></span></div></li><li><div class="src-line"><a name="a321"></a></span><span class="src-str"><span class="src-comm"></span> <span class="src-var">$ligneObjet</span> = <span class="src-key">new</span> <span class="src-id">stdClass</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a322"></a></span><span class="src-str"> <span class="src-key">foreach</span> <span class="src-sym">(</span><span class="src-var">$ligne</span> <span class="src-key">as</span> <span class="src-var">$colonne</span> => <span class="src-var">$valeur</span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a323"></a></span><span class="src-str"> <span class="src-var">$ligneObjet</span><span class="src-sym">-></span><span class="src-var">$colonne</span> = <span class="src-var">$valeur</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a324"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a325"></a></span><span class="src-str"> <span class="src-var">$ligne</span> = <span class="src-var">$ligneObjet</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a326"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a327"></a></span><span class="src-str"> <span class="src-var">$retour</span><span class="src-sym">[</span><span class="src-sym">]</span> = <span class="src-var">$ligne</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a328"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a329"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a330"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a331"></a></span><span class="src-str"> <span class="src-key">return</span> <span class="src-var">$retour</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a332"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a333"></a> </div></li><li><div class="src-line"><a name="a334"></a><span class="src-doc">/**</span><span class="src-str"> </span></span></div></li><li><div class="src-line"><a name="a335"></a><span class="src-doc"> * Protège une chaine de caractères avant l'insertion dans la base de données (ajout de quotes ou guillemets).</span></div></li><li><div class="src-line"><a name="a336"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc">la chaine à protéger</span></div></li><li><div class="src-line"><a name="a337"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span><span class="src-doc">la chaine protégée</span></div></li><li><div class="src-line"><a name="a338"></a><span class="src-doc"> */</span><span class="src-str"></span></span></div></li><li><div class="src-line"><a name="a339"></a></span><span class="src-str"> <span class="src-key">public</span> <span class="src-key">function</span> <a href="../Framework/Bdd.html#methodproteger">proteger</a><span class="src-sym">(</span><span class="src-var">$chaine</span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a340"></a></span><span class="src-str"> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#methodconnecter">connecter</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a341"></a> </div></li><li><div class="src-line"><a name="a342"></a></span><span class="src-str"> <span class="src-var">$retour</span> = <span class="src-var">$chaine</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a343"></a></span><span class="src-str"> <span class="src-key">switch</span> <span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$abstraction">abstraction</a></span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a344"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_PDO</span> :</span></div></li><li><div class="src-line"><a name="a345"></a></span><span class="src-str"> <span class="src-var">$retour</span> = <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$connexion">connexion</a></span><span class="src-sym">-></span><span class="src-id">quote</span><span class="src-sym">(</span><span class="src-var">$chaine</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a346"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a347"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_MYSQL</span> :</span></div></li><li><div class="src-line"><a name="a348"></a></span><span class="src-str"> <span class="src-var">$retour</span> = <span class="src-str">'"'</span>.<a href="http://www.php.net/mysql_real_escape_string">mysql_real_escape_string</a><span class="src-sym">(</span><span class="src-var">$chaine</span><span class="src-sym">,</span> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$connexion">connexion</a></span><span class="src-sym">)</span>.<span class="src-str">'"'</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a349"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a350"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_MYSQLI</span> :</span></div></li><li><div class="src-line"><a name="a351"></a></span><span class="src-str"> <span class="src-var">$retour</span> = <span class="src-str">'"'</span>.<span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$connexion">connexion</a></span><span class="src-sym">-></span><span class="src-id">real_escape_string</span><span class="src-sym">(</span><span class="src-var">$chaine</span><span class="src-sym">)</span>.<span class="src-str">'"'</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a352"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a353"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_SQLITE3</span> :</span></div></li><li><div class="src-line"><a name="a354"></a></span><span class="src-str"> <span class="src-var">$retour</span> = <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$connexion">connexion</a></span><span class="src-sym">-></span><span class="src-id">escapeString</span><span class="src-sym">(</span><span class="src-var">$chaine</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a355"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a356"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a357"></a></span><span class="src-str"> <span class="src-key">return</span> <span class="src-var">$retour</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a358"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a359"></a> </div></li><li><div class="src-line"><a name="a360"></a><span class="src-doc">/**</span><span class="src-str"> </span></span></div></li><li><div class="src-line"><a name="a361"></a><span class="src-doc"> * Retourne l'identifiant de la dernière ligne insérée, ou la dernière valeur d'une séquence d'objets, dépendamment, dans</span></div></li><li><div class="src-line"><a name="a362"></a><span class="src-doc"> * le cas de PDO, du driver utilisé. Les méthodes utilisées pour retourner l'identifiant peuvent avoir des comportements</span></div></li><li><div class="src-line"><a name="a363"></a><span class="src-doc"> * différent. Consulter la documentation PHP correspondant à l'abstraction choisie avant de l'utiliser :</span></div></li><li><div class="src-line"><a name="a364"></a><span class="src-doc"> * </span><span class="src-doc-tag">@link(http://fr.php.net/manual/fr/pdo.lastinsertid.php,</span><span class="src-doc"> PDO::lastInsertId([ string $name = NULL ]))</span></div></li><li><div class="src-line"><a name="a365"></a><span class="src-doc"> * </span><span class="src-doc-tag">@link(http://php.net/manual/en/mysqli.insert-id.php,</span><span class="src-doc"> mysqli->insert_id())</span></div></li><li><div class="src-line"><a name="a366"></a><span class="src-doc"> * </span><span class="src-doc-tag">@link(http://fr.php.net/manual/fr/function.mysql-insert-id.php,</span><span class="src-doc"> mysql_insert_id())</span></div></li><li><div class="src-line"><a name="a367"></a><span class="src-doc"> * </span><span class="src-doc-tag">@link(http://fr.php.net/manual/fr/sqlite3.lastinsertrowid.php,</span><span class="src-doc"> SQLite3::lastInsertRowID())</span></div></li><li><div class="src-line"><a name="a368"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">mixed </span><span class="src-doc">un paramètre éventuel à transmettre (en fonction de l'abstraction de BDD utilisée).</span></div></li><li><div class="src-line"><a name="a369"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">mixed </span><span class="src-doc">le dernier identifiant de clé primaire ajouté dans la base de données (string ou int).</span></div></li><li><div class="src-line"><a name="a370"></a><span class="src-doc"> */</span><span class="src-str"></span></span></div></li><li><div class="src-line"><a name="a371"></a></span><span class="src-str"> <span class="src-key">public</span> <span class="src-key">function</span> <a href="../Framework/Bdd.html#methodrecupererIdDernierAjout">recupererIdDernierAjout</a><span class="src-sym">(</span><span class="src-var">$parametres</span> = <span class="src-id">null</span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a372"></a></span><span class="src-str"> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Framework/Bdd.html#methodconnecter">connecter</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a373"></a> </div></li><li><div class="src-line"><a name="a374"></a></span><span class="src-str"> <span class="src-var">$retour</span> = <span class="src-var">$chaine</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a375"></a></span><span class="src-str"> <span class="src-key">switch</span> <span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$abstraction">abstraction</a></span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a376"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_PDO</span> :</span></div></li><li><div class="src-line"><a name="a377"></a></span><span class="src-str"> <span class="src-var">$retour</span> = <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$connexion">connexion</a></span><span class="src-sym">-></span><span class="src-id">lastInsertId</span><span class="src-sym">(</span><span class="src-var">$parametres</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a378"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a379"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_MYSQL</span> :</span></div></li><li><div class="src-line"><a name="a380"></a></span><span class="src-str"> <span class="src-var">$retour</span> = <a href="http://www.php.net/mysql_insert_id">mysql_insert_id</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$connexion">connexion</a></span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a381"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a382"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_MYSQLI</span> :</span></div></li><li><div class="src-line"><a name="a383"></a></span><span class="src-str"> <span class="src-var">$retour</span> = <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$connexion">connexion</a></span><span class="src-sym">-></span><span class="src-id">insert_id</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a384"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a385"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_SQLITE3</span> :</span></div></li><li><div class="src-line"><a name="a386"></a></span><span class="src-str"> <span class="src-var">$retour</span> = <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$connexion">connexion</a></span><span class="src-sym">-></span><span class="src-id">lastInsertRowID</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a387"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a388"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a389"></a></span><span class="src-str"> <span class="src-key">return</span> <span class="src-var">$retour</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a390"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a391"></a></span><span class="src-str"> </span></div></li><li><div class="src-line"><a name="a392"></a><span class="src-doc">/**</span><span class="src-str"> </span></span></div></li><li><div class="src-line"><a name="a393"></a><span class="src-doc"> * Destructeur de classe, se contente de fermer explicitement la connexion à la base de donnée.</span></div></li><li><div class="src-line"><a name="a394"></a><span class="src-doc"> */</span><span class="src-str"></span></span></div></li><li><div class="src-line"><a name="a395"></a></span><span class="src-str"> <span class="src-key">public</span> <span class="src-key">function</span> <a href="../Framework/Bdd.html#method__destruct">__destruct</a><span class="src-sym">(</span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a396"></a></span><span class="src-str"> <span class="src-key">switch</span> <span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$abstraction">abstraction</a></span><span class="src-sym">)</span> <span class="src-sym">{</span></span></div></li><li><div class="src-line"><a name="a397"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_PDO</span> :</span></div></li><li><div class="src-line"><a name="a398"></a></span><span class="src-str"> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$connexion">connexion</a></span> = <span class="src-id">null</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a399"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a400"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_MYSQL</span> :</span></div></li><li><div class="src-line"><a name="a401"></a></span><span class="src-str"> <span class="src-key">return</span> <a href="http://www.php.net/mysql_close">mysql_close</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$connexion">connexion</a></span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a402"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a403"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_MYSQLI</span> :</span></div></li><li><div class="src-line"><a name="a404"></a></span><span class="src-str"> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$connexion">connexion</a></span><span class="src-sym">-></span><span class="src-id">close</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a405"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a406"></a></span><span class="src-str"> <span class="src-key">case</span> <span class="src-id">self</span><span class="src-sym">::</span><span class="src-id">ABSTRACTION_SQLITE3</span> :</span></div></li><li><div class="src-line"><a name="a407"></a></span><span class="src-str"> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Framework/Bdd.html#var$connexion">connexion</a></span><span class="src-sym">-></span><span class="src-id">close</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a408"></a></span><span class="src-str"> <span class="src-key">break</span><span class="src-sym">;</span></span></div></li><li><div class="src-line"><a name="a409"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a410"></a></span><span class="src-str"> <span class="src-sym">}</span></span></div></li><li><div class="src-line"><a name="a411"></a></span><span class="src-str"><span class="src-sym">}</span></span></div></li></ol></div><div class="credit"><hr />Documentation generated on Tue, 18 Jan 2011 15:31:05 +0100 by <a href="http://www.phpdoc.org">phpDocumentor 1.4.3</a></div></td></tr></table></td></tr></table></body></html>