After successfully querying our database and

taking a look at our PDO statement results object, we're still gonna need to

work with our results to get the properly formatted data to our users.

Let's take a look at how to bend these results to our will.

Let's build out and work with our results set, by making our

index page of films link off to a single film and

then we can just query the database for just one film by using say the film ID.

So we have a 1,000 results, let's go ahead and

start by cleaning up our index file and listing out our films and

populating the actual list with what we have here from our database.

So switch back over to our index.php file.

We don't need to do this inside of our try catch.

So, I'm actually gonna cut that out.

So, once we have our results set and

we've run the query we can actually just come down here and do what we need to do.

I don't wanna die anymore.

I actually don't need our pretags any longer.

Let's get rid of all those, and instead of dumping this out,

I actually wanna take my result set and store it to a variable.

The variable here that makes sense to me is filmsplural.

Okay so result set, fetchAll will store to a variable called films and

films will be that 1,000 item array from our result set or from our films database.

So going down,

we're gonna use some standard PHP at the very bottom of this file.

Here we have our ordered list.

So let's go ahead and open up some four each after we open up our PHP tags.

So we'll go ahead and open those now and get started.

PHP, all right I'm gonna close those guys out.

And then here we're going to do a four each, so four each.

And then films, as film.

[BLANK_AUDIO]

All right, we're going to open up and close our curly braces and

then here we're actually going to have one of these items.

So I'm going to cut one from here and paste it in.

All right, so in order to use this with our

looping PHP code, we're gonna need to modify this just a little bit.

So we'll start by adding our echo statement, and

then we'll surround this entire thing in single quotes for now.

Okay, and all that will do is just echo the string,

as it is right now, a thousand times.

Let's double check that that works as we expect.

All right, you have film 1 a lot of times.

We don't need that.

Let's go back and make this echo statement do what we want.

So, we're gonna use this same class, lens, except we wanna modify this spot

right here where it says Film One with our actual film title.

And we'll say use string concatenation with the dot symbol, and then do $film.

Kay, We gotta put some single quotes here to stop the actual string.

There we go.

Film, so our column name will be title.

So we'll open up some double quotes here, and use title, hit Save.

Kay now let's go back and

refresh and see if that gives us our film titles, and it does.

So here is the one through 1,000 of all of our films.

But it doesn't go anywhere.

So, we actually need to link this off somewhere.

So let's go back to our code and see how we're gonna do this.

So on the same line here as our actual list items.

We're gonna open up that anchor tag just after our little image,

our little video icon.

So we'll do an A, and then href equals, and

we'll use double quotes here, and then we'll say films.php.

Now that file doesn't exist yet, but it will.

And then we're going to pass through a git variable, an argument here, and

that's gonna be called ID.

We're gonna set ID equal to, and

we wanna set it equal to something that's going to be unique for the database,

and in our case, if we go back to the sakila manual, so we'll do sakila.

Let's see, it's right here in our history.

And then we're gonna look at our film table.

So in our film table, you'll see that the film ID is asserted primary key used

to uniquely identify each film in table.

It's exactly what we're looking for.

So we will use film_id and

since the column names correspond to the key of the array.

We should be able to use film_id directly in our code.

We'll do that by doing more string concatenation, so

gonna break this string with single quotes,

add more of our concatenation dots here, and then do $film.

Okay? And then open up for an array index.

And in here we're going to use, let's see, film_id.

Let's Save that, refresh our page, and see if it gives us what we expect.

Well they are all links, that's good.

And so see now, if you look at the link in the status bar at the bottom,

you should be able to see it says ID equal to and then there is an array index or

a film ID index equal to the ID.

So that's good. So when we click on one of these guys.

You'll see it's gonna give us a 404 Not Found.

So let's solve that now by creating the films.php.

I don't need this anymore, close it.

And now in here, right click, New File films.