Managing URLs
The next two pages to be developed will allow users to add URLs and view those already added. This section of the site relies upon three tables in the database: urls, url_types, and url_titles. See the Database Scheme sidebar for details.
Adding URLs
The add_url.php script will perhaps be the most complicated one in the whole Web application (because of the normalized database structure). The script’s form will take a URL, a URL title (or name), a description, and up to three categories. Upon receiving the form, the URL, URL title, and description values will be added to the url_titles table. Then the primary key from that table (title_id) will be used along with the type_id values to add one to three records to the urls table, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access