1 /*
2 +----------------------------------------------------------------------+
3 | PHP Version 5 |
4 +----------------------------------------------------------------------+
5 | Copyright (c) 1997-2014 The PHP Group |
6 +----------------------------------------------------------------------+
7 | This source file is subject to version 3.01 of the PHP license, |
8 | that is bundled with this package in the file LICENSE, and is |
9 | available through the world-wide-web at the following url: |
10 | http://www.php.net/license/3_01.txt |
11 | If you did not receive a copy of the PHP license and are unable to |
12 | obtain it through the world-wide-web, please send a note to |
13 | license@php.net so we can mail you a copy immediately. |
14 +----------------------------------------------------------------------+
15 | Authors: Scott MacVicar <scottmac@php.net> |
16 +----------------------------------------------------------------------+
17 */
18
19 /* $Id$ */
20
21 #ifdef HAVE_CONFIG_H
22 #include "config.h"
23 #endif
24
25 #include "php.h"
26 #include "php_ini.h"
27 #include "ext/standard/info.h"
28 #include "php_sqlite3.h"
29 #include "php_sqlite3_structs.h"
30 #include "main/SAPI.h"
31
32 #include <sqlite3.h>
33
34 #include "zend_exceptions.h"
35 #include "zend_interfaces.h"
36 #include "SAPI.h"
37
38 ZEND_DECLARE_MODULE_GLOBALS(sqlite3)
39
40 static PHP_GINIT_FUNCTION(sqlite3);
41 static int php_sqlite3_authorizer(void *autharg, int access_type, const char *arg3, const char *arg4, const char *arg5, const char *arg6);
42 static void sqlite3_param_dtor(void *data);
43 static int php_sqlite3_compare_stmt_zval_free(php_sqlite3_free_list **free_list, zval *statement);
44
45 /* {{{ Error Handler
46 */
php_sqlite3_error(php_sqlite3_db_object * db_obj,char * format,...)47 static void php_sqlite3_error(php_sqlite3_db_object *db_obj, char *format, ...)
48 {
49 va_list arg;
50 char *message;
51 TSRMLS_FETCH();
52
53 va_start(arg, format);
54 vspprintf(&message, 0, format, arg);
55 va_end(arg);
56
57 if (db_obj->exception) {
58 zend_throw_exception(zend_exception_get_default(TSRMLS_C), message, 0 TSRMLS_CC);
59 } else {
60 php_error_docref(NULL TSRMLS_CC, E_WARNING, "%s", message);
61 }
62
63 if (message) {
64 efree(message);
65 }
66 }
67 /* }}} */
68
69 #define SQLITE3_CHECK_INITIALIZED(db_obj, member, class_name) \
70 if (!(member)) { \
71 php_sqlite3_error(db_obj, "The " #class_name " object has not been correctly initialised"); \
72 RETURN_FALSE; \
73 }
74
75 /* {{{ PHP_INI
76 */
77 PHP_INI_BEGIN()
78 STD_PHP_INI_ENTRY("sqlite3.extension_dir", NULL, PHP_INI_SYSTEM, OnUpdateString, extension_dir, zend_sqlite3_globals, sqlite3_globals)
79 PHP_INI_END()
80 /* }}} */
81
82 /* Handlers */
83 static zend_object_handlers sqlite3_object_handlers;
84 static zend_object_handlers sqlite3_stmt_object_handlers;
85 static zend_object_handlers sqlite3_result_object_handlers;
86
87 /* Class entries */
88 zend_class_entry *php_sqlite3_sc_entry;
89 zend_class_entry *php_sqlite3_stmt_entry;
90 zend_class_entry *php_sqlite3_result_entry;
91
92 /* {{{ proto void SQLite3::open(String filename [, int Flags [, string Encryption Key]])
93 Opens a SQLite 3 Database, if the build includes encryption then it will attempt to use the key. */
PHP_METHOD(sqlite3,open)94 PHP_METHOD(sqlite3, open)
95 {
96 php_sqlite3_db_object *db_obj;
97 zval *object = getThis();
98 char *filename, *encryption_key, *fullpath;
99 int filename_len, encryption_key_len = 0;
100 long flags = SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE;
101 zend_error_handling error_handling;
102
103 db_obj = (php_sqlite3_db_object *)zend_object_store_get_object(object TSRMLS_CC);
104 zend_replace_error_handling(EH_THROW, NULL, &error_handling TSRMLS_CC);
105
106 if (FAILURE == zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "p|ls", &filename, &filename_len, &flags, &encryption_key, &encryption_key_len)) {
107 zend_restore_error_handling(&error_handling TSRMLS_CC);
108 return;
109 }
110
111 zend_restore_error_handling(&error_handling TSRMLS_CC);
112
113 if (db_obj->initialised) {
114 zend_throw_exception(zend_exception_get_default(TSRMLS_C), "Already initialised DB Object", 0 TSRMLS_CC);
115 }
116
117 if (strlen(filename) != filename_len) {
118 return;
119 }
120 if (memcmp(filename, ":memory:", sizeof(":memory:")) != 0) {
121 if (!(fullpath = expand_filepath(filename, NULL TSRMLS_CC))) {
122 zend_throw_exception(zend_exception_get_default(TSRMLS_C), "Unable to expand filepath", 0 TSRMLS_CC);
123 return;
124 }
125
126 #if PHP_API_VERSION < 20100412
127 if (PG(safe_mode) && (!php_checkuid(fullpath, NULL, CHECKUID_CHECK_FILE_AND_DIR))) {
128 zend_throw_exception_ex(zend_exception_get_default(TSRMLS_C), 0 TSRMLS_CC, "safe_mode prohibits opening %s", fullpath);
129 efree(fullpath);
130 return;
131 }
132 #endif
133
134 if (php_check_open_basedir(fullpath TSRMLS_CC)) {
135 zend_throw_exception_ex(zend_exception_get_default(TSRMLS_C), 0 TSRMLS_CC, "open_basedir prohibits opening %s", fullpath);
136 efree(fullpath);
137 return;
138 }
139 } else {
140 fullpath = estrdup(filename);
141 }
142
143 #if SQLITE_VERSION_NUMBER >= 3005000
144 if (sqlite3_open_v2(fullpath, &(db_obj->db), flags, NULL) != SQLITE_OK) {
145 #else
146 if (sqlite3_open(fullpath, &(db_obj->db)) != SQLITE_OK) {
147 #endif
148 zend_throw_exception_ex(zend_exception_get_default(TSRMLS_C), 0 TSRMLS_CC, "Unable to open database: %s", sqlite3_errmsg(db_obj->db));
149 if (fullpath) {
150 efree(fullpath);
151 }
152 return;
153 }
154
155 #if SQLITE_HAS_CODEC
156 if (encryption_key_len > 0) {
157 if (sqlite3_key(db_obj->db, encryption_key, encryption_key_len) != SQLITE_OK) {
158 zend_throw_exception_ex(zend_exception_get_default(TSRMLS_C), 0 TSRMLS_CC, "Unable to open database: %s", sqlite3_errmsg(db_obj->db));
159 return;
160 }
161 }
162 #endif
163
164 db_obj->initialised = 1;
165
166 #if PHP_API_VERSION < 20100412
167 if (PG(safe_mode) || (PG(open_basedir) && *PG(open_basedir))) {
168 #else
169 if (PG(open_basedir) && *PG(open_basedir)) {
170 #endif
171 sqlite3_set_authorizer(db_obj->db, php_sqlite3_authorizer, NULL);
172 }
173
174 if (fullpath) {
175 efree(fullpath);
176 }
177 }
178 /* }}} */
179
180 /* {{{ proto bool SQLite3::close()
181 Close a SQLite 3 Database. */
182 PHP_METHOD(sqlite3, close)
183 {
184 php_sqlite3_db_object *db_obj;
185 zval *object = getThis();
186 int errcode;
187 db_obj = (php_sqlite3_db_object *)zend_object_store_get_object(object TSRMLS_CC);
188
189 if (zend_parse_parameters_none() == FAILURE) {
190 return;
191 }
192
193 if (db_obj->initialised) {
194 zend_llist_clean(&(db_obj->free_list));
195 errcode = sqlite3_close(db_obj->db);
196 if (errcode != SQLITE_OK) {
197 php_sqlite3_error(db_obj, "Unable to close database: %d, %s", errcode, sqlite3_errmsg(db_obj->db));
198 RETURN_FALSE;
199 }
200 db_obj->initialised = 0;
201 }
202
203 RETURN_TRUE;
204 }
205 /* }}} */
206
207 /* {{{ proto bool SQLite3::exec(String Query)
208 Executes a result-less query against a given database. */
209 PHP_METHOD(sqlite3, exec)
210 {
211 php_sqlite3_db_object *db_obj;
212 zval *object = getThis();
213 char *sql, *errtext = NULL;
214 int sql_len;
215 db_obj = (php_sqlite3_db_object *)zend_object_store_get_object(object TSRMLS_CC);
216
217 SQLITE3_CHECK_INITIALIZED(db_obj, db_obj->initialised, SQLite3)
218
219 if (FAILURE == zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "s", &sql, &sql_len)) {
220 return;
221 }
222
223 if (sqlite3_exec(db_obj->db, sql, NULL, NULL, &errtext) != SQLITE_OK) {
224 php_sqlite3_error(db_obj, "%s", errtext);
225 sqlite3_free(errtext);
226 RETURN_FALSE;
227 }
228
229 RETURN_TRUE;
230 }
231 /* }}} */
232
233 /* {{{ proto Array SQLite3::version()
234 Returns the SQLite3 Library version as a string constant and as a number. */
235 PHP_METHOD(sqlite3, version)
236 {
237 if (zend_parse_parameters_none() == FAILURE) {
238 return;
239 }
240
241 array_init(return_value);
242
243 add_assoc_string(return_value, "versionString", (char*)sqlite3_libversion(), 1);
244 add_assoc_long(return_value, "versionNumber", sqlite3_libversion_number());
245
246 return;
247 }
248 /* }}} */
249
250 /* {{{ proto int SQLite3::lastInsertRowID()
251 Returns the rowid of the most recent INSERT into the database from the database connection. */
252 PHP_METHOD(sqlite3, lastInsertRowID)
253 {
254 php_sqlite3_db_object *db_obj;
255 zval *object = getThis();
256 db_obj = (php_sqlite3_db_object *)zend_object_store_get_object(object TSRMLS_CC);
257
258 SQLITE3_CHECK_INITIALIZED(db_obj, db_obj->initialised, SQLite3)
259
260 if (zend_parse_parameters_none() == FAILURE) {
261 return;
262 }
263
264 RETURN_LONG(sqlite3_last_insert_rowid(db_obj->db));
265 }
266 /* }}} */
267
268 /* {{{ proto int SQLite3::lastErrorCode()
269 Returns the numeric result code of the most recent failed sqlite API call for the database connection. */
270 PHP_METHOD(sqlite3, lastErrorCode)
271 {
272 php_sqlite3_db_object *db_obj;
273 zval *object = getThis();
274 db_obj = (php_sqlite3_db_object *)zend_object_store_get_object(object TSRMLS_CC);
275
276 SQLITE3_CHECK_INITIALIZED(db_obj, db_obj->db, SQLite3)
277
278 if (zend_parse_parameters_none() == FAILURE) {
279 return;
280 }
281
282 RETURN_LONG(sqlite3_errcode(db_obj->db));
283 }
284 /* }}} */
285
286 /* {{{ proto string SQLite3::lastErrorMsg()
287 Returns english text describing the most recent failed sqlite API call for the database connection. */
288 PHP_METHOD(sqlite3, lastErrorMsg)
289 {
290 php_sqlite3_db_object *db_obj;
291 zval *object = getThis();
292 db_obj = (php_sqlite3_db_object *)zend_object_store_get_object(object TSRMLS_CC);
293
294 SQLITE3_CHECK_INITIALIZED(db_obj, db_obj->db, SQLite3)
295
296 if (zend_parse_parameters_none() == FAILURE) {
297 return;
298 }
299
300 RETVAL_STRING((char *)sqlite3_errmsg(db_obj->db), 1);
301 }
302 /* }}} */
303
304 /* {{{ proto bool SQLite3::busyTimeout(int msecs)
305 Sets a busy handler that will sleep until database is not locked or timeout is reached. Passing a value less than or equal to zero turns off all busy handlers. */
306 PHP_METHOD(sqlite3, busyTimeout)
307 {
308 php_sqlite3_db_object *db_obj;
309 zval *object = getThis();
310 long ms;
311 int return_code;
312 db_obj = (php_sqlite3_db_object *)zend_object_store_get_object(object TSRMLS_CC);
313
314 SQLITE3_CHECK_INITIALIZED(db_obj, db_obj->initialised, SQLite3)
315
316 if (FAILURE == zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "l", &ms)) {
317 return;
318 }
319
320 return_code = sqlite3_busy_timeout(db_obj->db, ms);
321 if (return_code != SQLITE_OK) {
322 php_sqlite3_error(db_obj, "Unable to set busy timeout: %d, %s", return_code, sqlite3_errmsg(db_obj->db));
323 RETURN_FALSE;
324 }
325
326 RETURN_TRUE;
327 }
328 /* }}} */
329
330
331 #ifndef SQLITE_OMIT_LOAD_EXTENSION
332 /* {{{ proto bool SQLite3::loadExtension(String Shared Library)
333 Attempts to load an SQLite extension library. */
334 PHP_METHOD(sqlite3, loadExtension)
335 {
336 php_sqlite3_db_object *db_obj;
337 zval *object = getThis();
338 char *extension, *lib_path, *extension_dir, *errtext = NULL;
339 char fullpath[MAXPATHLEN];
340 int extension_len, extension_dir_len;
341 db_obj = (php_sqlite3_db_object *)zend_object_store_get_object(object TSRMLS_CC);
342
343 SQLITE3_CHECK_INITIALIZED(db_obj, db_obj->initialised, SQLite3)
344
345 if (FAILURE == zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "s", &extension, &extension_len)) {
346 return;
347 }
348
349 #ifdef ZTS
350 if ((strncmp(sapi_module.name, "cgi", 3) != 0) &&
351 (strcmp(sapi_module.name, "cli") != 0) &&
352 (strncmp(sapi_module.name, "embed", 5) != 0)
353 ) { php_sqlite3_error(db_obj, "Not supported in multithreaded Web servers");
354 RETURN_FALSE;
355 }
356 #endif
357
358 if (!SQLITE3G(extension_dir)) {
359 php_sqlite3_error(db_obj, "SQLite Extension are disabled");
360 RETURN_FALSE;
361 }
362
363 if (extension_len == 0) {
364 php_sqlite3_error(db_obj, "Empty string as an extension");
365 RETURN_FALSE;
366 }
367
368 extension_dir = SQLITE3G(extension_dir);
369 extension_dir_len = strlen(SQLITE3G(extension_dir));
370
371 if (IS_SLASH(extension_dir[extension_dir_len-1])) {
372 spprintf(&lib_path, 0, "%s%s", extension_dir, extension);
373 } else {
374 spprintf(&lib_path, 0, "%s%c%s", extension_dir, DEFAULT_SLASH, extension);
375 }
376
377 if (!VCWD_REALPATH(lib_path, fullpath)) {
378 php_sqlite3_error(db_obj, "Unable to load extension at '%s'", lib_path);
379 efree(lib_path);
380 RETURN_FALSE;
381 }
382
383 efree(lib_path);
384
385 if (strncmp(fullpath, extension_dir, extension_dir_len) != 0) {
386 php_sqlite3_error(db_obj, "Unable to open extensions outside the defined directory");
387 RETURN_FALSE;
388 }
389
390 /* Extension loading should only be enabled for when we attempt to load */
391 sqlite3_enable_load_extension(db_obj->db, 1);
392 if (sqlite3_load_extension(db_obj->db, fullpath, 0, &errtext) != SQLITE_OK) {
393 php_sqlite3_error(db_obj, "%s", errtext);
394 sqlite3_free(errtext);
395 sqlite3_enable_load_extension(db_obj->db, 0);
396 RETURN_FALSE;
397 }
398 sqlite3_enable_load_extension(db_obj->db, 0);
399
400 RETURN_TRUE;
401 }
402 /* }}} */
403 #endif
404
405 /* {{{ proto int SQLite3::changes()
406 Returns the number of database rows that were changed (or inserted or deleted) by the most recent SQL statement. */
407 PHP_METHOD(sqlite3, changes)
408 {
409 php_sqlite3_db_object *db_obj;
410 zval *object = getThis();
411 db_obj = (php_sqlite3_db_object *)zend_object_store_get_object(object TSRMLS_CC);
412
413 SQLITE3_CHECK_INITIALIZED(db_obj, db_obj->initialised, SQLite3)
414
415 if (zend_parse_parameters_none() == FAILURE) {
416 return;
417 }
418
419 RETURN_LONG(sqlite3_changes(db_obj->db));
420 }
421 /* }}} */
422
423 /* {{{ proto String SQLite3::escapeString(String value)
424 Returns a string that has been properly escaped. */
425 PHP_METHOD(sqlite3, escapeString)
426 {
427 char *sql, *ret;
428 int sql_len;
429
430 if (FAILURE == zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "s", &sql, &sql_len)) {
431 return;
432 }
433
434 if (sql_len) {
435 ret = sqlite3_mprintf("%q", sql);
436 if (ret) {
437 RETVAL_STRING(ret, 1);
438 sqlite3_free(ret);
439 }
440 } else {
441 RETURN_EMPTY_STRING();
442 }
443 }
444 /* }}} */
445
446 /* {{{ proto SQLite3Stmt SQLite3::prepare(String Query)
447 Returns a prepared SQL statement for execution. */
448 PHP_METHOD(sqlite3, prepare)
449 {
450 php_sqlite3_db_object *db_obj;
451 php_sqlite3_stmt *stmt_obj;
452 zval *object = getThis();
453 char *sql;
454 int sql_len, errcode;
455 php_sqlite3_free_list *free_item;
456
457 db_obj = (php_sqlite3_db_object *)zend_object_store_get_object(object TSRMLS_CC);
458
459 SQLITE3_CHECK_INITIALIZED(db_obj, db_obj->initialised, SQLite3)
460
461 if (FAILURE == zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "s", &sql, &sql_len)) {
462 return;
463 }
464
465 if (!sql_len) {
466 RETURN_FALSE;
467 }
468
469 object_init_ex(return_value, php_sqlite3_stmt_entry);
470 stmt_obj = (php_sqlite3_stmt *)zend_object_store_get_object(return_value TSRMLS_CC);
471 stmt_obj->db_obj = db_obj;
472 stmt_obj->db_obj_zval = getThis();
473
474 Z_ADDREF_P(object);
475
476 errcode = sqlite3_prepare_v2(db_obj->db, sql, sql_len, &(stmt_obj->stmt), NULL);
477 if (errcode != SQLITE_OK) {
478 php_sqlite3_error(db_obj, "Unable to prepare statement: %d, %s", errcode, sqlite3_errmsg(db_obj->db));
479 zval_dtor(return_value);
480 RETURN_FALSE;
481 }
482
483 stmt_obj->initialised = 1;
484
485 free_item = emalloc(sizeof(php_sqlite3_free_list));
486 free_item->stmt_obj = stmt_obj;
487 free_item->stmt_obj_zval = return_value;
488
489 zend_llist_add_element(&(db_obj->free_list), &free_item);
490 }
491 /* }}} */
492
493 /* {{{ proto SQLite3Result SQLite3::query(String Query)
494 Returns true or false, for queries that return data it will return a SQLite3Result object. */
495 PHP_METHOD(sqlite3, query)
496 {
497 php_sqlite3_db_object *db_obj;
498 php_sqlite3_result *result;
499 php_sqlite3_stmt *stmt_obj;
500 zval *object = getThis();
501 zval *stmt = NULL;
502 char *sql, *errtext = NULL;
503 int sql_len, return_code;
504 db_obj = (php_sqlite3_db_object *)zend_object_store_get_object(object TSRMLS_CC);
505
506 SQLITE3_CHECK_INITIALIZED(db_obj, db_obj->initialised, SQLite3)
507
508 if (FAILURE == zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "s", &sql, &sql_len)) {
509 return;
510 }
511
512 if (!sql_len) {
513 RETURN_FALSE;
514 }
515
516 /* If there was no return value then just execute the query */
517 if (!return_value_used) {
518 if (sqlite3_exec(db_obj->db, sql, NULL, NULL, &errtext) != SQLITE_OK) {
519 php_sqlite3_error(db_obj, "%s", errtext);
520 sqlite3_free(errtext);
521 }
522 return;
523 }
524
525 MAKE_STD_ZVAL(stmt);
526
527 object_init_ex(stmt, php_sqlite3_stmt_entry);
528 stmt_obj = (php_sqlite3_stmt *)zend_object_store_get_object(stmt TSRMLS_CC);
529 stmt_obj->db_obj = db_obj;
530 stmt_obj->db_obj_zval = getThis();
531
532 Z_ADDREF_P(object);
533
534 return_code = sqlite3_prepare_v2(db_obj->db, sql, sql_len, &(stmt_obj->stmt), NULL);
535 if (return_code != SQLITE_OK) {
536 php_sqlite3_error(db_obj, "Unable to prepare statement: %d, %s", return_code, sqlite3_errmsg(db_obj->db));
537 zval_ptr_dtor(&stmt);
538 RETURN_FALSE;
539 }
540
541 stmt_obj->initialised = 1;
542
543 object_init_ex(return_value, php_sqlite3_result_entry);
544 result = (php_sqlite3_result *)zend_object_store_get_object(return_value TSRMLS_CC);
545 result->db_obj = db_obj;
546 result->stmt_obj = stmt_obj;
547 result->stmt_obj_zval = stmt;
548
549 return_code = sqlite3_step(result->stmt_obj->stmt);
550
551 switch (return_code) {
552 case SQLITE_ROW: /* Valid Row */
553 case SQLITE_DONE: /* Valid but no results */
554 {
555 php_sqlite3_free_list *free_item;
556 free_item = emalloc(sizeof(php_sqlite3_free_list));
557 free_item->stmt_obj = stmt_obj;
558 free_item->stmt_obj_zval = stmt;
559 zend_llist_add_element(&(db_obj->free_list), &free_item);
560 sqlite3_reset(result->stmt_obj->stmt);
561 break;
562 }
563 default:
564 php_sqlite3_error(db_obj, "Unable to execute statement: %s", sqlite3_errmsg(db_obj->db));
565 sqlite3_finalize(stmt_obj->stmt);
566 stmt_obj->initialised = 0;
567 zval_dtor(return_value);
568 RETURN_FALSE;
569 }
570 }
571 /* }}} */
572
573 static zval* sqlite_value_to_zval(sqlite3_stmt *stmt, int column) /* {{{ */
574 {
575 zval *data;
576 MAKE_STD_ZVAL(data);
577 switch (sqlite3_column_type(stmt, column)) {
578 case SQLITE_INTEGER:
579 if ((sqlite3_column_int64(stmt, column)) >= INT_MAX || sqlite3_column_int64(stmt, column) <= INT_MIN) {
580 ZVAL_STRINGL(data, (char *)sqlite3_column_text(stmt, column), sqlite3_column_bytes(stmt, column), 1);
581 } else {
582 ZVAL_LONG(data, sqlite3_column_int64(stmt, column));
583 }
584 break;
585
586 case SQLITE_FLOAT:
587 ZVAL_DOUBLE(data, sqlite3_column_double(stmt, column));
588 break;
589
590 case SQLITE_NULL:
591 ZVAL_NULL(data);
592 break;
593
594 case SQLITE3_TEXT:
595 ZVAL_STRING(data, (char*)sqlite3_column_text(stmt, column), 1);
596 break;
597
598 case SQLITE_BLOB:
599 default:
600 ZVAL_STRINGL(data, (char*)sqlite3_column_blob(stmt, column), sqlite3_column_bytes(stmt, column), 1);
601 }
602 return data;
603 }
604 /* }}} */
605
606 /* {{{ proto SQLite3Result SQLite3::querySingle(String Query [, bool entire_row = false])
607 Returns a string of the first column, or an array of the entire row. */
608 PHP_METHOD(sqlite3, querySingle)
609 {
610 php_sqlite3_db_object *db_obj;
611 zval *object = getThis();
612 char *sql, *errtext = NULL;
613 int sql_len, return_code;
614 zend_bool entire_row = 0;
615 sqlite3_stmt *stmt;
616 db_obj = (php_sqlite3_db_object *)zend_object_store_get_object(object TSRMLS_CC);
617
618 SQLITE3_CHECK_INITIALIZED(db_obj, db_obj->initialised, SQLite3)
619
620 if (FAILURE == zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "s|b", &sql, &sql_len, &entire_row)) {
621 return;
622 }
623
624 if (!sql_len) {
625 RETURN_FALSE;
626 }
627
628 /* If there was no return value then just execute the query */
629 if (!return_value_used) {
630 if (sqlite3_exec(db_obj->db, sql, NULL, NULL, &errtext) != SQLITE_OK) {
631 php_sqlite3_error(db_obj, "%s", errtext);
632 sqlite3_free(errtext);
633 }
634 return;
635 }
636
637 return_code = sqlite3_prepare_v2(db_obj->db, sql, sql_len, &stmt, NULL);
638 if (return_code != SQLITE_OK) {
639 php_sqlite3_error(db_obj, "Unable to prepare statement: %d, %s", return_code, sqlite3_errmsg(db_obj->db));
640 RETURN_FALSE;
641 }
642
643 return_code = sqlite3_step(stmt);
644
645 switch (return_code) {
646 case SQLITE_ROW: /* Valid Row */
647 {
648 if (!entire_row) {
649 zval *data;
650 data = sqlite_value_to_zval(stmt, 0);
651 *return_value = *data;
652 zval_copy_ctor(return_value);
653 zval_dtor(data);
654 FREE_ZVAL(data);
655 } else {
656 int i = 0;
657 array_init(return_value);
658 for (i = 0; i < sqlite3_data_count(stmt); i++) {
659 zval *data;
660 data = sqlite_value_to_zval(stmt, i);
661 add_assoc_zval(return_value, (char*)sqlite3_column_name(stmt, i), data);
662 }
663 }
664 break;
665 }
666 case SQLITE_DONE: /* Valid but no results */
667 {
668 if (!entire_row) {
669 RETVAL_NULL();
670 } else {
671 array_init(return_value);
672 }
673 break;
674 }
675 default:
676 php_sqlite3_error(db_obj, "Unable to execute statement: %s", sqlite3_errmsg(db_obj->db));
677 RETVAL_FALSE;
678 }
679 sqlite3_finalize(stmt);
680 }
681 /* }}} */
682
683 static int sqlite3_do_callback(struct php_sqlite3_fci *fc, zval *cb, int argc, sqlite3_value **argv, sqlite3_context *context, int is_agg TSRMLS_DC) /* {{{ */
684 {
685 zval ***zargs = NULL;
686 zval *retval = NULL;
687 int i;
688 int ret;
689 int fake_argc;
690 php_sqlite3_agg_context *agg_context = NULL;
691
692 if (is_agg) {
693 is_agg = 2;
694 }
695
696 fake_argc = argc + is_agg;
697
698 fc->fci.size = sizeof(fc->fci);
699 fc->fci.function_table = EG(function_table);
700 fc->fci.function_name = cb;
701 fc->fci.symbol_table = NULL;
702 fc->fci.object_ptr = NULL;
703 fc->fci.retval_ptr_ptr = &retval;
704 fc->fci.param_count = fake_argc;
705
706 /* build up the params */
707
708 if (fake_argc) {
709 zargs = (zval ***)safe_emalloc(fake_argc, sizeof(zval **), 0);
710 }
711
712 if (is_agg) {
713 /* summon the aggregation context */
714 agg_context = (php_sqlite3_agg_context *)sqlite3_aggregate_context(context, sizeof(php_sqlite3_agg_context));
715
716 if (!agg_context->zval_context) {
717 MAKE_STD_ZVAL(agg_context->zval_context);
718 ZVAL_NULL(agg_context->zval_context);
719 }
720 zargs[0] = &agg_context->zval_context;
721
722 zargs[1] = emalloc(sizeof(zval*));
723 MAKE_STD_ZVAL(*zargs[1]);
724 ZVAL_LONG(*zargs[1], agg_context->row_count);
725 }
726
727 for (i = 0; i < argc; i++) {
728 zargs[i + is_agg] = emalloc(sizeof(zval *));
729 MAKE_STD_ZVAL(*zargs[i + is_agg]);
730
731 switch (sqlite3_value_type(argv[i])) {
732 case SQLITE_INTEGER:
733 #if LONG_MAX > 2147483647
734 ZVAL_LONG(*zargs[i + is_agg], sqlite3_value_int64(argv[i]));
735 #else
736 ZVAL_LONG(*zargs[i + is_agg], sqlite3_value_int(argv[i]));
737 #endif
738 break;
739
740 case SQLITE_FLOAT:
741 ZVAL_DOUBLE(*zargs[i + is_agg], sqlite3_value_double(argv[i]));
742 break;
743
744 case SQLITE_NULL:
745 ZVAL_NULL(*zargs[i + is_agg]);
746 break;
747
748 case SQLITE_BLOB:
749 case SQLITE3_TEXT:
750 default:
751 ZVAL_STRINGL(*zargs[i + is_agg], (char*)sqlite3_value_text(argv[i]), sqlite3_value_bytes(argv[i]), 1);
752 break;
753 }
754 }
755
756 fc->fci.params = zargs;
757
758 if ((ret = zend_call_function(&fc->fci, &fc->fcc TSRMLS_CC)) == FAILURE) {
759 php_error_docref(NULL TSRMLS_CC, E_WARNING, "An error occurred while invoking the callback");
760 }
761
762 /* clean up the params */
763 if (fake_argc) {
764 for (i = is_agg; i < argc + is_agg; i++) {
765 zval_ptr_dtor(zargs[i]);
766 efree(zargs[i]);
767 }
768 if (is_agg) {
769 zval_ptr_dtor(zargs[1]);
770 efree(zargs[1]);
771 }
772 efree(zargs);
773 }
774
775 if (!is_agg || !argv) {
776 /* only set the sqlite return value if we are a scalar function,
777 * or if we are finalizing an aggregate */
778 if (retval) {
779 switch (Z_TYPE_P(retval)) {
780 case IS_LONG:
781 #if LONG_MAX > 2147483647
782 sqlite3_result_int64(context, Z_LVAL_P(retval));
783 #else
784 sqlite3_result_int(context, Z_LVAL_P(retval));
785 #endif
786 break;
787
788 case IS_NULL:
789 sqlite3_result_null(context);
790 break;
791
792 case IS_DOUBLE:
793 sqlite3_result_double(context, Z_DVAL_P(retval));
794 break;
795
796 default:
797 convert_to_string_ex(&retval);
798 sqlite3_result_text(context, Z_STRVAL_P(retval), Z_STRLEN_P(retval), SQLITE_TRANSIENT);
799 break;
800 }
801 } else {
802 sqlite3_result_error(context, "failed to invoke callback", 0);
803 }
804
805 if (agg_context && agg_context->zval_context) {
806 zval_ptr_dtor(&agg_context->zval_context);
807 }
808 } else {
809 /* we're stepping in an aggregate; the return value goes into
810 * the context */
811 if (agg_context && agg_context->zval_context) {
812 zval_ptr_dtor(&agg_context->zval_context);
813 }
814 if (retval) {
815 agg_context->zval_context = retval;
816 retval = NULL;
817 } else {
818 agg_context->zval_context = NULL;
819 }
820 }
821
822 if (retval) {
823 zval_ptr_dtor(&retval);
824 }
825 return ret;
826 }
827 /* }}}*/
828
829 static void php_sqlite3_callback_func(sqlite3_context *context, int argc, sqlite3_value **argv) /* {{{ */
830 {
831 php_sqlite3_func *func = (php_sqlite3_func *)sqlite3_user_data(context);
832 TSRMLS_FETCH();
833
834 sqlite3_do_callback(&func->afunc, func->func, argc, argv, context, 0 TSRMLS_CC);
835 }
836 /* }}}*/
837
838 static void php_sqlite3_callback_step(sqlite3_context *context, int argc, sqlite3_value **argv) /* {{{ */
839 {
840 php_sqlite3_func *func = (php_sqlite3_func *)sqlite3_user_data(context);
841 php_sqlite3_agg_context *agg_context = (php_sqlite3_agg_context *)sqlite3_aggregate_context(context, sizeof(php_sqlite3_agg_context));
842
843 TSRMLS_FETCH();
844 agg_context->row_count++;
845
846 sqlite3_do_callback(&func->astep, func->step, argc, argv, context, 1 TSRMLS_CC);
847 }
848 /* }}} */
849
850 static void php_sqlite3_callback_final(sqlite3_context *context) /* {{{ */
851 {
852 php_sqlite3_func *func = (php_sqlite3_func *)sqlite3_user_data(context);
853 php_sqlite3_agg_context *agg_context = (php_sqlite3_agg_context *)sqlite3_aggregate_context(context, sizeof(php_sqlite3_agg_context));
854
855 TSRMLS_FETCH();
856 agg_context->row_count = 0;
857
858 sqlite3_do_callback(&func->afini, func->fini, 0, NULL, context, 1 TSRMLS_CC);
859 }
860 /* }}} */
861
862 static int php_sqlite3_callback_compare(void *coll, int a_len, const void *a, int b_len, const void* b) /* {{{ */
863 {
864 php_sqlite3_collation *collation = (php_sqlite3_collation*)coll;
865 zval ***zargs = NULL;
866 zval *retval = NULL;
867 int ret;
868
869 TSRMLS_FETCH();
870
871 collation->fci.fci.size = (sizeof(collation->fci.fci));
872 collation->fci.fci.function_table = EG(function_table);
873 collation->fci.fci.function_name = collation->cmp_func;
874 collation->fci.fci.symbol_table = NULL;
875 collation->fci.fci.object_ptr = NULL;
876 collation->fci.fci.retval_ptr_ptr = &retval;
877 collation->fci.fci.param_count = 2;
878
879 zargs = (zval***)safe_emalloc(2, sizeof(zval**), 0);
880 zargs[0] = emalloc(sizeof(zval*));
881 zargs[1] = emalloc(sizeof(zval*));
882
883 MAKE_STD_ZVAL(*zargs[0]);
884 ZVAL_STRINGL(*zargs[0], a, a_len, 1);
885
886 MAKE_STD_ZVAL(*zargs[1]);
887 ZVAL_STRINGL(*zargs[1], b, b_len, 1);
888
889 collation->fci.fci.params = zargs;
890
891 if ((ret = zend_call_function(&collation->fci.fci, &collation->fci.fcc TSRMLS_CC)) == FAILURE) {
892 php_error_docref(NULL TSRMLS_CC, E_WARNING, "An error occurred while invoking the compare callback");
893 }
894
895 zval_ptr_dtor(zargs[0]);
896 zval_ptr_dtor(zargs[1]);
897 efree(zargs[0]);
898 efree(zargs[1]);
899 efree(zargs);
900
901 //retval ought to contain a ZVAL_LONG by now
902 // (the result of a comparison, i.e. most likely -1, 0, or 1)
903 //I suppose we could accept any scalar return type, though.
904 if (Z_TYPE_P(retval) != IS_LONG){
905 php_error_docref(NULL TSRMLS_CC, E_WARNING, "An error occurred while invoking the compare callback (invalid return type). Collation behaviour is undefined.");
906 }else{
907 ret = Z_LVAL_P(retval);
908 }
909
910 zval_ptr_dtor(&retval);
911
912 return ret;
913 }
914 /* }}} */
915
916 /* {{{ proto bool SQLite3::createFunction(string name, mixed callback [, int argcount])
917 Allows registration of a PHP function as a SQLite UDF that can be called within SQL statements. */
918 PHP_METHOD(sqlite3, createFunction)
919 {
920 php_sqlite3_db_object *db_obj;
921 zval *object = getThis();
922 php_sqlite3_func *func;
923 char *sql_func, *callback_name;
924 int sql_func_len;
925 zval *callback_func;
926 long sql_func_num_args = -1;
927 db_obj = (php_sqlite3_db_object *)zend_object_store_get_object(object TSRMLS_CC);
928
929 SQLITE3_CHECK_INITIALIZED(db_obj, db_obj->initialised, SQLite3)
930
931 if (zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "sz|l", &sql_func, &sql_func_len, &callback_func, &sql_func_num_args) == FAILURE) {
932 return;
933 }
934
935 if (!sql_func_len) {
936 RETURN_FALSE;
937 }
938
939 if (!zend_is_callable(callback_func, 0, &callback_name TSRMLS_CC)) {
940 php_sqlite3_error(db_obj, "Not a valid callback function %s", callback_name);
941 efree(callback_name);
942 RETURN_FALSE;
943 }
944 efree(callback_name);
945
946 func = (php_sqlite3_func *)ecalloc(1, sizeof(*func));
947
948 if (sqlite3_create_function(db_obj->db, sql_func, sql_func_num_args, SQLITE_UTF8, func, php_sqlite3_callback_func, NULL, NULL) == SQLITE_OK) {
949 func->func_name = estrdup(sql_func);
950
951 MAKE_STD_ZVAL(func->func);
952 MAKE_COPY_ZVAL(&callback_func, func->func);
953
954 func->argc = sql_func_num_args;
955 func->next = db_obj->funcs;
956 db_obj->funcs = func;
957
958 RETURN_TRUE;
959 }
960 efree(func);
961
962 RETURN_FALSE;
963 }
964 /* }}} */
965
966 /* {{{ proto bool SQLite3::createAggregate(string name, mixed step, mixed final [, int argcount])
967 Allows registration of a PHP function for use as an aggregate. */
968 PHP_METHOD(sqlite3, createAggregate)
969 {
970 php_sqlite3_db_object *db_obj;
971 zval *object = getThis();
972 php_sqlite3_func *func;
973 char *sql_func, *callback_name;
974 int sql_func_len;
975 zval *step_callback, *fini_callback;
976 long sql_func_num_args = -1;
977 db_obj = (php_sqlite3_db_object *)zend_object_store_get_object(object TSRMLS_CC);
978
979 SQLITE3_CHECK_INITIALIZED(db_obj, db_obj->initialised, SQLite3)
980
981 if (zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "szz|l", &sql_func, &sql_func_len, &step_callback, &fini_callback, &sql_func_num_args) == FAILURE) {
982 return;
983 }
984
985 if (!sql_func_len) {
986 RETURN_FALSE;
987 }
988
989 if (!zend_is_callable(step_callback, 0, &callback_name TSRMLS_CC)) {
990 php_sqlite3_error(db_obj, "Not a valid callback function %s", callback_name);
991 efree(callback_name);
992 RETURN_FALSE;
993 }
994 efree(callback_name);
995
996 if (!zend_is_callable(fini_callback, 0, &callback_name TSRMLS_CC)) {
997 php_sqlite3_error(db_obj, "Not a valid callback function %s", callback_name);
998 efree(callback_name);
999 RETURN_FALSE;
1000 }
1001 efree(callback_name);
1002
1003 func = (php_sqlite3_func *)ecalloc(1, sizeof(*func));
1004
1005 if (sqlite3_create_function(db_obj->db, sql_func, sql_func_num_args, SQLITE_UTF8, func, NULL, php_sqlite3_callback_step, php_sqlite3_callback_final) == SQLITE_OK) {
1006 func->func_name = estrdup(sql_func);
1007
1008 MAKE_STD_ZVAL(func->step);
1009 MAKE_COPY_ZVAL(&step_callback, func->step);
1010
1011 MAKE_STD_ZVAL(func->fini);
1012 MAKE_COPY_ZVAL(&fini_callback, func->fini);
1013
1014 func->argc = sql_func_num_args;
1015 func->next = db_obj->funcs;
1016 db_obj->funcs = func;
1017
1018 RETURN_TRUE;
1019 }
1020 efree(func);
1021
1022 RETURN_FALSE;
1023 }
1024 /* }}} */
1025
1026 /* {{{ proto bool SQLite3::createCollation(string name, mixed callback)
1027 Registers a PHP function as a comparator that can be used with the SQL COLLATE operator. Callback must accept two strings and return an integer (as strcmp()). */
1028 PHP_METHOD(sqlite3, createCollation)
1029 {
1030 php_sqlite3_db_object *db_obj;
1031 zval *object = getThis();
1032 php_sqlite3_collation *collation;
1033 char *collation_name, *callback_name;
1034 int collation_name_len;
1035 zval *callback_func;
1036 db_obj = (php_sqlite3_db_object *)zend_object_store_get_object(object TSRMLS_CC);
1037
1038 SQLITE3_CHECK_INITIALIZED(db_obj, db_obj->initialised, SQLite3)
1039
1040 if (zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "sz", &collation_name, &collation_name_len, &callback_func) == FAILURE) {
1041 RETURN_FALSE;
1042 }
1043
1044 if (!collation_name_len) {
1045 RETURN_FALSE;
1046 }
1047
1048 if (!zend_is_callable(callback_func, 0, &callback_name TSRMLS_CC)) {
1049 php_sqlite3_error(db_obj, "Not a valid callback function %s", callback_name);
1050 efree(callback_name);
1051 RETURN_FALSE;
1052 }
1053 efree(callback_name);
1054
1055 collation = (php_sqlite3_collation *)ecalloc(1, sizeof(*collation));
1056 if (sqlite3_create_collation(db_obj->db, collation_name, SQLITE_UTF8, collation, php_sqlite3_callback_compare) == SQLITE_OK) {
1057 collation->collation_name = estrdup(collation_name);
1058
1059 MAKE_STD_ZVAL(collation->cmp_func);
1060 MAKE_COPY_ZVAL(&callback_func, collation->cmp_func);
1061
1062 collation->next = db_obj->collations;
1063 db_obj->collations = collation;
1064
1065 RETURN_TRUE;
1066 }
1067 efree(collation);
1068
1069 RETURN_FALSE;
1070 }
1071 /* }}} */
1072
1073 typedef struct {
1074 sqlite3_blob *blob;
1075 size_t position;
1076 size_t size;
1077 } php_stream_sqlite3_data;
1078
1079 static size_t php_sqlite3_stream_write(php_stream *stream, const char *buf, size_t count TSRMLS_DC)
1080 {
1081 /* php_stream_sqlite3_data *sqlite3_stream = (php_stream_sqlite3_data *) stream->abstract; */
1082
1083 return 0;
1084 }
1085
1086 static size_t php_sqlite3_stream_read(php_stream *stream, char *buf, size_t count TSRMLS_DC)
1087 {
1088 php_stream_sqlite3_data *sqlite3_stream = (php_stream_sqlite3_data *) stream->abstract;
1089
1090 if (sqlite3_stream->position + count >= sqlite3_stream->size) {
1091 count = sqlite3_stream->size - sqlite3_stream->position;
1092 stream->eof = 1;
1093 }
1094 if (count) {
1095 if (sqlite3_blob_read(sqlite3_stream->blob, buf, count, sqlite3_stream->position) != SQLITE_OK) {
1096 return 0;
1097 }
1098 sqlite3_stream->position += count;
1099 }
1100 return count;
1101 }
1102
1103 static int php_sqlite3_stream_close(php_stream *stream, int close_handle TSRMLS_DC)
1104 {
1105 php_stream_sqlite3_data *sqlite3_stream = (php_stream_sqlite3_data *) stream->abstract;
1106
1107 if (sqlite3_blob_close(sqlite3_stream->blob) != SQLITE_OK) {
1108 /* Error occurred, but it still closed */
1109 }
1110
1111 efree(sqlite3_stream);
1112
1113 return 0;
1114 }
1115
1116 static int php_sqlite3_stream_flush(php_stream *stream TSRMLS_DC)
1117 {
1118 /* do nothing */
1119 return 0;
1120 }
1121
1122 /* {{{ */
1123 static int php_sqlite3_stream_seek(php_stream *stream, off_t offset, int whence, off_t *newoffs TSRMLS_DC)
1124 {
1125 php_stream_sqlite3_data *sqlite3_stream = (php_stream_sqlite3_data *) stream->abstract;
1126
1127 switch(whence) {
1128 case SEEK_CUR:
1129 if (offset < 0) {
1130 if (sqlite3_stream->position < (size_t)(-offset)) {
1131 sqlite3_stream->position = 0;
1132 *newoffs = -1;
1133 return -1;
1134 } else {
1135 sqlite3_stream->position = sqlite3_stream->position + offset;
1136 *newoffs = sqlite3_stream->position;
1137 stream->eof = 0;
1138 return 0;
1139 }
1140 } else {
1141 if (sqlite3_stream->position + (size_t)(offset) > sqlite3_stream->size) {
1142 sqlite3_stream->position = sqlite3_stream->size;
1143 *newoffs = -1;
1144 return -1;
1145 } else {
1146 sqlite3_stream->position = sqlite3_stream->position + offset;
1147 *newoffs = sqlite3_stream->position;
1148 stream->eof = 0;
1149 return 0;
1150 }
1151 }
1152 case SEEK_SET:
1153 if (sqlite3_stream->size < (size_t)(offset)) {
1154 sqlite3_stream->position = sqlite3_stream->size;
1155 *newoffs = -1;
1156 return -1;
1157 } else {
1158 sqlite3_stream->position = offset;
1159 *newoffs = sqlite3_stream->position;
1160 stream->eof = 0;
1161 return 0;
1162 }
1163 case SEEK_END:
1164 if (offset > 0) {
1165 sqlite3_stream->position = sqlite3_stream->size;
1166 *newoffs = -1;
1167 return -1;
1168 } else if (sqlite3_stream->size < (size_t)(-offset)) {
1169 sqlite3_stream->position = 0;
1170 *newoffs = -1;
1171 return -1;
1172 } else {
1173 sqlite3_stream->position = sqlite3_stream->size + offset;
1174 *newoffs = sqlite3_stream->position;
1175 stream->eof = 0;
1176 return 0;
1177 }
1178 default:
1179 *newoffs = sqlite3_stream->position;
1180 return -1;
1181 }
1182 }
1183 /* }}} */
1184
1185
1186 static int php_sqlite3_stream_cast(php_stream *stream, int castas, void **ret TSRMLS_DC)
1187 {
1188 return FAILURE;
1189 }
1190
1191 static int php_sqlite3_stream_stat(php_stream *stream, php_stream_statbuf *ssb TSRMLS_DC)
1192 {
1193 php_stream_sqlite3_data *sqlite3_stream = (php_stream_sqlite3_data *) stream->abstract;
1194 ssb->sb.st_size = sqlite3_stream->size;
1195 return 0;
1196 }
1197
1198 static php_stream_ops php_stream_sqlite3_ops = {
1199 php_sqlite3_stream_write,
1200 php_sqlite3_stream_read,
1201 php_sqlite3_stream_close,
1202 php_sqlite3_stream_flush,
1203 "SQLite3",
1204 php_sqlite3_stream_seek,
1205 php_sqlite3_stream_cast,
1206 php_sqlite3_stream_stat
1207 };
1208
1209 /* {{{ proto resource SQLite3::openBlob(string table, string column, int rowid [, string dbname])
1210 Open a blob as a stream which we can read / write to. */
1211 PHP_METHOD(sqlite3, openBlob)
1212 {
1213 php_sqlite3_db_object *db_obj;
1214 zval *object = getThis();
1215 char *table, *column, *dbname = "main";
1216 int table_len, column_len, dbname_len;
1217 long rowid, flags = 0;
1218 sqlite3_blob *blob = NULL;
1219 php_stream_sqlite3_data *sqlite3_stream;
1220 php_stream *stream;
1221
1222 db_obj = (php_sqlite3_db_object *)zend_object_store_get_object(object TSRMLS_CC);
1223
1224 SQLITE3_CHECK_INITIALIZED(db_obj, db_obj->initialised, SQLite3)
1225
1226 if (zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "ssl|s", &table, &table_len, &column, &column_len, &rowid, &dbname, &dbname_len) == FAILURE) {
1227 return;
1228 }
1229
1230 if (sqlite3_blob_open(db_obj->db, dbname, table, column, rowid, flags, &blob) != SQLITE_OK) {
1231 php_sqlite3_error(db_obj, "Unable to open blob: %s", sqlite3_errmsg(db_obj->db));
1232 RETURN_FALSE;
1233 }
1234
1235 sqlite3_stream = emalloc(sizeof(php_stream_sqlite3_data));
1236 sqlite3_stream->blob = blob;
1237 sqlite3_stream->position = 0;
1238 sqlite3_stream->size = sqlite3_blob_bytes(blob);
1239
1240 stream = php_stream_alloc(&php_stream_sqlite3_ops, sqlite3_stream, 0, "rb");
1241
1242 if (stream) {
1243 php_stream_to_zval(stream, return_value);
1244 } else {
1245 RETURN_FALSE;
1246 }
1247 }
1248 /* }}} */
1249
1250 /* {{{ proto bool SQLite3::enableExceptions([bool enableExceptions = false])
1251 Enables an exception error mode. */
1252 PHP_METHOD(sqlite3, enableExceptions)
1253 {
1254 php_sqlite3_db_object *db_obj;
1255 zval *object = getThis();
1256 zend_bool enableExceptions = 0;
1257
1258 db_obj = (php_sqlite3_db_object *)zend_object_store_get_object(object TSRMLS_CC);
1259
1260 if (zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "|b", &enableExceptions) == FAILURE) {
1261 return;
1262 }
1263
1264 RETVAL_BOOL(db_obj->exception);
1265
1266 db_obj->exception = enableExceptions;
1267 }
1268 /* }}} */
1269
1270 /* {{{ proto int SQLite3Stmt::paramCount()
1271 Returns the number of parameters within the prepared statement. */
1272 PHP_METHOD(sqlite3stmt, paramCount)
1273 {
1274 php_sqlite3_stmt *stmt_obj;
1275 zval *object = getThis();
1276 stmt_obj = (php_sqlite3_stmt *)zend_object_store_get_object(object TSRMLS_CC);
1277
1278 SQLITE3_CHECK_INITIALIZED(stmt_obj->db_obj, stmt_obj->initialised, SQLite3)
1279
1280 if (zend_parse_parameters_none() == FAILURE) {
1281 return;
1282 }
1283
1284 RETURN_LONG(sqlite3_bind_parameter_count(stmt_obj->stmt));
1285 }
1286 /* }}} */
1287
1288 /* {{{ proto bool SQLite3Stmt::close()
1289 Closes the prepared statement. */
1290 PHP_METHOD(sqlite3stmt, close)
1291 {
1292 php_sqlite3_stmt *stmt_obj;
1293 zval *object = getThis();
1294 stmt_obj = (php_sqlite3_stmt *)zend_object_store_get_object(object TSRMLS_CC);
1295
1296 SQLITE3_CHECK_INITIALIZED(stmt_obj->db_obj, stmt_obj->initialised, SQLite3)
1297
1298 if (zend_parse_parameters_none() == FAILURE) {
1299 return;
1300 }
1301
1302 zend_llist_del_element(&(stmt_obj->db_obj->free_list), object, (int (*)(void *, void *)) php_sqlite3_compare_stmt_zval_free);
1303
1304 RETURN_TRUE;
1305 }
1306 /* }}} */
1307
1308 /* {{{ proto bool SQLite3Stmt::reset()
1309 Reset the prepared statement to the state before it was executed, bindings still remain. */
1310 PHP_METHOD(sqlite3stmt, reset)
1311 {
1312 php_sqlite3_stmt *stmt_obj;
1313 zval *object = getThis();
1314 stmt_obj = (php_sqlite3_stmt *)zend_object_store_get_object(object TSRMLS_CC);
1315
1316 SQLITE3_CHECK_INITIALIZED(stmt_obj->db_obj, stmt_obj->initialised, SQLite3)
1317
1318 if (zend_parse_parameters_none() == FAILURE) {
1319 return;
1320 }
1321
1322 if (sqlite3_reset(stmt_obj->stmt) != SQLITE_OK) {
1323 php_sqlite3_error(stmt_obj->db_obj, "Unable to reset statement: %s", sqlite3_errmsg(sqlite3_db_handle(stmt_obj->stmt)));
1324 RETURN_FALSE;
1325 }
1326 RETURN_TRUE;
1327 }
1328 /* }}} */
1329
1330 /* {{{ proto bool SQLite3Stmt::clear()
1331 Clear all current bound parameters. */
1332 PHP_METHOD(sqlite3stmt, clear)
1333 {
1334 php_sqlite3_stmt *stmt_obj;
1335 zval *object = getThis();
1336 stmt_obj = (php_sqlite3_stmt *)zend_object_store_get_object(object TSRMLS_CC);
1337
1338 SQLITE3_CHECK_INITIALIZED(stmt_obj->db_obj, stmt_obj->initialised, SQLite3)
1339
1340 if (zend_parse_parameters_none() == FAILURE) {
1341 return;
1342 }
1343
1344 if (sqlite3_clear_bindings(stmt_obj->stmt) != SQLITE_OK) {
1345 php_sqlite3_error(stmt_obj->db_obj, "Unable to clear statement: %s", sqlite3_errmsg(sqlite3_db_handle(stmt_obj->stmt)));
1346 RETURN_FALSE;
1347 }
1348
1349 RETURN_TRUE;
1350 }
1351 /* }}} */
1352
1353 /* {{{ proto bool SQLite3Stmt::readOnly()
1354 Returns true if a statement is definitely read only */
1355 PHP_METHOD(sqlite3stmt, readOnly)
1356 {
1357 php_sqlite3_stmt *stmt_obj;
1358 zval *object = getThis();
1359 stmt_obj = (php_sqlite3_stmt *)zend_object_store_get_object(object TSRMLS_CC);
1360
1361 SQLITE3_CHECK_INITIALIZED(stmt_obj->db_obj, stmt_obj->initialised, SQLite3)
1362
1363 if (zend_parse_parameters_none() == FAILURE) {
1364 return;
1365 }
1366
1367 #if SQLITE_VERSION_NUMBER >= 3007004
1368 if (sqlite3_stmt_readonly(stmt_obj->stmt)) {
1369 RETURN_TRUE;
1370 }
1371 #endif
1372 RETURN_FALSE;
1373 }
1374 /* }}} */
1375
1376 static int register_bound_parameter_to_sqlite(struct php_sqlite3_bound_param *param, php_sqlite3_stmt *stmt TSRMLS_DC) /* {{{ */
1377 {
1378 HashTable *hash;
1379 hash = stmt->bound_params;
1380
1381 if (!hash) {
1382 ALLOC_HASHTABLE(hash);
1383 zend_hash_init(hash, 13, NULL, sqlite3_param_dtor, 0);
1384 stmt->bound_params = hash;
1385 }
1386
1387 /* We need a : prefix to resolve a name to a parameter number */
1388 if (param->name) {
1389 if (param->name[0] != ':') {
1390 /* pre-increment for character + 1 for null */
1391 char *temp = emalloc(++param->name_len + 1);
1392 temp[0] = ':';
1393 memmove(temp+1, param->name, param->name_len);
1394 param->name = temp;
1395 } else {
1396 param->name = estrndup(param->name, param->name_len);
1397 }
1398 /* do lookup*/
1399 param->param_number = sqlite3_bind_parameter_index(stmt->stmt, param->name);
1400 }
1401
1402 if (param->param_number < 1) {
1403 efree(param->name);
1404 return 0;
1405 }
1406
1407 if (param->param_number >= 1) {
1408 zend_hash_index_del(hash, param->param_number);
1409 }
1410
1411 if (param->name) {
1412 zend_hash_update(hash, param->name, param->name_len, param, sizeof(*param), NULL);
1413 } else {
1414 zend_hash_index_update(hash, param->param_number, param, sizeof(*param), NULL);
1415 }
1416
1417 return 1;
1418 }
1419 /* }}} */
1420
1421 /* {{{ proto bool SQLite3Stmt::bindParam(int parameter_number, mixed parameter [, int type])
1422 Bind Parameter to a stmt variable. */
1423 PHP_METHOD(sqlite3stmt, bindParam)
1424 {
1425 php_sqlite3_stmt *stmt_obj;
1426 zval *object = getThis();
1427 struct php_sqlite3_bound_param param = {0};
1428 stmt_obj = (php_sqlite3_stmt *)zend_object_store_get_object(object TSRMLS_CC);
1429
1430 SQLITE3_CHECK_INITIALIZED(stmt_obj->db_obj, stmt_obj->initialised, SQLite3)
1431
1432 param.param_number = -1;
1433 param.type = SQLITE3_TEXT;
1434
1435 if (zend_parse_parameters_ex(ZEND_PARSE_PARAMS_QUIET, ZEND_NUM_ARGS() TSRMLS_CC, "lz|l", ¶m.param_number, ¶m.parameter, ¶m.type) == FAILURE) {
1436 if (zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "sz|l", ¶m.name, ¶m.name_len, ¶m.parameter, ¶m.type) == FAILURE) {
1437 return;
1438 }
1439 }
1440
1441 Z_ADDREF_P(param.parameter);
1442
1443 if (!register_bound_parameter_to_sqlite(¶m, stmt_obj TSRMLS_CC)) {
1444 if (param.parameter) {
1445 zval_ptr_dtor(&(param.parameter));
1446 param.parameter = NULL;
1447 }
1448 RETURN_FALSE;
1449 }
1450 RETURN_TRUE;
1451 }
1452 /* }}} */
1453
1454 /* {{{ proto bool SQLite3Stmt::bindValue(int parameter_number, mixed parameter [, int type])
1455 Bind Value of a parameter to a stmt variable. */
1456 PHP_METHOD(sqlite3stmt, bindValue)
1457 {
1458 php_sqlite3_stmt *stmt_obj;
1459 zval *object = getThis();
1460 struct php_sqlite3_bound_param param = {0};
1461 stmt_obj = (php_sqlite3_stmt *)zend_object_store_get_object(object TSRMLS_CC);
1462
1463 SQLITE3_CHECK_INITIALIZED(stmt_obj->db_obj, stmt_obj->initialised, SQLite3)
1464
1465 param.param_number = -1;
1466 param.type = SQLITE3_TEXT;
1467
1468 if (zend_parse_parameters_ex(ZEND_PARSE_PARAMS_QUIET, ZEND_NUM_ARGS() TSRMLS_CC, "lz/|l", ¶m.param_number, ¶m.parameter, ¶m.type) == FAILURE) {
1469 if (zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "sz/|l", ¶m.name, ¶m.name_len, ¶m.parameter, ¶m.type) == FAILURE) {
1470 return;
1471 }
1472 }
1473
1474 Z_ADDREF_P(param.parameter);
1475
1476 if (!register_bound_parameter_to_sqlite(¶m, stmt_obj TSRMLS_CC)) {
1477 if (param.parameter) {
1478 zval_ptr_dtor(&(param.parameter));
1479 param.parameter = NULL;
1480 }
1481 RETURN_FALSE;
1482 }
1483 RETURN_TRUE;
1484 }
1485 /* }}} */
1486
1487 /* {{{ proto SQLite3Result SQLite3Stmt::execute()
1488 Executes a prepared statement and returns a result set object. */
1489 PHP_METHOD(sqlite3stmt, execute)
1490 {
1491 php_sqlite3_stmt *stmt_obj;
1492 php_sqlite3_result *result;
1493 zval *object = getThis();
1494 int return_code = 0;
1495 struct php_sqlite3_bound_param *param;
1496
1497 stmt_obj = (php_sqlite3_stmt *)zend_object_store_get_object(object TSRMLS_CC);
1498
1499 SQLITE3_CHECK_INITIALIZED(stmt_obj->db_obj, stmt_obj->initialised, SQLite3)
1500
1501 if (zend_parse_parameters_none() == FAILURE) {
1502 return;
1503 }
1504
1505 SQLITE3_CHECK_INITIALIZED(stmt_obj->db_obj, stmt_obj->initialised, SQLite3)
1506
1507 if (stmt_obj->bound_params) {
1508 zend_hash_internal_pointer_reset(stmt_obj->bound_params);
1509 while (zend_hash_get_current_data(stmt_obj->bound_params, (void **)¶m) == SUCCESS) {
1510 /* If the ZVAL is null then it should be bound as that */
1511 if (Z_TYPE_P(param->parameter) == IS_NULL) {
1512 sqlite3_bind_null(stmt_obj->stmt, param->param_number);
1513 zend_hash_move_forward(stmt_obj->bound_params);
1514 continue;
1515 }
1516
1517 switch (param->type) {
1518 case SQLITE_INTEGER:
1519 convert_to_long(param->parameter);
1520 #if LONG_MAX > 2147483647
1521 sqlite3_bind_int64(stmt_obj->stmt, param->param_number, Z_LVAL_P(param->parameter));
1522 #else
1523 sqlite3_bind_int(stmt_obj->stmt, param->param_number, Z_LVAL_P(param->parameter));
1524 #endif
1525 break;
1526
1527 case SQLITE_FLOAT:
1528 /* convert_to_double(param->parameter);*/
1529 sqlite3_bind_double(stmt_obj->stmt, param->param_number, Z_DVAL_P(param->parameter));
1530 break;
1531
1532 case SQLITE_BLOB:
1533 {
1534 php_stream *stream = NULL;
1535 int blength;
1536 char *buffer = NULL;
1537 if (Z_TYPE_P(param->parameter) == IS_RESOURCE) {
1538 php_stream_from_zval_no_verify(stream, ¶m->parameter);
1539 if (stream == NULL) {
1540 php_sqlite3_error(stmt_obj->db_obj, "Unable to read stream for parameter %ld", param->param_number);
1541 RETURN_FALSE;
1542 }
1543 blength = php_stream_copy_to_mem(stream, (void *)&buffer, PHP_STREAM_COPY_ALL, 0);
1544 } else {
1545 convert_to_string(param->parameter);
1546 blength = Z_STRLEN_P(param->parameter);
1547 buffer = Z_STRVAL_P(param->parameter);
1548 }
1549
1550 sqlite3_bind_blob(stmt_obj->stmt, param->param_number, buffer, blength, SQLITE_TRANSIENT);
1551
1552 if (stream) {
1553 pefree(buffer, 0);
1554 }
1555 break;
1556 }
1557
1558 case SQLITE3_TEXT:
1559 convert_to_string(param->parameter);
1560 sqlite3_bind_text(stmt_obj->stmt, param->param_number, Z_STRVAL_P(param->parameter), Z_STRLEN_P(param->parameter), SQLITE_STATIC);
1561 break;
1562
1563 case SQLITE_NULL:
1564 sqlite3_bind_null(stmt_obj->stmt, param->param_number);
1565 break;
1566
1567 default:
1568 php_sqlite3_error(stmt_obj->db_obj, "Unknown parameter type: %ld for parameter %ld", param->type, param->param_number);
1569 RETURN_FALSE;
1570 }
1571 zend_hash_move_forward(stmt_obj->bound_params);
1572 }
1573 }
1574
1575 return_code = sqlite3_step(stmt_obj->stmt);
1576
1577 switch (return_code) {
1578 case SQLITE_ROW: /* Valid Row */
1579 case SQLITE_DONE: /* Valid but no results */
1580 {
1581 sqlite3_reset(stmt_obj->stmt);
1582 object_init_ex(return_value, php_sqlite3_result_entry);
1583 result = (php_sqlite3_result *)zend_object_store_get_object(return_value TSRMLS_CC);
1584
1585 Z_ADDREF_P(object);
1586
1587 result->is_prepared_statement = 1;
1588 result->db_obj = stmt_obj->db_obj;
1589 result->stmt_obj = stmt_obj;
1590 result->stmt_obj_zval = getThis();
1591
1592 break;
1593 }
1594 case SQLITE_ERROR:
1595 sqlite3_reset(stmt_obj->stmt);
1596
1597 default:
1598 php_sqlite3_error(stmt_obj->db_obj, "Unable to execute statement: %s", sqlite3_errmsg(sqlite3_db_handle(stmt_obj->stmt)));
1599 zval_dtor(return_value);
1600 RETURN_FALSE;
1601 }
1602
1603 return;
1604 }
1605 /* }}} */
1606
1607 /* {{{ proto int SQLite3Stmt::__construct(SQLite3 dbobject, String Statement)
1608 __constructor for SQLite3Stmt. */
1609 PHP_METHOD(sqlite3stmt, __construct)
1610 {
1611 php_sqlite3_stmt *stmt_obj;
1612 php_sqlite3_db_object *db_obj;
1613 zval *object = getThis();
1614 zval *db_zval;
1615 char *sql;
1616 int sql_len, errcode;
1617 zend_error_handling error_handling;
1618 php_sqlite3_free_list *free_item;
1619
1620 stmt_obj = (php_sqlite3_stmt *)zend_object_store_get_object(object TSRMLS_CC);
1621 zend_replace_error_handling(EH_THROW, NULL, &error_handling TSRMLS_CC);
1622
1623 if (zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "Os", &db_zval, php_sqlite3_sc_entry, &sql, &sql_len) == FAILURE) {
1624 zend_restore_error_handling(&error_handling TSRMLS_CC);
1625 return;
1626 }
1627
1628 db_obj = (php_sqlite3_db_object *)zend_object_store_get_object(db_zval TSRMLS_CC);
1629
1630 SQLITE3_CHECK_INITIALIZED(db_obj, db_obj->initialised, SQLite3)
1631
1632 zend_restore_error_handling(&error_handling TSRMLS_CC);
1633
1634 if (!sql_len) {
1635 RETURN_FALSE;
1636 }
1637
1638 stmt_obj->db_obj = db_obj;
1639 stmt_obj->db_obj_zval = db_zval;
1640
1641 Z_ADDREF_P(db_zval);
1642
1643 errcode = sqlite3_prepare_v2(db_obj->db, sql, sql_len, &(stmt_obj->stmt), NULL);
1644 if (errcode != SQLITE_OK) {
1645 php_sqlite3_error(db_obj, "Unable to prepare statement: %d, %s", errcode, sqlite3_errmsg(db_obj->db));
1646 zval_dtor(return_value);
1647 RETURN_FALSE;
1648 }
1649 stmt_obj->initialised = 1;
1650
1651 free_item = emalloc(sizeof(php_sqlite3_free_list));
1652 free_item->stmt_obj = stmt_obj;
1653 free_item->stmt_obj_zval = getThis();
1654
1655 zend_llist_add_element(&(db_obj->free_list), &free_item);
1656 }
1657 /* }}} */
1658
1659 /* {{{ proto int SQLite3Result::numColumns()
1660 Number of columns in the result set. */
1661 PHP_METHOD(sqlite3result, numColumns)
1662 {
1663 php_sqlite3_result *result_obj;
1664 zval *object = getThis();
1665 result_obj = (php_sqlite3_result *)zend_object_store_get_object(object TSRMLS_CC);
1666
1667 SQLITE3_CHECK_INITIALIZED(result_obj->db_obj, result_obj->stmt_obj->initialised, SQLite3Result)
1668
1669 if (zend_parse_parameters_none() == FAILURE) {
1670 return;
1671 }
1672
1673 RETURN_LONG(sqlite3_column_count(result_obj->stmt_obj->stmt));
1674 }
1675 /* }}} */
1676
1677 /* {{{ proto string SQLite3Result::columnName(int column)
1678 Returns the name of the nth column. */
1679 PHP_METHOD(sqlite3result, columnName)
1680 {
1681 php_sqlite3_result *result_obj;
1682 zval *object = getThis();
1683 long column = 0;
1684 char *column_name;
1685 result_obj = (php_sqlite3_result *)zend_object_store_get_object(object TSRMLS_CC);
1686
1687 SQLITE3_CHECK_INITIALIZED(result_obj->db_obj, result_obj->stmt_obj->initialised, SQLite3Result)
1688
1689 if (zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "l", &column) == FAILURE) {
1690 return;
1691 }
1692 column_name = (char*) sqlite3_column_name(result_obj->stmt_obj->stmt, column);
1693
1694 if (column_name == NULL) {
1695 RETURN_FALSE;
1696 }
1697
1698 RETVAL_STRING(column_name, 1);
1699 }
1700 /* }}} */
1701
1702 /* {{{ proto int SQLite3Result::columnType(int column)
1703 Returns the type of the nth column. */
1704 PHP_METHOD(sqlite3result, columnType)
1705 {
1706 php_sqlite3_result *result_obj;
1707 zval *object = getThis();
1708 long column = 0;
1709 result_obj = (php_sqlite3_result *)zend_object_store_get_object(object TSRMLS_CC);
1710
1711 SQLITE3_CHECK_INITIALIZED(result_obj->db_obj, result_obj->stmt_obj->initialised, SQLite3Result)
1712
1713 if (zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "l", &column) == FAILURE) {
1714 return;
1715 }
1716
1717 if (result_obj->complete) {
1718 RETURN_FALSE;
1719 }
1720
1721 RETURN_LONG(sqlite3_column_type(result_obj->stmt_obj->stmt, column));
1722 }
1723 /* }}} */
1724
1725 /* {{{ proto array SQLite3Result::fetchArray([int mode])
1726 Fetch a result row as both an associative or numerically indexed array or both. */
1727 PHP_METHOD(sqlite3result, fetchArray)
1728 {
1729 php_sqlite3_result *result_obj;
1730 zval *object = getThis();
1731 int i, ret;
1732 long mode = PHP_SQLITE3_BOTH;
1733 result_obj = (php_sqlite3_result *)zend_object_store_get_object(object TSRMLS_CC);
1734
1735 SQLITE3_CHECK_INITIALIZED(result_obj->db_obj, result_obj->stmt_obj->initialised, SQLite3Result)
1736
1737 if (zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "|l", &mode) == FAILURE) {
1738 return;
1739 }
1740
1741 ret = sqlite3_step(result_obj->stmt_obj->stmt);
1742 switch (ret) {
1743 case SQLITE_ROW:
1744 /* If there was no return value then just skip fetching */
1745 if (!return_value_used) {
1746 return;
1747 }
1748
1749 array_init(return_value);
1750
1751 for (i = 0; i < sqlite3_data_count(result_obj->stmt_obj->stmt); i++) {
1752 zval *data;
1753
1754 data = sqlite_value_to_zval(result_obj->stmt_obj->stmt, i);
1755
1756 if (mode & PHP_SQLITE3_NUM) {
1757 add_index_zval(return_value, i, data);
1758 }
1759
1760 if (mode & PHP_SQLITE3_ASSOC) {
1761 if (mode & PHP_SQLITE3_NUM) {
1762 Z_ADDREF_P(data);
1763 }
1764 add_assoc_zval(return_value, (char*)sqlite3_column_name(result_obj->stmt_obj->stmt, i), data);
1765 }
1766 }
1767 break;
1768
1769 case SQLITE_DONE:
1770 result_obj->complete = 1;
1771 RETURN_FALSE;
1772 break;
1773
1774 default:
1775 php_sqlite3_error(result_obj->db_obj, "Unable to execute statement: %s", sqlite3_errmsg(sqlite3_db_handle(result_obj->stmt_obj->stmt)));
1776 }
1777 }
1778 /* }}} */
1779
1780 /* {{{ proto bool SQLite3Result::reset()
1781 Resets the result set back to the first row. */
1782 PHP_METHOD(sqlite3result, reset)
1783 {
1784 php_sqlite3_result *result_obj;
1785 zval *object = getThis();
1786 result_obj = (php_sqlite3_result *)zend_object_store_get_object(object TSRMLS_CC);
1787
1788 SQLITE3_CHECK_INITIALIZED(result_obj->db_obj, result_obj->stmt_obj->initialised, SQLite3Result)
1789
1790 if (zend_parse_parameters_none() == FAILURE) {
1791 return;
1792 }
1793
1794 if (sqlite3_reset(result_obj->stmt_obj->stmt) != SQLITE_OK) {
1795 RETURN_FALSE;
1796 }
1797
1798 result_obj->complete = 0;
1799
1800 RETURN_TRUE;
1801 }
1802 /* }}} */
1803
1804 /* {{{ proto bool SQLite3Result::finalize()
1805 Closes the result set. */
1806 PHP_METHOD(sqlite3result, finalize)
1807 {
1808 php_sqlite3_result *result_obj;
1809 zval *object = getThis();
1810 result_obj = (php_sqlite3_result *)zend_object_store_get_object(object TSRMLS_CC);
1811
1812 SQLITE3_CHECK_INITIALIZED(result_obj->db_obj, result_obj->stmt_obj->initialised, SQLite3Result)
1813
1814 if (zend_parse_parameters_none() == FAILURE) {
1815 return;
1816 }
1817
1818 /* We need to finalize an internal statement */
1819 if (result_obj->is_prepared_statement == 0) {
1820 zend_llist_del_element(&(result_obj->db_obj->free_list), result_obj->stmt_obj_zval,
1821 (int (*)(void *, void *)) php_sqlite3_compare_stmt_zval_free);
1822 } else {
1823 sqlite3_reset(result_obj->stmt_obj->stmt);
1824 }
1825
1826 RETURN_TRUE;
1827 }
1828 /* }}} */
1829
1830 /* {{{ proto int SQLite3Result::__construct()
1831 __constructor for SQLite3Result. */
1832 PHP_METHOD(sqlite3result, __construct)
1833 {
1834 zend_throw_exception(zend_exception_get_default(TSRMLS_C), "SQLite3Result cannot be directly instantiated", 0 TSRMLS_CC);
1835 }
1836 /* }}} */
1837
1838 /* {{{ arginfo */
1839 ZEND_BEGIN_ARG_INFO(arginfo_sqlite3_open, 0)
1840 ZEND_ARG_INFO(0, filename)
1841 ZEND_ARG_INFO(0, flags)
1842 ZEND_ARG_INFO(0, encryption_key)
1843 ZEND_END_ARG_INFO()
1844
1845 ZEND_BEGIN_ARG_INFO(arginfo_sqlite3_busytimeout, 0)
1846 ZEND_ARG_INFO(0, ms)
1847 ZEND_END_ARG_INFO()
1848
1849 #ifndef SQLITE_OMIT_LOAD_EXTENSION
1850 ZEND_BEGIN_ARG_INFO(arginfo_sqlite3_loadextension, 0)
1851 ZEND_ARG_INFO(0, shared_library)
1852 ZEND_END_ARG_INFO()
1853 #endif
1854
1855 ZEND_BEGIN_ARG_INFO_EX(arginfo_sqlite3_escapestring, 0, 0, 1)
1856 ZEND_ARG_INFO(0, value)
1857 ZEND_END_ARG_INFO()
1858
1859 ZEND_BEGIN_ARG_INFO_EX(arginfo_sqlite3_query, 0, 0, 1)
1860 ZEND_ARG_INFO(0, query)
1861 ZEND_END_ARG_INFO()
1862
1863 ZEND_BEGIN_ARG_INFO_EX(arginfo_sqlite3_querysingle, 0, 0, 1)
1864 ZEND_ARG_INFO(0, query)
1865 ZEND_ARG_INFO(0, entire_row)
1866 ZEND_END_ARG_INFO()
1867
1868 ZEND_BEGIN_ARG_INFO_EX(arginfo_sqlite3_createfunction, 0, 0, 2)
1869 ZEND_ARG_INFO(0, name)
1870 ZEND_ARG_INFO(0, callback)
1871 ZEND_ARG_INFO(0, argument_count)
1872 ZEND_END_ARG_INFO()
1873
1874 ZEND_BEGIN_ARG_INFO_EX(arginfo_sqlite3_createaggregate, 0, 0, 3)
1875 ZEND_ARG_INFO(0, name)
1876 ZEND_ARG_INFO(0, step_callback)
1877 ZEND_ARG_INFO(0, final_callback)
1878 ZEND_ARG_INFO(0, argument_count)
1879 ZEND_END_ARG_INFO()
1880
1881 ZEND_BEGIN_ARG_INFO_EX(arginfo_sqlite3_createcollation, 0, 0, 2)
1882 ZEND_ARG_INFO(0, name)
1883 ZEND_ARG_INFO(0, callback)
1884 ZEND_END_ARG_INFO()
1885
1886 ZEND_BEGIN_ARG_INFO_EX(argingo_sqlite3_openblob, 0, 0, 3)
1887 ZEND_ARG_INFO(0, table)
1888 ZEND_ARG_INFO(0, column)
1889 ZEND_ARG_INFO(0, rowid)
1890 ZEND_ARG_INFO(0, dbname)
1891 ZEND_END_ARG_INFO()
1892
1893 ZEND_BEGIN_ARG_INFO_EX(argingo_sqlite3_enableexceptions, 0, 0, 1)
1894 ZEND_ARG_INFO(0, enableExceptions)
1895 ZEND_END_ARG_INFO()
1896
1897 ZEND_BEGIN_ARG_INFO_EX(arginfo_sqlite3stmt_bindparam, 0, 0, 2)
1898 ZEND_ARG_INFO(0, param_number)
1899 ZEND_ARG_INFO(1, param)
1900 ZEND_ARG_INFO(0, type)
1901 ZEND_END_ARG_INFO()
1902
1903 ZEND_BEGIN_ARG_INFO_EX(arginfo_sqlite3stmt_bindvalue, 0, 0, 2)
1904 ZEND_ARG_INFO(0, param_number)
1905 ZEND_ARG_INFO(0, param)
1906 ZEND_ARG_INFO(0, type)
1907 ZEND_END_ARG_INFO()
1908
1909 ZEND_BEGIN_ARG_INFO(arginfo_sqlite3stmt_construct, 1)
1910 ZEND_ARG_INFO(0, sqlite3)
1911 ZEND_END_ARG_INFO()
1912
1913 ZEND_BEGIN_ARG_INFO_EX(arginfo_sqlite3result_columnname, 0, 0, 1)
1914 ZEND_ARG_INFO(0, column_number)
1915 ZEND_END_ARG_INFO()
1916
1917 ZEND_BEGIN_ARG_INFO_EX(arginfo_sqlite3result_columntype, 0, 0, 1)
1918 ZEND_ARG_INFO(0, column_number)
1919 ZEND_END_ARG_INFO()
1920
1921 ZEND_BEGIN_ARG_INFO_EX(arginfo_sqlite3result_fetcharray, 0, 0, 1)
1922 ZEND_ARG_INFO(0, mode)
1923 ZEND_END_ARG_INFO()
1924
1925 ZEND_BEGIN_ARG_INFO(arginfo_sqlite3_void, 0)
1926 ZEND_END_ARG_INFO()
1927 /* }}} */
1928
1929 /* {{{ php_sqlite3_class_methods */
1930 static zend_function_entry php_sqlite3_class_methods[] = {
1931 PHP_ME(sqlite3, open, arginfo_sqlite3_open, ZEND_ACC_PUBLIC)
1932 PHP_ME(sqlite3, close, arginfo_sqlite3_void, ZEND_ACC_PUBLIC)
1933 PHP_ME(sqlite3, exec, arginfo_sqlite3_query, ZEND_ACC_PUBLIC)
1934 PHP_ME(sqlite3, version, arginfo_sqlite3_void, ZEND_ACC_PUBLIC|ZEND_ACC_STATIC)
1935 PHP_ME(sqlite3, lastInsertRowID, arginfo_sqlite3_void, ZEND_ACC_PUBLIC)
1936 PHP_ME(sqlite3, lastErrorCode, arginfo_sqlite3_void, ZEND_ACC_PUBLIC)
1937 PHP_ME(sqlite3, lastErrorMsg, arginfo_sqlite3_void, ZEND_ACC_PUBLIC)
1938 PHP_ME(sqlite3, busyTimeout, arginfo_sqlite3_busytimeout, ZEND_ACC_PUBLIC)
1939 #ifndef SQLITE_OMIT_LOAD_EXTENSION
1940 PHP_ME(sqlite3, loadExtension, arginfo_sqlite3_loadextension, ZEND_ACC_PUBLIC)
1941 #endif
1942 PHP_ME(sqlite3, changes, arginfo_sqlite3_void, ZEND_ACC_PUBLIC)
1943 PHP_ME(sqlite3, escapeString, arginfo_sqlite3_escapestring, ZEND_ACC_PUBLIC|ZEND_ACC_STATIC)
1944 PHP_ME(sqlite3, prepare, arginfo_sqlite3_query, ZEND_ACC_PUBLIC)
1945 PHP_ME(sqlite3, query, arginfo_sqlite3_query, ZEND_ACC_PUBLIC)
1946 PHP_ME(sqlite3, querySingle, arginfo_sqlite3_querysingle, ZEND_ACC_PUBLIC)
1947 PHP_ME(sqlite3, createFunction, arginfo_sqlite3_createfunction, ZEND_ACC_PUBLIC)
1948 PHP_ME(sqlite3, createAggregate, arginfo_sqlite3_createaggregate, ZEND_ACC_PUBLIC)
1949 PHP_ME(sqlite3, createCollation, arginfo_sqlite3_createcollation, ZEND_ACC_PUBLIC)
1950 PHP_ME(sqlite3, openBlob, argingo_sqlite3_openblob, ZEND_ACC_PUBLIC)
1951 PHP_ME(sqlite3, enableExceptions, argingo_sqlite3_enableexceptions, ZEND_ACC_PUBLIC)
1952 /* Aliases */
1953 PHP_MALIAS(sqlite3, __construct, open, arginfo_sqlite3_open, ZEND_ACC_PUBLIC|ZEND_ACC_CTOR)
1954 PHP_FE_END
1955 };
1956 /* }}} */
1957
1958 /* {{{ php_sqlite3_stmt_class_methods */
1959 static zend_function_entry php_sqlite3_stmt_class_methods[] = {
1960 PHP_ME(sqlite3stmt, paramCount, arginfo_sqlite3_void, ZEND_ACC_PUBLIC)
1961 PHP_ME(sqlite3stmt, close, arginfo_sqlite3_void, ZEND_ACC_PUBLIC)
1962 PHP_ME(sqlite3stmt, reset, arginfo_sqlite3_void, ZEND_ACC_PUBLIC)
1963 PHP_ME(sqlite3stmt, clear, arginfo_sqlite3_void, ZEND_ACC_PUBLIC)
1964 PHP_ME(sqlite3stmt, execute, arginfo_sqlite3_void, ZEND_ACC_PUBLIC)
1965 PHP_ME(sqlite3stmt, bindParam, arginfo_sqlite3stmt_bindparam, ZEND_ACC_PUBLIC)
1966 PHP_ME(sqlite3stmt, bindValue, arginfo_sqlite3stmt_bindvalue, ZEND_ACC_PUBLIC)
1967 PHP_ME(sqlite3stmt, readOnly, arginfo_sqlite3_void, ZEND_ACC_PUBLIC)
1968 PHP_ME(sqlite3stmt, __construct, arginfo_sqlite3stmt_construct, ZEND_ACC_PRIVATE|ZEND_ACC_CTOR)
1969 PHP_FE_END
1970 };
1971 /* }}} */
1972
1973 /* {{{ php_sqlite3_result_class_methods */
1974 static zend_function_entry php_sqlite3_result_class_methods[] = {
1975 PHP_ME(sqlite3result, numColumns, arginfo_sqlite3_void, ZEND_ACC_PUBLIC)
1976 PHP_ME(sqlite3result, columnName, arginfo_sqlite3result_columnname, ZEND_ACC_PUBLIC)
1977 PHP_ME(sqlite3result, columnType, arginfo_sqlite3result_columntype, ZEND_ACC_PUBLIC)
1978 PHP_ME(sqlite3result, fetchArray, arginfo_sqlite3result_fetcharray, ZEND_ACC_PUBLIC)
1979 PHP_ME(sqlite3result, reset, arginfo_sqlite3_void, ZEND_ACC_PUBLIC)
1980 PHP_ME(sqlite3result, finalize, arginfo_sqlite3_void, ZEND_ACC_PUBLIC)
1981 PHP_ME(sqlite3result, __construct, arginfo_sqlite3_void, ZEND_ACC_PRIVATE|ZEND_ACC_CTOR)
1982 PHP_FE_END
1983 };
1984 /* }}} */
1985
1986 /* {{{ Authorization Callback
1987 */
1988 static int php_sqlite3_authorizer(void *autharg, int access_type, const char *arg3, const char *arg4, const char *arg5, const char *arg6)
1989 {
1990 switch (access_type) {
1991 case SQLITE_ATTACH:
1992 {
1993 if (memcmp(arg3, ":memory:", sizeof(":memory:")) && *arg3) {
1994 TSRMLS_FETCH();
1995
1996 #if PHP_API_VERSION < 20100412
1997 if (PG(safe_mode) && (!php_checkuid(arg3, NULL, CHECKUID_CHECK_FILE_AND_DIR))) {
1998 return SQLITE_DENY;
1999 }
2000 #endif
2001
2002 if (php_check_open_basedir(arg3 TSRMLS_CC)) {
2003 return SQLITE_DENY;
2004 }
2005 }
2006 return SQLITE_OK;
2007 }
2008
2009 default:
2010 /* access allowed */
2011 return SQLITE_OK;
2012 }
2013 }
2014 /* }}} */
2015
2016 /* {{{ php_sqlite3_free_list_dtor
2017 */
2018 static void php_sqlite3_free_list_dtor(void **item)
2019 {
2020 php_sqlite3_free_list *free_item = (php_sqlite3_free_list *)*item;
2021
2022 if (free_item->stmt_obj && free_item->stmt_obj->initialised) {
2023 sqlite3_finalize(free_item->stmt_obj->stmt);
2024 free_item->stmt_obj->initialised = 0;
2025 }
2026 efree(*item);
2027 }
2028 /* }}} */
2029
2030 static int php_sqlite3_compare_stmt_zval_free( php_sqlite3_free_list **free_list, zval *statement ) /* {{{ */
2031 {
2032 return ((*free_list)->stmt_obj->initialised && statement == (*free_list)->stmt_obj_zval);
2033 }
2034 /* }}} */
2035
2036 static int php_sqlite3_compare_stmt_free( php_sqlite3_free_list **free_list, sqlite3_stmt *statement ) /* {{{ */
2037 {
2038 return ((*free_list)->stmt_obj->initialised && statement == (*free_list)->stmt_obj->stmt);
2039 }
2040 /* }}} */
2041
2042 static void php_sqlite3_object_free_storage(void *object TSRMLS_DC) /* {{{ */
2043 {
2044 php_sqlite3_db_object *intern = (php_sqlite3_db_object *)object;
2045 php_sqlite3_func *func;
2046 php_sqlite3_collation *collation;
2047
2048 if (!intern) {
2049 return;
2050 }
2051
2052 while (intern->funcs) {
2053 func = intern->funcs;
2054 intern->funcs = func->next;
2055 if (intern->initialised && intern->db) {
2056 sqlite3_create_function(intern->db, func->func_name, func->argc, SQLITE_UTF8, func, NULL, NULL, NULL);
2057 }
2058
2059 efree((char*)func->func_name);
2060
2061 if (func->func) {
2062 zval_ptr_dtor(&func->func);
2063 }
2064 if (func->step) {
2065 zval_ptr_dtor(&func->step);
2066 }
2067 if (func->fini) {
2068 zval_ptr_dtor(&func->fini);
2069 }
2070 efree(func);
2071 }
2072
2073 while (intern->collations){
2074 collation = intern->collations;
2075 intern->collations = collation->next;
2076 if (intern->initialised && intern->db){
2077 sqlite3_create_collation(intern->db, collation->collation_name, SQLITE_UTF8, NULL, NULL);
2078 }
2079 efree((char*)collation->collation_name);
2080 if (collation->cmp_func){
2081 zval_ptr_dtor(&collation->cmp_func);
2082 }
2083 efree(collation);
2084 }
2085
2086 if (intern->initialised && intern->db) {
2087 sqlite3_close(intern->db);
2088 intern->initialised = 0;
2089 }
2090
2091 zend_object_std_dtor(&intern->zo TSRMLS_CC);
2092 efree(intern);
2093 }
2094 /* }}} */
2095
2096 static void php_sqlite3_stmt_object_free_storage(void *object TSRMLS_DC) /* {{{ */
2097 {
2098 php_sqlite3_stmt *intern = (php_sqlite3_stmt *)object;
2099
2100 if (!intern) {
2101 return;
2102 }
2103
2104 if (intern->bound_params) {
2105 zend_hash_destroy(intern->bound_params);
2106 FREE_HASHTABLE(intern->bound_params);
2107 intern->bound_params = NULL;
2108 }
2109
2110 if (intern->initialised) {
2111 zend_llist_del_element(&(intern->db_obj->free_list), intern->stmt,
2112 (int (*)(void *, void *)) php_sqlite3_compare_stmt_free);
2113 }
2114
2115 if (intern->db_obj_zval) {
2116 zval_ptr_dtor(&intern->db_obj_zval);
2117 }
2118
2119 zend_object_std_dtor(&intern->zo TSRMLS_CC);
2120 efree(intern);
2121 }
2122 /* }}} */
2123
2124 static void php_sqlite3_result_object_free_storage(void *object TSRMLS_DC) /* {{{ */
2125 {
2126 php_sqlite3_result *intern = (php_sqlite3_result *)object;
2127
2128 if (!intern) {
2129 return;
2130 }
2131
2132 if (intern->stmt_obj_zval) {
2133 if (intern->stmt_obj->initialised) {
2134 sqlite3_reset(intern->stmt_obj->stmt);
2135 }
2136
2137 if (intern->is_prepared_statement == 0) {
2138 zval_dtor(intern->stmt_obj_zval);
2139 FREE_ZVAL(intern->stmt_obj_zval);
2140 } else {
2141 zval_ptr_dtor(&intern->stmt_obj_zval);
2142 }
2143 }
2144
2145 zend_object_std_dtor(&intern->zo TSRMLS_CC);
2146 efree(intern);
2147 }
2148 /* }}} */
2149
2150 static zend_object_value php_sqlite3_object_new(zend_class_entry *class_type TSRMLS_DC) /* {{{ */
2151 {
2152 zend_object_value retval;
2153 php_sqlite3_db_object *intern;
2154
2155 /* Allocate memory for it */
2156 intern = emalloc(sizeof(php_sqlite3_db_object));
2157 memset(intern, 0, sizeof(php_sqlite3_db_object));
2158 intern->exception = 0;
2159
2160 /* Need to keep track of things to free */
2161 zend_llist_init(&(intern->free_list), sizeof(php_sqlite3_free_list *), (llist_dtor_func_t)php_sqlite3_free_list_dtor, 0);
2162
2163 zend_object_std_init(&intern->zo, class_type TSRMLS_CC);
2164 object_properties_init(&intern->zo, class_type);
2165
2166 retval.handle = zend_objects_store_put(intern, NULL, (zend_objects_free_object_storage_t) php_sqlite3_object_free_storage, NULL TSRMLS_CC);
2167 retval.handlers = (zend_object_handlers *) &sqlite3_object_handlers;
2168
2169 return retval;
2170 }
2171 /* }}} */
2172
2173 static zend_object_value php_sqlite3_stmt_object_new(zend_class_entry *class_type TSRMLS_DC) /* {{{ */
2174 {
2175 zend_object_value retval;
2176 php_sqlite3_stmt *intern;
2177
2178 /* Allocate memory for it */
2179 intern = emalloc(sizeof(php_sqlite3_stmt));
2180 memset(intern, 0, sizeof(php_sqlite3_stmt));
2181
2182 intern->db_obj_zval = NULL;
2183
2184 zend_object_std_init(&intern->zo, class_type TSRMLS_CC);
2185 object_properties_init(&intern->zo, class_type);
2186
2187 retval.handle = zend_objects_store_put(intern, NULL, (zend_objects_free_object_storage_t) php_sqlite3_stmt_object_free_storage, NULL TSRMLS_CC);
2188 retval.handlers = (zend_object_handlers *) &sqlite3_stmt_object_handlers;
2189
2190 return retval;
2191 }
2192 /* }}} */
2193
2194 static zend_object_value php_sqlite3_result_object_new(zend_class_entry *class_type TSRMLS_DC) /* {{{ */
2195 {
2196 zend_object_value retval;
2197 php_sqlite3_result *intern;
2198
2199 /* Allocate memory for it */
2200 intern = emalloc(sizeof(php_sqlite3_result));
2201 memset(intern, 0, sizeof(php_sqlite3_result));
2202
2203 intern->complete = 0;
2204 intern->is_prepared_statement = 0;
2205 intern->stmt_obj_zval = NULL;
2206
2207 zend_object_std_init(&intern->zo, class_type TSRMLS_CC);
2208 object_properties_init(&intern->zo, class_type);
2209
2210 retval.handle = zend_objects_store_put(intern, NULL, (zend_objects_free_object_storage_t) php_sqlite3_result_object_free_storage, NULL TSRMLS_CC);
2211 retval.handlers = (zend_object_handlers *) &sqlite3_result_object_handlers;
2212
2213 return retval;
2214 }
2215 /* }}} */
2216
2217 static void sqlite3_param_dtor(void *data) /* {{{ */
2218 {
2219 struct php_sqlite3_bound_param *param = (struct php_sqlite3_bound_param*)data;
2220
2221 if (param->name) {
2222 efree(param->name);
2223 }
2224
2225 if (param->parameter) {
2226 zval_ptr_dtor(&(param->parameter));
2227 param->parameter = NULL;
2228 }
2229 }
2230 /* }}} */
2231
2232 /* {{{ PHP_MINIT_FUNCTION
2233 */
2234 PHP_MINIT_FUNCTION(sqlite3)
2235 {
2236 zend_class_entry ce;
2237
2238 #if defined(ZTS)
2239 /* Refuse to load if this wasn't a threasafe library loaded */
2240 if (!sqlite3_threadsafe()) {
2241 php_error_docref(NULL TSRMLS_CC, E_WARNING, "A thread safe version of SQLite is required when using a thread safe version of PHP.");
2242 return FAILURE;
2243 }
2244 #endif
2245
2246 memcpy(&sqlite3_object_handlers, zend_get_std_object_handlers(), sizeof(zend_object_handlers));
2247 memcpy(&sqlite3_stmt_object_handlers, zend_get_std_object_handlers(), sizeof(zend_object_handlers));
2248 memcpy(&sqlite3_result_object_handlers, zend_get_std_object_handlers(), sizeof(zend_object_handlers));
2249
2250 /* Register SQLite 3 Class */
2251 INIT_CLASS_ENTRY(ce, "SQLite3", php_sqlite3_class_methods);
2252 ce.create_object = php_sqlite3_object_new;
2253 sqlite3_object_handlers.clone_obj = NULL;
2254 php_sqlite3_sc_entry = zend_register_internal_class(&ce TSRMLS_CC);
2255
2256 /* Register SQLite 3 Prepared Statement Class */
2257 INIT_CLASS_ENTRY(ce, "SQLite3Stmt", php_sqlite3_stmt_class_methods);
2258 ce.create_object = php_sqlite3_stmt_object_new;
2259 sqlite3_stmt_object_handlers.clone_obj = NULL;
2260 php_sqlite3_stmt_entry = zend_register_internal_class(&ce TSRMLS_CC);
2261
2262 /* Register SQLite 3 Result Class */
2263 INIT_CLASS_ENTRY(ce, "SQLite3Result", php_sqlite3_result_class_methods);
2264 ce.create_object = php_sqlite3_result_object_new;
2265 sqlite3_result_object_handlers.clone_obj = NULL;
2266 php_sqlite3_result_entry = zend_register_internal_class(&ce TSRMLS_CC);
2267
2268 REGISTER_INI_ENTRIES();
2269
2270 REGISTER_LONG_CONSTANT("SQLITE3_ASSOC", PHP_SQLITE3_ASSOC, CONST_CS | CONST_PERSISTENT);
2271 REGISTER_LONG_CONSTANT("SQLITE3_NUM", PHP_SQLITE3_NUM, CONST_CS | CONST_PERSISTENT);
2272 REGISTER_LONG_CONSTANT("SQLITE3_BOTH", PHP_SQLITE3_BOTH, CONST_CS | CONST_PERSISTENT);
2273
2274 REGISTER_LONG_CONSTANT("SQLITE3_INTEGER", SQLITE_INTEGER, CONST_CS | CONST_PERSISTENT);
2275 REGISTER_LONG_CONSTANT("SQLITE3_FLOAT", SQLITE_FLOAT, CONST_CS | CONST_PERSISTENT);
2276 REGISTER_LONG_CONSTANT("SQLITE3_TEXT", SQLITE3_TEXT, CONST_CS | CONST_PERSISTENT);
2277 REGISTER_LONG_CONSTANT("SQLITE3_BLOB", SQLITE_BLOB, CONST_CS | CONST_PERSISTENT);
2278 REGISTER_LONG_CONSTANT("SQLITE3_NULL", SQLITE_NULL, CONST_CS | CONST_PERSISTENT);
2279
2280 REGISTER_LONG_CONSTANT("SQLITE3_OPEN_READONLY", SQLITE_OPEN_READONLY, CONST_CS | CONST_PERSISTENT);
2281 REGISTER_LONG_CONSTANT("SQLITE3_OPEN_READWRITE", SQLITE_OPEN_READWRITE, CONST_CS | CONST_PERSISTENT);
2282 REGISTER_LONG_CONSTANT("SQLITE3_OPEN_CREATE", SQLITE_OPEN_CREATE, CONST_CS | CONST_PERSISTENT);
2283
2284 return SUCCESS;
2285 }
2286 /* }}} */
2287
2288 /* {{{ PHP_MSHUTDOWN_FUNCTION
2289 */
2290 PHP_MSHUTDOWN_FUNCTION(sqlite3)
2291 {
2292 UNREGISTER_INI_ENTRIES();
2293
2294 return SUCCESS;
2295 }
2296 /* }}} */
2297
2298 /* {{{ PHP_MINFO_FUNCTION
2299 */
2300 PHP_MINFO_FUNCTION(sqlite3)
2301 {
2302 php_info_print_table_start();
2303 php_info_print_table_header(2, "SQLite3 support", "enabled");
2304 php_info_print_table_row(2, "SQLite3 module version", PHP_SQLITE3_VERSION);
2305 php_info_print_table_row(2, "SQLite Library", sqlite3_libversion());
2306 php_info_print_table_end();
2307
2308 DISPLAY_INI_ENTRIES();
2309 }
2310 /* }}} */
2311
2312 /* {{{ PHP_GINIT_FUNCTION
2313 */
2314 static PHP_GINIT_FUNCTION(sqlite3)
2315 {
2316 memset(sqlite3_globals, 0, sizeof(*sqlite3_globals));
2317 }
2318 /* }}} */
2319
2320 /* {{{ sqlite3_module_entry
2321 */
2322 zend_module_entry sqlite3_module_entry = {
2323 STANDARD_MODULE_HEADER,
2324 "sqlite3",
2325 NULL,
2326 PHP_MINIT(sqlite3),
2327 PHP_MSHUTDOWN(sqlite3),
2328 NULL,
2329 NULL,
2330 PHP_MINFO(sqlite3),
2331 PHP_SQLITE3_VERSION,
2332 PHP_MODULE_GLOBALS(sqlite3),
2333 PHP_GINIT(sqlite3),
2334 NULL,
2335 NULL,
2336 STANDARD_MODULE_PROPERTIES_EX
2337 };
2338 /* }}} */
2339
2340 #ifdef COMPILE_DL_SQLITE3
2341 ZEND_GET_MODULE(sqlite3)
2342 #endif
2343
2344 /*
2345 * Local variables:
2346 * tab-width: 4
2347 * c-basic-offset: 4
2348 * End:
2349 * vim600: sw=4 ts=4 fdm=marker
2350 * vim<600: sw=4 ts=4
2351 */
2352