add sqlite_exec - now to the right tag

smalyshev · smalyshev · commit 49a1413f504e · 2004-05-13T14:54:55.000Z
diff --git a/ext/sqlite/php_sqlite.h b/ext/sqlite/php_sqlite.h
@@ -46,6 +46,7 @@ PHP_FUNCTION(sqlite_open);
 PHP_FUNCTION(sqlite_popen);
 PHP_FUNCTION(sqlite_close);
 PHP_FUNCTION(sqlite_query);
+PHP_FUNCTION(sqlite_exec);
 PHP_FUNCTION(sqlite_unbuffered_query);
 PHP_FUNCTION(sqlite_array_query);
 PHP_FUNCTION(sqlite_single_query);
diff --git a/ext/sqlite/sqlite.c b/ext/sqlite/sqlite.c
@@ -126,6 +126,7 @@ function_entry sqlite_functions[] = {
 	PHP_FE(sqlite_popen, arg3_force_ref)
 	PHP_FE(sqlite_close, NULL)
 	PHP_FE(sqlite_query, NULL)
+	PHP_FE(sqlite_exec, NULL)
 	PHP_FE(sqlite_array_query, NULL)
 	PHP_FE(sqlite_single_query, NULL)
 	PHP_FE(sqlite_fetch_array, NULL)
@@ -1111,6 +1112,37 @@ PHP_FUNCTION(sqlite_query)
 }
 /* }}} */
 
+/* {{{ proto boolean sqlite_exec(string query, resource db)
+   Executes a result-less query against a given database */
+PHP_FUNCTION(sqlite_exec)
+{
+	zval *zdb;
+	struct php_sqlite_db *db;
+	char *sql;
+	long sql_len;
+	char *errtext = NULL;
+
+	if (FAILURE == zend_parse_parameters_ex(ZEND_PARSE_PARAMS_QUIET,
+			ZEND_NUM_ARGS() TSRMLS_CC, "sr", &sql, &sql_len, &zdb) && 
+		FAILURE == zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "rs", &zdb, &sql, &sql_len)) {
+		return;
+	}
+	DB_FROM_ZVAL(db, &zdb);
+
+	PHP_SQLITE_EMPTY_QUERY;
+
+	db->last_err_code = sqlite_exec(db->db, sql, NULL, NULL, &errtext);
+
+	if (db->last_err_code != SQLITE_OK) {
+		php_error_docref(NULL TSRMLS_CC, E_WARNING, "%s", errtext);
+		sqlite_freemem(errtext);
+		RETURN_FALSE;
+	}
+
+	RETURN_TRUE;
+}
+/* }}} */
+
 /* {{{ php_sqlite_fetch_array */
 static void php_sqlite_fetch_array(struct php_sqlite_result *res, int mode, zend_bool decode_binary, int move_next, zval *return_value TSRMLS_DC)
 {
