The sakila database is a sample video rental business with basic tables for storing customer, inventory, and rental information. My goal is to write a framework for creating generic forms without additonal programming. To accomplish this, I have added two meta-data tables that store information about web forms for business processes. The goal is to create a php program that will read the meta-data from the database and create the form accordingly. In this way, new functions could be added to the application with no additional programming.

My first attempts are with displaying the database tables and generating simple reports. Each of these options has just one php program that takes a parameter and does a meta-data query to display a dynamic form.

Now that these two are functional, I am working on a basic customer application management program to find, create, update, and delete customer records. Please use the links to view the tables structure, visit the forms, and view the code behind them. This is a work in progress, so if a link is absent or not functional, then I'm still working on it!