In this challenge assignment, you are asked to create a new table for storing records about pages of content.
- [Instructor] It's time for another challenge assignment.…So far in this chapter,…we've been learning how to use MySQL to create tables…and to populate them with data.…We've been doing that using our Subjects Table.…Now, your challenge assignment is to do that same work…but with the Pages Table that we're also going to need.…Let me walk you though the points…you need to make sure you hit.…First, start by logging completely out of MySQL,…so you can get a fresh start.…Log into MySQL.…Make sure that you can do that confidently.…You want to do that as the root user,…and supply a password.…
And then once you're in there,…make sure that you're using the correct database.…Use the globe_bank database we already created.…And then create a table for pages.…It's extremely helpful…if you construct that table definition in a text editor,…and not try and do it from the command line.…Do it in a text editor first,…where you have the ability to make revisions,…to check for bugs,…make sure that you've got it all just right,…and then copy and paste it into MySQL…
- Organizing project files
- Including and requiring files
- Working with URL parameters
- Encoding dynamic content
- Modifying headers and page redirection
- Creating forms and processing form data
- MySQL basics
- Using PHP to access database tables
- Creating, reading, updating, and deleting database records with PHP
- Validating data
- Preventing SQL injection
Skill Level Beginner
1. Start a Database-Driven Project
2. Build Web Pages with PHP
3. Headers and Redirects
4. Build Forms with PHP
5. MySQL Basics
6. Use PHP to Access MySQL
7. CRUD with PHP
8. Validate Data with PHP
9. Prevent SQL Injection
Next steps1m 8s
- 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.