|
|
|
|
Bookmark this on Delicious
Share on Facebook
 Slashdot It!
Digg  sqlite_open
Opens a SQLite database and create the database if it does not exist
(PHP 5, PECL sqlite:1.0-1.0.3)
Example 2338. sqlite_open() example<?phpCode Examples / Notes » sqlite_open15-nov-2006 10:45
the above example dows not! work since sqlite_query() does not accept one argument, but only 2. so correct is: <?php if ($db = sqlite_open('mysqlitedb', 0666, $sqliteerror)) { sqlite_query($db,'CREATE TABLE foo (bar varchar(10))'); sqlite_query($db,"INSERT INTO foo VALUES ('fnord')"); $result = sqlite_query($db,'select bar from foo'); var_dump(sqlite_fetch_array($result)); } else { die ($sqliteerror); } ?> ivoras
Since sqlite uses a journal to do updates and inserts (and creates it on the fly), you ALSO must have write permissions set for the web server to write in the same DIRECTORY as the database file.
phillip berndt
If you miss to set the permissions mentioned by ivoras Sqlite will drop an error message saying "Malformed database scheme", which is somehow misleading. (I mentioned this as some [I did] might search php.net for this error message) |
Change Language
sqlite_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 |
