|
|
Posted by Jim Carlock on 01/23/07 23:29
"Jim Carlock" wrote:
: I added the following lines to PHP.INI.
:
: extension=php_pdo.dll
: extension=php_pdo_sqlite.dll
: extension=php_sqlite.dll
:
: specifically in that order. I noticed the extensions getting loaded
: are alphabetally listed, so I'm thinking that the order of the load
: doesn't matter.
:
: Is that true?
I don't have an answer to that question.
: And when I use the following statements to create a test.db file...
I forgot to type in the statements. The [extension=php_sqlite.dll]
line above provides the mechanisms...
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_has_more()
sqlite_has_prev()
sqlite_key()
sqlite_last_error()
sqlite_next()
sqlite_prev()
sqlite_rewind()
sqlite_seek ()
sqlite_query()
sqlite_query()
sqlite_open()
sqlite_popen()
There's a sqlite.api file available at with provides the parameter lists
for SciTE at the following link...
http://www.microcosmotalk.com/tech/windows/php/sqlite
// The following makes the data file, and creates a table in it...
// The file created though, contains the following string identifying
// it as:
// ** This file contains an SQLite 2.1 database **
var $hDb;
var $sSQL_MT;
var $sErrMsg;
$hDb = sqlite_open("path_to_folder/names.db", 0666, $sErrMsg);
$sSQL_MT = "CREATE TABLE (first_name text, last_name text);";
sqlite_exec($hDb, $sSQL_MT, $sErrMsg);
sqlite_close($hDb);
My aplogies about leaving that out in the last post.
: Searching php.net for that string turned up the following link:
:
: http://gcov.php.net/PHP_5_2/lcov_html/ext/sqlite/libsqlite/src/btree.c.gcov.php
:
I believe I've identified a way to create SQLite version 3 files.
It involves commenting the following line out of the PHP.INI.
; extension=php_sqlite.dll
I'll update this thread once I get a query together to test out
creating a PDO object to create the file, unless someone else
has already run through this and beats me to it.
: It appears that PHP 5.2 mis-identifies the file. I took a look
: at some other software found at SourceForge advertised as
: a visual front end to access and create SQLite databases.
: However, the SQLite Browser identifies the SQLite data file
: as NOT a 3.1 version (perhaps due to PHP's mis-tagging (?)).
:
: http://sqlitebrowser.sourceforge.net
: http://sourceforge.net/projects/sqlitebrowser
:
: Can anyone else confirm this?
I answered that question in the above comments.
There's two SciTE .api files at the following link with instructions
on how to get the SQLite API drop-downs/parameters activated
in SciTE at the following link (sqlite.api and pdo.api).
http://www.microcosmotalk.com/tech/windows/php/sqlite
--
Jim Carlock
Post replies to the group.
http://www.microcosmotalk.com/tech/windows/php/sqlite
[Back to original message]
|