phpLiterAdmin v0.9



I have created a SQLite v2.x compatible Manager! You can't find a whole lot that are compatible with SQLite 2.x, but now there is 1 more. It is called phpLiterAdmin and released under the GPL v2 License


[DOWNLOAD LINK]


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

Features
  • Password Protection
  • Ability to lock the manager (won't allow anyone to access the database, even with a password)
  • Export the database, it doesn't just get the file itself, it formats it with SQLite CREATE TABLE, INSERT, etc.
  • Import, you can import a db file that will parse the SQLite Queries inside the file
  • Query Box, you can run multiple queries into your SQLite Database, however, you can only do 1 SELECT
  • Table list (of course)
  • VACUUM Command (Somewhat like MySQL OPTIMIZE, it removes empty space)
  • Empty selected tables
  • Drop selected tables
  • Show Create Table (SQLite Query that made the table)
  • Multiple Database Support! You can now easily edit more then 1 database without having to edit the file over and over again!
  • Supports more then 1 user!

Mailing List

Sign up so you can recieve news and updates about phpLiterAdmin!

Coming Soon!

Changelog

v0.9 - Date Unknown

Sorry, however, this release, no changelog was made

v0.7.2 - July 15, 2008
  • Added FAQ on Exporting Page
  • Exporting now features GZ Compression (Import too!)
  • BEGIN TRANSACTION now only show if there are any rows and if the option is chosen
v0.7.1 - July 13, 2008
  • Exporting an import from phpLiterAdmin with queries like CREATE INDEX, Unique etc. would cause a possible error in the order of how they were saved.
  • Introducing DEBUG MODE, which will sqlite_escape_string all values if you choose that option (recommended you download it with and without)
v0.7 - July 13, 2008
  • Fixed the CREATE|INSERT|UPDATE etc bug which if the file !is_writeable() then it would give an error, even if it properly executed, now it just outputs the query error if there is one
  • Muted the sqlite_query (@sqlite_query) in the list_tables(); function
  • list_tables now orders tables in ASC order by the table name
  • All settings variables are md5'd at the end of the script for possible security reasons...
  • Now you can have more then 1 username and password to be able to manage the databases!
  • Enhanced Exporting, with comments and now BEGIN TRANSACTION; and COMMIT;
  • Import no longer listens to !is_writeable, and tries to import if the database even if it isn't writeable and will return an SQLite Query Error if it didn't succeed
  • Drop and Empty Tables also no longer listen to is_writeable
  • Now shows column names in a SQLite SELECT *even* if no SQLite rows exist!
  • print_sct(); (Show Create Table) will return an error if the table does not exist
  • The export file now orders by tbl_name
  • Now more PHP comments
  • Attempts to delete the uploaded import file once it is done being used
v0.6 - July 13, 2008
  • Bug Fix: When a SELECT Query has an error, it would improperly display it, it has been fixed to not do that
  • Added Feature! It now supports multiple databases! So you can load all the databases into an array, and there will be a select box where you can choose which one to edit so you don't have to edit the file each time you want to move to another database
  • When you export your database, instead of the format sqlite_MONTH_DAY_YEAR.sql it is now DBname_MONTH_DAY_YEAR.sql
v0.5.1 - July 11, 2008
  • Bug Fix: The List table also listed indexes, which could output the table more then once, it will now only show tables (Will still export CREATE INDEX though)
  • Change: Instead of a .db export extension, it saves it as a .sql file
v0.5 - July 11, 2008
  • Released for the first time