phpLiterAdmin, the better SQLite Manager

phpLiterAdmin is an SQLite Manager which uses PHP. Unlike some SQLite Managers, phpLiterAdmin is SQLite v2.x compatible. Many features are in phpLiterAdmin right now, and hopefully more to come.

phpLiterAdmin v1.0

The newest version of phpLiterAdmin is currently available, however, it is not officially released, though you can download it through the Downloads page or get the latest through our SVN.

Instructions: Download of course, then open the phpliteradmin.php file, find $settings'users' and change the username and password (Read the comments on how to add more users), this makes it so you can protect your database file then find $settings'db' and change database.db to the path of your database (You can also put an array of databases, read the file for more information). Now, if you want to be able to write (CREATE TABLE, INSERT, UPDATE, DROP, DELETE, lol, and so on) to the database file, you need to CHMOD the file to 777, otherwise you can only do like SELECT and anything that has nothing to do with altering the file ;]

If you find any security holes, please contact me @ aldo@mschat.net

Feature List

• Ability to switch databases quickly. (Multiple database support)
• Password protection with multiple users.
• Lock down mode
• Export and import the database
• Query box, where you can run multiple queries into your database. You can also query a SELECT and have the results displayed.
• List of tables in the database
• Quick table tools including: VACUUM, Empty tables, drop tables and show/hide indexes.
• Quickly insert rows into tables
• Quickly edit rows
• Quickly delete rows (Since v1.0)
• Show Create Table ability
• Table structure viewer (Since v1.0)
• Table creation tool (Since v1.0)