Finally I have released version 3 of the MySQL Table Manager. The last version 2.8 was released in October 2003, that's nearly 5 years ago. I apologise for my lack of motivation in getting this one out, and hope you find the new version as useful as I do.

Many new features have been added such as user management, change privileges, backup functionality, ajax edit in place functionality to update fields, optimize tables, save queries, save results.

A new privilege system has been added that restricts functionality based on MySQL privileges and privileges set in the settings file. The privilege system works best with MySQL versions greater then 5.0.2.

To coincide with the release I have added support forums so it will be easier to track and manage support requests. Let me know what works and what fails in different MySQL server versions, operating systems or browsers.

Enjoy.

While testing the next version of Table Manager, which is badly in need of a new name, I once again have started adding new features. I have a simple test plan, basically a list of features or actions that need to be tested in different browser operating system combinations. Most of my testing at this stage has been while using the system to preform tasks for work etc. Occasionally while preforming a task I have an idea of a new feature which would simplify things, other times I come across features that are just plain missing. So my feature list of functionality to test gets longer and I have to start again at the top.

My latest additions have been MySQL user management related, things like adding users, changing passwords setting privileges etc. These are all handy features that I felt should be included so along with adding the functionality you need to check that the flow of menus and pages make sense.

Some of the features need to stand alone others work best when paired with something else and some need both. For example you can create a user as an isolated task but in reality a user without any privileges is a lonely user, so I am adding a button which will take you straight to grant privileges after a user is created.

Usually I develop on Linux then test on windows, this time things are around the other way. I am using my work laptop for the development (from home of course) and testing on my Linux system at home, hopefully I can get a work mac to test on once I have tied down the functionality. In most cases people will upload the system to a directory on there web server which will most likely be a Linux system of sorts with MySQL an PHP and Apache. So I need to throughly test that scenario. Testing on my local Linux box was going fine until I tried the backup functionality which works fine on Windows. At this stage I think it is just a path issue, more testing will tell.

So that's about where I am up to at the moment between work which has been getting really busy, family life and Aikido which is about to get back into full swing after a short break while Sensei visited Japan.

This php/mysql System enable users to submit a link and description to a database. An email is sent to notify the site administrator who can then check and approve the link before its available on the links page.

Links are grouped together by type and a menu structure is created to each group. Counts are kept of the visits to each link and number of links in each group.

This link system contains all the files required for creating the database, approving and viewing the links.

You require PHP and and a MySql databse to use this system. It was built with PHP4 but may run with earlier version.

As the product is free the creators and download sites accept no responsibility for any problems that may occur from the use or download of this product. We hope you find this links system useful and we welcome comments and suggestions.

Download LinkSystem.Zip here

Change log

Version 2.5 released September 2002

Upgraded for global variable set to off in PHP 4.1 or greater.
Admin page requires logon and is session based.
Createtablelinks page requires logon and is session based.

Version 2.4 released 25 February 2002.

Fixed a link from the admin page to a no longer
available add a link page.

Version 2.3 released 21 January 2002.

Added simple search functionality.
Made the system easier to customise.
Reduced the number of files required.

Version 2.2 realeased 9 December 2001.

An admin page has been added to enable the administrator to
approve, delete or edit selected links.

The PHP/MySQL Table Manager is designed to simplify administration of a MySql web database. With it you can easily:

• Create or delete a database
• Create, drop or rename tables
• Alter table structure
• Add or drop keys and indexes
• Add, remove or change the properties of columns
• Add, modify, search or delete table records
• Manage users and privileges
• Backup and restore databases
• Save queries and results
• Optimise tables

Requirements

You require PHP4.1.0 or greater and a MySql database to use this system. This Table Manager was designed for MySql database. It is assumed that the correct database privileges are in place before use.

As the product is free the creators and download sites accept no responsibility for any problems that may occur from the use or download of this product. We hope you find this system useful and we welcome comments and suggestions.

Download

You must log in to download this file. You can log in with an existing OpenID or create an account.

Change Log

DevShed have recently published a couple of articles,
Building An Extensible Form Validator Class which looks at building a PHP-based Form Validator object to validate HTML form input and Error Handling In PHP (part 1) shows you how PHP's error-handling functions can be used in real-world development.