PHP SQLView 2.8

A user friendly interface for browsing a SQL database and modifying SQL tables using a Web browser
PHP SQLView
  2 Screenshots
SQLView provides a user friendly interface for browsing a SQL database and modifying SQL tables using a Web browser.

This is strictly an application to give users access to view and modify their SQL tables. PHP SQLView is not a tool to help database administrators (other than perhaps getting users to manage their own data).

Users often have data in SQL databases and while they are keenly interested in the data in the tables, they sometimes have little motivation or ability to use command line interfaces or generate SQL commands to see or modify the data.

SQLView provides a user friendly interface for browsing a SQL database and modifying SQL tables using a web browser. This is stickly an application to give users access to view and modify their SQL tables. It is not a tool to help database administrators (other than perhaps getting users to do manage their own data).

Using a local configuration file to set default values, the user might be prompted for all information to connect to a database (type of database, host, userid, password etc.) or as little as one field.

SQLView allows one to walk through a table, viewing all rows. If the tables have a primary key and SQLView is so enabled, the users may modify any given column for a row, may add a row or even delete a row. Additionally, the user may export data from the table in a convenient comma separated value (CSV) format.

In addition to the expected "Add Record" and "Del" (delete), one convenient form is "Copy". In this case an existing row is editted and the user is expected to modify the primary key. Since the database is modified with an INSERT SQL statement, the primary key provided by the user must be unique and may not already exist.

last updated on:
June 13th, 2012, 9:00 GMT
price:
FREE!
homepage:
phpsqlview.sourceforge.net
license type:
GPL (GNU General Public License) 
developed by:
Terry Gliedt
category:
ROOT \ Internet \ HTTP (WWW)
PHP SQLView
Download Button

In a hurry? Add it to your Download Basket!

user rating

UNRATED
0.0/5
 

0/5

Rate it!
2 Screenshots
PHP SQLView
What's New in This Release:
  • Various bugfixes.
  • The dependency on Pear::DB has been removed, since many sites do not install it.
  • This means that only MySQL is supported until someone codes alternatives in the interface module.
read full changelog

Add your review!

SUBMIT