Subversion Repositories Applications.framework

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
464 jpm 1
<!DOCTYPE html>
2
<html>
3
<head>
4
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
5
	<meta name="generator" content="ApiGen 2.8.0">
6
	<meta name="robots" content="noindex">
7
 
8
	<title>File framework/Bdd.php | TBFramework - v0.4</title>
9
 
10
	<script type="text/javascript" src="resources/combined.js?4205936287"></script>
11
	<script type="text/javascript" src="elementlist.js?1964084359"></script>
12
	<link rel="stylesheet" type="text/css" media="all" href="resources/style.css?3505392360">
13
 
14
</head>
15
 
16
<body>
17
<div id="left">
18
	<div id="menu">
19
		<a href="index.html" title="Overview"><span>Overview</span></a>
20
 
21
 
22
		<div id="groups">
23
			<h3>Packages</h3>
24
			<ul>
25
				<li class="active"><a href="package-Framework.html">Framework</a>
26
						</li>
27
				<li><a href="package-None.html">None</a>
28
						</li>
29
				<li><a href="package-PHP.html">PHP</a>
30
						</li>
31
				<li><a href="package-Utilitaire.html">Utilitaire</a>
32
						</li>
33
			</ul>
34
		</div>
35
 
36
		<hr>
37
 
38
 
39
		<div id="elements">
40
			<h3>Classes</h3>
41
			<ul>
42
				<li class="active"><a href="class-Bdd.html">Bdd</a></li>
43
				<li><a href="class-Cache.html">Cache</a></li>
44
				<li><a href="class-CacheSimple.html">CacheSimple</a></li>
45
				<li><a href="class-Chronometre.html">Chronometre</a></li>
46
				<li><a href="class-Cli.html">Cli</a></li>
47
				<li><a href="class-Config.html">Config</a></li>
48
				<li><a href="class-Controleur.html">Controleur</a></li>
49
				<li><a href="class-Debug.html">Debug</a></li>
50
				<li><a href="class-Framework.html">Framework</a></li>
51
				<li><a href="class-GestionnaireException.html">GestionnaireException</a></li>
52
				<li><a href="class-I18n.html">I18n</a></li>
53
				<li><a href="class-Log.html">Log</a></li>
54
				<li><a href="class-MonService.html">MonService</a></li>
55
				<li><a href="class-Registre.html">Registre</a></li>
56
				<li><a href="class-RestClient.html">RestClient</a></li>
57
				<li><a href="class-RestServeur.html">RestServeur</a></li>
58
				<li><a href="class-RestService.html">RestService</a></li>
59
				<li><a href="class-Script.html">Script</a></li>
60
				<li><a href="class-ServiceCacheFichier.html">ServiceCacheFichier</a></li>
61
				<li><a href="class-ServiceCacheSimple.html">ServiceCacheSimple</a></li>
62
				<li><a href="class-ServiceCacheSqlite.html">ServiceCacheSqlite</a></li>
63
				<li><a href="class-SquelettePhp.html">SquelettePhp</a></li>
64
				<li><a href="class-Url.html">Url</a></li>
65
			</ul>
66
 
67
 
68
 
69
 
70
 
71
		</div>
72
	</div>
73
</div>
74
 
75
<div id="splitter"></div>
76
 
77
<div id="right">
78
<div id="rightInner">
79
	<form id="search">
80
		<input type="hidden" name="cx" value="">
81
		<input type="hidden" name="ie" value="UTF-8">
82
		<input type="text" name="q" class="text">
83
		<input type="submit" value="Search">
84
	</form>
85
 
86
	<div id="navigation">
87
		<ul>
88
			<li>
89
				<a href="index.html" title="Overview"><span>Overview</span></a>
90
			</li>
91
			<li>
92
				<a href="package-Framework.html" title="Summary of Framework"><span>Package</span></a>
93
			</li>
94
			<li>
95
				<a href="class-Bdd.html" title="Summary of Bdd"><span>Class</span></a>
96
			</li>
97
		</ul>
98
		<ul>
99
			<li>
100
				<a href="tree.html" title="Tree view of classes, interfaces, traits and exceptions"><span>Tree</span></a>
101
			</li>
102
			<li>
103
				<a href="deprecated.html" title="List of deprecated elements"><span>Deprecated</span></a>
104
			</li>
105
			<li>
106
				<a href="todo.html" title="Todo list"><span>Todo</span></a>
107
			</li>
108
		</ul>
109
		<ul>
110
		</ul>
111
	</div>
112
 
113
<pre><code><span id="1" class="l"><a class="l" href="#1">  1: </a><span class="xlang">&lt;?php</span>
114
</span><span id="2" class="l"><a class="l" href="#2">  2: </a><span class="php-comment">// declare(encoding='UTF-8');</span>
115
</span><span id="3" class="l"><a class="l" href="#3">  3: </a><span class="php-comment">/**
116
</span></span><span id="4" class="l"><a class="l" href="#4">  4: </a><span class="php-comment"> * Classe Bdd, d'accés au base de données.
117
</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 diverses possibilités d'accès aux
118
</span></span><span id="6" class="l"><a class="l" href="#6">  6: </a><span class="php-comment"> * bases de données (PDO, mysql, mysqli, SQLite3).
119
</span></span><span id="7" class="l"><a class="l" href="#7">  7: </a><span class="php-comment"> * Les valeurs pour le paramètre 'bdd_abstraction' du fichier config.ini sont : pdo, mysql, mysqli, sqlite3
120
</span></span><span id="8" class="l"><a class="l" href="#8">  8: </a><span class="php-comment"> * Vous pouvez aussi utiliser : &quot;php:Bdd::ABSTRACTION_PDO&quot;,&quot;php:Bdd::ABSTRACTION_MYSQL&quot;, &quot;php:Bdd::ABSTRACTION_MYSQLI&quot;,
121
</span></span><span id="9" class="l"><a class="l" href="#9">  9: </a><span class="php-comment"> * &quot;php:Bdd::ABSTRACTION_SQLITE3&quot;.
122
</span></span><span id="10" class="l"><a class="l" href="#10"> 10: </a><span class="php-comment"> * Elle peut être étendue, pour ajouter le support d'autres bases de données où prendre en compte des méthodes spécifique à
123
</span></span><span id="11" class="l"><a class="l" href="#11"> 11: </a><span class="php-comment"> * un type d'abstraction.
124
</span></span><span id="12" class="l"><a class="l" href="#12"> 12: </a><span class="php-comment"> *
125
</span></span><span id="13" class="l"><a class="l" href="#13"> 13: </a><span class="php-comment"> * @category    php 5.2
126
</span></span><span id="14" class="l"><a class="l" href="#14"> 14: </a><span class="php-comment"> * @package Framework
127
</span></span><span id="15" class="l"><a class="l" href="#15"> 15: </a><span class="php-comment"> * @author      Aurélien PERONNET &lt;aurelien@tela-botanica.org&gt;
128
</span></span><span id="16" class="l"><a class="l" href="#16"> 16: </a><span class="php-comment"> * @author      Jean-Pascal MILCENT &lt;jpm@tela-botanica.org&gt;
129
</span></span><span id="17" class="l"><a class="l" href="#17"> 17: </a><span class="php-comment"> * @copyright   Copyright (c) 2010, Tela Botanica (accueil@tela-botanica.org)
130
</span></span><span id="18" class="l"><a class="l" href="#18"> 18: </a><span class="php-comment"> * @license http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt Licence CECILL
131
</span></span><span id="19" class="l"><a class="l" href="#19"> 19: </a><span class="php-comment"> * @license http://www.gnu.org/licenses/gpl.html Licence GNU-GPL
132
</span></span><span id="20" class="l"><a class="l" href="#20"> 20: </a><span class="php-comment"> * @version $Id: Bdd.php 461 2014-03-05 16:13:16Z jpm $
133
</span></span><span id="21" class="l"><a class="l" href="#21"> 21: </a><span class="php-comment"> * @link        /doc/framework/
134
</span></span><span id="22" class="l"><a class="l" href="#22"> 22: </a><span class="php-comment"> */</span>
135
</span><span id="23" class="l"><a class="l" href="#23"> 23: </a><span class="php-keyword1">class</span> <a id="Bdd" href="#Bdd">Bdd</a> {
136
</span><span id="24" class="l"><a class="l" href="#24"> 24: </a>    <span class="php-comment">/** Constante stockant le squelette du message en cas d'erreur de requête sql. */</span>
137
</span><span id="25" class="l"><a class="l" href="#25"> 25: </a>    <span class="php-keyword1">const</span> <a id="ERREUR_REQUETE_TPL" href="#ERREUR_REQUETE_TPL">ERREUR_REQUETE_TPL</a> = <span class="php-quote">'Requête echec.\nFichier : %s.\nLigne : %s.\nMessage : %s.\nRequête : %s'</span>;
138
</span><span id="26" class="l"><a class="l" href="#26"> 26: </a>
139
</span><span id="27" class="l"><a class="l" href="#27"> 27: </a>    <span class="php-comment">/** Constante stockant le squelette du message en cas d'erreur de connexion à la base de données. */</span>
140
</span><span id="28" class="l"><a class="l" href="#28"> 28: </a>    <span class="php-keyword1">const</span> <a id="ERREUR_CONNEXION_TPL" href="#ERREUR_CONNEXION_TPL">ERREUR_CONNEXION_TPL</a> = <span class="php-quote">'Erreur de connexion à la base de données, vérifiez les paramètres du fichier de configuration.\nMessage : %S.'</span>;
141
</span><span id="29" class="l"><a class="l" href="#29"> 29: </a>
142
</span><span id="30" class="l"><a class="l" href="#30"> 30: </a>    <span class="php-comment">/** Constante stockant le squelette du message en cas d'erreur de sélection de la base de données. */</span>
143
</span><span id="31" class="l"><a class="l" href="#31"> 31: </a>    <span class="php-keyword1">const</span> <a id="ERREUR_SELECTION_BDD_TPL" href="#ERREUR_SELECTION_BDD_TPL">ERREUR_SELECTION_BDD_TPL</a> = <span class="php-quote">'Erreur de sélection de la base de données, vérifiez les paramètres du fichier de configuration.\nMessage : %S.'</span>;
144
</span><span id="32" class="l"><a class="l" href="#32"> 32: </a>
145
</span><span id="33" class="l"><a class="l" href="#33"> 33: </a>    <span class="php-comment">/** Constante stockant le code pour l'abstraction de PDO. */</span>
146
</span><span id="34" class="l"><a class="l" href="#34"> 34: </a>    <span class="php-keyword1">const</span> <a id="ABSTRACTION_PDO" href="#ABSTRACTION_PDO">ABSTRACTION_PDO</a> = <span class="php-quote">'pdo'</span>;
147
</span><span id="35" class="l"><a class="l" href="#35"> 35: </a>
148
</span><span id="36" class="l"><a class="l" href="#36"> 36: </a>    <span class="php-comment">/** Constante stockant le code pour l'abstraction de mysql. */</span>
149
</span><span id="37" class="l"><a class="l" href="#37"> 37: </a>    <span class="php-keyword1">const</span> <a id="ABSTRACTION_MYSQL" href="#ABSTRACTION_MYSQL">ABSTRACTION_MYSQL</a> = <span class="php-quote">'mysql'</span>;
150
</span><span id="38" class="l"><a class="l" href="#38"> 38: </a>
151
</span><span id="39" class="l"><a class="l" href="#39"> 39: </a>    <span class="php-comment">/** Constante stockant le code pour l'abstraction de mysqli. */</span>
152
</span><span id="40" class="l"><a class="l" href="#40"> 40: </a>    <span class="php-keyword1">const</span> <a id="ABSTRACTION_MYSQLI" href="#ABSTRACTION_MYSQLI">ABSTRACTION_MYSQLI</a> = <span class="php-quote">'mysqli'</span>;
153
</span><span id="41" class="l"><a class="l" href="#41"> 41: </a>
154
</span><span id="42" class="l"><a class="l" href="#42"> 42: </a>    <span class="php-comment">/** Constante stockant le code pour l'abstraction de SQLite3. */</span>
155
</span><span id="43" class="l"><a class="l" href="#43"> 43: </a>    <span class="php-keyword1">const</span> ABSTRACTION_SQLITE3 = <span class="php-quote">'sqlite3'</span>;
156
</span><span id="44" class="l"><a class="l" href="#44"> 44: </a>
157
</span><span id="45" class="l"><a class="l" href="#45"> 45: </a>    <span class="php-comment">/** Constante stockant le code pour le mode tableau associatif des résultats des requêtes. */</span>
158
</span><span id="46" class="l"><a class="l" href="#46"> 46: </a>    <span class="php-keyword1">const</span> <a id="MODE_ASSOC" href="#MODE_ASSOC">MODE_ASSOC</a> = <span class="php-quote">'ASSOC'</span>;
159
</span><span id="47" class="l"><a class="l" href="#47"> 47: </a>
160
</span><span id="48" class="l"><a class="l" href="#48"> 48: </a>    <span class="php-comment">/** Constante stockant le code pour le mode objet des résultats des requêtes. */</span>
161
</span><span id="49" class="l"><a class="l" href="#49"> 49: </a>    <span class="php-keyword1">const</span> <a id="MODE_OBJET" href="#MODE_OBJET">MODE_OBJET</a> = <span class="php-quote">'OBJECT'</span>;
162
</span><span id="50" class="l"><a class="l" href="#50"> 50: </a>
163
</span><span id="51" class="l"><a class="l" href="#51"> 51: </a>    <span class="php-comment">/** Mode de fetch associatif */</span>
164
</span><span id="52" class="l"><a class="l" href="#52"> 52: </a>    <span class="php-keyword1">protected</span> <span class="php-var"><a id="$ASSOC" href="#$ASSOC">$ASSOC</a></span> = <span class="php-quote">''</span>;
165
</span><span id="53" class="l"><a class="l" href="#53"> 53: </a>
166
</span><span id="54" class="l"><a class="l" href="#54"> 54: </a>    <span class="php-comment">/** Mode de fetch objet */</span>
167
</span><span id="55" class="l"><a class="l" href="#55"> 55: </a>    <span class="php-keyword1">protected</span> <span class="php-var"><a id="$OBJECT" href="#$OBJECT">$OBJECT</a></span> = <span class="php-quote">''</span>;
168
</span><span id="56" class="l"><a class="l" href="#56"> 56: </a>
169
</span><span id="57" class="l"><a class="l" href="#57"> 57: </a>    <span class="php-comment">/** abstraction de base de données utilisée */</span>
170
</span><span id="58" class="l"><a class="l" href="#58"> 58: </a>    <span class="php-keyword1">protected</span> <span class="php-var"><a id="$abstraction" href="#$abstraction">$abstraction</a></span>;
171
</span><span id="59" class="l"><a class="l" href="#59"> 59: </a>
172
</span><span id="60" class="l"><a class="l" href="#60"> 60: </a>    <span class="php-comment">/** DSN pour accéder à la base de données */</span>
173
</span><span id="61" class="l"><a class="l" href="#61"> 61: </a>    <span class="php-keyword1">protected</span> <span class="php-var"><a id="$dsn" href="#$dsn">$dsn</a></span>;
174
</span><span id="62" class="l"><a class="l" href="#62"> 62: </a>
175
</span><span id="63" class="l"><a class="l" href="#63"> 63: </a>    <span class="php-comment">/** Type de base de données (mysql, mysqli, etc ...) */</span>
176
</span><span id="64" class="l"><a class="l" href="#64"> 64: </a>    <span class="php-keyword1">protected</span> <span class="php-var"><a id="$type" href="#$type">$type</a></span>;
177
</span><span id="65" class="l"><a class="l" href="#65"> 65: </a>
178
</span><span id="66" class="l"><a class="l" href="#66"> 66: </a>    <span class="php-comment">/** Hote herbergeant la base de données */</span>
179
</span><span id="67" class="l"><a class="l" href="#67"> 67: </a>    <span class="php-keyword1">protected</span> <span class="php-var"><a id="$hote" href="#$hote">$hote</a></span>;
180
</span><span id="68" class="l"><a class="l" href="#68"> 68: </a>
181
</span><span id="69" class="l"><a class="l" href="#69"> 69: </a>    <span class="php-comment">/** Nom de la base de données à laquelle le modèle doit se connecter */</span>
182
</span><span id="70" class="l"><a class="l" href="#70"> 70: </a>    <span class="php-keyword1">protected</span> <span class="php-var"><a id="$bdd_nom" href="#$bdd_nom">$bdd_nom</a></span>;
183
</span><span id="71" class="l"><a class="l" href="#71"> 71: </a>
184
</span><span id="72" class="l"><a class="l" href="#72"> 72: </a>    <span class="php-comment">/** Nom d'utilisateur */</span>
185
</span><span id="73" class="l"><a class="l" href="#73"> 73: </a>    <span class="php-keyword1">protected</span> <span class="php-var"><a id="$utilisateur" href="#$utilisateur">$utilisateur</a></span>;
186
</span><span id="74" class="l"><a class="l" href="#74"> 74: </a>
187
</span><span id="75" class="l"><a class="l" href="#75"> 75: </a>    <span class="php-comment">/** Mot de passe */</span>
188
</span><span id="76" class="l"><a class="l" href="#76"> 76: </a>    <span class="php-keyword1">protected</span> <span class="php-var"><a id="$pass" href="#$pass">$pass</a></span>;
189
</span><span id="77" class="l"><a class="l" href="#77"> 77: </a>
190
</span><span id="78" class="l"><a class="l" href="#78"> 78: </a>    <span class="php-comment">/** Encodage de la base de données */</span>
191
</span><span id="79" class="l"><a class="l" href="#79"> 79: </a>    <span class="php-keyword1">protected</span> <span class="php-var"><a id="$encodage" href="#$encodage">$encodage</a></span> = <span class="php-keyword1">null</span>;
192
</span><span id="80" class="l"><a class="l" href="#80"> 80: </a>
193
</span><span id="81" class="l"><a class="l" href="#81"> 81: </a>    <span class="php-comment">/** Connexion à la base de données */</span>
194
</span><span id="82" class="l"><a class="l" href="#82"> 82: </a>    <span class="php-keyword1">protected</span> <span class="php-var"><a id="$connexion" href="#$connexion">$connexion</a></span> = <span class="php-keyword1">null</span>;
195
</span><span id="83" class="l"><a class="l" href="#83"> 83: </a>
196
</span><span id="84" class="l"><a class="l" href="#84"> 84: </a>    <span class="php-comment">/** Tableau des noms des paramètres à définir dans le fichier de config car obligatoirement nécessaire à cette classe.*/</span>
197
</span><span id="85" class="l"><a class="l" href="#85"> 85: </a>    <span class="php-keyword1">protected</span> <span class="php-var"><a id="$parametres_obligatoires" href="#$parametres_obligatoires">$parametres_obligatoires</a></span> = <span class="php-keyword1">array</span>(<span class="php-quote">'bdd_abstraction'</span>, <span class="php-quote">'bdd_protocole'</span>, <span class="php-quote">'bdd_serveur'</span>, <span class="php-quote">'bdd_nom'</span>,
198
</span><span id="86" class="l"><a class="l" href="#86"> 86: </a>        <span class="php-quote">'bdd_utilisateur'</span>, <span class="php-quote">'bdd_mot_de_passe'</span>, <span class="php-quote">'bdd_encodage'</span>);
199
</span><span id="87" class="l"><a class="l" href="#87"> 87: </a>
200
</span><span id="88" class="l"><a class="l" href="#88"> 88: </a>    <span class="php-comment">/** Constructeur par défaut, appelé à l'initialisation. */</span>
201
</span><span id="89" class="l"><a class="l" href="#89"> 89: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="___construct" href="#___construct">__construct</a>() {
202
</span><span id="90" class="l"><a class="l" href="#90"> 90: </a>        Config::verifierPresenceParametres(<span class="php-var">$this</span>-&gt;parametres_obligatoires);
203
</span><span id="91" class="l"><a class="l" href="#91"> 91: </a>        <span class="php-var">$this</span>-&gt;abstraction = <span class="php-keyword2">strtolower</span>(Config::get(<span class="php-quote">'bdd_abstraction'</span>));
204
</span><span id="92" class="l"><a class="l" href="#92"> 92: </a>        <span class="php-var">$this</span>-&gt;type = Config::get(<span class="php-quote">'bdd_protocole'</span>);
205
</span><span id="93" class="l"><a class="l" href="#93"> 93: </a>        <span class="php-var">$this</span>-&gt;hote = Config::get(<span class="php-quote">'bdd_serveur'</span>);
206
</span><span id="94" class="l"><a class="l" href="#94"> 94: </a>        <span class="php-var">$this</span>-&gt;bdd_nom = Config::get(<span class="php-quote">'bdd_nom'</span>);
207
</span><span id="95" class="l"><a class="l" href="#95"> 95: </a>        <span class="php-var">$this</span>-&gt;utilisateur = Config::get(<span class="php-quote">'bdd_utilisateur'</span>);
208
</span><span id="96" class="l"><a class="l" href="#96"> 96: </a>        <span class="php-var">$this</span>-&gt;pass = Config::get(<span class="php-quote">'bdd_mot_de_passe'</span>);
209
</span><span id="97" class="l"><a class="l" href="#97"> 97: </a>
210
</span><span id="98" class="l"><a class="l" href="#98"> 98: </a>        <span class="php-var">$this</span>-&gt;encodage = Config::get(<span class="php-quote">'bdd_encodage'</span>);
211
</span><span id="99" class="l"><a class="l" href="#99"> 99: </a>
212
</span><span id="100" class="l"><a class="l" href="#100">100: </a>        <span class="php-keyword1">if</span> (<span class="php-var">$this</span>-&gt;type == <span class="php-quote">'sqlite'</span> || <span class="php-var">$this</span>-&gt;type == <span class="php-quote">'sqlite2'</span>) {
213
</span><span id="101" class="l"><a class="l" href="#101">101: </a>            <span class="php-var">$this</span>-&gt;dsn = <span class="php-var">$this</span>-&gt;type.<span class="php-quote">':'</span>.<span class="php-var">$this</span>-&gt;hote;
214
</span><span id="102" class="l"><a class="l" href="#102">102: </a>        } <span class="php-keyword1">else</span> {
215
</span><span id="103" class="l"><a class="l" href="#103">103: </a>            <span class="php-var">$this</span>-&gt;dsn = <span class="php-var">$this</span>-&gt;type.<span class="php-quote">':dbname='</span>.<span class="php-var">$this</span>-&gt;bdd_nom.<span class="php-quote">';host='</span>.<span class="php-var">$this</span>-&gt;hote;
216
</span><span id="104" class="l"><a class="l" href="#104">104: </a>        }
217
</span><span id="105" class="l"><a class="l" href="#105">105: </a>        <span class="php-var">$this</span>-&gt;initialiserProtocole();
218
</span><span id="106" class="l"><a class="l" href="#106">106: </a>    }
219
</span><span id="107" class="l"><a class="l" href="#107">107: </a>
220
</span><span id="108" class="l"><a class="l" href="#108">108: </a>    <span class="php-comment">/** Initialise les constantes de classe à leur bonne valeur et déclenche une erreur si le protocole n'est pas bien défini. */</span>
221
</span><span id="109" class="l"><a class="l" href="#109">109: </a>    <span class="php-keyword1">protected</span> <span class="php-keyword1">function</span> <a id="_initialiserProtocole" href="#_initialiserProtocole">initialiserProtocole</a>() {
222
</span><span id="110" class="l"><a class="l" href="#110">110: </a>        <span class="php-keyword1">switch</span> (<span class="php-var">$this</span>-&gt;abstraction) {
223
</span><span id="111" class="l"><a class="l" href="#111">111: </a>            <span class="php-keyword1">case</span> self::ABSTRACTION_PDO :
224
</span><span id="112" class="l"><a class="l" href="#112">112: </a>                <span class="php-var">$this</span>-&gt;ASSOC = PDO::FETCH_ASSOC;
225
</span><span id="113" class="l"><a class="l" href="#113">113: </a>                <span class="php-var">$this</span>-&gt;OBJECT = PDO::FETCH_OBJ;
226
</span><span id="114" class="l"><a class="l" href="#114">114: </a>                <span class="php-keyword1">break</span>;
227
</span><span id="115" class="l"><a class="l" href="#115">115: </a>            <span class="php-keyword1">case</span> self::ABSTRACTION_MYSQL :
228
</span><span id="116" class="l"><a class="l" href="#116">116: </a>                <span class="php-var">$this</span>-&gt;ASSOC = <span class="php-quote">'mysql_fetch_assoc'</span>;
229
</span><span id="117" class="l"><a class="l" href="#117">117: </a>                <span class="php-var">$this</span>-&gt;OBJECT = <span class="php-quote">'mysql_fetch_object'</span>;
230
</span><span id="118" class="l"><a class="l" href="#118">118: </a>                <span class="php-keyword1">break</span>;
231
</span><span id="119" class="l"><a class="l" href="#119">119: </a>            <span class="php-keyword1">case</span> self::ABSTRACTION_MYSQLI :
232
</span><span id="120" class="l"><a class="l" href="#120">120: </a>                <span class="php-var">$this</span>-&gt;ASSOC = <span class="php-quote">'fetch_assoc'</span>;
233
</span><span id="121" class="l"><a class="l" href="#121">121: </a>                <span class="php-var">$this</span>-&gt;OBJECT = <span class="php-quote">'fetch_object'</span>;
234
</span><span id="122" class="l"><a class="l" href="#122">122: </a>                <span class="php-keyword1">break</span>;
235
</span><span id="123" class="l"><a class="l" href="#123">123: </a>            <span class="php-keyword1">case</span> self::ABSTRACTION_SQLITE3 :
236
</span><span id="124" class="l"><a class="l" href="#124">124: </a>                <span class="php-var">$this</span>-&gt;ASSOC = <span class="php-quote">'SQLITE3_ASSOC'</span>;
237
</span><span id="125" class="l"><a class="l" href="#125">125: </a>                <span class="php-var">$this</span>-&gt;OBJECT = <span class="php-quote">'SQLITE3_OBJECT'</span>;
238
</span><span id="126" class="l"><a class="l" href="#126">126: </a>                <span class="php-keyword1">break</span>;
239
</span><span id="127" class="l"><a class="l" href="#127">127: </a>            <span class="php-keyword1">default</span>:
240
</span><span id="128" class="l"><a class="l" href="#128">128: </a>                <span class="php-var">$m</span> = <span class="php-quote">&quot;Erreur : l'abstraction '</span><span class="php-var">{$this-&gt;abstraction}</span><span class="php-quote">' n'est pas prise en charge&quot;</span>;
241
</span><span id="129" class="l"><a class="l" href="#129">129: </a>                <span class="php-keyword2">trigger_error</span>(<span class="php-var">$m</span>, E_USER_WARNING);
242
</span><span id="130" class="l"><a class="l" href="#130">130: </a>        }
243
</span><span id="131" class="l"><a class="l" href="#131">131: </a>    }
244
</span><span id="132" class="l"><a class="l" href="#132">132: </a>
245
</span><span id="133" class="l"><a class="l" href="#133">133: </a>    <span class="php-comment">/**
246
</span></span><span id="134" class="l"><a class="l" href="#134">134: </a><span class="php-comment">     * Connection à la base de données en utilisant les informations fournies par
247
</span></span><span id="135" class="l"><a class="l" href="#135">135: </a><span class="php-comment">     * le fichier de configuration.
248
</span></span><span id="136" class="l"><a class="l" href="#136">136: </a><span class="php-comment">     * Cette méthode est private et final car elle n'a pas vocation a être appelée par l'utilisateur.
249
</span></span><span id="137" class="l"><a class="l" href="#137">137: </a><span class="php-comment">     * TODO : il est peut être nécessaire pour MYSQL, MYSQLi et SQLITE3 afin d'éviter les boucles infinis
250
</span></span><span id="138" class="l"><a class="l" href="#138">138: </a><span class="php-comment">     * d'erreur quand la bdd n'est pas configuré d'utiliser : $this-&gt;connexion-&gt;query (comme pour PDO)
251
</span></span><span id="139" class="l"><a class="l" href="#139">139: </a><span class="php-comment">     */</span>
252
</span><span id="140" class="l"><a class="l" href="#140">140: </a>    <span class="php-keyword1">protected</span> <span class="php-keyword1">function</span> <a id="_connecter" href="#_connecter">connecter</a>() {
253
</span><span id="141" class="l"><a class="l" href="#141">141: </a>        <span class="php-keyword1">if</span> (<span class="php-var">$this</span>-&gt;connexion == <span class="php-keyword1">null</span>) {
254
</span><span id="142" class="l"><a class="l" href="#142">142: </a>            <span class="php-keyword1">switch</span> (<span class="php-var">$this</span>-&gt;abstraction) {
255
</span><span id="143" class="l"><a class="l" href="#143">143: </a>                <span class="php-keyword1">case</span> self::ABSTRACTION_PDO :
256
</span><span id="144" class="l"><a class="l" href="#144">144: </a>                    <span class="php-keyword1">try</span> {
257
</span><span id="145" class="l"><a class="l" href="#145">145: </a>                        <span class="php-var">$this</span>-&gt;connexion = <span class="php-keyword1">new</span> PDO(<span class="php-var">$this</span>-&gt;dsn, <span class="php-var">$this</span>-&gt;utilisateur, <span class="php-var">$this</span>-&gt;pass);
258
</span><span id="146" class="l"><a class="l" href="#146">146: </a>                        <span class="php-var">$this</span>-&gt;connexion-&gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
259
</span><span id="147" class="l"><a class="l" href="#147">147: </a>                    } <span class="php-keyword1">catch</span> (PDOException <span class="php-var">$e</span>) {
260
</span><span id="148" class="l"><a class="l" href="#148">148: </a>                        <span class="php-var">$e</span> = <span class="php-keyword2">sprintf</span>(self::ERREUR_CONNEXION_TPL, <span class="php-var">$e</span>-&gt;getMessage());
261
</span><span id="149" class="l"><a class="l" href="#149">149: </a>                        <span class="php-keyword2">trigger_error</span>(<span class="php-var">$e</span>, E_USER_WARNING);
262
</span><span id="150" class="l"><a class="l" href="#150">150: </a>                    }
263
</span><span id="151" class="l"><a class="l" href="#151">151: </a>                    <span class="php-keyword1">if</span> (<span class="php-var">$this</span>-&gt;encodage != <span class="php-keyword1">null</span> &amp;&amp; <span class="php-var">$this</span>-&gt;type == <span class="php-quote">'mysql'</span>) {
264
</span><span id="152" class="l"><a class="l" href="#152">152: </a>                        <span class="php-var">$this</span>-&gt;connexion-&gt;query(<span class="php-quote">&quot;SET names '&quot;</span>.<span class="php-var">$this</span>-&gt;encodage.<span class="php-quote">&quot;'&quot;</span>);
265
</span><span id="153" class="l"><a class="l" href="#153">153: </a>                    } <span class="php-keyword1">else</span> <span class="php-keyword1">if</span> (<span class="php-var">$this</span>-&gt;type == <span class="php-quote">'sqlite'</span>) {
266
</span><span id="154" class="l"><a class="l" href="#154">154: </a>                        <span class="php-var">$this</span>-&gt;connexion-&gt;query(<span class="php-quote">&quot;PRAGMA case_sensitive_like = false&quot;</span>);
267
</span><span id="155" class="l"><a class="l" href="#155">155: </a>                    }
268
</span><span id="156" class="l"><a class="l" href="#156">156: </a>                    <span class="php-keyword1">break</span>;
269
</span><span id="157" class="l"><a class="l" href="#157">157: </a>                <span class="php-keyword1">case</span> self::ABSTRACTION_MYSQL :
270
</span><span id="158" class="l"><a class="l" href="#158">158: </a>                    <span class="php-var">$this</span>-&gt;connexion = <span class="php-keyword2">mysql_connect</span>(<span class="php-var">$this</span>-&gt;hote, <span class="php-var">$this</span>-&gt;utilisateur, <span class="php-var">$this</span>-&gt;pass);
271
</span><span id="159" class="l"><a class="l" href="#159">159: </a>                    <span class="php-keyword1">if</span> (<span class="php-var">$this</span>-&gt;connexion !== <span class="php-keyword1">false</span>) {
272
</span><span id="160" class="l"><a class="l" href="#160">160: </a>                        <span class="php-var">$selection</span> = <span class="php-keyword2">mysql_select_db</span>(<span class="php-var">$this</span>-&gt;bdd_nom, <span class="php-var">$this</span>-&gt;connexion);
273
</span><span id="161" class="l"><a class="l" href="#161">161: </a>                        <span class="php-keyword1">if</span> (<span class="php-var">$selection</span> === <span class="php-keyword1">false</span>) {
274
</span><span id="162" class="l"><a class="l" href="#162">162: </a>                            <span class="php-var">$e</span> = <span class="php-keyword2">sprintf</span>(self::ERREUR_SELECTION_BDD_TPL, <span class="php-keyword2">mysql_error</span>());
275
</span><span id="163" class="l"><a class="l" href="#163">163: </a>                            <span class="php-keyword2">trigger_error</span>(<span class="php-var">$e</span>, E_USER_WARNING);
276
</span><span id="164" class="l"><a class="l" href="#164">164: </a>                        }
277
</span><span id="165" class="l"><a class="l" href="#165">165: </a>                    } <span class="php-keyword1">else</span> {
278
</span><span id="166" class="l"><a class="l" href="#166">166: </a>                        <span class="php-var">$e</span> = <span class="php-keyword2">sprintf</span>(self::ERREUR_CONNEXION_TPL, <span class="php-keyword2">mysql_error</span>());
279
</span><span id="167" class="l"><a class="l" href="#167">167: </a>                        <span class="php-keyword2">trigger_error</span>(<span class="php-var">$e</span>, E_USER_WARNING);
280
</span><span id="168" class="l"><a class="l" href="#168">168: </a>                    }
281
</span><span id="169" class="l"><a class="l" href="#169">169: </a>                    <span class="php-keyword1">if</span> (<span class="php-var">$this</span>-&gt;encodage != <span class="php-keyword1">null</span>) {
282
</span><span id="170" class="l"><a class="l" href="#170">170: </a>                        <span class="php-var">$this</span>-&gt;requeter(<span class="php-quote">&quot;SET names '&quot;</span>.<span class="php-var">$this</span>-&gt;encodage.<span class="php-quote">&quot;'&quot;</span>);
283
</span><span id="171" class="l"><a class="l" href="#171">171: </a>                    }
284
</span><span id="172" class="l"><a class="l" href="#172">172: </a>                    <span class="php-keyword1">break</span>;
285
</span><span id="173" class="l"><a class="l" href="#173">173: </a>                <span class="php-keyword1">case</span> self::ABSTRACTION_MYSQLI :
286
</span><span id="174" class="l"><a class="l" href="#174">174: </a>                    <span class="php-var">$this</span>-&gt;connexion = @<span class="php-keyword1">new</span> mysqli(<span class="php-var">$this</span>-&gt;hote, <span class="php-var">$this</span>-&gt;utilisateur, <span class="php-var">$this</span>-&gt;pass, <span class="php-var">$this</span>-&gt;bdd_nom);
287
</span><span id="175" class="l"><a class="l" href="#175">175: </a>                    <span class="php-keyword1">if</span> (<span class="php-var">$this</span>-&gt;connexion-&gt;connect_errno) {
288
</span><span id="176" class="l"><a class="l" href="#176">176: </a>                        <span class="php-var">$e</span> = <span class="php-keyword2">sprintf</span>(self::ERREUR_CONNEXION_TPL, <span class="php-var">$this</span>-&gt;connexion-&gt;connect_error);
289
</span><span id="177" class="l"><a class="l" href="#177">177: </a>                        <span class="php-keyword2">trigger_error</span>(<span class="php-var">$e</span>, E_USER_WARNING);
290
</span><span id="178" class="l"><a class="l" href="#178">178: </a>                    }
291
</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>-&gt;encodage != <span class="php-keyword1">null</span>) {
292
</span><span id="180" class="l"><a class="l" href="#180">180: </a>                        <span class="php-var">$this</span>-&gt;requeter(<span class="php-quote">&quot;SET names '&quot;</span>.<span class="php-var">$this</span>-&gt;encodage.<span class="php-quote">&quot;'&quot;</span>);
293
</span><span id="181" class="l"><a class="l" href="#181">181: </a>                    }
294
</span><span id="182" class="l"><a class="l" href="#182">182: </a>                    <span class="php-keyword1">break</span>;
295
</span><span id="183" class="l"><a class="l" href="#183">183: </a>                <span class="php-keyword1">case</span> self::ABSTRACTION_SQLITE3 :
296
</span><span id="184" class="l"><a class="l" href="#184">184: </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>
297
</span><span id="185" class="l"><a class="l" href="#185">185: </a>                    <span class="php-var">$this</span>-&gt;connexion = <span class="php-keyword1">new</span> SQLite3(<span class="php-var">$this</span>-&gt;bdd_nom);
298
</span><span id="186" class="l"><a class="l" href="#186">186: </a>                    <span class="php-keyword1">if</span> (!<span class="php-var">$this</span>-&gt;connexion) {
299
</span><span id="187" class="l"><a class="l" href="#187">187: </a>                        <span class="php-var">$e</span> = <span class="php-keyword2">sprintf</span>(self::ERREUR_CONNEXION_TPL, <span class="php-quote">''</span>);
300
</span><span id="188" class="l"><a class="l" href="#188">188: </a>                        <span class="php-keyword2">trigger_error</span>(<span class="php-var">$e</span>, E_USER_WARNING);
301
</span><span id="189" class="l"><a class="l" href="#189">189: </a>                    }
302
</span><span id="190" class="l"><a class="l" href="#190">190: </a>                    <span class="php-var">$this</span>-&gt;requeter(<span class="php-quote">&quot;PRAGMA case_sensitive_like = false&quot;</span>);
303
</span><span id="191" class="l"><a class="l" href="#191">191: </a>                    <span class="php-keyword1">break</span>;
304
</span><span id="192" class="l"><a class="l" href="#192">192: </a>                <span class="php-keyword1">default</span>:
305
</span><span id="193" class="l"><a class="l" href="#193">193: </a>                    <span class="php-var">$this</span>-&gt;connexion = <span class="php-keyword1">null</span>;
306
</span><span id="194" class="l"><a class="l" href="#194">194: </a>            }
307
</span><span id="195" class="l"><a class="l" href="#195">195: </a>
308
</span><span id="196" class="l"><a class="l" href="#196">196: </a>            <span class="php-keyword1">if</span> (<span class="php-var">$this</span>-&gt;encodage != <span class="php-keyword1">null</span>) {
309
</span><span id="197" class="l"><a class="l" href="#197">197: </a>                <span class="php-var">$this</span>-&gt;requete(<span class="php-quote">&quot;SET names '&quot;</span>.<span class="php-var">$this</span>-&gt;encodage.<span class="php-quote">&quot;'&quot;</span>);
310
</span><span id="198" class="l"><a class="l" href="#198">198: </a>            }
311
</span><span id="199" class="l"><a class="l" href="#199">199: </a>        }
312
</span><span id="200" class="l"><a class="l" href="#200">200: </a>    }
313
</span><span id="201" class="l"><a class="l" href="#201">201: </a>
314
</span><span id="202" class="l"><a class="l" href="#202">202: </a>    <span class="php-comment">/**
315
</span></span><span id="203" class="l"><a class="l" href="#203">203: </a><span class="php-comment">     * @deprecated changement de nom. Disparaîtra dans la version 0.4. Utiliser à la place : @see requeter
316
</span></span><span id="204" class="l"><a class="l" href="#204">204: </a><span class="php-comment">     */</span>
317
</span><span id="205" class="l"><a class="l" href="#205">205: </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>) {
318
</span><span id="206" class="l"><a class="l" href="#206">206: </a>        <span class="php-keyword1">return</span> <span class="php-var">$this</span>-&gt;requeter(<span class="php-var">$requete</span>);
319
</span><span id="207" class="l"><a class="l" href="#207">207: </a>    }
320
</span><span id="208" class="l"><a class="l" href="#208">208: </a>
321
</span><span id="209" class="l"><a class="l" href="#209">209: </a>    <span class="php-comment">/**
322
</span></span><span id="210" class="l"><a class="l" href="#210">210: </a><span class="php-comment">     * Execute une requête et retourne le résultat tel que renvoyé par l'abstraction courante.
323
</span></span><span id="211" class="l"><a class="l" href="#211">211: </a><span class="php-comment">     *
324
</span></span><span id="212" class="l"><a class="l" href="#212">212: </a><span class="php-comment">     * @param string la requête à effectuer
325
</span></span><span id="213" class="l"><a class="l" href="#213">213: </a><span class="php-comment">     * @return mixed un objet contenant le résultat de la requête
326
</span></span><span id="214" class="l"><a class="l" href="#214">214: </a><span class="php-comment">     */</span>
327
</span><span id="215" class="l"><a class="l" href="#215">215: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_requeter" href="#_requeter">requeter</a>(<span class="php-var">$requete</span>) {
328
</span><span id="216" class="l"><a class="l" href="#216">216: </a>        <span class="php-var">$this</span>-&gt;connecter();
329
</span><span id="217" class="l"><a class="l" href="#217">217: </a>
330
</span><span id="218" class="l"><a class="l" href="#218">218: </a>        <span class="php-var">$retour</span> = <span class="php-keyword1">null</span>;
331
</span><span id="219" class="l"><a class="l" href="#219">219: </a>        <span class="php-keyword1">switch</span> (<span class="php-var">$this</span>-&gt;abstraction) {
332
</span><span id="220" class="l"><a class="l" href="#220">220: </a>            <span class="php-keyword1">case</span> self::ABSTRACTION_PDO :
333
</span><span id="221" class="l"><a class="l" href="#221">221: </a>                <span class="php-keyword1">try</span> {
334
</span><span id="222" class="l"><a class="l" href="#222">222: </a>                    <span class="php-var">$retour</span> = <span class="php-var">$this</span>-&gt;connexion-&gt;query(<span class="php-var">$requete</span>);
335
</span><span id="223" class="l"><a class="l" href="#223">223: </a>                } <span class="php-keyword1">catch</span> (PDOException <span class="php-var">$e</span>) {
336
</span><span id="224" class="l"><a class="l" href="#224">224: </a>                    <span class="php-var">$m</span> = <span class="php-keyword2">sprintf</span>(self::ERREUR_REQUETE_TPL, <span class="php-var">$e</span>-&gt;getFile(), <span class="php-var">$e</span>-&gt;getLine(), <span class="php-var">$e</span>-&gt;getMessage(), <span class="php-var">$requete</span>);
337
</span><span id="225" class="l"><a class="l" href="#225">225: </a>                    <span class="php-keyword2">trigger_error</span>(<span class="php-var">$m</span>, E_USER_WARNING);
338
</span><span id="226" class="l"><a class="l" href="#226">226: </a>                }
339
</span><span id="227" class="l"><a class="l" href="#227">227: </a>                <span class="php-keyword1">break</span>;
340
</span><span id="228" class="l"><a class="l" href="#228">228: </a>            <span class="php-keyword1">case</span> self::ABSTRACTION_MYSQL :
341
</span><span id="229" class="l"><a class="l" href="#229">229: </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>-&gt;connexion);
342
</span><span id="230" class="l"><a class="l" href="#230">230: </a>                <span class="php-keyword1">break</span>;
343
</span><span id="231" class="l"><a class="l" href="#231">231: </a>            <span class="php-keyword1">case</span> self::ABSTRACTION_MYSQLI :
344
</span><span id="232" class="l"><a class="l" href="#232">232: </a>                <span class="php-var">$retour</span> = <span class="php-var">$this</span>-&gt;connexion-&gt;query(<span class="php-var">$requete</span>);
345
</span><span id="233" class="l"><a class="l" href="#233">233: </a>                <span class="php-keyword1">break</span>;
346
</span><span id="234" class="l"><a class="l" href="#234">234: </a>            <span class="php-keyword1">case</span> self::ABSTRACTION_SQLITE3 :
347
</span><span id="235" class="l"><a class="l" href="#235">235: </a>                <span class="php-var">$retour</span> = <span class="php-var">$this</span>-&gt;connexion-&gt;<span class="php-keyword2">exec</span>(<span class="php-var">$requete</span>);
348
</span><span id="236" class="l"><a class="l" href="#236">236: </a>                <span class="php-keyword1">break</span>;
349
</span><span id="237" class="l"><a class="l" href="#237">237: </a>        }
350
</span><span id="238" class="l"><a class="l" href="#238">238: </a>        <span class="php-keyword1">return</span> <span class="php-var">$retour</span>;
351
</span><span id="239" class="l"><a class="l" href="#239">239: </a>    }
352
</span><span id="240" class="l"><a class="l" href="#240">240: </a>
353
</span><span id="241" class="l"><a class="l" href="#241">241: </a>    <span class="php-comment">/**
354
</span></span><span id="242" class="l"><a class="l" href="#242">242: </a><span class="php-comment">     * @deprecated changement de nom. Disparaîtra dans la version 0.4. Utiliser à la place : @see recuperer
355
</span></span><span id="243" class="l"><a class="l" href="#243">243: </a><span class="php-comment">     */</span>
356
</span><span id="244" class="l"><a class="l" href="#244">244: </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> = self::MODE_ASSOC) {
357
</span><span id="245" class="l"><a class="l" href="#245">245: </a>        <span class="php-keyword1">return</span> <span class="php-var">$this</span>-&gt;recuperer(<span class="php-var">$requete</span>, <span class="php-var">$mode</span>);
358
</span><span id="246" class="l"><a class="l" href="#246">246: </a>    }
359
</span><span id="247" class="l"><a class="l" href="#247">247: </a>
360
</span><span id="248" class="l"><a class="l" href="#248">248: </a>    <span class="php-comment">/**
361
</span></span><span id="249" class="l"><a class="l" href="#249">249: </a><span class="php-comment">     * Execute une requête et retourne le premier résultat sous forme de tableau (par défaut) ou d'objet.
362
</span></span><span id="250" class="l"><a class="l" href="#250">250: </a><span class="php-comment">     * 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.
363
</span></span><span id="251" class="l"><a class="l" href="#251">251: </a><span class="php-comment">     *
364
</span></span><span id="252" class="l"><a class="l" href="#252">252: </a><span class="php-comment">     * @param string la requête à effectuer
365
</span></span><span id="253" class="l"><a class="l" href="#253">253: </a><span class="php-comment">     * @param string le mode de retour ASSOC (Bdd::MODE_ASSOC) pour un tableau ou OBJECT (Bdd::MODE_OBJET) pour un objet.
366
</span></span><span id="254" class="l"><a class="l" href="#254">254: </a><span class="php-comment">     * @return mixed un objet ou un tableau contenant le résultat de la requête
367
</span></span><span id="255" class="l"><a class="l" href="#255">255: </a><span class="php-comment">     */</span>
368
</span><span id="256" class="l"><a class="l" href="#256">256: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_recuperer" href="#_recuperer">recuperer</a>(<span class="php-var">$requete</span>, <span class="php-var">$mode</span> = self::MODE_ASSOC) {
369
</span><span id="257" class="l"><a class="l" href="#257">257: </a>        <span class="php-var">$this</span>-&gt;connecter();
370
</span><span id="258" class="l"><a class="l" href="#258">258: </a>
371
</span><span id="259" class="l"><a class="l" href="#259">259: </a>        <span class="php-var">$retour</span> = <span class="php-keyword1">null</span>;
372
</span><span id="260" class="l"><a class="l" href="#260">260: </a>        <span class="php-keyword1">switch</span> (<span class="php-var">$this</span>-&gt;abstraction) {
373
</span><span id="261" class="l"><a class="l" href="#261">261: </a>            <span class="php-keyword1">case</span> self::ABSTRACTION_PDO :
374
</span><span id="262" class="l"><a class="l" href="#262">262: </a>                <span class="php-keyword1">try</span> {
375
</span><span id="263" class="l"><a class="l" href="#263">263: </a>                    <span class="php-var">$resultat</span> = <span class="php-var">$this</span>-&gt;connexion-&gt;query(<span class="php-var">$requete</span>);
376
</span><span id="264" class="l"><a class="l" href="#264">264: </a>                    <span class="php-var">$retour</span> = (<span class="php-var">$resultat</span> !== <span class="php-keyword1">false</span>) ? <span class="php-var">$resultat</span>-&gt;fetch(<span class="php-var">$this</span>-&gt;<span class="php-var">$mode</span>) : <span class="php-var">$resultat</span>;
377
</span><span id="265" class="l"><a class="l" href="#265">265: </a>                } <span class="php-keyword1">catch</span> (PDOException <span class="php-var">$e</span>) {
378
</span><span id="266" class="l"><a class="l" href="#266">266: </a>                    <span class="php-var">$m</span> = <span class="php-keyword2">sprintf</span>(self::ERREUR_REQUETE_TPL, <span class="php-var">$e</span>-&gt;getFile(), <span class="php-var">$e</span>-&gt;getLine(), <span class="php-var">$e</span>-&gt;getMessage(), <span class="php-var">$requete</span>);
379
</span><span id="267" class="l"><a class="l" href="#267">267: </a>                    <span class="php-keyword2">trigger_error</span>(<span class="php-var">$m</span>, E_USER_WARNING);
380
</span><span id="268" class="l"><a class="l" href="#268">268: </a>                }
381
</span><span id="269" class="l"><a class="l" href="#269">269: </a>                <span class="php-keyword1">break</span>;
382
</span><span id="270" class="l"><a class="l" href="#270">270: </a>            <span class="php-keyword1">case</span> self::ABSTRACTION_MYSQL :
383
</span><span id="271" class="l"><a class="l" href="#271">271: </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>-&gt;connexion);
384
</span><span id="272" class="l"><a class="l" href="#272">272: </a>                <span class="php-var">$fonction_fetch</span> = <span class="php-var">$this</span>-&gt;<span class="php-var">$mode</span>;
385
</span><span id="273" class="l"><a class="l" href="#273">273: </a>                <span class="php-var">$retour</span> = <span class="php-var">$fonction_fetch</span>(<span class="php-var">$res</span>);
386
</span><span id="274" class="l"><a class="l" href="#274">274: </a>                <span class="php-keyword1">break</span>;
387
</span><span id="275" class="l"><a class="l" href="#275">275: </a>            <span class="php-keyword1">case</span> self::ABSTRACTION_MYSQLI :
388
</span><span id="276" class="l"><a class="l" href="#276">276: </a>                <span class="php-var">$res</span> = <span class="php-var">$this</span>-&gt;connexion-&gt;query(<span class="php-var">$requete</span>);
389
</span><span id="277" class="l"><a class="l" href="#277">277: </a>                <span class="php-var">$fonction_fetch</span> = <span class="php-var">$this</span>-&gt;<span class="php-var">$mode</span>;
390
</span><span id="278" class="l"><a class="l" href="#278">278: </a>                <span class="php-var">$retour</span> = <span class="php-var">$res</span>-&gt;<span class="php-var">$fonction_fetch</span>();
391
</span><span id="279" class="l"><a class="l" href="#279">279: </a>                <span class="php-keyword1">break</span>;
392
</span><span id="280" class="l"><a class="l" href="#280">280: </a>            <span class="php-keyword1">case</span> self::ABSTRACTION_SQLITE3 :
393
</span><span id="281" class="l"><a class="l" href="#281">281: </a>                <span class="php-var">$retour</span> = <span class="php-var">$this</span>-&gt;connexion-&gt;querySingle(<span class="php-var">$requete</span>);
394
</span><span id="282" class="l"><a class="l" href="#282">282: </a>                <span class="php-keyword1">break</span>;
395
</span><span id="283" class="l"><a class="l" href="#283">283: </a>        }
396
</span><span id="284" class="l"><a class="l" href="#284">284: </a>        <span class="php-keyword1">return</span> <span class="php-var">$retour</span>;
397
</span><span id="285" class="l"><a class="l" href="#285">285: </a>    }
398
</span><span id="286" class="l"><a class="l" href="#286">286: </a>
399
</span><span id="287" class="l"><a class="l" href="#287">287: </a>    <span class="php-comment">/**
400
</span></span><span id="288" class="l"><a class="l" href="#288">288: </a><span class="php-comment">     * @deprecated changement de nom. Disparaîtra dans la version 0.4. Utiliser à la place : @see recupererTous
401
</span></span><span id="289" class="l"><a class="l" href="#289">289: </a><span class="php-comment">     */</span>
402
</span><span id="290" class="l"><a class="l" href="#290">290: </a>    <span class="php-keyword1">final</span> <span class="php-keyword1">protected</span> <span class="php-keyword1">function</span> <a id="_requeteTous" href="#_requeteTous">requeteTous</a>(<span class="php-var">$requete</span>, <span class="php-var">$mode</span> = self::MODE_ASSOC) {
403
</span><span id="291" class="l"><a class="l" href="#291">291: </a>        <span class="php-keyword1">return</span> <span class="php-var">$this</span>-&gt;recupererTous(<span class="php-var">$requete</span>, <span class="php-var">$mode</span>);
404
</span><span id="292" class="l"><a class="l" href="#292">292: </a>    }
405
</span><span id="293" class="l"><a class="l" href="#293">293: </a>
406
</span><span id="294" class="l"><a class="l" href="#294">294: </a>    <span class="php-comment">/**
407
</span></span><span id="295" class="l"><a class="l" href="#295">295: </a><span class="php-comment">     * Execute une requête et retourne un tableau de résultats. Un résultat peut être présentés sous forme
408
</span></span><span id="296" class="l"><a class="l" href="#296">296: </a><span class="php-comment">     * de tableau (par défaut) ou d'objet.
409
</span></span><span id="297" class="l"><a class="l" href="#297">297: </a><span class="php-comment">     * Les noms des champs de la base de données correspondent aux noms des clés du tableau résultat ou
410
</span></span><span id="298" class="l"><a class="l" href="#298">298: </a><span class="php-comment">     * aux noms des attributs de l'objet résultat.
411
</span></span><span id="299" class="l"><a class="l" href="#299">299: </a><span class="php-comment">     *
412
</span></span><span id="300" class="l"><a class="l" href="#300">300: </a><span class="php-comment">     * @param string la requête à effectuer
413
</span></span><span id="301" class="l"><a class="l" href="#301">301: </a><span class="php-comment">     * @param string le mode de retour des résultats : ASSOC (Bdd::MODE_ASSOC) pour un tableau ou OBJECT (Bdd::MODE_OBJET) pour un objet.
414
</span></span><span id="302" class="l"><a class="l" href="#302">302: </a><span class="php-comment">     * @return array un tableau contenant les résultats sous forme d'objets ou de tableau (par défaut).
415
</span></span><span id="303" class="l"><a class="l" href="#303">303: </a><span class="php-comment">     */</span>
416
</span><span id="304" class="l"><a class="l" href="#304">304: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_recupererTous" href="#_recupererTous">recupererTous</a>(<span class="php-var">$requete</span>, <span class="php-var">$mode</span> = self::MODE_ASSOC) {
417
</span><span id="305" class="l"><a class="l" href="#305">305: </a>        <span class="php-var">$this</span>-&gt;connecter();
418
</span><span id="306" class="l"><a class="l" href="#306">306: </a>
419
</span><span id="307" class="l"><a class="l" href="#307">307: </a>        <span class="php-var">$retour</span> = <span class="php-keyword1">null</span>;
420
</span><span id="308" class="l"><a class="l" href="#308">308: </a>        <span class="php-keyword1">switch</span> (<span class="php-var">$this</span>-&gt;abstraction) {
421
</span><span id="309" class="l"><a class="l" href="#309">309: </a>            <span class="php-keyword1">case</span> self::ABSTRACTION_PDO :
422
</span><span id="310" class="l"><a class="l" href="#310">310: </a>                <span class="php-keyword1">try</span> {
423
</span><span id="311" class="l"><a class="l" href="#311">311: </a>                    <span class="php-var">$resultat</span> = <span class="php-var">$this</span>-&gt;connexion-&gt;query(<span class="php-var">$requete</span>);
424
</span><span id="312" class="l"><a class="l" href="#312">312: </a>                    <span class="php-var">$retour</span> = (<span class="php-var">$resultat</span> !== <span class="php-keyword1">false</span>) ? <span class="php-var">$resultat</span>-&gt;fetchAll(<span class="php-var">$this</span>-&gt;<span class="php-var">$mode</span>) : <span class="php-var">$resultat</span>;
425
</span><span id="313" class="l"><a class="l" href="#313">313: </a>                } <span class="php-keyword1">catch</span> (PDOException <span class="php-var">$e</span>) {
426
</span><span id="314" class="l"><a class="l" href="#314">314: </a>                    <span class="php-var">$m</span> = <span class="php-keyword2">sprintf</span>(self::ERREUR_REQUETE_TPL, <span class="php-var">$e</span>-&gt;getFile(), <span class="php-var">$e</span>-&gt;getLine(), <span class="php-var">$e</span>-&gt;getMessage(), <span class="php-var">$requete</span>);
427
</span><span id="315" class="l"><a class="l" href="#315">315: </a>                    <span class="php-keyword2">trigger_error</span>(<span class="php-var">$m</span>, E_USER_WARNING);
428
</span><span id="316" class="l"><a class="l" href="#316">316: </a>                }
429
</span><span id="317" class="l"><a class="l" href="#317">317: </a>                <span class="php-keyword1">break</span>;
430
</span><span id="318" class="l"><a class="l" href="#318">318: </a>            <span class="php-keyword1">case</span> self::ABSTRACTION_MYSQL :
431
</span><span id="319" class="l"><a class="l" href="#319">319: </a>                <span class="php-var">$resultat</span> = <span class="php-keyword2">mysql_query</span>(<span class="php-var">$requete</span>, <span class="php-var">$this</span>-&gt;connexion);
432
</span><span id="320" class="l"><a class="l" href="#320">320: </a>                <span class="php-var">$fonction_fetch</span> = <span class="php-var">$this</span>-&gt;<span class="php-var">$mode</span>;
433
</span><span id="321" class="l"><a class="l" href="#321">321: </a>                <span class="php-keyword1">while</span> (<span class="php-var">$ligne</span> = <span class="php-var">$fonction_fetch</span>(<span class="php-var">$resultat</span>)) {
434
</span><span id="322" class="l"><a class="l" href="#322">322: </a>                    <span class="php-var">$retour</span>[] = <span class="php-var">$ligne</span>;
435
</span><span id="323" class="l"><a class="l" href="#323">323: </a>                }
436
</span><span id="324" class="l"><a class="l" href="#324">324: </a>                <span class="php-keyword1">break</span>;
437
</span><span id="325" class="l"><a class="l" href="#325">325: </a>            <span class="php-keyword1">case</span> self::ABSTRACTION_MYSQLI :
438
</span><span id="326" class="l"><a class="l" href="#326">326: </a>                <span class="php-var">$resultat</span> = <span class="php-var">$this</span>-&gt;connexion-&gt;query(<span class="php-var">$requete</span>);
439
</span><span id="327" class="l"><a class="l" href="#327">327: </a>                <span class="php-var">$function_fetch</span> = <span class="php-var">$this</span>-&gt;<span class="php-var">$mode</span>;
440
</span><span id="328" class="l"><a class="l" href="#328">328: </a>                <span class="php-keyword1">while</span> (<span class="php-var">$ligne</span> = <span class="php-var">$resultat</span>-&gt;<span class="php-var">$function_fetch</span>()) {
441
</span><span id="329" class="l"><a class="l" href="#329">329: </a>                    <span class="php-var">$retour</span>[] = <span class="php-var">$ligne</span>;
442
</span><span id="330" class="l"><a class="l" href="#330">330: </a>                }
443
</span><span id="331" class="l"><a class="l" href="#331">331: </a>                <span class="php-keyword1">break</span>;
444
</span><span id="332" class="l"><a class="l" href="#332">332: </a>            <span class="php-keyword1">case</span> self::ABSTRACTION_SQLITE3 :
445
</span><span id="333" class="l"><a class="l" href="#333">333: </a>                <span class="php-var">$resultat</span> = <span class="php-var">$this</span>-&gt;connexion-&gt;query(<span class="php-var">$requete</span>);
446
</span><span id="334" class="l"><a class="l" href="#334">334: </a>                <span class="php-keyword1">while</span> (<span class="php-var">$ligne</span> = <span class="php-var">$resultat</span>-&gt;fetch_array(<span class="php-var">$this</span>-&gt;ASSOC)) {
447
</span><span id="335" class="l"><a class="l" href="#335">335: </a>                    <span class="php-keyword1">if</span> (<span class="php-var">$mode</span> == self::MODE_OBJET) {
448
</span><span id="336" class="l"><a class="l" href="#336">336: </a>                        <span class="php-comment">// Cas particulier de sqllite qui n'a pas de fonction fetch_object</span>
449
</span><span id="337" class="l"><a class="l" href="#337">337: </a>                        <span class="php-var">$ligneObjet</span> = <span class="php-keyword1">new</span> stdClass();
450
</span><span id="338" class="l"><a class="l" href="#338">338: </a>                        <span class="php-keyword1">foreach</span> (<span class="php-var">$ligne</span> <span class="php-keyword1">as</span> <span class="php-var">$colonne</span> =&gt; <span class="php-var">$valeur</span>) {
451
</span><span id="339" class="l"><a class="l" href="#339">339: </a>                            <span class="php-var">$ligneObjet</span>-&gt;<span class="php-var">$colonne</span> = <span class="php-var">$valeur</span>;
452
</span><span id="340" class="l"><a class="l" href="#340">340: </a>                        }
453
</span><span id="341" class="l"><a class="l" href="#341">341: </a>                        <span class="php-var">$ligne</span> = <span class="php-var">$ligneObjet</span>;
454
</span><span id="342" class="l"><a class="l" href="#342">342: </a>                    }
455
</span><span id="343" class="l"><a class="l" href="#343">343: </a>                    <span class="php-var">$retour</span>[] = <span class="php-var">$ligne</span>;
456
</span><span id="344" class="l"><a class="l" href="#344">344: </a>                }
457
</span><span id="345" class="l"><a class="l" href="#345">345: </a>                <span class="php-keyword1">break</span>;
458
</span><span id="346" class="l"><a class="l" href="#346">346: </a>        }
459
</span><span id="347" class="l"><a class="l" href="#347">347: </a>        <span class="php-keyword1">return</span> <span class="php-var">$retour</span>;
460
</span><span id="348" class="l"><a class="l" href="#348">348: </a>    }
461
</span><span id="349" class="l"><a class="l" href="#349">349: </a>
462
</span><span id="350" class="l"><a class="l" href="#350">350: </a>    <span class="php-comment">/**
463
</span></span><span id="351" class="l"><a class="l" href="#351">351: </a><span class="php-comment">     * Protège une chaine de caractères ou le contenu d'un tablea avant l'insertion dans la base de données
464
</span></span><span id="352" class="l"><a class="l" href="#352">352: </a><span class="php-comment">     * (ajout de quotes ou guillemets).
465
</span></span><span id="353" class="l"><a class="l" href="#353">353: </a><span class="php-comment">     * @param Mixed une chaine ou un tableau à protéger
466
</span></span><span id="354" class="l"><a class="l" href="#354">354: </a><span class="php-comment">     * @return mixed la chaine ou le tableau à protégé
467
</span></span><span id="355" class="l"><a class="l" href="#355">355: </a><span class="php-comment">     */</span>
468
</span><span id="356" class="l"><a class="l" href="#356">356: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_proteger" href="#_proteger">proteger</a>(<span class="php-var">$donnees</span>) {
469
</span><span id="357" class="l"><a class="l" href="#357">357: </a>        <span class="php-var">$this</span>-&gt;connecter();
470
</span><span id="358" class="l"><a class="l" href="#358">358: </a>        <span class="php-keyword1">if</span> (<span class="php-keyword2">is_array</span>(<span class="php-var">$donnees</span>)) {
471
</span><span id="359" class="l"><a class="l" href="#359">359: </a>            <span class="php-var">$retour</span> = <span class="php-var">$this</span>-&gt;protegerTableau(<span class="php-var">$donnees</span>);
472
</span><span id="360" class="l"><a class="l" href="#360">360: </a>        } <span class="php-keyword1">else</span> {
473
</span><span id="361" class="l"><a class="l" href="#361">361: </a>            <span class="php-var">$retour</span> = <span class="php-var">$this</span>-&gt;protegerChaine(<span class="php-var">$donnees</span>);
474
</span><span id="362" class="l"><a class="l" href="#362">362: </a>        }
475
</span><span id="363" class="l"><a class="l" href="#363">363: </a>        <span class="php-keyword1">return</span> <span class="php-var">$retour</span>;
476
</span><span id="364" class="l"><a class="l" href="#364">364: </a>    }
477
</span><span id="365" class="l"><a class="l" href="#365">365: </a>
478
</span><span id="366" class="l"><a class="l" href="#366">366: </a>    <span class="php-comment">/**
479
</span></span><span id="367" class="l"><a class="l" href="#367">367: </a><span class="php-comment">     * Protège une chaine de caractères avant l'insertion dans la base de données (ajout de quotes ou guillemets).
480
</span></span><span id="368" class="l"><a class="l" href="#368">368: </a><span class="php-comment">     * @param string la chaine à protéger
481
</span></span><span id="369" class="l"><a class="l" href="#369">369: </a><span class="php-comment">     * @return string la chaine protégée
482
</span></span><span id="370" class="l"><a class="l" href="#370">370: </a><span class="php-comment">     */</span>
483
</span><span id="371" class="l"><a class="l" href="#371">371: </a>    <span class="php-keyword1">private</span> <span class="php-keyword1">function</span> <a id="_protegerChaine" href="#_protegerChaine">protegerChaine</a>(<span class="php-var">$chaine</span>) {
484
</span><span id="372" class="l"><a class="l" href="#372">372: </a>        <span class="php-var">$retour</span> = <span class="php-var">$chaine</span>;
485
</span><span id="373" class="l"><a class="l" href="#373">373: </a>        <span class="php-keyword1">switch</span> (<span class="php-var">$this</span>-&gt;abstraction) {
486
</span><span id="374" class="l"><a class="l" href="#374">374: </a>            <span class="php-keyword1">case</span> self::ABSTRACTION_PDO :
487
</span><span id="375" class="l"><a class="l" href="#375">375: </a>                <span class="php-var">$retour</span> = <span class="php-var">$this</span>-&gt;connexion-&gt;quote(<span class="php-var">$chaine</span>);
488
</span><span id="376" class="l"><a class="l" href="#376">376: </a>                <span class="php-keyword1">break</span>;
489
</span><span id="377" class="l"><a class="l" href="#377">377: </a>            <span class="php-keyword1">case</span> self::ABSTRACTION_MYSQL :
490
</span><span id="378" class="l"><a class="l" href="#378">378: </a>                <span class="php-var">$retour</span> = <span class="php-quote">'&quot;'</span>.<span class="php-keyword2">mysql_real_escape_string</span>(<span class="php-var">$chaine</span>, <span class="php-var">$this</span>-&gt;connexion).<span class="php-quote">'&quot;'</span>;
491
</span><span id="379" class="l"><a class="l" href="#379">379: </a>                <span class="php-keyword1">break</span>;
492
</span><span id="380" class="l"><a class="l" href="#380">380: </a>            <span class="php-keyword1">case</span> self::ABSTRACTION_MYSQLI :
493
</span><span id="381" class="l"><a class="l" href="#381">381: </a>                <span class="php-var">$retour</span> = <span class="php-quote">'&quot;'</span>.<span class="php-var">$this</span>-&gt;connexion-&gt;real_escape_string(<span class="php-var">$chaine</span>).<span class="php-quote">'&quot;'</span>;
494
</span><span id="382" class="l"><a class="l" href="#382">382: </a>                <span class="php-keyword1">break</span>;
495
</span><span id="383" class="l"><a class="l" href="#383">383: </a>            <span class="php-keyword1">case</span> self::ABSTRACTION_SQLITE3 :
496
</span><span id="384" class="l"><a class="l" href="#384">384: </a>                <span class="php-var">$retour</span> = <span class="php-var">$this</span>-&gt;connexion-&gt;escapeString(<span class="php-var">$chaine</span>);
497
</span><span id="385" class="l"><a class="l" href="#385">385: </a>                <span class="php-keyword1">break</span>;
498
</span><span id="386" class="l"><a class="l" href="#386">386: </a>        }
499
</span><span id="387" class="l"><a class="l" href="#387">387: </a>        <span class="php-keyword1">return</span> <span class="php-var">$retour</span>;
500
</span><span id="388" class="l"><a class="l" href="#388">388: </a>    }
501
</span><span id="389" class="l"><a class="l" href="#389">389: </a>
502
</span><span id="390" class="l"><a class="l" href="#390">390: </a>    <span class="php-comment">/**
503
</span></span><span id="391" class="l"><a class="l" href="#391">391: </a><span class="php-comment">     * @deprecated changement de nom. Deviendra &quot;private&quot; dans la version 0.5. Utiliser à la place : @see proteger
504
</span></span><span id="392" class="l"><a class="l" href="#392">392: </a><span class="php-comment">     */</span>
505
</span><span id="393" class="l"><a class="l" href="#393">393: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_protegerTableau" href="#_protegerTableau">protegerTableau</a>(<span class="php-keyword1">Array</span> <span class="php-var">$tableau</span>) {
506
</span><span id="394" class="l"><a class="l" href="#394">394: </a>        <span class="php-keyword1">foreach</span> (<span class="php-var">$tableau</span> <span class="php-keyword1">as</span> <span class="php-var">$id</span> =&gt; <span class="php-var">$val</span>) {
507
</span><span id="395" class="l"><a class="l" href="#395">395: </a>            <span class="php-keyword1">if</span> (<span class="php-keyword2">is_array</span>(<span class="php-var">$val</span>)) {
508
</span><span id="396" class="l"><a class="l" href="#396">396: </a>                <span class="php-var">$tableau</span>[<span class="php-var">$id</span>] = <span class="php-var">$this</span>-&gt;protegerTableau(<span class="php-var">$val</span>);
509
</span><span id="397" class="l"><a class="l" href="#397">397: </a>            } <span class="php-keyword1">else</span> {
510
</span><span id="398" class="l"><a class="l" href="#398">398: </a>                <span class="php-var">$tableau</span>[<span class="php-var">$id</span>] = <span class="php-var">$this</span>-&gt;protegerChaine(<span class="php-var">$val</span>);
511
</span><span id="399" class="l"><a class="l" href="#399">399: </a>            }
512
</span><span id="400" class="l"><a class="l" href="#400">400: </a>        }
513
</span><span id="401" class="l"><a class="l" href="#401">401: </a>        <span class="php-keyword1">return</span> <span class="php-var">$tableau</span>;
514
</span><span id="402" class="l"><a class="l" href="#402">402: </a>    }
515
</span><span id="403" class="l"><a class="l" href="#403">403: </a>
516
</span><span id="404" class="l"><a class="l" href="#404">404: </a>    <span class="php-comment">/**
517
</span></span><span id="405" class="l"><a class="l" href="#405">405: </a><span class="php-comment">     * 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
518
</span></span><span id="406" class="l"><a class="l" href="#406">406: </a><span class="php-comment">     * le cas de PDO, du driver utilisé. Les méthodes utilisées pour retourner l'identifiant peuvent avoir des comportements
519
</span></span><span id="407" class="l"><a class="l" href="#407">407: </a><span class="php-comment">     * différent. Consulter la documentation PHP correspondant à l'abstraction choisie avant de l'utiliser :
520
</span></span><span id="408" class="l"><a class="l" href="#408">408: </a><span class="php-comment">     * @link(http://fr.php.net/manual/fr/pdo.lastinsertid.php, PDO::lastInsertId([ string $name = NULL ]))
521
</span></span><span id="409" class="l"><a class="l" href="#409">409: </a><span class="php-comment">     * @link(http://php.net/manual/en/mysqli.insert-id.php, mysqli-&gt;insert_id())
522
</span></span><span id="410" class="l"><a class="l" href="#410">410: </a><span class="php-comment">     * @link(http://fr.php.net/manual/fr/function.mysql-insert-id.php, mysql_insert_id())
523
</span></span><span id="411" class="l"><a class="l" href="#411">411: </a><span class="php-comment">     * @link(http://fr.php.net/manual/fr/sqlite3.lastinsertrowid.php, SQLite3::lastInsertRowID())
524
</span></span><span id="412" class="l"><a class="l" href="#412">412: </a><span class="php-comment">     * @param mixed un paramètre éventuel à transmettre (en fonction de l'abstraction de BDD utilisée).
525
</span></span><span id="413" class="l"><a class="l" href="#413">413: </a><span class="php-comment">     * @return mixed le dernier identifiant de clé primaire ajouté dans la base de données (string ou int).
526
</span></span><span id="414" class="l"><a class="l" href="#414">414: </a><span class="php-comment">     */</span>
527
</span><span id="415" class="l"><a class="l" href="#415">415: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_recupererIdDernierAjout" href="#_recupererIdDernierAjout">recupererIdDernierAjout</a>(<span class="php-var">$parametres</span> = <span class="php-keyword1">null</span>) {
528
</span><span id="416" class="l"><a class="l" href="#416">416: </a>        <span class="php-var">$this</span>-&gt;connecter();
529
</span><span id="417" class="l"><a class="l" href="#417">417: </a>
530
</span><span id="418" class="l"><a class="l" href="#418">418: </a>        <span class="php-var">$retour</span> = <span class="php-keyword1">null</span>;
531
</span><span id="419" class="l"><a class="l" href="#419">419: </a>        <span class="php-keyword1">switch</span> (<span class="php-var">$this</span>-&gt;abstraction) {
532
</span><span id="420" class="l"><a class="l" href="#420">420: </a>            <span class="php-keyword1">case</span> self::ABSTRACTION_PDO :
533
</span><span id="421" class="l"><a class="l" href="#421">421: </a>                <span class="php-var">$retour</span> = <span class="php-var">$this</span>-&gt;connexion-&gt;lastInsertId(<span class="php-var">$parametres</span>);
534
</span><span id="422" class="l"><a class="l" href="#422">422: </a>                <span class="php-keyword1">break</span>;
535
</span><span id="423" class="l"><a class="l" href="#423">423: </a>            <span class="php-keyword1">case</span> self::ABSTRACTION_MYSQL :
536
</span><span id="424" class="l"><a class="l" href="#424">424: </a>                <span class="php-var">$retour</span> = <span class="php-keyword2">mysql_insert_id</span>(<span class="php-var">$this</span>-&gt;connexion);
537
</span><span id="425" class="l"><a class="l" href="#425">425: </a>                <span class="php-keyword1">break</span>;
538
</span><span id="426" class="l"><a class="l" href="#426">426: </a>            <span class="php-keyword1">case</span> self::ABSTRACTION_MYSQLI :
539
</span><span id="427" class="l"><a class="l" href="#427">427: </a>                <span class="php-var">$retour</span> = <span class="php-var">$this</span>-&gt;connexion-&gt;insert_id();
540
</span><span id="428" class="l"><a class="l" href="#428">428: </a>                <span class="php-keyword1">break</span>;
541
</span><span id="429" class="l"><a class="l" href="#429">429: </a>            <span class="php-keyword1">case</span> self::ABSTRACTION_SQLITE3 :
542
</span><span id="430" class="l"><a class="l" href="#430">430: </a>                <span class="php-var">$retour</span> = <span class="php-var">$this</span>-&gt;connexion-&gt;lastInsertRowID();
543
</span><span id="431" class="l"><a class="l" href="#431">431: </a>                <span class="php-keyword1">break</span>;
544
</span><span id="432" class="l"><a class="l" href="#432">432: </a>        }
545
</span><span id="433" class="l"><a class="l" href="#433">433: </a>        <span class="php-keyword1">return</span> <span class="php-var">$retour</span>;
546
</span><span id="434" class="l"><a class="l" href="#434">434: </a>    }
547
</span><span id="435" class="l"><a class="l" href="#435">435: </a>
548
</span><span id="436" class="l"><a class="l" href="#436">436: </a>    <span class="php-comment">/**
549
</span></span><span id="437" class="l"><a class="l" href="#437">437: </a><span class="php-comment">     * Destructeur de classe, se contente de fermer explicitement la connexion à la base de donnée.
550
</span></span><span id="438" class="l"><a class="l" href="#438">438: </a><span class="php-comment">     */</span>
551
</span><span id="439" class="l"><a class="l" href="#439">439: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="___destruct" href="#___destruct">__destruct</a>() {
552
</span><span id="440" class="l"><a class="l" href="#440">440: </a>        <span class="php-keyword1">if</span> (<span class="php-keyword1">isset</span>(<span class="php-var">$this</span>-&gt;connexion)) {
553
</span><span id="441" class="l"><a class="l" href="#441">441: </a>            <span class="php-keyword1">switch</span> (<span class="php-var">$this</span>-&gt;abstraction) {
554
</span><span id="442" class="l"><a class="l" href="#442">442: </a>                <span class="php-keyword1">case</span> self::ABSTRACTION_PDO :
555
</span><span id="443" class="l"><a class="l" href="#443">443: </a>                    <span class="php-var">$this</span>-&gt;connexion = <span class="php-keyword1">null</span>;
556
</span><span id="444" class="l"><a class="l" href="#444">444: </a>                    <span class="php-keyword1">break</span>;
557
</span><span id="445" class="l"><a class="l" href="#445">445: </a>                <span class="php-keyword1">case</span> self::ABSTRACTION_MYSQL :
558
</span><span id="446" class="l"><a class="l" href="#446">446: </a>                    <span class="php-keyword1">if</span> (<span class="php-keyword1">isset</span>(<span class="php-var">$this</span>-&gt;connexion)) {
559
</span><span id="447" class="l"><a class="l" href="#447">447: </a>                        <span class="php-keyword1">return</span> <span class="php-keyword2">mysql_close</span>(<span class="php-var">$this</span>-&gt;connexion);
560
</span><span id="448" class="l"><a class="l" href="#448">448: </a>                    }
561
</span><span id="449" class="l"><a class="l" href="#449">449: </a>                    <span class="php-keyword1">break</span>;
562
</span><span id="450" class="l"><a class="l" href="#450">450: </a>                <span class="php-keyword1">case</span> self::ABSTRACTION_MYSQLI :
563
</span><span id="451" class="l"><a class="l" href="#451">451: </a>                    <span class="php-var">$this</span>-&gt;connexion-&gt;close();
564
</span><span id="452" class="l"><a class="l" href="#452">452: </a>                    <span class="php-keyword1">break</span>;
565
</span><span id="453" class="l"><a class="l" href="#453">453: </a>                <span class="php-keyword1">case</span> self::ABSTRACTION_SQLITE3 :
566
</span><span id="454" class="l"><a class="l" href="#454">454: </a>                    <span class="php-var">$this</span>-&gt;connexion-&gt;close();
567
</span><span id="455" class="l"><a class="l" href="#455">455: </a>                    <span class="php-keyword1">break</span>;
568
</span><span id="456" class="l"><a class="l" href="#456">456: </a>            }
569
</span><span id="457" class="l"><a class="l" href="#457">457: </a>        }
570
</span><span id="458" class="l"><a class="l" href="#458">458: </a>    }
571
</span><span id="459" class="l"><a class="l" href="#459">459: </a>}
572
</span><span id="460" class="l"><a class="l" href="#460">460: </a></span><span class="xlang">?&gt;</span></code></pre>
573
 
574
	<div id="footer">
575
		TBFramework - v0.4 API documentation generated by <a href="http://apigen.org">ApiGen 2.8.0</a>
576
	</div>
577
</div>
578
</div>
579
</body>
580
</html>