| Line 6... |
Line 6... |
| 6 |
<meta name="robots" content="noindex">
|
6 |
<meta name="robots" content="noindex">
|
| Line 7... |
Line 7... |
| 7 |
|
7 |
|
| Line 8... |
Line 8... |
| 8 |
<title>File Modele.php | TBFramework - v0.2</title>
|
8 |
<title>File Modele.php | TBFramework - v0.2</title>
|
| 9 |
|
9 |
|
| 10 |
<script type="text/javascript" src="resources/combined.js?4205936287"></script>
|
10 |
<script type="text/javascript" src="resources/combined.js?4205936287"></script>
|
| Line 11... |
Line 11... |
| 11 |
<script type="text/javascript" src="elementlist.js?117657638"></script>
|
11 |
<script type="text/javascript" src="elementlist.js?1835392179"></script>
|
| Line 12... |
Line 12... |
| 12 |
<link rel="stylesheet" type="text/css" media="all" href="resources/style.css?3505392360">
|
12 |
<link rel="stylesheet" type="text/css" media="all" href="resources/style.css?3505392360">
|
| Line 39... |
Line 39... |
| 39 |
<li><a href="class-Chronometre.html">Chronometre</a></li>
|
39 |
<li><a href="class-Chronometre.html">Chronometre</a></li>
|
| 40 |
<li><a href="class-Config.html">Config</a></li>
|
40 |
<li><a href="class-Config.html">Config</a></li>
|
| 41 |
<li><a href="class-Controleur.html">Controleur</a></li>
|
41 |
<li><a href="class-Controleur.html">Controleur</a></li>
|
| 42 |
<li><a href="class-Debug.html">Debug</a></li>
|
42 |
<li><a href="class-Debug.html">Debug</a></li>
|
| 43 |
<li><a href="class-GestionnaireException.html">GestionnaireException</a></li>
|
43 |
<li><a href="class-GestionnaireException.html">GestionnaireException</a></li>
|
| - |
|
44 |
<li><a href="class-I18n.html">I18n</a></li>
|
| 44 |
<li><a href="class-Log.html">Log</a></li>
|
45 |
<li><a href="class-Log.html">Log</a></li>
|
| 45 |
<li class="active"><a href="class-Modele.html">Modele</a></li>
|
46 |
<li class="active"><a href="class-Modele.html">Modele</a></li>
|
| 46 |
<li><a href="class-Registre.html">Registre</a></li>
|
47 |
<li><a href="class-Registre.html">Registre</a></li>
|
| 47 |
<li><a href="class-SquelettePhp.html">SquelettePhp</a></li>
|
48 |
<li><a href="class-SquelettePhp.html">SquelettePhp</a></li>
|
| 48 |
<li><a href="class-Url.html">Url</a></li>
|
49 |
<li><a href="class-Url.html">Url</a></li>
|
| Line 100... |
Line 101... |
| 100 |
</div>
|
101 |
</div>
|
| Line 101... |
Line 102... |
| 101 |
|
102 |
|
| 102 |
<pre><code><span id="1" class="l"><a class="l" href="#1"> 1: </a><span class="xlang"><?php</span>
|
103 |
<pre><code><span id="1" class="l"><a class="l" href="#1"> 1: </a><span class="xlang"><?php</span>
|
| 103 |
</span><span id="2" class="l"><a class="l" href="#2"> 2: </a><span class="php-comment">// declare(encoding='UTF-8');</span>
|
104 |
</span><span id="2" class="l"><a class="l" href="#2"> 2: </a><span class="php-comment">// declare(encoding='UTF-8');</span>
|
| 104 |
</span><span id="3" class="l"><a class="l" href="#3"> 3: </a><span class="php-comment">/**
|
105 |
</span><span id="3" class="l"><a class="l" href="#3"> 3: </a><span class="php-comment">/**
|
| 105 |
</span></span><span id="4" class="l"><a class="l" href="#4"> 4: </a><span class="php-comment">* Classe modèle, donc d'accés au données, elle ne devrait pas être appelée de l'extérieur.
|
106 |
</span></span><span id="4" class="l"><a class="l" href="#4"> 4: </a><span class="php-comment"> * Classe modèle, donc d'accés au données, elle ne devrait pas être appelée de l'extérieur.
|
| 106 |
</span></span><span id="5" class="l"><a class="l" href="#5"> 5: </a><span class="php-comment">* Elle fait office d'abstraction légère de base de données en utilisant diveres possibilités
|
107 |
</span></span><span id="5" class="l"><a class="l" href="#5"> 5: </a><span class="php-comment"> * Elle fait office d'abstraction légère de base de données en utilisant diveres possibilités
|
| 107 |
</span></span><span id="6" class="l"><a class="l" href="#6"> 6: </a><span class="php-comment">* d'abstraction de base de données (PDO, mysql, mysqli, sqlite)
|
108 |
</span></span><span id="6" class="l"><a class="l" href="#6"> 6: </a><span class="php-comment"> * d'abstraction de base de données (PDO, mysql, mysqli, sqlite)
|
| 108 |
</span></span><span id="7" class="l"><a class="l" href="#7"> 7: </a><span class="php-comment">* Elle est abstraite donc doit obligatoirement être étendue.
|
109 |
</span></span><span id="7" class="l"><a class="l" href="#7"> 7: </a><span class="php-comment"> * Elle est abstraite donc doit obligatoirement être étendue.
|
| 109 |
</span></span><span id="8" class="l"><a class="l" href="#8"> 8: </a><span class="php-comment">*
|
110 |
</span></span><span id="8" class="l"><a class="l" href="#8"> 8: </a><span class="php-comment"> *
|
| 110 |
</span></span><span id="9" class="l"><a class="l" href="#9"> 9: </a><span class="php-comment">* PHP Version 5
|
111 |
</span></span><span id="9" class="l"><a class="l" href="#9"> 9: </a><span class="php-comment"> * @category PHP 5.2
|
| 111 |
</span></span><span id="10" class="l"><a class="l" href="#10"> 10: </a><span class="php-comment">*
|
112 |
</span></span><span id="10" class="l"><a class="l" href="#10"> 10: </a><span class="php-comment"> * @package Framework
|
| 112 |
</span></span><span id="11" class="l"><a class="l" href="#11"> 11: </a><span class="php-comment">* @category Class
|
113 |
</span></span><span id="11" class="l"><a class="l" href="#11"> 11: </a><span class="php-comment"> * @author Aurélien PERONNET <aurelien@tela-botanica.org>
|
| 113 |
</span></span><span id="12" class="l"><a class="l" href="#12"> 12: </a><span class="php-comment">* @package Framework
|
114 |
</span></span><span id="12" class="l"><a class="l" href="#12"> 12: </a><span class="php-comment"> * @copyright Copyright (c) 2009, Tela Botanica (accueil@tela-botanica.org)
|
| 114 |
</span></span><span id="13" class="l"><a class="l" href="#13"> 13: </a><span class="php-comment">* @author aurelien <aurelien@tela-botanica.org>
|
115 |
</span></span><span id="13" class="l"><a class="l" href="#13"> 13: </a><span class="php-comment"> * @license GNU-GPL-v3 <http://www.gnu.org/licenses/gpl.html>
|
| 115 |
</span></span><span id="14" class="l"><a class="l" href="#14"> 14: </a><span class="php-comment">* @copyright 2009 Tela-Botanica
|
116 |
</span></span><span id="14" class="l"><a class="l" href="#14"> 14: </a><span class="php-comment"> * @license CECILL-v2 <http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt>
|
| 116 |
</span></span><span id="15" class="l"><a class="l" href="#15"> 15: </a><span class="php-comment">* @license http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt Licence CECILL
|
117 |
</span></span><span id="15" class="l"><a class="l" href="#15"> 15: </a><span class="php-comment"> */</span>
|
| 117 |
</span></span><span id="16" class="l"><a class="l" href="#16"> 16: </a><span class="php-comment">* @license http://www.gnu.org/licenses/gpl.html Licence GNU-GPL
|
118 |
</span><span id="16" class="l"><a class="l" href="#16"> 16: </a><span class="php-keyword1">abstract</span> <span class="php-keyword1">class</span> <a id="Modele" href="#Modele">Modele</a> {
|
| 118 |
</span></span><span id="17" class="l"><a class="l" href="#17"> 17: </a><span class="php-comment">* @version SVN: $$Id: Modele.php 426 2013-04-30 16:58:14Z jpm $$
|
119 |
</span><span id="17" class="l"><a class="l" href="#17"> 17: </a>
|
| 119 |
</span></span><span id="18" class="l"><a class="l" href="#18"> 18: </a><span class="php-comment">* @link /doc/framework/
|
120 |
</span><span id="18" class="l"><a class="l" href="#18"> 18: </a> <span class="php-comment">/**
|
| 120 |
</span></span><span id="19" class="l"><a class="l" href="#19"> 19: </a><span class="php-comment">*
|
121 |
</span></span><span id="19" class="l"><a class="l" href="#19"> 19: </a><span class="php-comment"> * Mode de fetch associatif
|
| 121 |
</span></span><span id="20" class="l"><a class="l" href="#20"> 20: </a><span class="php-comment">*/</span>
|
122 |
</span></span><span id="20" class="l"><a class="l" href="#20"> 20: </a><span class="php-comment"> */</span>
|
| 122 |
</span><span id="21" class="l"><a class="l" href="#21"> 21: </a><span class="php-keyword1">abstract</span> <span class="php-keyword1">class</span> <a id="Modele" href="#Modele">Modele</a> {
|
- |
|
| 123 |
</span><span id="22" class="l"><a class="l" href="#22"> 22: </a>
|
123 |
</span><span id="21" class="l"><a class="l" href="#21"> 21: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$ASSOC" href="#$ASSOC">$ASSOC</a></span> = <span class="php-quote">''</span>;
|
| 124 |
</span><span id="23" class="l"><a class="l" href="#23"> 23: </a> <span class="php-comment">/**
|
124 |
</span><span id="22" class="l"><a class="l" href="#22"> 22: </a> <span class="php-comment">/**
|
| 125 |
</span></span><span id="24" class="l"><a class="l" href="#24"> 24: </a><span class="php-comment"> * Mode de fetch associatif
|
125 |
</span></span><span id="23" class="l"><a class="l" href="#23"> 23: </a><span class="php-comment"> * Mode de fetch objet
|
| 126 |
</span></span><span id="25" class="l"><a class="l" href="#25"> 25: </a><span class="php-comment"> */</span>
|
126 |
</span></span><span id="24" class="l"><a class="l" href="#24"> 24: </a><span class="php-comment"> */</span>
|
| - |
|
127 |
</span><span id="25" class="l"><a class="l" href="#25"> 25: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$OBJECT" href="#$OBJECT">$OBJECT</a></span> = <span class="php-quote">''</span>;
|
| 127 |
</span><span id="26" class="l"><a class="l" href="#26"> 26: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$ASSOC" href="#$ASSOC">$ASSOC</a></span> = <span class="php-quote">''</span>;
|
128 |
</span><span id="26" class="l"><a class="l" href="#26"> 26: </a>
|
| 128 |
</span><span id="27" class="l"><a class="l" href="#27"> 27: </a> <span class="php-comment">/**
|
129 |
</span><span id="27" class="l"><a class="l" href="#27"> 27: </a> <span class="php-comment">/**
|
| 129 |
</span></span><span id="28" class="l"><a class="l" href="#28"> 28: </a><span class="php-comment"> * Mode de fetch objet
|
130 |
</span></span><span id="28" class="l"><a class="l" href="#28"> 28: </a><span class="php-comment"> * abstraction de base de données utilisée
|
| 130 |
</span></span><span id="29" class="l"><a class="l" href="#29"> 29: </a><span class="php-comment"> */</span>
|
131 |
</span></span><span id="29" class="l"><a class="l" href="#29"> 29: </a><span class="php-comment"> */</span>
|
| 131 |
</span><span id="30" class="l"><a class="l" href="#30"> 30: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$OBJECT" href="#$OBJECT">$OBJECT</a></span> = <span class="php-quote">''</span>;
|
- |
|
| 132 |
</span><span id="31" class="l"><a class="l" href="#31"> 31: </a>
|
132 |
</span><span id="30" class="l"><a class="l" href="#30"> 30: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$abstraction" href="#$abstraction">$abstraction</a></span>;
|
| 133 |
</span><span id="32" class="l"><a class="l" href="#32"> 32: </a> <span class="php-comment">/**
|
133 |
</span><span id="31" class="l"><a class="l" href="#31"> 31: </a> <span class="php-comment">/**
|
| 134 |
</span></span><span id="33" class="l"><a class="l" href="#33"> 33: </a><span class="php-comment"> * abstraction de base de données utilisée
|
134 |
</span></span><span id="32" class="l"><a class="l" href="#32"> 32: </a><span class="php-comment"> * registre global
|
| 135 |
</span></span><span id="34" class="l"><a class="l" href="#34"> 34: </a><span class="php-comment"> */</span>
|
135 |
</span></span><span id="33" class="l"><a class="l" href="#33"> 33: </a><span class="php-comment"> */</span>
|
| 136 |
</span><span id="35" class="l"><a class="l" href="#35"> 35: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$abstraction" href="#$abstraction">$abstraction</a></span>;
|
136 |
</span><span id="34" class="l"><a class="l" href="#34"> 34: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$registre" href="#$registre">$registre</a></span>;
|
| 137 |
</span><span id="36" class="l"><a class="l" href="#36"> 36: </a> <span class="php-comment">/**
|
137 |
</span><span id="35" class="l"><a class="l" href="#35"> 35: </a> <span class="php-comment">/**
|
| 138 |
</span></span><span id="37" class="l"><a class="l" href="#37"> 37: </a><span class="php-comment"> * registre global
|
138 |
</span></span><span id="36" class="l"><a class="l" href="#36"> 36: </a><span class="php-comment"> * DSN pour accéder à la base de données
|
| 139 |
</span></span><span id="38" class="l"><a class="l" href="#38"> 38: </a><span class="php-comment"> */</span>
|
139 |
</span></span><span id="37" class="l"><a class="l" href="#37"> 37: </a><span class="php-comment"> */</span>
|
| 140 |
</span><span id="39" class="l"><a class="l" href="#39"> 39: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$registre" href="#$registre">$registre</a></span>;
|
140 |
</span><span id="38" class="l"><a class="l" href="#38"> 38: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$dsn" href="#$dsn">$dsn</a></span>;
|
| 141 |
</span><span id="40" class="l"><a class="l" href="#40"> 40: </a> <span class="php-comment">/**
|
141 |
</span><span id="39" class="l"><a class="l" href="#39"> 39: </a> <span class="php-comment">/**
|
| 142 |
</span></span><span id="41" class="l"><a class="l" href="#41"> 41: </a><span class="php-comment"> * DSN pour accéder à la base de données
|
142 |
</span></span><span id="40" class="l"><a class="l" href="#40"> 40: </a><span class="php-comment"> * Type de base de données (mysql, mysqli, etc ...)
|
| 143 |
</span></span><span id="42" class="l"><a class="l" href="#42"> 42: </a><span class="php-comment"> */</span>
|
143 |
</span></span><span id="41" class="l"><a class="l" href="#41"> 41: </a><span class="php-comment"> */</span>
|
| 144 |
</span><span id="43" class="l"><a class="l" href="#43"> 43: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$dsn" href="#$dsn">$dsn</a></span>;
|
144 |
</span><span id="42" class="l"><a class="l" href="#42"> 42: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$type" href="#$type">$type</a></span>;
|
| 145 |
</span><span id="44" class="l"><a class="l" href="#44"> 44: </a> <span class="php-comment">/**
|
145 |
</span><span id="43" class="l"><a class="l" href="#43"> 43: </a> <span class="php-comment">/**
|
| 146 |
</span></span><span id="45" class="l"><a class="l" href="#45"> 45: </a><span class="php-comment"> * Type de base de données (mysql, mysqli, etc ...)
|
146 |
</span></span><span id="44" class="l"><a class="l" href="#44"> 44: </a><span class="php-comment"> * Hote herbergeant la base de données
|
| 147 |
</span></span><span id="46" class="l"><a class="l" href="#46"> 46: </a><span class="php-comment"> */</span>
|
147 |
</span></span><span id="45" class="l"><a class="l" href="#45"> 45: </a><span class="php-comment"> */</span>
|
| 148 |
</span><span id="47" class="l"><a class="l" href="#47"> 47: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$type" href="#$type">$type</a></span>;
|
148 |
</span><span id="46" class="l"><a class="l" href="#46"> 46: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$hote" href="#$hote">$hote</a></span>;
|
| 149 |
</span><span id="48" class="l"><a class="l" href="#48"> 48: </a> <span class="php-comment">/**
|
149 |
</span><span id="47" class="l"><a class="l" href="#47"> 47: </a> <span class="php-comment">/**
|
| 150 |
</span></span><span id="49" class="l"><a class="l" href="#49"> 49: </a><span class="php-comment"> * Hote herbergeant la base de données
|
150 |
</span></span><span id="48" class="l"><a class="l" href="#48"> 48: </a><span class="php-comment"> * Nom de la base de données à laquelle le modèle doit se connecter
|
| 151 |
</span></span><span id="50" class="l"><a class="l" href="#50"> 50: </a><span class="php-comment"> */</span>
|
151 |
</span></span><span id="49" class="l"><a class="l" href="#49"> 49: </a><span class="php-comment"> */</span>
|
| 152 |
</span><span id="51" class="l"><a class="l" href="#51"> 51: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$hote" href="#$hote">$hote</a></span>;
|
152 |
</span><span id="50" class="l"><a class="l" href="#50"> 50: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$bdd_nom" href="#$bdd_nom">$bdd_nom</a></span>;
|
| 153 |
</span><span id="52" class="l"><a class="l" href="#52"> 52: </a> <span class="php-comment">/**
|
153 |
</span><span id="51" class="l"><a class="l" href="#51"> 51: </a> <span class="php-comment">/**
|
| 154 |
</span></span><span id="53" class="l"><a class="l" href="#53"> 53: </a><span class="php-comment"> * Nom de la base de données à laquelle le modèle doit se connecter
|
154 |
</span></span><span id="52" class="l"><a class="l" href="#52"> 52: </a><span class="php-comment"> * Nom d'utilisateur
|
| 155 |
</span></span><span id="54" class="l"><a class="l" href="#54"> 54: </a><span class="php-comment"> */</span>
|
155 |
</span></span><span id="53" class="l"><a class="l" href="#53"> 53: </a><span class="php-comment"> */</span>
|
| 156 |
</span><span id="55" class="l"><a class="l" href="#55"> 55: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$bdd_nom" href="#$bdd_nom">$bdd_nom</a></span>;
|
156 |
</span><span id="54" class="l"><a class="l" href="#54"> 54: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$utilisateur" href="#$utilisateur">$utilisateur</a></span>;
|
| 157 |
</span><span id="56" class="l"><a class="l" href="#56"> 56: </a> <span class="php-comment">/**
|
157 |
</span><span id="55" class="l"><a class="l" href="#55"> 55: </a> <span class="php-comment">/**
|
| 158 |
</span></span><span id="57" class="l"><a class="l" href="#57"> 57: </a><span class="php-comment"> * Nom d'utilisateur
|
158 |
</span></span><span id="56" class="l"><a class="l" href="#56"> 56: </a><span class="php-comment"> * Mot de passe
|
| 159 |
</span></span><span id="58" class="l"><a class="l" href="#58"> 58: </a><span class="php-comment"> */</span>
|
159 |
</span></span><span id="57" class="l"><a class="l" href="#57"> 57: </a><span class="php-comment"> */</span>
|
| - |
|
160 |
</span><span id="58" class="l"><a class="l" href="#58"> 58: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$pass" href="#$pass">$pass</a></span>;
|
| 160 |
</span><span id="59" class="l"><a class="l" href="#59"> 59: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$utilisateur" href="#$utilisateur">$utilisateur</a></span>;
|
161 |
</span><span id="59" class="l"><a class="l" href="#59"> 59: </a>
|
| 161 |
</span><span id="60" class="l"><a class="l" href="#60"> 60: </a> <span class="php-comment">/**
|
162 |
</span><span id="60" class="l"><a class="l" href="#60"> 60: </a> <span class="php-comment">/**
|
| 162 |
</span></span><span id="61" class="l"><a class="l" href="#61"> 61: </a><span class="php-comment"> * Mot de passe
|
163 |
</span></span><span id="61" class="l"><a class="l" href="#61"> 61: </a><span class="php-comment"> * Encodage de la base de données
|
| 163 |
</span></span><span id="62" class="l"><a class="l" href="#62"> 62: </a><span class="php-comment"> */</span>
|
164 |
</span></span><span id="62" class="l"><a class="l" href="#62"> 62: </a><span class="php-comment"> */</span>
|
| 164 |
</span><span id="63" class="l"><a class="l" href="#63"> 63: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$pass" href="#$pass">$pass</a></span>;
|
- |
|
| 165 |
</span><span id="64" class="l"><a class="l" href="#64"> 64: </a>
|
165 |
</span><span id="63" class="l"><a class="l" href="#63"> 63: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$encodage" href="#$encodage">$encodage</a></span> = <span class="php-keyword1">null</span>;
|
| 166 |
</span><span id="65" class="l"><a class="l" href="#65"> 65: </a> <span class="php-comment">/**
|
166 |
</span><span id="64" class="l"><a class="l" href="#64"> 64: </a> <span class="php-comment">/**
|
| 167 |
</span></span><span id="66" class="l"><a class="l" href="#66"> 66: </a><span class="php-comment"> * Encodage de la base de données
|
167 |
</span></span><span id="65" class="l"><a class="l" href="#65"> 65: </a><span class="php-comment"> * Connexion à la base de données
|
| 168 |
</span></span><span id="67" class="l"><a class="l" href="#67"> 67: </a><span class="php-comment"> */</span>
|
168 |
</span></span><span id="66" class="l"><a class="l" href="#66"> 66: </a><span class="php-comment"> */</span>
|
| - |
|
169 |
</span><span id="67" class="l"><a class="l" href="#67"> 67: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$connexion" href="#$connexion">$connexion</a></span> = <span class="php-keyword1">null</span>;
|
| 169 |
</span><span id="68" class="l"><a class="l" href="#68"> 68: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$encodage" href="#$encodage">$encodage</a></span> = <span class="php-keyword1">null</span>;
|
170 |
</span><span id="68" class="l"><a class="l" href="#68"> 68: </a>
|
| 170 |
</span><span id="69" class="l"><a class="l" href="#69"> 69: </a> <span class="php-comment">/**
|
171 |
</span><span id="69" class="l"><a class="l" href="#69"> 69: </a> <span class="php-comment">/**
|
| 171 |
</span></span><span id="70" class="l"><a class="l" href="#70"> 70: </a><span class="php-comment"> * Connexion à la base de données
|
172 |
</span></span><span id="70" class="l"><a class="l" href="#70"> 70: </a><span class="php-comment"> * Constructeur par défaut, appelé à l'initialisation.
|
| 172 |
</span></span><span id="71" class="l"><a class="l" href="#71"> 71: </a><span class="php-comment"> */</span>
|
- |
|
| 173 |
</span><span id="72" class="l"><a class="l" href="#72"> 72: </a> <span class="php-keyword1">private</span> <span class="php-var"><a id="$connexion" href="#$connexion">$connexion</a></span> = <span class="php-keyword1">null</span>;
|
- |
|
| 174 |
</span><span id="73" class="l"><a class="l" href="#73"> 73: </a>
|
- |
|
| 175 |
</span><span id="74" class="l"><a class="l" href="#74"> 74: </a> <span class="php-comment">/**
|
- |
|
| 176 |
</span></span><span id="75" class="l"><a class="l" href="#75"> 75: </a><span class="php-comment"> * Constructeur par défaut, appelé à l'initialisation.
|
- |
|
| 177 |
</span></span><span id="76" class="l"><a class="l" href="#76"> 76: </a><span class="php-comment"> */</span>
|
173 |
</span></span><span id="71" class="l"><a class="l" href="#71"> 71: </a><span class="php-comment"> */</span>
|
| 178 |
</span><span id="77" class="l"><a class="l" href="#77"> 77: </a> <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="___construct" href="#___construct">__construct</a>() {
|
174 |
</span><span id="72" class="l"><a class="l" href="#72"> 72: </a> <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="___construct" href="#___construct">__construct</a>() {
|
| 179 |
</span><span id="78" class="l"><a class="l" href="#78"> 78: </a> <span class="php-comment">// les différents paramètres nécessaires sont lus à partir du registre</span>
|
175 |
</span><span id="73" class="l"><a class="l" href="#73"> 73: </a> <span class="php-comment">// les différents paramètres nécessaires sont lus à partir du registre</span>
|
| 180 |
</span><span id="79" class="l"><a class="l" href="#79"> 79: </a> <span class="php-var">$this</span>->registre = Registre::getInstance();
|
176 |
</span><span id="74" class="l"><a class="l" href="#74"> 74: </a> <span class="php-var">$this</span>->registre = Registre::getInstance();
|
| 181 |
</span><span id="80" class="l"><a class="l" href="#80"> 80: </a> <span class="php-var">$this</span>->abstraction = <span class="php-keyword2">strtolower</span>(Config::get(<span class="php-quote">'bdd_abstraction'</span>));
|
177 |
</span><span id="75" class="l"><a class="l" href="#75"> 75: </a> <span class="php-var">$this</span>->abstraction = <span class="php-keyword2">strtolower</span>(Config::get(<span class="php-quote">'bdd_abstraction'</span>));
|
| 182 |
</span><span id="81" class="l"><a class="l" href="#81"> 81: </a> <span class="php-var">$this</span>->type = Config::get(<span class="php-quote">'bdd_protocole'</span>);
|
178 |
</span><span id="76" class="l"><a class="l" href="#76"> 76: </a> <span class="php-var">$this</span>->type = Config::get(<span class="php-quote">'bdd_protocole'</span>);
|
| 183 |
</span><span id="82" class="l"><a class="l" href="#82"> 82: </a> <span class="php-var">$this</span>->hote = Config::get(<span class="php-quote">'bdd_serveur'</span>);
|
179 |
</span><span id="77" class="l"><a class="l" href="#77"> 77: </a> <span class="php-var">$this</span>->hote = Config::get(<span class="php-quote">'bdd_serveur'</span>);
|
| 184 |
</span><span id="83" class="l"><a class="l" href="#83"> 83: </a> <span class="php-var">$this</span>->bdd_nom = Config::get(<span class="php-quote">'bdd_nom'</span>);
|
180 |
</span><span id="78" class="l"><a class="l" href="#78"> 78: </a> <span class="php-var">$this</span>->bdd_nom = Config::get(<span class="php-quote">'bdd_nom'</span>);
|
| 185 |
</span><span id="84" class="l"><a class="l" href="#84"> 84: </a> <span class="php-var">$this</span>->utilisateur = Config::get(<span class="php-quote">'bdd_utilisateur'</span>);
|
181 |
</span><span id="79" class="l"><a class="l" href="#79"> 79: </a> <span class="php-var">$this</span>->utilisateur = Config::get(<span class="php-quote">'bdd_utilisateur'</span>);
|
| 186 |
</span><span id="85" class="l"><a class="l" href="#85"> 85: </a> <span class="php-var">$this</span>->pass = Config::get(<span class="php-quote">'bdd_mot_de_passe'</span>);
|
182 |
</span><span id="80" class="l"><a class="l" href="#80"> 80: </a> <span class="php-var">$this</span>->pass = Config::get(<span class="php-quote">'bdd_mot_de_passe'</span>);
|
| 187 |
</span><span id="86" class="l"><a class="l" href="#86"> 86: </a> <span class="php-var">$this</span>->encodage = Config::get(<span class="php-quote">'bdd_encodage'</span>);
|
183 |
</span><span id="81" class="l"><a class="l" href="#81"> 81: </a> <span class="php-var">$this</span>->encodage = Config::get(<span class="php-quote">'bdd_encodage'</span>);
|
| 188 |
</span><span id="87" class="l"><a class="l" href="#87"> 87: </a>
|
184 |
</span><span id="82" class="l"><a class="l" href="#82"> 82: </a>
|
| 189 |
</span><span id="88" class="l"><a class="l" href="#88"> 88: </a> <span class="php-var">$this</span>->dsn = <span class="php-var">$this</span>->type.<span class="php-quote">':dbname='</span>.<span class="php-var">$this</span>->bdd_nom.<span class="php-quote">';host='</span>.<span class="php-var">$this</span>->hote;
|
185 |
</span><span id="83" class="l"><a class="l" href="#83"> 83: </a> <span class="php-var">$this</span>->dsn = <span class="php-var">$this</span>->type.<span class="php-quote">':dbname='</span>.<span class="php-var">$this</span>->bdd_nom.<span class="php-quote">';host='</span>.<span class="php-var">$this</span>->hote;
|
| 190 |
</span><span id="89" class="l"><a class="l" href="#89"> 89: </a> <span class="php-var">$this</span>->initialiserProtocole();
|
186 |
</span><span id="84" class="l"><a class="l" href="#84"> 84: </a> <span class="php-var">$this</span>->initialiserProtocole();
|
| 191 |
</span><span id="90" class="l"><a class="l" href="#90"> 90: </a> }
|
187 |
</span><span id="85" class="l"><a class="l" href="#85"> 85: </a> }
|
| 192 |
</span><span id="91" class="l"><a class="l" href="#91"> 91: </a>
|
188 |
</span><span id="86" class="l"><a class="l" href="#86"> 86: </a>
|
| 193 |
</span><span id="92" class="l"><a class="l" href="#92"> 92: </a> <span class="php-comment">/**
|
189 |
</span><span id="87" class="l"><a class="l" href="#87"> 87: </a> <span class="php-comment">/**
|
| 194 |
</span></span><span id="93" class="l"><a class="l" href="#93"> 93: </a><span class="php-comment"> * Connection à la base de données en utilisant les informations fournies par
|
190 |
</span></span><span id="88" class="l"><a class="l" href="#88"> 88: </a><span class="php-comment"> * Connection à la base de données en utilisant les informations fournies par
|
| 195 |
</span></span><span id="94" class="l"><a class="l" href="#94"> 94: </a><span class="php-comment"> * le fichier de configuration.
|
191 |
</span></span><span id="89" class="l"><a class="l" href="#89"> 89: </a><span class="php-comment"> * le fichier de configuration.
|
| 196 |
</span></span><span id="95" class="l"><a class="l" href="#95"> 95: </a><span class="php-comment"> * private et final car n'a pas vocation a être appelée par l'utilisateur.
|
192 |
</span></span><span id="90" class="l"><a class="l" href="#90"> 90: </a><span class="php-comment"> * private et final car n'a pas vocation a être appelée par l'utilisateur.
|
| 197 |
</span></span><span id="96" class="l"><a class="l" href="#96"> 96: </a><span class="php-comment"> *
|
193 |
</span></span><span id="91" class="l"><a class="l" href="#91"> 91: </a><span class="php-comment"> *
|
| 198 |
</span></span><span id="97" class="l"><a class="l" href="#97"> 97: </a><span class="php-comment"> * @throws Exception une exception dans le cas ou là connexion échoue
|
194 |
</span></span><span id="92" class="l"><a class="l" href="#92"> 92: </a><span class="php-comment"> * @throws Exception une exception dans le cas ou là connexion échoue
|
| 199 |
</span></span><span id="98" class="l"><a class="l" href="#98"> 98: </a><span class="php-comment"> */</span>
|
195 |
</span></span><span id="93" class="l"><a class="l" href="#93"> 93: </a><span class="php-comment"> */</span>
|
| 200 |
</span><span id="99" class="l"><a class="l" href="#99"> 99: </a> <span class="php-keyword1">final</span> <span class="php-keyword1">private</span> <span class="php-keyword1">function</span> <a id="_connecter" href="#_connecter">connecter</a>() {
|
196 |
</span><span id="94" class="l"><a class="l" href="#94"> 94: </a> <span class="php-keyword1">final</span> <span class="php-keyword1">private</span> <span class="php-keyword1">function</span> <a id="_connecter" href="#_connecter">connecter</a>() {
|
| 201 |
</span><span id="100" class="l"><a class="l" href="#100">100: </a> <span class="php-keyword1">switch</span> (<span class="php-var">$this</span>->abstraction) {
|
197 |
</span><span id="95" class="l"><a class="l" href="#95"> 95: </a> <span class="php-keyword1">switch</span> (<span class="php-var">$this</span>->abstraction) {
|
| 202 |
</span><span id="101" class="l"><a class="l" href="#101">101: </a> <span class="php-keyword1">case</span> <span class="php-quote">'pdo'</span>:
|
198 |
</span><span id="96" class="l"><a class="l" href="#96"> 96: </a> <span class="php-keyword1">case</span> <span class="php-quote">'pdo'</span>:
|
| 203 |
</span><span id="102" class="l"><a class="l" href="#102">102: </a> <span class="php-keyword1">try</span> {
|
199 |
</span><span id="97" class="l"><a class="l" href="#97"> 97: </a> <span class="php-keyword1">try</span> {
|
| 204 |
</span><span id="103" class="l"><a class="l" href="#103">103: </a> <span class="php-var">$this</span>->connexion = <span class="php-keyword1">new</span> PDO(<span class="php-var">$this</span>->dsn, <span class="php-var">$this</span>->utilisateur, <span class="php-var">$this</span>->pass);
|
200 |
</span><span id="98" class="l"><a class="l" href="#98"> 98: </a> <span class="php-var">$this</span>->connexion = <span class="php-keyword1">new</span> PDO(<span class="php-var">$this</span>->dsn, <span class="php-var">$this</span>->utilisateur, <span class="php-var">$this</span>->pass);
|
| 205 |
</span><span id="104" class="l"><a class="l" href="#104">104: </a> <span class="php-var">$this</span>->connexion->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
201 |
</span><span id="99" class="l"><a class="l" href="#99"> 99: </a> <span class="php-var">$this</span>->connexion->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
| 206 |
</span><span id="105" class="l"><a class="l" href="#105">105: </a> } <span class="php-keyword1">catch</span> (PDOException <span class="php-var">$e</span>) {
|
202 |
</span><span id="100" class="l"><a class="l" href="#100">100: </a> } <span class="php-keyword1">catch</span> (PDOException <span class="php-var">$e</span>) {
|
| 207 |
</span><span id="106" class="l"><a class="l" href="#106">106: </a> <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> Exception(<span class="php-quote">'Erreur de connexion à la base de données : '</span>.<span class="php-var">$e</span>->getMessage());
|
203 |
</span><span id="101" class="l"><a class="l" href="#101">101: </a> <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> Exception(<span class="php-quote">'Erreur de connexion à la base de données : '</span>.<span class="php-var">$e</span>->getMessage());
|
| 208 |
</span><span id="107" class="l"><a class="l" href="#107">107: </a> }
|
204 |
</span><span id="102" class="l"><a class="l" href="#102">102: </a> }
|
| 209 |
</span><span id="108" class="l"><a class="l" href="#108">108: </a> <span class="php-keyword1">break</span>;
|
205 |
</span><span id="103" class="l"><a class="l" href="#103">103: </a> <span class="php-keyword1">break</span>;
|
| 210 |
</span><span id="109" class="l"><a class="l" href="#109">109: </a>
|
206 |
</span><span id="104" class="l"><a class="l" href="#104">104: </a>
|
| 211 |
</span><span id="110" class="l"><a class="l" href="#110">110: </a> <span class="php-keyword1">case</span> <span class="php-quote">'mysql'</span>:
|
207 |
</span><span id="105" class="l"><a class="l" href="#105">105: </a> <span class="php-keyword1">case</span> <span class="php-quote">'mysql'</span>:
|
| 212 |
</span><span id="111" class="l"><a class="l" href="#111">111: </a> <span class="php-var">$this</span>->connexion = <span class="php-keyword2">mysql_connect</span>(<span class="php-var">$this</span>->hote,<span class="php-var">$this</span>->utilisateur,<span class="php-var">$this</span>->pass);
|
208 |
</span><span id="106" class="l"><a class="l" href="#106">106: </a> <span class="php-var">$this</span>->connexion = <span class="php-keyword2">mysql_connect</span>(<span class="php-var">$this</span>->hote,<span class="php-var">$this</span>->utilisateur,<span class="php-var">$this</span>->pass);
|
| 213 |
</span><span id="112" class="l"><a class="l" href="#112">112: </a> <span class="php-keyword1">if</span> (<span class="php-var">$this</span>->connexion != <span class="php-keyword1">null</span>) {
|
209 |
</span><span id="107" class="l"><a class="l" href="#107">107: </a> <span class="php-keyword1">if</span> (<span class="php-var">$this</span>->connexion != <span class="php-keyword1">null</span>) {
|
| 214 |
</span><span id="113" class="l"><a class="l" href="#113">113: </a> <span class="php-keyword2">mysql_select_db</span>(<span class="php-var">$this</span>->bdd_nom, <span class="php-var">$this</span>->connexion);
|
210 |
</span><span id="108" class="l"><a class="l" href="#108">108: </a> <span class="php-keyword2">mysql_select_db</span>(<span class="php-var">$this</span>->bdd_nom, <span class="php-var">$this</span>->connexion);
|
| 215 |
</span><span id="114" class="l"><a class="l" href="#114">114: </a> } <span class="php-keyword1">else</span> {
|
211 |
</span><span id="109" class="l"><a class="l" href="#109">109: </a> } <span class="php-keyword1">else</span> {
|
| 216 |
</span><span id="115" class="l"><a class="l" href="#115">115: </a> <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> Exception(<span class="php-quote">'Erreur de connexion à la base de données, vérifiez les paramètres du fichier de configuration'</span>);
|
212 |
</span><span id="110" class="l"><a class="l" href="#110">110: </a> <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> Exception(<span class="php-quote">'Erreur de connexion à la base de données, vérifiez les paramètres du fichier de configuration'</span>);
|
| 217 |
</span><span id="116" class="l"><a class="l" href="#116">116: </a> }
|
213 |
</span><span id="111" class="l"><a class="l" href="#111">111: </a> }
|
| 218 |
</span><span id="117" class="l"><a class="l" href="#117">117: </a> <span class="php-keyword1">break</span>;
|
214 |
</span><span id="112" class="l"><a class="l" href="#112">112: </a> <span class="php-keyword1">break</span>;
|
| 219 |
</span><span id="118" class="l"><a class="l" href="#118">118: </a>
|
215 |
</span><span id="113" class="l"><a class="l" href="#113">113: </a>
|
| 220 |
</span><span id="119" class="l"><a class="l" href="#119">119: </a> <span class="php-keyword1">case</span> <span class="php-quote">'mysqli'</span>:
|
216 |
</span><span id="114" class="l"><a class="l" href="#114">114: </a> <span class="php-keyword1">case</span> <span class="php-quote">'mysqli'</span>:
|
| 221 |
</span><span id="120" class="l"><a class="l" href="#120">120: </a> <span class="php-var">$this</span>->connexion = <span class="php-keyword1">new</span> mysqli(<span class="php-var">$this</span>->hote,<span class="php-var">$this</span>->utilisateur,<span class="php-var">$this</span>->pass, <span class="php-var">$this</span>->bdd_nom);
|
217 |
</span><span id="115" class="l"><a class="l" href="#115">115: </a> <span class="php-var">$this</span>->connexion = <span class="php-keyword1">new</span> mysqli(<span class="php-var">$this</span>->hote,<span class="php-var">$this</span>->utilisateur,<span class="php-var">$this</span>->pass, <span class="php-var">$this</span>->bdd_nom);
|
| 222 |
</span><span id="121" class="l"><a class="l" href="#121">121: </a> <span class="php-keyword1">if</span> (!<span class="php-var">$this</span>->connexion) {
|
218 |
</span><span id="116" class="l"><a class="l" href="#116">116: </a> <span class="php-keyword1">if</span> (!<span class="php-var">$this</span>->connexion) {
|
| 223 |
</span><span id="122" class="l"><a class="l" href="#122">122: </a> <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> Exception(<span class="php-quote">'Erreur de connexion à la base de données, vérifiez les paramètres du fichier de configuration'</span>);
|
219 |
</span><span id="117" class="l"><a class="l" href="#117">117: </a> <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> Exception(<span class="php-quote">'Erreur de connexion à la base de données, vérifiez les paramètres du fichier de configuration'</span>);
|
| 224 |
</span><span id="123" class="l"><a class="l" href="#123">123: </a> <span class="php-keyword1">return</span>;
|
220 |
</span><span id="118" class="l"><a class="l" href="#118">118: </a> <span class="php-keyword1">return</span>;
|
| 225 |
</span><span id="124" class="l"><a class="l" href="#124">124: </a> }
|
221 |
</span><span id="119" class="l"><a class="l" href="#119">119: </a> }
|
| 226 |
</span><span id="125" class="l"><a class="l" href="#125">125: </a> <span class="php-keyword1">break</span>;
|
222 |
</span><span id="120" class="l"><a class="l" href="#120">120: </a> <span class="php-keyword1">break</span>;
|
| 227 |
</span><span id="126" class="l"><a class="l" href="#126">126: </a>
|
223 |
</span><span id="121" class="l"><a class="l" href="#121">121: </a>
|
| 228 |
</span><span id="127" class="l"><a class="l" href="#127">127: </a> <span class="php-keyword1">case</span> <span class="php-quote">'sqlite3'</span>:
|
224 |
</span><span id="122" class="l"><a class="l" href="#122">122: </a> <span class="php-keyword1">case</span> <span class="php-quote">'sqlite3'</span>:
|
| 229 |
</span><span id="128" class="l"><a class="l" href="#128">128: </a> <span class="php-comment">// cas particulier de sqllite, on considère que le nom de la base de données correspond au fichier à ouvrir</span>
|
225 |
</span><span id="123" class="l"><a class="l" href="#123">123: </a> <span class="php-comment">// cas particulier de sqllite, on considère que le nom de la base de données correspond au fichier à ouvrir</span>
|
| 230 |
</span><span id="129" class="l"><a class="l" href="#129">129: </a> <span class="php-var">$this</span>->connexion = <span class="php-keyword1">new</span> SQLite3(<span class="php-var">$this</span>->bdd_nom);
|
226 |
</span><span id="124" class="l"><a class="l" href="#124">124: </a> <span class="php-var">$this</span>->connexion = <span class="php-keyword1">new</span> SQLite3(<span class="php-var">$this</span>->bdd_nom);
|
| 231 |
</span><span id="130" class="l"><a class="l" href="#130">130: </a> <span class="php-keyword1">if</span> (!<span class="php-var">$this</span>->connexion) {
|
227 |
</span><span id="125" class="l"><a class="l" href="#125">125: </a> <span class="php-keyword1">if</span> (!<span class="php-var">$this</span>->connexion) {
|
| 232 |
</span><span id="131" class="l"><a class="l" href="#131">131: </a> <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> Exception(<span class="php-quote">'Erreur de connexion à la base de données, vérifiez les paramètres du fichier de configuration'</span>);
|
228 |
</span><span id="126" class="l"><a class="l" href="#126">126: </a> <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> Exception(<span class="php-quote">'Erreur de connexion à la base de données, vérifiez les paramètres du fichier de configuration'</span>);
|
| 233 |
</span><span id="132" class="l"><a class="l" href="#132">132: </a> <span class="php-keyword1">return</span>;
|
229 |
</span><span id="127" class="l"><a class="l" href="#127">127: </a> <span class="php-keyword1">return</span>;
|
| 234 |
</span><span id="133" class="l"><a class="l" href="#133">133: </a> }
|
230 |
</span><span id="128" class="l"><a class="l" href="#128">128: </a> }
|
| 235 |
</span><span id="134" class="l"><a class="l" href="#134">134: </a> <span class="php-keyword1">break</span>;
|
231 |
</span><span id="129" class="l"><a class="l" href="#129">129: </a> <span class="php-keyword1">break</span>;
|
| 236 |
</span><span id="135" class="l"><a class="l" href="#135">135: </a>
|
232 |
</span><span id="130" class="l"><a class="l" href="#130">130: </a>
|
| 237 |
</span><span id="136" class="l"><a class="l" href="#136">136: </a> <span class="php-keyword1">default</span>:
|
233 |
</span><span id="131" class="l"><a class="l" href="#131">131: </a> <span class="php-keyword1">default</span>:
|
| - |
|
234 |
</span><span id="132" class="l"><a class="l" href="#132">132: </a> <span class="php-var">$this</span>->connexion = <span class="php-keyword1">null</span>;
|
| - |
|
235 |
</span><span id="133" class="l"><a class="l" href="#133">133: </a> }
|
| - |
|
236 |
</span><span id="134" class="l"><a class="l" href="#134">134: </a>
|
| - |
|
237 |
</span><span id="135" class="l"><a class="l" href="#135">135: </a> <span class="php-keyword1">if</span> (<span class="php-var">$this</span>->encodage != <span class="php-keyword1">null</span>) {
|
| 238 |
</span><span id="137" class="l"><a class="l" href="#137">137: </a> <span class="php-var">$this</span>->connexion = <span class="php-keyword1">null</span>;
|
238 |
</span><span id="136" class="l"><a class="l" href="#136">136: </a> <span class="php-var">$this</span>->requete(<span class="php-quote">"SET names '"</span>.<span class="php-var">$this</span>->encodage.<span class="php-quote">"'"</span>);
|
| - |
|
239 |
</span><span id="137" class="l"><a class="l" href="#137">137: </a> }
|
| 239 |
</span><span id="138" class="l"><a class="l" href="#138">138: </a> }
|
240 |
</span><span id="138" class="l"><a class="l" href="#138">138: </a> }
|
| 240 |
</span><span id="139" class="l"><a class="l" href="#139">139: </a>
|
- |
|
| 241 |
</span><span id="140" class="l"><a class="l" href="#140">140: </a> <span class="php-keyword1">if</span> (<span class="php-var">$this</span>->encodage != <span class="php-keyword1">null</span>) {
|
- |
|
| 242 |
</span><span id="141" class="l"><a class="l" href="#141">141: </a> <span class="php-var">$this</span>->requete(<span class="php-quote">"SET names '"</span>.<span class="php-var">$this</span>->encodage.<span class="php-quote">"'"</span>);
|
- |
|
| 243 |
</span><span id="142" class="l"><a class="l" href="#142">142: </a> }
|
- |
|
| 244 |
</span><span id="143" class="l"><a class="l" href="#143">143: </a> }
|
- |
|
| 245 |
</span><span id="144" class="l"><a class="l" href="#144">144: </a>
|
241 |
</span><span id="139" class="l"><a class="l" href="#139">139: </a>
|
| 246 |
</span><span id="145" class="l"><a class="l" href="#145">145: </a> <span class="php-comment">/**
|
242 |
</span><span id="140" class="l"><a class="l" href="#140">140: </a> <span class="php-comment">/**
|
| 247 |
</span></span><span id="146" class="l"><a class="l" href="#146">146: </a><span class="php-comment"> * Fonction qui appelle la bonne fonction pour executer une requête suivant le type de bdd.
|
243 |
</span></span><span id="141" class="l"><a class="l" href="#141">141: </a><span class="php-comment"> * Fonction qui appelle la bonne fonction pour executer une requête suivant le type de bdd.
|
| 248 |
</span></span><span id="147" class="l"><a class="l" href="#147">147: </a><span class="php-comment"> *
|
244 |
</span></span><span id="142" class="l"><a class="l" href="#142">142: </a><span class="php-comment"> *
|
| 249 |
</span></span><span id="148" class="l"><a class="l" href="#148">148: </a><span class="php-comment"> * @param string la requete à effectuer
|
245 |
</span></span><span id="143" class="l"><a class="l" href="#143">143: </a><span class="php-comment"> * @param string la requete à effectuer
|
| 250 |
</span></span><span id="149" class="l"><a class="l" href="#149">149: </a><span class="php-comment"> * @return PDOStatement un objet contenant le résultat de la requête
|
246 |
</span></span><span id="144" class="l"><a class="l" href="#144">144: </a><span class="php-comment"> * @return PDOStatement un objet contenant le résultat de la requête
|
| 251 |
</span></span><span id="150" class="l"><a class="l" href="#150">150: </a><span class="php-comment"> */</span>
|
247 |
</span></span><span id="145" class="l"><a class="l" href="#145">145: </a><span class="php-comment"> */</span>
|
| 252 |
</span><span id="151" class="l"><a class="l" href="#151">151: </a> <span class="php-keyword1">final</span> <span class="php-keyword1">protected</span> <span class="php-keyword1">function</span> <a id="_requete" href="#_requete">requete</a>(<span class="php-var">$requete</span>) {
|
248 |
</span><span id="146" class="l"><a class="l" href="#146">146: </a> <span class="php-keyword1">final</span> <span class="php-keyword1">protected</span> <span class="php-keyword1">function</span> <a id="_requete" href="#_requete">requete</a>(<span class="php-var">$requete</span>) {
|
| 253 |
</span><span id="152" class="l"><a class="l" href="#152">152: </a> <span class="php-comment">// on ne se connecte que lors du premier appel à une requete (lazy connexion)</span>
|
249 |
</span><span id="147" class="l"><a class="l" href="#147">147: </a> <span class="php-comment">// on ne se connecte que lors du premier appel à une requete (lazy connexion)</span>
|
| 254 |
</span><span id="153" class="l"><a class="l" href="#153">153: </a> <span class="php-keyword1">if</span> (<span class="php-var">$this</span>->connexion == <span class="php-keyword1">null</span>) {
|
250 |
</span><span id="148" class="l"><a class="l" href="#148">148: </a> <span class="php-keyword1">if</span> (<span class="php-var">$this</span>->connexion == <span class="php-keyword1">null</span>) {
|
| 255 |
</span><span id="154" class="l"><a class="l" href="#154">154: </a> <span class="php-var">$this</span>->connecter();
|
251 |
</span><span id="149" class="l"><a class="l" href="#149">149: </a> <span class="php-var">$this</span>->connecter();
|
| 256 |
</span><span id="155" class="l"><a class="l" href="#155">155: </a> }
|
252 |
</span><span id="150" class="l"><a class="l" href="#150">150: </a> }
|
| 257 |
</span><span id="156" class="l"><a class="l" href="#156">156: </a>
|
253 |
</span><span id="151" class="l"><a class="l" href="#151">151: </a>
|
| 258 |
</span><span id="157" class="l"><a class="l" href="#157">157: </a> <span class="php-var">$retour</span> = <span class="php-keyword1">null</span>;
|
254 |
</span><span id="152" class="l"><a class="l" href="#152">152: </a> <span class="php-var">$retour</span> = <span class="php-keyword1">null</span>;
|
| 259 |
</span><span id="158" class="l"><a class="l" href="#158">158: </a>
|
255 |
</span><span id="153" class="l"><a class="l" href="#153">153: </a>
|
| 260 |
</span><span id="159" class="l"><a class="l" href="#159">159: </a> <span class="php-keyword1">switch</span> (<span class="php-var">$this</span>->abstraction) {
|
256 |
</span><span id="154" class="l"><a class="l" href="#154">154: </a> <span class="php-keyword1">switch</span> (<span class="php-var">$this</span>->abstraction) {
|
| 261 |
</span><span id="160" class="l"><a class="l" href="#160">160: </a> <span class="php-keyword1">case</span> <span class="php-quote">'pdo'</span>:
|
257 |
</span><span id="155" class="l"><a class="l" href="#155">155: </a> <span class="php-keyword1">case</span> <span class="php-quote">'pdo'</span>:
|
| 262 |
</span><span id="161" class="l"><a class="l" href="#161">161: </a> <span class="php-var">$retour</span> = <span class="php-var">$this</span>->connexion->query(<span class="php-var">$requete</span>);
|
258 |
</span><span id="156" class="l"><a class="l" href="#156">156: </a> <span class="php-var">$retour</span> = <span class="php-var">$this</span>->connexion->query(<span class="php-var">$requete</span>);
|
| 263 |
</span><span id="162" class="l"><a class="l" href="#162">162: </a> <span class="php-keyword1">break</span>;
|
259 |
</span><span id="157" class="l"><a class="l" href="#157">157: </a> <span class="php-keyword1">break</span>;
|
| 264 |
</span><span id="163" class="l"><a class="l" href="#163">163: </a> <span class="php-keyword1">case</span> <span class="php-quote">'mysql'</span>:
|
260 |
</span><span id="158" class="l"><a class="l" href="#158">158: </a> <span class="php-keyword1">case</span> <span class="php-quote">'mysql'</span>:
|
| 265 |
</span><span id="164" class="l"><a class="l" href="#164">164: </a> <span class="php-var">$retour</span> = <span class="php-keyword2">mysql_query</span>(<span class="php-var">$requete</span>,<span class="php-var">$this</span>->connexion);
|
261 |
</span><span id="159" class="l"><a class="l" href="#159">159: </a> <span class="php-var">$retour</span> = <span class="php-keyword2">mysql_query</span>(<span class="php-var">$requete</span>,<span class="php-var">$this</span>->connexion);
|
| 266 |
</span><span id="165" class="l"><a class="l" href="#165">165: </a> <span class="php-keyword1">break</span>;
|
262 |
</span><span id="160" class="l"><a class="l" href="#160">160: </a> <span class="php-keyword1">break</span>;
|
| 267 |
</span><span id="166" class="l"><a class="l" href="#166">166: </a> <span class="php-keyword1">case</span> <span class="php-quote">'mysqli'</span>:
|
263 |
</span><span id="161" class="l"><a class="l" href="#161">161: </a> <span class="php-keyword1">case</span> <span class="php-quote">'mysqli'</span>:
|
| 268 |
</span><span id="167" class="l"><a class="l" href="#167">167: </a> <span class="php-var">$retour</span> = <span class="php-var">$this</span>->connexion->query(<span class="php-var">$requete</span>);
|
264 |
</span><span id="162" class="l"><a class="l" href="#162">162: </a> <span class="php-var">$retour</span> = <span class="php-var">$this</span>->connexion->query(<span class="php-var">$requete</span>);
|
| 269 |
</span><span id="168" class="l"><a class="l" href="#168">168: </a> <span class="php-keyword1">break</span>;
|
265 |
</span><span id="163" class="l"><a class="l" href="#163">163: </a> <span class="php-keyword1">break</span>;
|
| 270 |
</span><span id="169" class="l"><a class="l" href="#169">169: </a> <span class="php-keyword1">case</span> <span class="php-quote">'sqlite3'</span>:
|
266 |
</span><span id="164" class="l"><a class="l" href="#164">164: </a> <span class="php-keyword1">case</span> <span class="php-quote">'sqlite3'</span>:
|
| 271 |
</span><span id="170" class="l"><a class="l" href="#170">170: </a> <span class="php-var">$retour</span> = <span class="php-var">$this</span>->connexion-><span class="php-keyword2">exec</span>(<span class="php-var">$requete</span>);
|
267 |
</span><span id="165" class="l"><a class="l" href="#165">165: </a> <span class="php-var">$retour</span> = <span class="php-var">$this</span>->connexion-><span class="php-keyword2">exec</span>(<span class="php-var">$requete</span>);
|
| 272 |
</span><span id="171" class="l"><a class="l" href="#171">171: </a> <span class="php-keyword1">break</span>;
|
268 |
</span><span id="166" class="l"><a class="l" href="#166">166: </a> <span class="php-keyword1">break</span>;
|
| 273 |
</span><span id="172" class="l"><a class="l" href="#172">172: </a> }
|
269 |
</span><span id="167" class="l"><a class="l" href="#167">167: </a> }
|
| 274 |
</span><span id="173" class="l"><a class="l" href="#173">173: </a>
|
270 |
</span><span id="168" class="l"><a class="l" href="#168">168: </a>
|
| 275 |
</span><span id="174" class="l"><a class="l" href="#174">174: </a> <span class="php-keyword1">return</span> <span class="php-var">$retour</span>;
|
271 |
</span><span id="169" class="l"><a class="l" href="#169">169: </a> <span class="php-keyword1">return</span> <span class="php-var">$retour</span>;
|
| 276 |
</span><span id="175" class="l"><a class="l" href="#175">175: </a> }
|
272 |
</span><span id="170" class="l"><a class="l" href="#170">170: </a> }
|
| 277 |
</span><span id="176" class="l"><a class="l" href="#176">176: </a>
|
273 |
</span><span id="171" class="l"><a class="l" href="#171">171: </a>
|
| 278 |
</span><span id="177" class="l"><a class="l" href="#177">177: </a> <span class="php-keyword1">final</span> <span class="php-keyword1">protected</span> <span class="php-keyword1">function</span> <a id="_requeteUn" href="#_requeteUn">requeteUn</a>(<span class="php-var">$requete</span>,<span class="php-var">$mode</span> = <span class="php-quote">'ASSOC'</span>) {
|
274 |
</span><span id="172" class="l"><a class="l" href="#172">172: </a> <span class="php-keyword1">final</span> <span class="php-keyword1">protected</span> <span class="php-keyword1">function</span> <a id="_requeteUn" href="#_requeteUn">requeteUn</a>(<span class="php-var">$requete</span>,<span class="php-var">$mode</span> = <span class="php-quote">'ASSOC'</span>) {
|
| 279 |
</span><span id="178" class="l"><a class="l" href="#178">178: </a> <span class="php-comment">// Connection seulement lors du premier appel à une requete (lazy connexion)</span>
|
275 |
</span><span id="173" class="l"><a class="l" href="#173">173: </a> <span class="php-comment">// Connection seulement lors du premier appel à une requete (lazy connexion)</span>
|
| 280 |
</span><span id="179" class="l"><a class="l" href="#179">179: </a> <span class="php-keyword1">if</span> (<span class="php-var">$this</span>->connexion == <span class="php-keyword1">null</span>) {
|
276 |
</span><span id="174" class="l"><a class="l" href="#174">174: </a> <span class="php-keyword1">if</span> (<span class="php-var">$this</span>->connexion == <span class="php-keyword1">null</span>) {
|
| 281 |
</span><span id="180" class="l"><a class="l" href="#180">180: </a> <span class="php-var">$this</span>->connecter();
|
277 |
</span><span id="175" class="l"><a class="l" href="#175">175: </a> <span class="php-var">$this</span>->connecter();
|
| 282 |
</span><span id="181" class="l"><a class="l" href="#181">181: </a> }
|
278 |
</span><span id="176" class="l"><a class="l" href="#176">176: </a> }
|
| 283 |
</span><span id="182" class="l"><a class="l" href="#182">182: </a>
|
279 |
</span><span id="177" class="l"><a class="l" href="#177">177: </a>
|
| 284 |
</span><span id="183" class="l"><a class="l" href="#183">183: </a> <span class="php-var">$retour</span> = <span class="php-keyword1">null</span>;
|
280 |
</span><span id="178" class="l"><a class="l" href="#178">178: </a> <span class="php-var">$retour</span> = <span class="php-keyword1">null</span>;
|
| 285 |
</span><span id="184" class="l"><a class="l" href="#184">184: </a> <span class="php-keyword1">switch</span> (<span class="php-var">$this</span>->abstraction) {
|
281 |
</span><span id="179" class="l"><a class="l" href="#179">179: </a> <span class="php-keyword1">switch</span> (<span class="php-var">$this</span>->abstraction) {
|
| 286 |
</span><span id="185" class="l"><a class="l" href="#185">185: </a> <span class="php-keyword1">case</span> <span class="php-quote">'pdo'</span>:
|
282 |
</span><span id="180" class="l"><a class="l" href="#180">180: </a> <span class="php-keyword1">case</span> <span class="php-quote">'pdo'</span>:
|
| 287 |
</span><span id="186" class="l"><a class="l" href="#186">186: </a> <span class="php-keyword1">try</span> {
|
283 |
</span><span id="181" class="l"><a class="l" href="#181">181: </a> <span class="php-keyword1">try</span> {
|
| 288 |
</span><span id="187" class="l"><a class="l" href="#187">187: </a> <span class="php-var">$res_req</span> = <span class="php-var">$this</span>->connexion->query(<span class="php-var">$requete</span>);
|
284 |
</span><span id="182" class="l"><a class="l" href="#182">182: </a> <span class="php-var">$res_req</span> = <span class="php-var">$this</span>->connexion->query(<span class="php-var">$requete</span>);
|
| 289 |
</span><span id="188" class="l"><a class="l" href="#188">188: </a> <span class="php-var">$retour</span> = (<span class="php-var">$res_req</span> !== <span class="php-keyword1">false</span>) ? <span class="php-var">$res_req</span>->fetch(<span class="php-var">$this</span>-><span class="php-var">$mode</span>) : <span class="php-var">$res_req</span>;
|
285 |
</span><span id="183" class="l"><a class="l" href="#183">183: </a> <span class="php-var">$retour</span> = (<span class="php-var">$res_req</span> !== <span class="php-keyword1">false</span>) ? <span class="php-var">$res_req</span>->fetch(<span class="php-var">$this</span>-><span class="php-var">$mode</span>) : <span class="php-var">$res_req</span>;
|
| 290 |
</span><span id="189" class="l"><a class="l" href="#189">189: </a> } <span class="php-keyword1">catch</span> (PDOException <span class="php-var">$e</span>) {
|
286 |
</span><span id="184" class="l"><a class="l" href="#184">184: </a> } <span class="php-keyword1">catch</span> (PDOException <span class="php-var">$e</span>) {
|
| 291 |
</span><span id="190" class="l"><a class="l" href="#190">190: </a> <span class="php-var">$message</span> = <span class="php-quote">'Requête echec. Fichier : "%s". Ligne : "%s". Message : %s'</span>;
|
287 |
</span><span id="185" class="l"><a class="l" href="#185">185: </a> <span class="php-var">$message</span> = <span class="php-quote">'Requête echec. Fichier : "%s". Ligne : "%s". Message : %s'</span>;
|
| 292 |
</span><span id="191" class="l"><a class="l" href="#191">191: </a> <span class="php-keyword2">trigger_error</span>(<span class="php-keyword2">sprintf</span>(<span class="php-var">$message</span>, <span class="php-var">$e</span>->getFile(), <span class="php-var">$e</span>->getLine(), <span class="php-var">$e</span>->getMessage()), E_USER_WARNING);
|
288 |
</span><span id="186" class="l"><a class="l" href="#186">186: </a> <span class="php-keyword2">trigger_error</span>(<span class="php-keyword2">sprintf</span>(<span class="php-var">$message</span>, <span class="php-var">$e</span>->getFile(), <span class="php-var">$e</span>->getLine(), <span class="php-var">$e</span>->getMessage()), E_USER_WARNING);
|
| - |
|
289 |
</span><span id="187" class="l"><a class="l" href="#187">187: </a> }
|
| - |
|
290 |
</span><span id="188" class="l"><a class="l" href="#188">188: </a> <span class="php-keyword1">break</span>;
|
| - |
|
291 |
</span><span id="189" class="l"><a class="l" href="#189">189: </a> <span class="php-keyword1">case</span> <span class="php-quote">'mysql'</span>:
|
| - |
|
292 |
</span><span id="190" class="l"><a class="l" href="#190">190: </a> <span class="php-var">$res</span> = <span class="php-keyword2">mysql_query</span>(<span class="php-var">$requete</span>,<span class="php-var">$this</span>->connexion);
|
| - |
|
293 |
</span><span id="191" class="l"><a class="l" href="#191">191: </a> <span class="php-var">$fonction_fetch</span> = <span class="php-var">$this</span>-><span class="php-var">$mode</span>;
|
| 293 |
</span><span id="192" class="l"><a class="l" href="#192">192: </a> }
|
294 |
</span><span id="192" class="l"><a class="l" href="#192">192: </a> <span class="php-var">$retour</span> = <span class="php-var">$fonction_fetch</span>(<span class="php-var">$res</span>);
|
| 294 |
</span><span id="193" class="l"><a class="l" href="#193">193: </a> <span class="php-keyword1">break</span>;
|
295 |
</span><span id="193" class="l"><a class="l" href="#193">193: </a> <span class="php-keyword1">break</span>;
|
| 295 |
</span><span id="194" class="l"><a class="l" href="#194">194: </a> <span class="php-keyword1">case</span> <span class="php-quote">'mysql'</span>:
|
296 |
</span><span id="194" class="l"><a class="l" href="#194">194: </a> <span class="php-keyword1">case</span> <span class="php-quote">'mysqli'</span>:
|
| 296 |
</span><span id="195" class="l"><a class="l" href="#195">195: </a> <span class="php-var">$res</span> = <span class="php-keyword2">mysql_query</span>(<span class="php-var">$requete</span>,<span class="php-var">$this</span>->connexion);
|
297 |
</span><span id="195" class="l"><a class="l" href="#195">195: </a> <span class="php-var">$res</span> = <span class="php-var">$this</span>->connexion->query(<span class="php-var">$requete</span>);
|
| 297 |
</span><span id="196" class="l"><a class="l" href="#196">196: </a> <span class="php-var">$fonction_fetch</span> = <span class="php-var">$this</span>-><span class="php-var">$mode</span>;
|
298 |
</span><span id="196" class="l"><a class="l" href="#196">196: </a> <span class="php-var">$fonction_fetch</span> = <span class="php-var">$this</span>-><span class="php-var">$mode</span>;
|
| 298 |
</span><span id="197" class="l"><a class="l" href="#197">197: </a> <span class="php-var">$retour</span> = <span class="php-var">$fonction_fetch</span>(<span class="php-var">$res</span>);
|
299 |
</span><span id="197" class="l"><a class="l" href="#197">197: </a> <span class="php-var">$retour</span> = <span class="php-var">$res</span>-><span class="php-var">$fonction_fetch</span>();
|
| Line 448... |
Line 444... |
| 448 |
</span><span id="347" class="l"><a class="l" href="#347">347: </a></span><span class="xlang">?></span></code></pre>
|
444 |
</span><span id="342" class="l"><a class="l" href="#342">342: </a></span><span class="xlang">?></span></code></pre>
|
| 449 |
|
445 |
|
| 450 |
<div id="footer">
|
446 |
<div id="footer">
|
| 451 |
TBFramework - v0.2 API documentation generated by <a href="http://apigen.org">ApiGen 2.8.0</a>
|
447 |
TBFramework - v0.2 API documentation generated by <a href="http://apigen.org">ApiGen 2.8.0</a>
|