PHP with MySQL Essential Training: 2 Build a CMS

This course—the second installment in a series—builds on the fundamentals of PHP with MySQL and teaches the intermediate concepts necessary to develop real-world web applications while creating a working content management system. Kevin Skoglund shows how to create dynamic navigation to allow public users to browse different pages of database-driven content. He demonstrates how to hide content from the public and to write functions which are context-sensitive and use argument options for conditional behavior. He shows how to implement user authentication and utilize PHP's built-in password functions to securely regulate page access. Finally, he shows how related database tables can become nested resources by modifying and scoping functions. Along the way, Kevin provides practical advice and offers examples of best practices.

Learning objectives
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