Defining and creating data relationships in MySQL can make the job of maintaining data easier. In relational database tables data relationships, such as one-to-many, are maintained through the use of foreign keys. This online video shows you how to create a table and add a foreign key to connect the data to another table.
- View Offline
- Exercise Files
In this movie we'll learn how relational databases work. …The idea behind relational databases is simple but the results are very powerful. …Let's imagine for a moment that a subject like about Widget Corp, that we created …in the last movie. Let's imagine that it has a set of pages …that should be listed under that subject. This is what would be called a one to …many relationship. And when describing that relationship, …you can say that a subject has many pages and that each page belongs to the subject. …In order to understand why having a relationship is important, let's imagine …for a moment that when each one of these pages displays on the final public site.…
Then it also needs to display the subject name along with the page, the subject …that it belongs to. So we could create a table for our pages …and we could give that table a column called subject name. …And then we could store the subject name with each and every page. …But then what happens if the subject name changes at some point, we want to make a …
- 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.