For most websites, a well-defined, reliable content management system (CMS) is required to elevate a site's overall quality. Once an application is blueprinted, you need to start building the database tables necessary for proper function. Take a look at this training video and learn how to build a CMS database with MySQL at the helm.
- View Offline
- Exercise Files
In this movie, we're going to set up the database tables that we'll need for our …content management system. In addition to blueprinting the whole …project, it's also very helpful to map out what our project's database tables …are going to look like. This phase is called data modeling …because we're thinking about what kind of data we'll have and how we'll store it …and how it relates to each other. In our data model, we're going to have …three tables. We're going to have subjects, we're …going to have pages, then we're going to have our admins. …So, for subjects, you can see that we have our ID. …That's the primary key, the unique value for finding any subject.…
Then we'll have it's menu_name, the common name that the user will see, it's …position, so that we can sort them in a certain order. …And then a visible Boolean, that determines whether or not the subject is …visible to the public. Then we our pages, which are almost …exactly the same, except that they have a subject_id, which is a foreign key that …
- 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.