GpsTracker / servers / php / sqlite /
@brentfraser brentfraser authored on 4 Sep 2015
..
README.md added notes on SQLite 9 years ago
gpstracker-09-14-14.sql changed 0001-01-01 to 0000-00-00 for preparation to use nulls a 9 years ago
gpstracker.sqlite added databases 9 years ago
README.md

PHP and SQLite

Unlike using a client-server database (such as MySQL, PostgreSQL, or SQL Server), using SQLite with GpsTracker does not require installing any databse software. It does still require a web server, such as Apache, and PHP scripting. You need to create a website on your Apache web server and create a directory called gpstracker. Put all of the files from the php download directory into there.

The SQLite subdirectory inside the PHP directory contains a gpstracker.sqlite file with the table and views already setup and read to go! Open GpsTracker's PHP file "dbconnect.php" to set the database type to SQLite:

$dbType = DB_SQLITE3;

That's it!