MySQL SiteMaker (mySiteMaker) is a collection of CGI tools to rapidly create web interfaces to MySQL database tables. It started out as a "Lite" version of phpMyAdmin, which may sound silly and pointless because phpMyAdmin is such a great tool for administrators, BUT sometimes phpMyAdmin is overkill; especially when you want a web front end to a MySQL database and the intended users are the general public and not administrators. Since its beginning, however, many, many useful features have been added that make mySiteMaker an entirely different beast. Features: Web based configuration. Automatically generates Search, Results, Add and Edit HTML screens. The search screen is very simple, easy to use and does not require the user to have any knowledge of SQL. The user can select which columns they want to view or export. Searches can be based on the contents of files that the user can upload. For example, the user might have a list of employee numbers in a file and, instead of having to run a separate search for each number, they can just upload the file that contains the numbers. Searches can be refined by allowing searches within result sets. This effectively lets users append AND style clauses to their searches without complicating the user interface and without requring the user to know SQL. Data can be viewed or exported in a variety of ways: as HTML pages, as tab delimited text files and as MS-Excel files. The administrator may specify columns in the database that contain only URLs or email address and they will appear in the results screen as hyper-links. |
