Website: https://www.phpliteadmin.org/
Bitbucket: https://bitbucket.org/phpliteadmin/public/
phpLiteAdmin is a web-based SQLite database admin tool written in PHP with support for SQLite3 and SQLite2. Following in the spirit of the flat-file system used by SQLite, phpLiteAdmin consists of a single source file, phpliteadmin.php, that is dropped into a directory on a server and then visited in a browser. There is no installation required. The available operations, feature set, interface, and user experience is comparable to that of phpMyAdmin.
05.09.2019: phpLiteAdmin 1.9.8.2 released Download now
03.09.2019: phpLiteAdmin 1.9.8.1 released Download now
30.08.2019: phpLiteAdmin 1.9.8 released Download now
17.08.2017: Security alert: phpLiteAdmin 1.9.8-dev (stable versions not affected)
14.12.2016: Just released phpLiteAdmin 1.9.7.1 as 1.9.7 was built incorrectly Download now
13.12.2016: Just released phpLiteAdmin 1.9.7! Download now
05.07.2015: Just released phpLiteAdmin 1.9.6! Download now
A live demo of phpLiteAdmin can be found here: https://demo.phpliteadmin.org/
PHP version 5.3.0 and greater usually comes with the SQLite3 extension installed and enabled by default so no custom action is necessary.
The files in the source repositories are meant for development, not for use in production.
You can find the latest downloads here: https://www.phpliteadmin.org/download/
See https://bitbucket.org/phpliteadmin/public/wiki/Installation
NEW as of 1.9.4: You can now configure phpLiteAdmin in an external file. If you want to do this:
phpliteadmin.config.sample.php
into phpliteadmin.config.php
phpliteadmin.php
but in
phpliteadmin.config.php
See https://bitbucket.org/phpliteadmin/public/wiki/Configuration for details.
Open phpliteadmin.config.php
(or phpliteadmin.php
before 1.9.4) in
a text editor.
If you want to have a directory scanned for your databases instead of
listing them manually, specify the directory as the value of the
$directory
variable and skip to step 4.
If you want to specify your databases manually, set the value of the
$directory
variable as false and modify the $databases
array to
hold the databases you would like to manage.
The path field is the file path of the database relative to where
phpliteadmin.php
will be located on the server. For example, if
phpliteadmin.php
is located at "databases/manager/phpliteadmin.php" and
you want to manage "databases/yourdatabase.sqlite", the path value
would be "../yourdatabase.sqlite".
The name field is the human-friendly way of referencing the database within the application. It can be anything you want.
Modify the $password
variable to be the password used for gaining access
to the phpLiteAdmin tool.
If you want to have multiple installations of phpLiteAdmin on the same
server, change the $cookie_name
variable to be unique for each installation
(optional).
Save and upload phpliteadmin.php
to your web server.
Open a web browser and navigate to the uploaded phpliteadmin.php
file. You
will be prompted to enter a password. Use the same password you set in step 4.
The code repository is available both on bitbucket and github:
Github: https://github.com/phpLiteAdmin/pla
Bitbucket: https://bitbucket.org/phpliteadmin/public/src
You are welcome to fork the project and send us pull requests on any of these platforms.
Download the themes package from the project Downloads page.
Unzip the file and choose your desired theme.
Upload phpliteadmin.css
from the theme's directory alongside
phpliteadmin.php
.
Your theme will automatically override the default.
The project's wiki provides information on how to do certain things and is located at https://bitbucket.org/phpliteadmin/public/wiki/Home . In addition, the project's discussion group is located at https://groups.google.com/group/phpliteadmin .
If you find any issues while using the tool, please report them at https://bitbucket.org/phpliteadmin/public/issues?status=new&status=open .
This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program. If not, see <https://www.gnu.org/licenses/>.