Now that we have successfully run a query,

we need to take a closer look at what is returned to us by our query method.

All of the return data comes back to us in the form of a PDO statement object.

Okay continuing, we're going to get rid of this exception that we have here.

It's refreshed I've already fixed it in the file.

So refresh this and we're back to our PDO statement object showing the query string.

And we need to extract the results from this.

We wanna get, get all of our films out of our PDO statement object.

And the first place I would say check is we go to our documentation and

look up the PDOStatement object.

I'm just gonna actually copy this and paste it and hit enter, and

that will take us to the manual page for the PHP PDOStatement.

So, here is our PDOStatement class.

It, says it represents a prepared statement and

after it is executed, the associated results set, so

that is what we're gonna work with is our associated results set.

We're gonna go on down and

look at the methods and the method that we're gonna want here.

Let's say we could do fetch, fetch, fetch all.

Yeah, that sounds good, fetch everything.

This says it returns an array containing all the result set rows.

So it's going to return to us an array, and

it doesn't have any required arguments.

So let's go ahead and run that method.

On our results object which is a instance of the PDOStatement object.

And back over to our code, we're gonna go down here and

we're gonna work with this results set.

So here I'm gonna continue to var_dump and

then dive, our result set, but we want to use the fetch all method.

Before we dig into our fetch all method and

see what it's gonna return to us, we wanna get rid of that error or

the possibility of an exception being thrown by the query being incorrect.

The way we're gonna do that is with wrapping it in a try catch block.

So we'll go ahead up here to line four,

come down a little bit, and wrap this in a try block.

Try no arguments.

I'm gonna tab this in.

All right.

Close this guy out, and then open up catch.

And we are still going to catch the Exception class, and

pass it through to an object $e, close it out.

And in here the same thing as before.

We're just going to echo out our exception object, which is $e.

And the method that we're going to use is going to be

the same as before, getMessage.

Okay, pass that through just to make sure that our tri catch block is working.

We'll again, get rid of our correct statement and then refresh.

And then now you'll see it says General Error.

That's saying it's our syntax error.

That's exactly what we wanted to see,

except we didn't want to see the rest of this.

So we need to add a die statement to the end of this.

Okay, so let's refresh again.

There we go much better.

It just kills it, and gives us the actual error itself.

That's exactly what we're looking for.

All right, let's go back in and fix our statement here.

Select, all right save that.

Double check that we're back to working.

And we are, great.

Now instead of just dumping the results,

we're going to use that method that we looked at which is fetch all.

So, object operator, fetch, capital A for fetchAll.

And then open and close parens with no arguments and let's go see what it does.

Hit refresh.

All right. We have an array with a thousand results.

That's a lot.

And it's really hard to look at right now,

so let's put some pre tags in here so we can see this a bit better.

Right before here we'll go ahead and do, echo.

And then open up some tags for pre.

Close it out.

I'm gonna copy this line.

I'm gonna head down here and close out my pre tag.

Let's go back and see if that makes it looks a little nicer.

Much better.

So, looking at our result set here again, we have a thousand results.

A lot of results.

We definitely would wanna paginate this in a production environment, but

again, this is just for examples and not to be put into production.

What do we have?

We have each one of the films it seems.

And a lot of information that looks duplicate.

Okay, so the only difference between them is the key.

So you see we have a film id and that's equal to a string of one.

And then we have a numerically indexed zero, so

the first index zero, with an id of one.

Double checking title.

Key of title, that's the academy dinosaur.

All right?

And then index one, which is a second key.

And that's the same, title as well.

So it looks like we have something indexed by column name and

something indexed by a numeric index.

So let's go back to our PDO statement, fetchAll.

Look at the manual, and the first optional argument is the fetch style,

which takes another argument called fetch argument.

Okay, so let's look down here at fetch style.

So it says fetch_style controls the content of the returned array as

documented in the Fetch documents.

So let's go to Fetch, see what that says.

Okay this is a result set, single row, fetch_style parameters.

Okay so the default here, it says, is returns and

array indexed by both column name and zero indexed column number.

That's what we have.

That's our default.

But the option to do just the associative array, is our first argument here.

Great, great. So that's PDO fetch.

ASSOC or associative.

So it returns an array index by column name as a return in your result set.

Let's do that.

So we wanna set fetch style to PDO FETCH_ASSOC.

So I'm gonna copy this here and

I'm gonna pass that through in our code here in our FetchAll statement.

Right here is our first argument.

Gonna paste in that class constant.

Hit Save.

Let's go back to our code and refresh.

Okay.

Still 1,000 results.

That's right. That's exactly what we were looking for.

And now all of them are indexed by column name.

So there's no miscellaneous zero through whatever for the keys.

It's just an associative array for each film, that's awesome.

So now we know that our result set is a set of films indexed by a column name,

so we should be able to build out our code a little bit.

So next we'll do that by providing some links,

work with these results, and create a little bit more of a website.