Managing URLs
The next three pages to be developed will allow users to add URLs, view those already added, and edit the existing records. This section of the site relies upon three tables in the content database: urls, url_categories, and url_associations. See the “Database Scheme” sidebar for details.
Adding URLs
The add_url.php script will be one of the most complicated ones in the whole Web application on account of the normalized database structure. The script’s form will take a URL, a URL title (or name), a description, and the categories with which it should be associated. Upon receiving the form, the URL, URL title, and description values will be added to the urls table. Then the primary key from that table (url_id) will be used along ...
Get PHP and MySQL for Dynamic Web Sites: Visual Quickpro Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
