Share this ad

Description

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.

Fifteen years ago ten seconds to load a web page were an acceptable maximum - if it lasted longer, the visitors would lose interest was taught to web developers. Today, more than two seconds loading time is standard unless the website is loaded from a different continent - then three to four seconds are alowed. Today this kind of performance is one of the strengths of FASTproject - and many others that enhance the quality of your website.