|
sqlite_exec
Executes a result-less query against a given database
(PHP 5, PECL sqlite:1.0.3)
Object oriented style (method): SQLiteDatabase { Executes an SQL statement given by the query against a given database handle (specified by the dbhandle parameter).
Warning:
SQLite will execute multiple queries separated by semicolons, so you can use it to execute a batch of SQL that you have loaded from a file or have embedded in a script. Parameters
Note:
Two alternative syntaxes are supported for compatibility with other database extensions (such as MySQL). The preferred form is the first, where the dbhandle parameter is the first parameter to the function. Return Values
This function will return a boolean result; The column names returned by
ExamplesExample 2326. Procedural example<?php Example 2327. Object-oriented example<?php Code Examples / Notes » sqlite_execrrf5000
If you run a multiline SQL command (an INSERT, for example), and there is a SQL error in any of the lines, this function will recognize the error and return FALSE. However, any correct commands before the one with the error will still execute. Additionally, if you run changes() after such an incident, it will report that 0 rows have been changed, even though there were rows added to the table by the successful commands. An example would be: <?php // create new database (OO interface) $dbo = new SQLiteDatabase("db/database.sqlite"); // create table foo $dbo->query("CREATE TABLE foo(id INTEGER PRIMARY KEY, name CHAR(255));"); // insert sample data $ins_query = "INSERT INTO foo (name) VALUES ('Ilia1'); INSERT INTO foo (name) VALUES('Ilia2'); INSECT INTO foo (name) VALUES('Ilia3');"; $dbo->queryExec($ins_query); // get number of rows changed $changes = $dbo->changes(); echo "<br />Rows changed: $changes<br />"; // Get and show inputted data $tableArray = $dbo->arrayQuery("SELECT * FROM foo;"); echo "Table Contents\n"; echo "<pre>\n"; print_r($tableArray); echo "\n</pre>"; ?> The above code should show that 0 rows have been changed, but that there is new data in the table. |
Change Languagesqlite_array_query sqlite_busy_timeout sqlite_changes sqlite_close sqlite_column sqlite_create_aggregate sqlite_create_function sqlite_current sqlite_error_string sqlite_escape_string sqlite_exec sqlite_factory sqlite_fetch_all sqlite_fetch_array sqlite_fetch_column_types sqlite_fetch_object sqlite_fetch_single sqlite_fetch_string sqlite_field_name sqlite_has_more sqlite_has_prev sqlite_key sqlite_last_error sqlite_last_insert_rowid sqlite_libencoding sqlite_libversion sqlite_next sqlite_num_fields sqlite_num_rows sqlite_open sqlite_popen sqlite_prev sqlite_query sqlite_rewind sqlite_seek sqlite_single_query sqlite_udf_decode_binary sqlite_udf_encode_binary sqlite_unbuffered_query sqlite_valid |