An Overview of MAPIT

MAPIT is an acronym for 'MySql and PHP Integrated Technology' a name I decided upon as the most appropriate for the functionality it provides. In simple terms it is a powerful MySql database management system that uses PHP code to create, edit, copy, search and delete mutiple database tables, fields and records.

This is a system I began to develop many years ago and still use today. The code itself needs to be on the server which allows access to one or more MySql databases. Obviously I cannot allow access to others for security reasons, but I can show you snapshots that give you a good idea of what is possible.

If you click on the image to the left you will see a snapshot which shows the details for the selected table 'offmembers'. In the left hand column are the dropdown selection boxes to select a database and then a table within the selected database.

In this next snapshot you can see how the 'Interogate' function has been used to find records where the field 'name' is like 'Peter' (like rather than equals is used when the checkbox alongside the field is clicked as in this case).

The right hand column now shows the number of records that meet the criteria and the first record found. In this case there is only one record; when more than one record is found a select list is shown enabling any other records to be viewed and edited.

One last point worth mentioning is that up to five fields within a table can be used to narrow the search using the 'Interogate' function.