Preview
Video Player
00:00
00:00
Creating the Search Function
3:10Let’s create the function that actually pulls the items using our search term.
We changed our count function to
count the results of the search term.
0:00
While we're in this functions file,
0:04
let's create the function that actually
pulls the items using our search term.
0:06
We'll duplicate the category,
catalog array.
0:10
And we'll name this search_catalog_array.
0:27
Instead of the argument category,
we'll wanna change that to search.
0:31
Then we're ready to replace
the WHERE statement as we did above.
0:36
We want to search for
where our title is like our search term.
0:45
Finally, we'll change the first
bindParam to bindValue.
0:52
Then we'll change this out for our search.
1:01
We need to make sure we
include our wildcards.
1:04
We also need to change this bindParam
to bindValue in our else statement.
1:10
We can also remove the line at the top
that changes our category to lower case.
1:23
By default,
the like operator is not case sensitive.
1:30
Let's go back to our catalog.php file.
1:34
And start using these
new functional changes.
1:36
When setting total items,
we can now pass both the section and
1:39
the search to our function.
1:43
One of them will be null and that's okay.
1:46
All this stays the same until we scroll
down to setting the catalog variable.
1:49
We're going to add another conditional.
1:55
We want to check if our
search term is not empty.
2:02
Again, make sure you add else
to the second if statement.
2:12
If our search term is not empty,
we want to set
2:17
the catalog equal to our
search_catalog_array.
2:21
We'll pass in our search term,
2:27
the items_per_page, And our offset.
2:30
Let's view this in the browser and
perform a search.
2:38
You can see that it's mostly working.
2:45
We can see a list of results that have
been filtered by our search term.
2:48
But what happens if nothing
matches our search results?
2:51
We get redirected to the full catalog.
2:56
Now, that's confusing.
2:58
We need to let our users know
that there are no search results.
3:00
We also wanna change your header so that
they know that they are seeing the search
3:03
results, and not the full catalog page.
3:06