PHP and MySQL Web Development - P119: PHP and MySQL Web Development teaches the reader to develop dynamic, secure, commercial Web sites. Using the same accessible, popular teaching style of the first edition, this best-selling book has been updated to reflect the rapidly changing landscape of MySQL and PHP. | 562 Chapter 26 Building a Content Management System tn_width max_width else tn_width ceil y_ratio width tn_height max_height Solution Design Overview A summary of the files in this application is shown in Table . Table Files in the Content Management Application Name Type Description SQL SQL to set up the content database and some sample data Functions Collection of include files for this application Functions Collection of functions for connecting to content database Functions Collection of functions to aid creation of SELECT lists Functions Collection of functions for authenticating users Template Shown at the top of every content page Template Shown at the bottom of every content page Image The logo file displayed in Application Shows the most recent headline from each page of the site Application Lists the headlines and story text for a particular page Application Resizes an image on-the-fly for Application Form to enter keywords for searching the site content Application Displays headlines of content matching keyword criteria Application Authenticates a user s password and logs her in to the system Application Logs a user out of the system Application Lists stories that the logged-in user has written with an option to add modify or delete stories Application The story detail screen for editing or adding a new story Designing the Database 563 Table Continued Name Type Description Application Adds new story or commits changes from data entered in Application Processes story delete request from Application Lists keywords for a story with option to add or delete keywords Application Processes keyword add request from .
