PHPackages planetacodigo/pla - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Database & ORM](/categories/database) 4. / 5. planetacodigo/pla ActiveLibrary[Database & ORM](/categories/database) planetacodigo/pla ================= phpLiteAdmin is a web-based SQLite database admin tool written in PHP with support for SQLite3 and SQLite2 1.0.24(4y ago)0109GPL-1.0-or-laterPHPPHP >=5.2.4 Since Sep 19Pushed 4y agoCompare [ Source](https://github.com/planetacodigo/pla)[ Packagist](https://packagist.org/packages/planetacodigo/pla)[ RSS](/packages/planetacodigo-pla/feed)WikiDiscussions master Synced 1w ago READMEChangelogDependencies (1)Versions (26)Used By (0) phpLiteAdmin ============ [](#phpliteadmin) install with composer ``` $ composer require planetacodigo/pla ``` who to use ``` require("vendor/autoload.php"); use phpLiteAdmin\phpLiteAdmin; $phpLiteAdmin = new phpLiteAdmin(); $phpLiteAdmin->setPassword('admin'); $phpLiteAdmin->setDirectory('.'); $phpLiteAdmin->setDatabases([ [ 'path'=> 'database1.sqlite', 'name'=> 'Database 1' ], [ 'path'=> 'database2.sqlite', 'name'=> 'Database 2' ] ]); $phpLiteAdmin->web(); ``` phpLiteAdmin ============ [](#phpliteadmin-1) Website: Bitbucket: What is phpLiteAdmin? --------------------- [](#what-is-phpliteadmin) 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. News ---- [](#news) **05.09.2019: phpLiteAdmin 1.9.8.2 released [Download now](https://www.phpliteadmin.org/download/)** **03.09.2019: phpLiteAdmin 1.9.8.1 released [Download now](https://www.phpliteadmin.org/download/)** **30.08.2019: phpLiteAdmin 1.9.8 released [Download now](https://www.phpliteadmin.org/download/)** **17.08.2017: [Security alert: phpLiteAdmin 1.9.8-dev](https://www.phpliteadmin.org/2017/08/17/security-alert-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](https://www.phpliteadmin.org/download/)** **13.12.2016: Just released phpLiteAdmin 1.9.7! [Download now](https://www.phpliteadmin.org/download/)** **05.07.2015: Just released phpLiteAdmin 1.9.6! [Download now](https://www.phpliteadmin.org/download/)** Features -------- [](#features) - Lightweight - consists of a single 200KB source file for portability - Supports SQLite3 and SQLite2 databases - Translated and available in [15 languages](https://bitbucket.org/phpliteadmin/public/wiki/Localization) - and counting - Specify and manage an unlimited number of databases - Specify a directory and optionally its subdirectories to scan for databases - Create and delete databases - Add, delete, rename, empty, and drop tables - Browse, add, edit, and delete records - Add, delete, and edit table columns - Manage table indexes - Manage table triggers - Import and export tables, structure, indexes, and data (SQL, CSV) - View data as bar, pie, and line charts - Graphical search tool to find records based on specified field values - Create and run your own custom SQL queries in the free-form query editor/builder - Easily apply core SQLite functions to column values using the GUI - Write your own PHP functions to be available to apply to column values - Design your own theme using CSS or install a pre-made [theme from the community](https://bitbucket.org/phpliteadmin/public/wiki/Themes) - All presented in an intuitive, easy-to-use GUI that allows non-technical, SQL-illiterate users to fully manage databases - Allows multiple installations on the same server, each with a different password - Secure password-protected interface with login screen and cookies Demo ---- [](#demo) A live demo of phpLiteAdmin can be found here: Requirements ------------ [](#requirements) - a server with PHP >= 5.2.4 installed - at least one PHP SQLite library extension installed and enabled: PDO, SQLite3, or SQLiteDatabase PHP version 5.3.0 and greater usually comes with the SQLite3 extension installed and enabled by default so no custom action is necessary. Download -------- [](#download) The files in the source repositories are meant for development, not for use in production. You can find the latest downloads here: Installation ------------ [](#installation) See Configuration ------------- [](#configuration) **NEW** as of 1.9.4: You can now configure phpLiteAdmin in an external file. If you want to do this: - rename `phpliteadmin.config.sample.php` into `phpliteadmin.config.php` - do not change the settings in `phpliteadmin.php` but in `phpliteadmin.config.php` See for details. 1. Open `phpliteadmin.config.php` (or `phpliteadmin.php` before 1.9.4) in a text editor. 2. 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. 3. 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. ``` 4. Modify the `$password` variable to be the password used for gaining access to the phpLiteAdmin tool. 5. 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). 6. Save and upload `phpliteadmin.php` to your web server. 7. 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. Code Repository and pull requests --------------------------------- [](#code-repository-and-pull-requests) The code repository is available both on bitbucket and github: Github: Bitbucket: You are welcome to fork the project and send us pull requests on any of these platforms. Installing a theme ------------------ [](#installing-a-theme) 1. Download the themes package from the [project Downloads page](https://www.phpliteadmin.org/download/). 2. Unzip the file and choose your desired theme. 3. Upload `phpliteadmin.css` from the theme's directory alongside `phpliteadmin.php`. 4. Your theme will automatically override the default. Getting help ------------ [](#getting-help) The project's wiki provides information on how to do certain things and is located at . In addition, the project's discussion group is located at . Reporting errors and bugs ------------------------- [](#reporting-errors-and-bugs) If you find any issues while using the tool, please report them at [https://bitbucket.org/phpliteadmin/public/issues?status=new&status=open](https://bitbucket.org/phpliteadmin/public/issues?status=new&status=open) . License ------- [](#license) 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 <>. ### Health Score 26 — LowBetter than 43% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity10 Limited adoption so far Community13 Small or concentrated contributor base Maturity55 Maturing project, gaining track record Bus Factor1 Top contributor holds 93.5% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~0 days Total 25 Last Release 1694d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/6efed72abf68622b4010c9b0bf5b8e0eb732bd6ee6cf9e6d923ad150e783a0c6?d=identicon)[planetacodigo](/maintainers/planetacodigo) --- Top Contributors [![crazy4chrissi](https://avatars.githubusercontent.com/u/6806325?v=4)](https://github.com/crazy4chrissi "crazy4chrissi (215 commits)")[![diracleo](https://avatars.githubusercontent.com/u/3370219?v=4)](https://github.com/diracleo "diracleo (7 commits)")[![NaveenDA](https://avatars.githubusercontent.com/u/20555082?v=4)](https://github.com/NaveenDA "NaveenDA (2 commits)")[![DeyV](https://avatars.githubusercontent.com/u/311626?v=4)](https://github.com/DeyV "DeyV (2 commits)")[![vintagesucks](https://avatars.githubusercontent.com/u/13335308?v=4)](https://github.com/vintagesucks "vintagesucks (1 commits)")[![dreadnaut](https://avatars.githubusercontent.com/u/584584?v=4)](https://github.com/dreadnaut "dreadnaut (1 commits)")[![mehere](https://avatars.githubusercontent.com/u/1482130?v=4)](https://github.com/mehere "mehere (1 commits)")[![Tazeg](https://avatars.githubusercontent.com/u/6105535?v=4)](https://github.com/Tazeg "Tazeg (1 commits)") ### Embed Badge ![Health badge](/badges/planetacodigo-pla/health.svg) ``` [![Health](https://phpackages.com/badges/planetacodigo-pla/health.svg)](https://phpackages.com/packages/planetacodigo-pla) ``` ### Alternatives [doctrine/orm Object-Relational-Mapper for PHP 10.2k285.3M6.2k](/packages/doctrine-orm)[robmorgan/phinx Phinx makes it ridiculously easy to manage the database migrations for your PHP app. 4.5k46.2M405](/packages/robmorgan-phinx)[doctrine/migrations PHP Doctrine Migrations project offer additional functionality on top of the database abstraction layer (DBAL) for versioning your database schema and easily deploying changes to it. It is a very easy to use and a powerful tool. 4.8k204.8M440](/packages/doctrine-migrations)[mongodb/laravel-mongodb A MongoDB based Eloquent model and Query builder for Laravel 7.1k7.2M71](/packages/mongodb-laravel-mongodb)[mongodb/mongodb MongoDB driver library 1.6k64.0M546](/packages/mongodb-mongodb)[doctrine/mongodb-odm-bundle Symfony Doctrine MongoDB Bundle 38418.7M195](/packages/doctrine-mongodb-odm-bundle) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)