Commit | Line | Data |
---|---|---|
0337d704 | 1 | <?php |
2 | /*************************************************************************** | |
e92ecb8c | 3 | * Copyright (C) 2003-2011 Polytechnique.org * |
0337d704 | 4 | * http://opensource.polytechnique.org/ * |
5 | * * | |
6 | * This program is free software; you can redistribute it and/or modify * | |
7 | * it under the terms of the GNU General Public License as published by * | |
8 | * the Free Software Foundation; either version 2 of the License, or * | |
9 | * (at your option) any later version. * | |
10 | * * | |
11 | * This program is distributed in the hope that it will be useful, * | |
12 | * but WITHOUT ANY WARRANTY; without even the implied warranty of * | |
13 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * | |
14 | * GNU General Public License for more details. * | |
15 | * * | |
16 | * You should have received a copy of the GNU General Public License * | |
17 | * along with this program; if not, write to the Free Software * | |
18 | * Foundation, Inc., * | |
19 | * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA * | |
20 | **************************************************************************/ | |
21 | ||
08cce2ff | 22 | class XDB |
0337d704 | 23 | { |
32d9ae72 | 24 | private static $mysqli = null; |
25 | ||
821744e0 | 26 | public static function connect() |
32d9ae72 | 27 | { |
821744e0 | 28 | global $globals; |
e4f6c7d0 | 29 | self::$mysqli = new mysqli($globals->dbhost, $globals->dbuser, $globals->dbpwd, $globals->dbdb); |
81e9c63f | 30 | if ($globals->debug & DEBUG_BT) { |
d3f26be9 | 31 | $bt = new PlBacktrace('MySQL'); |
32 | if (mysqli_connect_errno()) { | |
33 | $bt->newEvent("MySQLI connection", 0, mysqli_connect_error()); | |
34 | return false; | |
35 | } | |
32d9ae72 | 36 | } |
e4f6c7d0 FB |
37 | self::$mysqli->autocommit(true); |
38 | self::$mysqli->set_charset($globals->dbcharset); | |
32d9ae72 | 39 | return true; |
40 | } | |
f1ca33de | 41 | |
cd1d4b4f | 42 | public static function prepare($args) |
ed3f4d3e | 43 | { |
4d6eeacc | 44 | global $globals; |
f62bd784 | 45 | $query = array_map(Array('XDB', 'escape'), $args); |
f3e3cab8 | 46 | $query[0] = preg_replace('/#([a-z0-9]+)#/', $globals->dbprefix . '$1', $args[0]); |
4d6eeacc VZ |
47 | $query[0] = str_replace('%', '%%', $query[0]); |
48 | $query[0] = str_replace('{?}', '%s', $query[0]); | |
0337d704 | 49 | return call_user_func_array('sprintf', $query); |
50 | } | |
13a25546 | 51 | |
cd1d4b4f | 52 | public static function reformatQuery($query) |
7c571120 | 53 | { |
a4f89886 | 54 | $query = preg_split("/\n\\s*/", trim($query)); |
7c571120 | 55 | $length = 0; |
d3c52d30 | 56 | foreach ($query as $key=>$line) { |
57 | $local = -2; | |
a14159bf | 58 | if (preg_match('/^([A-Z]+(?:\s+(?:JOIN|BY|FROM|INTO))?)\s+(.*)/u', $line, $matches) |
85d3b330 | 59 | && $matches[1] != 'AND' && $matches[1] != 'OR') |
60 | { | |
d3c52d30 | 61 | $local = strlen($matches[1]); |
62 | $line = $matches[1] . ' ' . $matches[2]; | |
63 | $length = max($length, $local); | |
7c571120 | 64 | } |
d3c52d30 | 65 | $query[$key] = array($line, $local); |
7c571120 | 66 | } |
67 | $res = ''; | |
d3c52d30 | 68 | foreach ($query as $array) { |
69 | list($line, $local) = $array; | |
9630c649 | 70 | $local = max(0, $length - $local); |
7c571120 | 71 | $res .= str_repeat(' ', $local) . $line . "\n"; |
72 | $length += 2 * (substr_count($line, '(') - substr_count($line, ')')); | |
73 | } | |
74 | return $res; | |
75 | } | |
76 | ||
cd1d4b4f | 77 | public static function run($query) |
ed3f4d3e | 78 | { |
f1ca33de | 79 | global $globals; |
80 | ||
e4f6c7d0 | 81 | if (!self::$mysqli && !self::connect()) { |
12ccfec7 | 82 | header($_SERVER['SERVER_PROTOCOL'] . ' 500 Internal Server Error'); |
084a60da FB |
83 | Platal::page()->kill('Impossible de se connecter à la base de données.'); |
84 | exit; | |
821744e0 | 85 | } |
86 | ||
81e9c63f | 87 | if ($globals->debug & DEBUG_BT) { |
f1ca33de | 88 | $explain = array(); |
e49b22c0 | 89 | if (strpos($query, 'FOUND_ROWS()') === false && strpos($query, 'AUTOCOMMIT') === false) { |
e4f6c7d0 | 90 | $res = self::$mysqli->query("EXPLAIN $query"); |
32d9ae72 | 91 | if ($res) { |
92 | while ($row = $res->fetch_assoc()) { | |
5fb22b39 | 93 | $explain[] = $row; |
94 | } | |
32d9ae72 | 95 | $res->free(); |
5fb22b39 | 96 | } |
f1ca33de | 97 | } |
cd1d4b4f | 98 | PlBacktrace::$bt['MySQL']->start(XDB::reformatQuery($query)); |
f1ca33de | 99 | } |
100 | ||
32d9ae72 | 101 | $res = XDB::$mysqli->query($query); |
0381e170 | 102 | |
81e9c63f | 103 | if ($globals->debug & DEBUG_BT) { |
e4f6c7d0 FB |
104 | PlBacktrace::$bt['MySQL']->stop(@$res->num_rows ? $res->num_rows : self::$mysqli->affected_rows, |
105 | self::$mysqli->error, | |
d3f26be9 | 106 | $explain); |
f1ca33de | 107 | } |
084a60da FB |
108 | |
109 | if ($res === false) { | |
cd1d4b4f | 110 | throw new XDBException(XDB::reformatQuery($query), XDB::$mysqli->error); |
084a60da | 111 | } |
f1ca33de | 112 | return $res; |
113 | } | |
114 | ||
e4f6c7d0 FB |
115 | private static function queryv($query) |
116 | { | |
cd1d4b4f | 117 | return new XDBResult(self::prepare($query)); |
e4f6c7d0 FB |
118 | } |
119 | ||
6995a9b9 | 120 | public static function query() |
0337d704 | 121 | { |
e4f6c7d0 | 122 | return self::queryv(func_get_args()); |
0337d704 | 123 | } |
124 | ||
4c455d70 FB |
125 | public static function rawQuery($query) |
126 | { | |
127 | return new XDBResult($query); | |
128 | } | |
129 | ||
20973bf8 FB |
130 | public static function format() |
131 | { | |
cd1d4b4f | 132 | return self::prepare(func_get_args()); |
20973bf8 FB |
133 | } |
134 | ||
0ef5bd4b FB |
135 | // Produce the SQL statement for setting/unsetting a flag |
136 | public static function changeFlag($fieldname, $flagname, $state) | |
137 | { | |
138 | if ($state) { | |
139 | return XDB::format($fieldname . ' = CONCAT({?}, \',\', ' . $fieldname . ')', $flagname); | |
140 | } else { | |
141 | return XDB::format($fieldname . ' = REPLACE(' . $fieldname . ', {?}, \'\')', $flagname); | |
142 | } | |
143 | } | |
144 | ||
145 | // Produce the SQL statement representing an array | |
146 | public static function formatArray(array $array) | |
147 | { | |
e677bc13 | 148 | return self::escape($array); |
0ef5bd4b FB |
149 | } |
150 | ||
adf947ff RB |
151 | const WILDCARD_EXACT = 0x00; |
152 | const WILDCARD_PREFIX = 0x01; | |
153 | const WILDCARD_SUFFIX = 0x02; | |
154 | const WILDCARD_CONTAINS = 0x03; // WILDCARD_PREFIX | WILDCARD_SUFFIX | |
155 | ||
cd1d4b4f FB |
156 | // Produce a valid XDB argument that get formatted as a wildcard |
157 | // according to the given mode. | |
158 | // | |
159 | // Example: | |
160 | // XDB::query("SELECT * FROM table WHERE field {?}", XDB::wildcard($text, WILDCARD_EXACT)); | |
161 | public static function wildcard($mode, $value) | |
162 | { | |
163 | return new XDBWildcard($value, $mode); | |
164 | } | |
165 | ||
adf947ff RB |
166 | // Returns the SQL statement for a wildcard search. |
167 | public static function formatWildcards($mode, $text) | |
168 | { | |
cd1d4b4f | 169 | return XDB::wildcard($mode, $text)->format(); |
adf947ff RB |
170 | } |
171 | ||
47595f9a RB |
172 | // Returns a FIELD(blah, 3, 1, 2) for use in an order with custom orders |
173 | public static function formatCustomOrder($field, $values) | |
174 | { | |
29bd16df | 175 | return 'FIELD( ' . $field . ', ' . implode(', ', array_map(array('XDB', 'escape'), $values)) . ')'; |
47595f9a RB |
176 | } |
177 | ||
6995a9b9 | 178 | public static function execute() |
f1ca33de | 179 | { |
fe556813 FB |
180 | global $globals; |
181 | $args = func_get_args(); | |
182 | if ($globals->mode != 'rw' && !strpos($args[0], 'logger')) { | |
183 | return; | |
184 | } | |
cd1d4b4f | 185 | return self::run(XDB::prepare($args)); |
0337d704 | 186 | } |
13a25546 | 187 | |
4c455d70 FB |
188 | public static function rawExecute($query) |
189 | { | |
190 | global $globals; | |
191 | if ($globals->mode != 'rw') { | |
192 | return; | |
193 | } | |
194 | return self::run($query); | |
195 | } | |
196 | ||
2e11cb87 | 197 | private static $inTransaction = false; |
e49b22c0 FB |
198 | public static function startTransaction() |
199 | { | |
2e11cb87 FB |
200 | if (self::$inTransaction) { |
201 | throw new XDBException('START TRANSACTION', 'Already in a transaction'); | |
202 | } | |
203 | self::$inTransaction = true; | |
e49b22c0 FB |
204 | self::rawExecute('SET AUTOCOMMIT = 0'); |
205 | self::rawExecute('START TRANSACTION'); | |
206 | } | |
207 | ||
208 | public static function commit() | |
209 | { | |
210 | self::rawExecute('COMMIT'); | |
211 | self::rawExecute('SET AUTOCOMMIT = 1'); | |
2e11cb87 | 212 | self::$inTransaction = false; |
e49b22c0 FB |
213 | } |
214 | ||
215 | public static function rollback() | |
216 | { | |
217 | self::rawExecute('ROLLBACK'); | |
218 | self::rawExecute('SET AUTOCOMMIT = 1'); | |
2e11cb87 | 219 | self::$inTransaction = false; |
e49b22c0 FB |
220 | } |
221 | ||
f23d33e1 FB |
222 | public static function runTransactionV($callback, array $args) |
223 | { | |
224 | self::startTransaction(); | |
225 | try { | |
226 | if (call_user_func_array($callback, $args)) { | |
227 | self::commit(); | |
228 | return true; | |
229 | } else { | |
230 | self::rollback(); | |
231 | return false; | |
232 | } | |
233 | } catch (Exception $e) { | |
234 | self::rollback(); | |
235 | throw $e; | |
236 | } | |
237 | } | |
238 | ||
239 | /** This function takes a callback followed by the arguments to be passed to the callback | |
240 | * as arguments. It starts a transaction and execute the callback. If the callback fails | |
241 | * (return false or raise an exception), the transaction is rollbacked, if the callback | |
242 | * succeeds (return true), the transaction is committed. | |
243 | */ | |
244 | public static function runTransaction() | |
245 | { | |
246 | $args = func_get_args(); | |
247 | $cb = array_shift($args); | |
6305462f | 248 | return self::runTransactionV($cb, $args); |
f23d33e1 FB |
249 | } |
250 | ||
6995a9b9 | 251 | public static function iterator() |
0337d704 | 252 | { |
cd1d4b4f | 253 | return new XDBIterator(self::prepare(func_get_args())); |
0337d704 | 254 | } |
13a25546 | 255 | |
4c455d70 FB |
256 | public static function rawIterator($query) |
257 | { | |
258 | return new XDBIterator($query); | |
259 | } | |
260 | ||
6995a9b9 | 261 | public static function iterRow() |
0337d704 | 262 | { |
cd1d4b4f | 263 | return new XDBIterator(self::prepare(func_get_args()), MYSQL_NUM); |
e4f6c7d0 FB |
264 | } |
265 | ||
4c455d70 FB |
266 | public static function rawIterRow($query) |
267 | { | |
268 | return new XDBIterator($query, MYSQL_NUM); | |
269 | } | |
270 | ||
e4f6c7d0 FB |
271 | private static function findQuery($params, $default = array()) |
272 | { | |
273 | for ($i = 0 ; $i < count($default) ; ++$i) { | |
274 | $is_query = false; | |
275 | foreach (array('insert', 'select', 'replace', 'delete', 'update') as $kwd) { | |
276 | if (stripos($params[0], $kwd) !== false) { | |
277 | $is_query = true; | |
278 | break; | |
279 | } | |
280 | } | |
281 | if ($is_query) { | |
282 | break; | |
283 | } else { | |
284 | $default[$i] = array_shift($params); | |
285 | } | |
286 | } | |
287 | return array($default, $params); | |
288 | } | |
289 | ||
290 | /** Fetch all rows returned by the given query. | |
cd1d4b4f | 291 | * This functions can take 2 optional arguments (cf XDBResult::fetchAllRow()). |
e4f6c7d0 FB |
292 | * Optional arguments are given *before* the query. |
293 | */ | |
294 | public static function fetchAllRow() | |
295 | { | |
296 | list($args, $query) = self::findQuery(func_get_args(), array(false, false)); | |
297 | return self::queryv($query)->fetchAllRow($args[0], $args[1]); | |
298 | } | |
299 | ||
dec6c3bd FB |
300 | public static function rawFetchAllRow($query, $id = false, $keep_array = false) |
301 | { | |
302 | return self::rawQuery($query)->fetchAllRow($id, $keep_array); | |
303 | } | |
304 | ||
e4f6c7d0 | 305 | /** Fetch all rows returned by the given query. |
cd1d4b4f | 306 | * This functions can take 2 optional arguments (cf XDBResult::fetchAllAssoc()). |
e4f6c7d0 FB |
307 | * Optional arguments are given *before* the query. |
308 | */ | |
309 | public static function fetchAllAssoc() | |
310 | { | |
311 | list($args, $query) = self::findQuery(func_get_args(), array(false, false)); | |
312 | return self::queryv($query)->fetchAllAssoc($args[0], $args[1]); | |
313 | } | |
314 | ||
dec6c3bd FB |
315 | public static function rawFetchAllAssoc($query, $id = false, $keep_array = false) |
316 | { | |
317 | return self::rawQuery($query)->fetchAllAssoc($id, $keep_array); | |
318 | } | |
319 | ||
e4f6c7d0 FB |
320 | public static function fetchOneCell() |
321 | { | |
322 | list($args, $query) = self::findQuery(func_get_args()); | |
323 | return self::queryv($query)->fetchOneCell(); | |
324 | } | |
325 | ||
dec6c3bd FB |
326 | public static function rawFetchOneCell($query) |
327 | { | |
328 | return self::rawQuery($query)->fetchOneCell(); | |
329 | } | |
330 | ||
e4f6c7d0 FB |
331 | public static function fetchOneRow() |
332 | { | |
333 | list($args, $query) = self::findQuery(func_get_args()); | |
334 | return self::queryv($query)->fetchOneRow(); | |
335 | } | |
336 | ||
dec6c3bd FB |
337 | public static function rawFetchOneRow($query) |
338 | { | |
339 | return self::rawQuery($query)->fetchOneRow(); | |
340 | } | |
341 | ||
e4f6c7d0 FB |
342 | public static function fetchOneAssoc() |
343 | { | |
344 | list($args, $query) = self::findQuery(func_get_args()); | |
345 | return self::queryv($query)->fetchOneAssoc(); | |
346 | } | |
347 | ||
dec6c3bd FB |
348 | public static function rawFetchOneAssoc($query) |
349 | { | |
350 | return self::rawQuery($query)->fetchOneAssoc(); | |
351 | } | |
352 | ||
e4f6c7d0 | 353 | /** Fetch a column from the result of the given query. |
cd1d4b4f | 354 | * This functions can take 1 optional arguments (cf XDBResult::fetchColumn()). |
e4f6c7d0 FB |
355 | * Optional arguments are given *before* the query. |
356 | */ | |
357 | public static function fetchColumn() | |
358 | { | |
359 | list($args, $query) = self::findQuery(func_get_args(), array(0)); | |
dec6c3bd FB |
360 | return self::queryv($query)->fetchColumn($args[0]); |
361 | } | |
362 | ||
363 | public static function rawFetchColumn($query, $key = 0) | |
364 | { | |
365 | return self::rawQuery($query)->fetchColumn($key); | |
0337d704 | 366 | } |
13a25546 | 367 | |
6995a9b9 | 368 | public static function insertId() |
13a25546 | 369 | { |
e4f6c7d0 | 370 | return self::$mysqli->insert_id; |
13a25546 | 371 | } |
372 | ||
0380bf85 | 373 | public static function errno() |
374 | { | |
e4f6c7d0 | 375 | return self::$mysqli->errno; |
0380bf85 | 376 | } |
377 | ||
378 | public static function error() | |
834fd0f6 | 379 | { |
e4f6c7d0 | 380 | return self::$mysqli->error; |
0380bf85 | 381 | } |
382 | ||
383 | public static function affectedRows() | |
384 | { | |
e4f6c7d0 | 385 | return self::$mysqli->affected_rows; |
0380bf85 | 386 | } |
387 | ||
f62bd784 | 388 | public static function escape($var) |
0337d704 | 389 | { |
390 | switch (gettype($var)) { | |
13a25546 | 391 | case 'boolean': |
392 | return $var ? 1 : 0; | |
393 | ||
394 | case 'integer': | |
395 | case 'double': | |
396 | case 'float': | |
397 | return $var; | |
398 | ||
399 | case 'string': | |
400 | return "'".addslashes($var)."'"; | |
401 | ||
402 | case 'NULL': | |
403 | return 'NULL'; | |
404 | ||
405 | case 'object': | |
cd1d4b4f FB |
406 | if ($var instanceof XDBFormat) { |
407 | return $var->format(); | |
e677bc13 FB |
408 | } else { |
409 | return "'".addslashes(serialize($var))."'"; | |
04c1b2eb | 410 | } |
e677bc13 | 411 | |
13a25546 | 412 | case 'array': |
e677bc13 | 413 | return '(' . implode(', ', array_map(array('XDB', 'escape'), $var)) . ')'; |
13a25546 | 414 | |
415 | default: | |
416 | die(var_export($var, true).' is not a valid for a database entry'); | |
0337d704 | 417 | } |
418 | } | |
0337d704 | 419 | } |
420 | ||
cd1d4b4f | 421 | class XDBException extends PlException |
0337d704 | 422 | { |
cd1d4b4f FB |
423 | public function __construct($query, $error) |
424 | { | |
425 | if (strpos($query, 'INSERT') === false && strpos($query, 'UPDATE') === false | |
426 | && strpos($query, 'REPLACE') === false && strpos($query, 'DELETE') === false) { | |
427 | $text = 'Erreur lors de l\'interrogation de la base de données'; | |
428 | } else { | |
429 | $text = 'Erreur lors de l\'écriture dans la base de données'; | |
430 | } | |
431 | parent::__construct($text, $query . "\n" . $error); | |
432 | } | |
433 | } | |
434 | ||
435 | interface XDBFormat | |
436 | { | |
437 | public function format(); | |
438 | } | |
0337d704 | 439 | |
cd1d4b4f FB |
440 | class XDBWildcard implements XDBFormat |
441 | { | |
442 | private $value; | |
443 | private $mode; | |
444 | ||
445 | public function __construct($value, $mode) | |
446 | { | |
447 | $this->value = $value; | |
448 | $this->mode = $mode; | |
449 | } | |
450 | ||
451 | public function format() | |
452 | { | |
453 | if ($this->mode == XDB::WILDCARD_EXACT) { | |
454 | return XDB::format(' = {?}', $this->value); | |
455 | } else { | |
456 | $text = str_replace(array('%', '_'), array('\%', '\_'), $this->value); | |
457 | if ($this->mode & XDB::WILDCARD_PREFIX) { | |
458 | $text = $text . '%'; | |
459 | } | |
460 | if ($this->mode & XDB::WILDCARD_SUFFIX) { | |
461 | $text = '%' . $text; | |
462 | } | |
463 | return XDB::format(" LIKE {?}", $text); | |
464 | } | |
465 | } | |
466 | } | |
467 | ||
468 | ||
469 | class XDBResult | |
470 | { | |
471 | private $res; | |
0337d704 | 472 | |
0381e170 | 473 | public function __construct($query) |
0337d704 | 474 | { |
cd1d4b4f | 475 | $this->res = XDB::run($query); |
0337d704 | 476 | } |
477 | ||
0381e170 | 478 | public function free() |
0337d704 | 479 | { |
cd1d4b4f FB |
480 | if ($this->res) { |
481 | $this->res->free(); | |
0381e170 | 482 | } |
0337d704 | 483 | unset($this); |
484 | } | |
485 | ||
cd1d4b4f | 486 | protected function fetchRow() |
0337d704 | 487 | { |
cd1d4b4f | 488 | return $this->res ? $this->res->fetch_row() : null; |
0337d704 | 489 | } |
490 | ||
cd1d4b4f | 491 | protected function fetchAssoc() |
0337d704 | 492 | { |
cd1d4b4f | 493 | return $this->res ? $this->res->fetch_assoc() : null; |
0337d704 | 494 | } |
495 | ||
e4f6c7d0 | 496 | public function fetchAllRow($id = false, $keep_array = false) |
0337d704 | 497 | { |
498 | $result = Array(); | |
cd1d4b4f | 499 | if (!$this->res) { |
0381e170 | 500 | return $result; |
501 | } | |
cd1d4b4f | 502 | while (($data = $this->res->fetch_row())) { |
e4f6c7d0 FB |
503 | if ($id !== false) { |
504 | $key = $data[$id]; | |
505 | unset($data[$id]); | |
506 | if (!$keep_array && count($data) == 1) { | |
507 | reset($data); | |
508 | $result[$key] = current($data); | |
509 | } else { | |
510 | $result[$key] = $data; | |
511 | } | |
512 | } else { | |
513 | $result[] = $data; | |
514 | } | |
515 | } | |
0337d704 | 516 | $this->free(); |
517 | return $result; | |
518 | } | |
519 | ||
e4f6c7d0 | 520 | public function fetchAllAssoc($id = false, $keep_array = false) |
0337d704 | 521 | { |
522 | $result = Array(); | |
cd1d4b4f | 523 | if (!$this->res) { |
0381e170 | 524 | return $result; |
525 | } | |
cd1d4b4f | 526 | while (($data = $this->res->fetch_assoc())) { |
e4f6c7d0 FB |
527 | if ($id !== false) { |
528 | $key = $data[$id]; | |
529 | unset($data[$id]); | |
530 | if (!$keep_array && count($data) == 1) { | |
531 | reset($data); | |
532 | $result[$key] = current($data); | |
533 | } else { | |
534 | $result[$key] = $data; | |
535 | } | |
536 | } else { | |
537 | $result[] = $data; | |
538 | } | |
539 | } | |
0337d704 | 540 | $this->free(); |
541 | return $result; | |
542 | } | |
543 | ||
0381e170 | 544 | public function fetchOneAssoc() |
0337d704 | 545 | { |
cd1d4b4f | 546 | $tmp = $this->fetchAssoc(); |
0337d704 | 547 | $this->free(); |
548 | return $tmp; | |
549 | } | |
550 | ||
0381e170 | 551 | public function fetchOneRow() |
0337d704 | 552 | { |
cd1d4b4f | 553 | $tmp = $this->fetchRow(); |
0337d704 | 554 | $this->free(); |
555 | return $tmp; | |
556 | } | |
557 | ||
0381e170 | 558 | public function fetchOneCell() |
0337d704 | 559 | { |
cd1d4b4f | 560 | $tmp = $this->fetchRow(); |
0337d704 | 561 | $this->free(); |
562 | return $tmp[0]; | |
563 | } | |
564 | ||
0381e170 | 565 | public function fetchColumn($key = 0) |
0337d704 | 566 | { |
567 | $res = Array(); | |
568 | if (is_numeric($key)) { | |
cd1d4b4f | 569 | while($tmp = $this->fetchRow()) { |
0337d704 | 570 | $res[] = $tmp[$key]; |
571 | } | |
572 | } else { | |
cd1d4b4f | 573 | while($tmp = $this->fetchAssoc()) { |
0337d704 | 574 | $res[] = $tmp[$key]; |
575 | } | |
576 | } | |
577 | $this->free(); | |
578 | return $res; | |
579 | } | |
580 | ||
0381e170 | 581 | public function fetchOneField() |
0380bf85 | 582 | { |
cd1d4b4f | 583 | return $this->res ? $this->res->fetch_field() : null; |
0380bf85 | 584 | } |
585 | ||
0381e170 | 586 | public function fetchFields() |
0380bf85 | 587 | { |
588 | $res = array(); | |
589 | while ($res[] = $this->fetchOneField()); | |
590 | return $res; | |
591 | } | |
592 | ||
0381e170 | 593 | public function numRows() |
0337d704 | 594 | { |
cd1d4b4f | 595 | return $this->res ? $this->res->num_rows : 0; |
0337d704 | 596 | } |
0380bf85 | 597 | |
0381e170 | 598 | public function fieldCount() |
0380bf85 | 599 | { |
cd1d4b4f | 600 | return $this->res ? $this->res->field_count : 0; |
0380bf85 | 601 | } |
0337d704 | 602 | } |
603 | ||
2b1ee50b | 604 | |
cd1d4b4f | 605 | class XDBIterator extends XDBResult implements PlIterator |
0337d704 | 606 | { |
cd1d4b4f FB |
607 | private $result; |
608 | private $pos; | |
609 | private $total; | |
610 | private $fpos; | |
611 | private $fields; | |
612 | private $mode = MYSQL_ASSOC; | |
0337d704 | 613 | |
0381e170 | 614 | public function __construct($query, $mode = MYSQL_ASSOC) |
0337d704 | 615 | { |
0381e170 | 616 | parent::__construct($query); |
cd1d4b4f FB |
617 | $this->pos = 0; |
618 | $this->total = $this->numRows(); | |
619 | $this->fpost = 0; | |
620 | $this->fields = $this->fieldCount(); | |
621 | $this->mode = $mode; | |
0337d704 | 622 | } |
623 | ||
0381e170 | 624 | public function next() |
0337d704 | 625 | { |
cd1d4b4f FB |
626 | $this->pos ++; |
627 | if ($this->pos > $this->total) { | |
0381e170 | 628 | $this->free(); |
0337d704 | 629 | unset($this); |
630 | return null; | |
631 | } | |
cd1d4b4f | 632 | return $this->mode != MYSQL_ASSOC ? $this->fetchRow() : $this->fetchAssoc(); |
0337d704 | 633 | } |
634 | ||
0381e170 | 635 | public function first() |
0337d704 | 636 | { |
cd1d4b4f | 637 | return $this->pos == 1; |
0337d704 | 638 | } |
639 | ||
0381e170 | 640 | public function last() |
0337d704 | 641 | { |
cd1d4b4f | 642 | return $this->pos == $this->total; |
0337d704 | 643 | } |
644 | ||
0381e170 | 645 | public function total() |
0337d704 | 646 | { |
cd1d4b4f | 647 | return $this->total; |
0337d704 | 648 | } |
0380bf85 | 649 | |
0381e170 | 650 | public function nextField() |
0380bf85 | 651 | { |
cd1d4b4f FB |
652 | $this->fpos++; |
653 | if ($this->fpos > $this->fields) { | |
0380bf85 | 654 | return null; |
655 | } | |
0381e170 | 656 | return $this->fetchOneField(); |
0380bf85 | 657 | } |
658 | ||
0381e170 | 659 | public function firstField() |
0380bf85 | 660 | { |
cd1d4b4f | 661 | return $this->fpos == 1; |
0380bf85 | 662 | } |
663 | ||
0381e170 | 664 | public function lastField() |
0380bf85 | 665 | { |
cd1d4b4f | 666 | return $this->fpos == $this->fields; |
0380bf85 | 667 | } |
668 | ||
0381e170 | 669 | public function totalFields() |
0380bf85 | 670 | { |
cd1d4b4f | 671 | return $this->fields; |
0380bf85 | 672 | } |
0337d704 | 673 | } |
674 | ||
a7de4ef7 | 675 | // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: |
0337d704 | 676 | ?> |