Array pointers offer important features that you will need when working with databases. PHP in MySQL uses a pointer to determine which items in an array it is working with. Since Foreach and Next will not move database pointers, PHP coders need to know how array pointers operate. Watch this online video to learn more about how you can use array pointers to improve your PHP coding skills.
Before we leave the topic of loops behind, I want to talk about array pointers and show you how they work. It may seem like a technical detail, but it will become important later when we start working with databases. PHP maintains a pointer that points to one of the items in an array. That item is referred to as the current item. By default, that's always the first item in the array. When we start looping through arrays using something like Foreach, PHP moves the pointer down the array as it assigns each value to the loop's variable. Moving the pointer to the next value is how PHP keeps track of which item you're working with now and what the next item is that it should give you after that.
But loops are not the only way to move pointers around. Let's take a look. Let's create ourselves a little workspace by using basic dot html. And we'll use Save As, and then we're going to create pointers.php. To begin with, let's just give ourselves a little area here, php, and we'll put in array of ages. I'll also change the title to be pointers. Alright. So this is the array that we were working with before. So the pointer, by default. The current item that's being pointed at in this array is the first item, four.
As we do a loop through there, the pointer moves. So, the first time, it's pointing at four. The second time through the loop, it's now pointing at eight. And then it's pointing at 15, and so on. It moves all the way down, and when it gets to the last one. Then it moves one more and says, oops, there's no more items, I must be done. And so the loop ends. We can take a look at this current pointer value by using the current function. So here it is, just current, and then we pass in the array. That'll tell us what the current value that it's pointing to is. Let's try that. Let's save it.
Let's go back to Firefox. And instead of break, let's open up pointers.php. So there it is, it is pointing at the item four, I've got the one if front of it just so we can tell between each of these tests that we run. So here's four, now we can tell the pointer to move to the next item manually by using the next function. So here's, this is just simply next ages. We're just saying hey, advance the pointer for ages to point to the next item. And then will once again echo back what the current item it's pointing to is.
This time, I've got a 2 in front of it so we can tell the difference. I'll save that. Let's go here. And there it is. It's pointing at eight. See how that works? Let's go back and let's just do a couple more here. Let's tell it to go two more times and then we'll do a third one and we'll ask it what it is for the third time. All right. It went 2 this time, so we're at 16, so you've skipped over the 15, and now we're pointing at 16. We can also have it go backwards by using Prev, short for "previous," p-r-e-v, and that's going to move it backwards. So tell ages to go backwards one, and then we'll use number 4 to see what the value's at now.
And there it is, it's at 15, and my backwards one. We also have two more that we'll look at together, which are reset, so reset will move the pointer back to the first element, and end will tell it to shoot all the way to the end, the last element. I've numbered those 5 and 6, let's take a look at that real quick. There we are. The first element and the last element. And now, just so that we can see what happens when we're at the end, let's go ahead and do next one more time. So, here it is, it's at the end, we're going to call next after the last element,and that's going to be 7. Let's see what that gives us back.
Go to return. We get back nothing, right? So that's how it knows that it's done. When it retrieves the last item, the last item is null then it knows that it's done. Okay, so how is this useful? Let's take a look at a while loop example that will illustrate how it works in practice and which is going to set the stage for working with database records. Switch back over here, and let's just put a br tag, and then we'll put in my while example. So, it's a while loop that moves the array pointer. This is very similar to what foreach does.
Notice that in the condition of our while loop, right here, this expression, that we're doing an assignment, not a comparison. That is a single equal sign, not a double equals. What we're doing, is we're. Assigning a value from current to age. And we're also testing then to see if that assignment was successful. If it returned a value, then the expression is going to evaluate to true. But if it returned null, in other words we got to the end of it, then this expression will evaluate to a Boolean false.
Null will be considered false. And so at that point it will exit. So what we're essentially saying is, get the item that the array pointer points to. Assign it to age. And if that is an item. If you successfully got one, then execute the loop. If you did not successfully get an item, well then exit the loop. We're all done. And then of course, we do have to increment inside the array using next. That'll move the pointer to the next item. So that now, current will fetch something different the next time through the loop. So as I said, this is how foreach works. So why not just use for each step? Well, I want you to see this technique because when we start working with databases, we are going to use something very similar.
We'll retrieve many rows of data from a database table as an array and then move through each row, advancing the pointer as we go. But we can't use foreach for this, because the database pointers are not exactly the same as the array pointers. They're similar, but not the same. And the database pointers are going to be moved by the database driver. Each time that we request a row. Each time that we do this assignment here. It's going to increment the pointer as soon as it finishes making that assignment. Foreach and next won't be able to move those database pointers.
They're going to work only on PHP arrays. Not on these database arrays that we'll be working with later. So let's just try out this code real quick. Let's save it. We'll go back to. Firefox, let's try and reload the page. Notice that nothing happened. Well why is that? Well, it because current is still pointing at null, remember? Current here was null, so what is it here? It's still null, nothing has changed. We need to reset the pointer back to the beginning for ages. And now. We come back here. You'll see that it zips back to the beginning, and it starts going through with each one for all the way through 'til it gets to 42, and then the last one is null so the loop ends.
So I hope you understand how pointers work, and this gives you some insight into how foreach works and also how you can manipulate those pointers yourself. But more importantly I want to make sure that you're familiar with this syntax using the while loop, because that's what we're going to be using when we start working with databases.
- 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.
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.