phpLiteAdmin Local SQLite Management Guide

phpLiteAdmin is a web-based SQLite management tool that runs as a single PHP file, suitable for local small projects, prototypes, or PHP applications that do not require MySQL.

Access Address

After extracting phpLiteAdmin to the web root directory phpliteadmin/:

http://localhost/phpliteadmin

(The specific path depends on the folder name and entry file name, commonly phpliteadmin.php or index.php in the directory.)

Installation

1. Download from phpliteadmin.org or GitHub.
2. Extract to htdocs/phpliteadmin/.
3. Edit phpliteadmin.config.php (or config.php):
   • Set $password to prevent unauthorized access.
   • Configure $directory to point to the directory containing .db / .sqlite files.
4. Ensure the PHP SQLite extension (php-sqlite3) is enabled.
5. Access via browser after starting Apache.

Prerequisites

• PHP with pdo_sqlite or sqlite3 extension.
• Web server (Apache + PHP, or php -S with appropriate configuration).

Verify the extension:

php -m | grep -i sqlite

Typical Use Cases

• Manage local .sqlite database files.
• Debug table structures for small CMS or tool projects.
• Lightweight local development without the need for MySQL.

Differences from phpMyAdmin

Frequently Asked Questions

Database file not found
Check if the $directory path in config is correct and that the web user has read permissions.

SQLite extension not loaded
Enable extension=pdo_sqlite or extension=sqlite3 in php.ini and restart Apache.

Conclusion

phpLiteAdmin is suitable for managing local SQLite files at http://localhost/phpliteadmin, without the need for MySQL service, making it a common tool for lightweight PHP projects.