Subjects have a one-to-many relationship to pages. Use the foreign key that forms this relationship to find and list the pages for each subject.
- [Instructor] In the previous movie,…we were able to create a list of subjects…to display in the navigation that users will…use to navigate the page content…of the public facing website.…In this movie, we will learn to add a list…of each subject's pages underneath those subject names.…What I mean is that underneath About Globe Bank,…there should be a series of pages of content…that are related to this subject.…About Globe Bank is the subject.…It's not the page, it doesn't have any content on its own.…There are a series of pages related to it that do,…and those should show up right below it.…
And then for consumer, there should be a list of pages…that show up under consumer, and so on.…If you recall, in the first part of this course,…we talked about the fact that there is…a one-to-many relationship between a subject and its pages.…One subject has many pages.…And the way that we represent this in a relational database…is we use a foreign key that's in the pages table.…And that's what relates them together.…So a subject with an id of three as its primary key…
- Creating a content management system
- Building dynamic content navigation
- Using context and function options for conditional behavior
- Hiding content from the public view
- Insecure direct object reference
- Allowing HTML in dynamic content
- Previewing content in the public context
- Working with cookies and sessions
- Storing status messages in the session
- Secure user authentication (login/logout)
- Regulating page access
- Nesting related resources
- Managing an ordered list automatically
Skill Level Beginner
PHP with MySQL Beyond the Basicswith Kevin Skoglund10h 26m Intermediate
MVC Frameworks for Building PHP Web Applicationswith Drew Falkman2h 57m Intermediate
1. Create a Content Management System
2. Build Dynamic Content Navigation
3. Use Context and Options
4. Cookies and Sessions
5. Regulate Page Access
6. Nesting Related Resources
Next steps1m 15s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.