Once your navigation is working in MySQL, you will have an ID for the current subject of the current page, and will be able to add CRUD to the app. CRUD stands for Create, Read, Update, and Delete, and in order to add it to the application, you will need to access the appropriate content. This online video walks you through the process of finding a subject in the database in order to read it.
- View Offline
- Exercise Files
Now that we have a working navigation for our staff area, which sends an ID for the …current subject of the current page. We're ready to use that ID to pull up the …content that corresponds to it. Now, this is our first step in adding …CRUD to our application. It's the read, in create, read, update …and delete. So we're still going to be working with …our manage content.php page. Essentially what we want to do is right …here in this manage content area. We want to display the subject if the …subject is selected, or the page, if the page is selected.…
We just want to read back that data. So let's first of all, let's just put in …a little PHP here. And let's just do a real quick, PHP if …Let's check and see if the selected subject ID has been set. …Then we know that we're going to display a subject. …Alright. And let me just make another PHP block here. …So that will go like this. Else.…
If we have a deleted page id then we'll know that we are working with a page. …Otherwise we'll know that we don't have either one, nothing has been selected... …
- 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.