PHP Multipurpose Forms with data binding and cross table

Categories

Updated: 06/07/2006

PHP Multipurpose Forms with data binding and cross table: To administrate data has to be efficient and easy to handle. If you consider for example a publishers company with several authors who have written different books it makes no sense to present the data on different web pages. That''s not lucid. PHP and MySql programming and a cross table can help you out. The cross table holds the id-data from the author and book table. All the action will take place on one web page. Show data, add data, edit data and delete data: We take the authors from a dropdown list, using arrays and ensure the control is still in the right position, when an author was activated. In this query we ask also for the book data using the cross table in which the author_id is allocated to the book_id. To add or edit author or books data we open new controls. If a new author has been added his data will be presented in the main form. Authors can not be deleted if there is a corresponding book. A new book entry corresponds to the author and adds the data in the books.