Apache Friends Support Forum

Bob Strand wrote:XAMPP includes a sample SQLite application, the phonebook. After you install XAMPP, check out the phonebook demo. All the code is in xampp\htdocs\xampp in file phonebook.php. In this case, the first few lines of PHP code (about line 35 in the file) designate where the actual DB is located. Since there’s no SQLite “server,” there’s also no special location required for the databases.

I suggest you go to http://www.sqlite.org for more information on SQLite and specifically on creating a new database.
Hope that helps.

Sharley wrote:From version 1.7.4 the sqlite.exe files are no longer available to run sqlite.
In http://localhost/xampp/phpinfo.php you will see it enabled by default.

Version 1.7.3 of XAMPP was the last version with sqlite.exe in the \xampp\apache\bin\ folder.

In XAMPP there is the address book demo that should give you some clues.
http://localhost/xampp/phonebook.php
You can see the source code for details.

Bob Strand wrote:XAMPP includes a sample SQLite application, the phonebook. After you install XAMPP, check out the phonebook demo. All the code is in xampp\htdocs\xampp in file phonebook.php. In this case, the first few lines of PHP code (about line 35 in the file) designate where the actual DB is located. Since there’s no SQLite “server,” there’s also no special location required for the databases.

I suggest you go to http://www.sqlite.org for more information on SQLite and specifically on creating a new database.
Hope that helps.

I couldn't have said it better myself.

urboyfriend wrote:could i use sqlite without the command line shell?