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
38ZEND_DECLARE_MODULE_GLOBALS(sqlite3)
39
40static PHP_GINIT_FUNCTION(sqlite3);
41static int php_sqlite3_authorizer(void *autharg, int access_type, const char *arg3, const char *arg4, const char *arg5, const char *arg6);
42static void sqlite3_param_dtor(void *data);
43static int php_sqlite3_compare_stmt_zval_free(php_sqlite3_free_list **free_list, zval *statement);
44
45/* {{{ Error Handler
46*/
47static 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*/
77PHP_INI_BEGIN()
78    STD_PHP_INI_ENTRY("sqlite3.extension_dir",  NULL, PHP_INI_SYSTEM, OnUpdateString, extension_dir, zend_sqlite3_globals, sqlite3_globals)
79PHP_INI_END()
80/* }}} */
81
82/* Handlers */
83static zend_object_handlers sqlite3_object_handlers;
84static zend_object_handlers sqlite3_stmt_object_handlers;
85static zend_object_handlers sqlite3_result_object_handlers;
86
87/* Class entries */
88zend_class_entry *php_sqlite3_sc_entry;
89zend_class_entry *php_sqlite3_stmt_entry;
90zend_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. */
94PHP_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. */
182PHP_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. */
209PHP_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. */
235PHP_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. */
252PHP_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. */
270PHP_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. */
288PHP_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. */
306PHP_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. */
334PHP_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. */
407PHP_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. */
425PHP_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. */
448PHP_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. */
495PHP_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
573static 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. */
608PHP_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
683static 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
829static 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
838static 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
850static 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
862static 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. */
918PHP_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. */
968PHP_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()). */
1028PHP_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
1073typedef struct {
1074    sqlite3_blob *blob;
1075    size_t       position;
1076    size_t       size;
1077} php_stream_sqlite3_data;
1078
1079static 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
1086static 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
1103static 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
1116static int php_sqlite3_stream_flush(php_stream *stream TSRMLS_DC)
1117{
1118    /* do nothing */
1119    return 0;
1120}
1121
1122/* {{{ */
1123static 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
1186static int php_sqlite3_stream_cast(php_stream *stream, int castas, void **ret TSRMLS_DC)
1187{
1188    return FAILURE;
1189}
1190
1191static 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
1198static 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. */
1211PHP_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. */
1252PHP_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. */
1272PHP_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. */
1290PHP_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. */
1310PHP_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. */
1332PHP_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 */
1355PHP_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
1376static 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. */
1423PHP_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", &param.param_number, &param.parameter, &param.type) == FAILURE) {
1436        if (zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "sz|l", &param.name, &param.name_len, &param.parameter, &param.type) == FAILURE) {
1437            return;
1438        }
1439    }
1440
1441    Z_ADDREF_P(param.parameter);
1442
1443    if (!register_bound_parameter_to_sqlite(&param, 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. */
1456PHP_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", &param.param_number, &param.parameter, &param.type) == FAILURE) {
1469        if (zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "sz/|l", &param.name, &param.name_len, &param.parameter, &param.type) == FAILURE) {
1470            return;
1471        }
1472    }
1473
1474    Z_ADDREF_P(param.parameter);
1475
1476    if (!register_bound_parameter_to_sqlite(&param, 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. */
1489PHP_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 **)&param) == 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, &param->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. */
1609PHP_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. */
1661PHP_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. */
1679PHP_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. */
1704PHP_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. */
1727PHP_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. */
1782PHP_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. */
1806PHP_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. */
1832PHP_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 */
1839ZEND_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)
1843ZEND_END_ARG_INFO()
1844
1845ZEND_BEGIN_ARG_INFO(arginfo_sqlite3_busytimeout, 0)
1846    ZEND_ARG_INFO(0, ms)
1847ZEND_END_ARG_INFO()
1848
1849#ifndef SQLITE_OMIT_LOAD_EXTENSION
1850ZEND_BEGIN_ARG_INFO(arginfo_sqlite3_loadextension, 0)
1851    ZEND_ARG_INFO(0, shared_library)
1852ZEND_END_ARG_INFO()
1853#endif
1854
1855ZEND_BEGIN_ARG_INFO_EX(arginfo_sqlite3_escapestring, 0, 0, 1)
1856    ZEND_ARG_INFO(0, value)
1857ZEND_END_ARG_INFO()
1858
1859ZEND_BEGIN_ARG_INFO_EX(arginfo_sqlite3_query, 0, 0, 1)
1860    ZEND_ARG_INFO(0, query)
1861ZEND_END_ARG_INFO()
1862
1863ZEND_BEGIN_ARG_INFO_EX(arginfo_sqlite3_querysingle, 0, 0, 1)
1864    ZEND_ARG_INFO(0, query)
1865    ZEND_ARG_INFO(0, entire_row)
1866ZEND_END_ARG_INFO()
1867
1868ZEND_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)
1872ZEND_END_ARG_INFO()
1873
1874ZEND_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)
1879ZEND_END_ARG_INFO()
1880
1881ZEND_BEGIN_ARG_INFO_EX(arginfo_sqlite3_createcollation, 0, 0, 2)
1882    ZEND_ARG_INFO(0, name)
1883    ZEND_ARG_INFO(0, callback)
1884ZEND_END_ARG_INFO()
1885
1886ZEND_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)
1891ZEND_END_ARG_INFO()
1892
1893ZEND_BEGIN_ARG_INFO_EX(argingo_sqlite3_enableexceptions, 0, 0, 1)
1894    ZEND_ARG_INFO(0, enableExceptions)
1895ZEND_END_ARG_INFO()
1896
1897ZEND_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)
1901ZEND_END_ARG_INFO()
1902
1903ZEND_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)
1907ZEND_END_ARG_INFO()
1908
1909ZEND_BEGIN_ARG_INFO(arginfo_sqlite3stmt_construct, 1)
1910    ZEND_ARG_INFO(0, sqlite3)
1911ZEND_END_ARG_INFO()
1912
1913ZEND_BEGIN_ARG_INFO_EX(arginfo_sqlite3result_columnname, 0, 0, 1)
1914    ZEND_ARG_INFO(0, column_number)
1915ZEND_END_ARG_INFO()
1916
1917ZEND_BEGIN_ARG_INFO_EX(arginfo_sqlite3result_columntype, 0, 0, 1)
1918    ZEND_ARG_INFO(0, column_number)
1919ZEND_END_ARG_INFO()
1920
1921ZEND_BEGIN_ARG_INFO_EX(arginfo_sqlite3result_fetcharray, 0, 0, 1)
1922    ZEND_ARG_INFO(0, mode)
1923ZEND_END_ARG_INFO()
1924
1925ZEND_BEGIN_ARG_INFO(arginfo_sqlite3_void, 0)
1926ZEND_END_ARG_INFO()
1927/* }}} */
1928
1929/* {{{ php_sqlite3_class_methods */
1930static 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 */
1959static 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 */
1974static 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*/
1988static 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*/
2018static 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
2030static 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
2036static 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
2042static 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
2096static 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
2124static 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
2150static 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
2173static 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
2194static 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
2217static 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*/
2234PHP_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*/
2290PHP_MSHUTDOWN_FUNCTION(sqlite3)
2291{
2292    UNREGISTER_INI_ENTRIES();
2293
2294    return SUCCESS;
2295}
2296/* }}} */
2297
2298/* {{{ PHP_MINFO_FUNCTION
2299*/
2300PHP_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*/
2314static PHP_GINIT_FUNCTION(sqlite3)
2315{
2316    memset(sqlite3_globals, 0, sizeof(*sqlite3_globals));
2317}
2318/* }}} */
2319
2320/* {{{ sqlite3_module_entry
2321*/
2322zend_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
2341ZEND_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