At this point, the fundamentals of PHP have come together to create a framework in which you can start to learn more intermediate MySQL functions and features. Watch this online tutorial video to learn why blueprinting your applications, via PHP and MySQL, are necessary in establishing defined public and admin spaces within a website.
- View Offline
- Exercise Files
Now that we've learned the fundamentals of PHP and also know how to connect PHP …to MySQL, we're going to put it all together. …We're going to build our first PHP project. …That's going to give us the opportunity to apply what we've learned to see how to …approach development tasks. And to get an overall feel for the flow …of development, as well as to pick up a few more tips to help you to write better …code and to avoid common mistakes. The project that we're going to be …building is a Content Management System or CMS for short. …Now if you've never worked with a CMS before, the idea is to have private web …pages that help us to manage the content of our public website.…
In other words, the public mostly just views our content. …That is they read it from the database. But then there will be an admin area. …And the admins will be able to do CRUD on the content. …That is create, read, update, and delete the subject and pages of our website. …An essential first step when starting any web project, is to create a project blueprint. …
- What is PHP?
- Installing and configuring PHP and MySQL
- Exploring data types
- Controlling code with logical expressions and loops
- Using PHP's built-in functions
- Writing custom functions
- Building dynamic webpages
- Working with forms and form data
- Using cookies and sessions to store data
- Connecting to MySQL with PHP
- Creating and editing database records
- Building a content management system
- Adding user authentication
Skill Level Beginner
PHP with MySQL Beyond the Basicswith Kevin Skoglund10h 26m Intermediate
1. PHP Overview
2. Mac Installation
3. Windows Installation
4. First Steps
5. Exploring Data Types
6. Control Structures: Logical Expressions
7. Control Structures: Loops
8. User-Defined Functions
10. Building Web Pages with PHP
11. Working with Forms and Form Data
12. Working with Cookies and Sessions
13. MySQL Basics
14. Using PHP to Access MySQL
15. Building a Content Management System (CMS)
16. Using Site Navigation to Choose Content
17. Application CRUD
18. Building the Public Area
19. Regulating Page Access
Next steps2m 4s
- 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.