…Now that we've confirmed that our query isn't generating any errors,…we can go ahead with displaying the results of our query.…So let's go down to the section where we want to display the results.…There it is.…We need to put a loop, so we put one row of results each time that the loop runs.…So the loop begins above the div for section.…A…PHP block there.…And the type of loop that I'm going to use this time is called a while loop, and the…condition that I'm going to have in the while loop…will be, getting one row of results at a time.…
And I'm going to store that in a variable called row.…And assign to that result. Then the arrow…operator, and its fetch_assoc,…so it's fetching an associative array, which will be called row.…And that would be one row of results at a time.…So we need an opening curly brace for our while loop.…Then we need to find the closing div tag.…There it is.…
And that's where the closing curly brace of that loop will go.…And to remind ourselves of what it is, add a comment, end of loop.…So each time that the while loop runs, row will…
Author
Released
12/9/2013Note: This course was recorded with Adobe Dreamweaver, but you can use the code editor of your choice to follow along.
- How to use PHP in a webpage
- Storing and displaying text and numbers in variables
- Using functions
- Adding comments to your PHP scripts
- Moving common page elements to include files
- Displaying different content on a page
- Working with multiple values in arrays and loops
- Getting form input sent by the POST method
- Using PHP sessions to preserve data
- Storing data in session variables
- Connecting to and querying a database
- Handling errors
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome1m 30s
-
Using the exercise files5m 13s
-
-
1. Introduction to PHP
-
How to use PHP in a web page6m 43s
-
2. Using Server-Side Includes for Common Page Elements
-
3. Using Conditions to Change Page Output
-
How PHP makes decisions3m 30s
-
-
4. Working with Multiple Values in Arrays and Loops
-
Labeling array elements7m 21s
-
5. Getting User Input from a Form
-
Calculating the order total6m 34s
-
6. Displaying Content from a Database
-
Loading data into MySQL5m 37s
-
Connecting to the database7m 47s
-
Querying the database6m 15s
-
Linking to a details page2m 40s
-
-
7. Handling Errors
-
Dealing with PHP errors4m 15s
-
Tracking down parse errors4m 32s
-
-
Conclusion
-
What's next?2m 26s
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Displaying the results of the query