- Getting Specific with Queries 4:38
- Filtering Data by Category 6:28
- Filtering Data 3 objectives
- Setting Up Pagination Variables 7:43
- Calculations and Links 5:32
- Variable and Calculations 5 questions
- Setting LIMITs 4:52
- LIMIT and OFFSET 2 objectives
- Adding Pagination Links 7:05
- Pagination Function 2 objectives
- Challenge 1:08
- Simplifying with a Function 10:24
- Pagination 5 questions
Preview
Video Player
00:00
00:00
Challenge
1:08Ready for a challenge? You've learned a lot about PHP and databases so far. Functions, Queries, Conditional Statements and Loops. In fact, you've learned enough to pull the genres for the form dropdown from the database. For this challenge, I want you to use the database for the genre dropdown instead of hard coding it.
You've learned a lot about PHP and
databases so far.
0:00
Functions queries,
conditional statements and loops.
0:03
In fact, you've learned
enough to pull the genres for
0:08
the form drop down from the database.
0:11
For this challenge, I want you to use
the database for the genres drop down.
0:13
Instead of hard coding it,
this will require several things.
0:18
First, you'll need to pull all the genres
from the database, sorted alphabetically,
0:22
and grouped by category.
0:27
Second, you'll need to loop
through these results and
0:29
create the HTML for the genre's dropdown.
0:32
Third, you'll need to make sure that the
HTML includes an optional selection for
0:36
the genre that the user
posted to the form.
0:41
Remember, comments
are a great way to start.
0:45
They help you to organize
what goes where and
0:47
to make sure you accomplish
all the requirements.
0:50
If you're not sure where to start,
I've added a link in the teacher's notes.
0:53
To take another look at
where we pulled people and
0:57
rolls for the item details page.
1:00
In the next video,
I'll show you how I solve this challenge.
1:03
Good luck.
1:07