Working with retrieved data can be made easier depending on how you retrieve that data from the database. In MySQL, there are four ways to read data from the database; each method returns the results differently. This online video reviews the array methods, how to use them, and offers advice on the speed and memory considerations for each method.
We've learned how to connect to MySQL using PHP and how to access the results …that it returns. In this movie we're going to look a …little closer at some of the options we have for working with those results sets. …There are four ways to retrieve data from the query result, and the first of these …we've already seen, it's mysqli_fetch_row. …And it brings back a row of data and assigns it to a standard array. …The keys for each one of those columns are going to be integers. …So if we want to get the menu name, we ask for what's in column one. …That's the index position in the array one.…
We have another option though. We can use mysqli_fetch_assoc in its …place, use it exactly the same way. The only difference is that the results …are going to be returned in an associative array. …That's nice because now the keys are going to be the column names. …If we want to get menu name for our subject, well then we ask for the key …menu name. It's nice and easy, it is a touch slower, …because it does have to make an extra query to MySQL to find out the column names. …
- 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
Q: This course was revised on 6/4/2013. What changed?
A: The old version of this course was 6 years old and it was time for a complete revision, using PHP 5.4. (The tutorials will work with any version of PHP and covers any differences you might encounter). The author has also added updated installation instructions for Mac OS X Mountain Lion and Windows 8. The topics and end project are the same, but the code is slightly different. It also addresses frequently asked questions from the previous version.
Q: This course was updated on 5/20/2015. What changed?
A: We added one movie called "Changing the document root in Yosemite," which helps the Mac installation run more smoothly.
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.