Begin building content navigation by reviewing basic database connectivity and learn how to loop through returned records in order to output a list of the subjects stored in the database.
- [Instructor] In this chapter, we will learn to build…the navigation that the public is going to use…to change the page content that they're viewing.…We'll begin by creating a list…of the current subjects in the navigation.…This is going to apply the skills that we learned…in part one of this course, and it also gives us…an opportunity to do a quick review…of how PHP interacts with the database.…If you'll remember, there are five basic steps…to PHP-database interaction.…The first is we need to create a connection to the database.…After we have a connection, we can perform…a database query, we can use the data returned…by that query, if any, and then finally…release the returned data when we're done with it.…
That frees up memory.…And then, when we're done with all of it,…we can close the database connection at the end.…Steps one and five are performed only once per PHP script.…Steps two, three, and four…can be performed one or multiple times.…Let's look at it in PHP code.…Here you can see I'm using the mysqli_connect function.…
- 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.