Strengthen your PHP and MySQL skills by building a robust content management system with secure user authentication.
- [Voiceover] Welcome to PHP with MySQL Essential Training part two. My name is Kevin Skoglund. I'm excited to teach you more about PHP and MySQL because these are fundamental tools of web development. They allow us to create full-featured applications that connect to backend databases. This course is the second part of a series on PHP and MySQL. In this course, we will build on those skills from the previous course and finish building a content management system using PHP.
We will regulate access to all staff area pages so that users must first log in with a valid username and password before they can view the page, a process known as user authentication. We will discover the benefits of nesting resources such as our subjects and pages and examine how nesting impacts the organization of our project code. By the end of the course, the project we build together will be a working content management system with database-driven public pages and a password-protected staff area for managing the site content.
This is a beginner course, but it will assume that you already know the basics of PHP as well as the techniques from part one. If you need to review your skills, PHP Essential Training and PHP with MySQL Essential Training part one will prepare you with everything that you need to know for this course. Once you're ready, let's get started learning to use PHP with MySQL.
- 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