Your like query implementation is not correct.
Try this :
public function findTag()
{
$term = Input::get('tag_name');
return Tag::where('tag_name', 'LIKE', '%' .$term . '%')->lists('tag_name');
}
Last updated
10 months ago.
0
When I exactly what you have there it returns all of the results. When I only replace the query and leave the rest alone, it doesn't return anything.
Last updated
10 months ago.
0
Check this http://www.w3schools.com/sql/sql_like.asp how to use % in LIKE operator.
Last updated
10 months ago.
0
Maybe die/dump the query so you can see what the DB is actually getting... prior to your foreach() you could try:
$search = Tag::where('tag_name', 'LIKE', '%' . $term . '%')->get();
dd(DB::getQueryLog());
Last updated
10 months ago.
0
Sign in to participate in this thread!
Moderators
-
driesvints
Joined 16 Dec 2013
-
joedixon
Joined 23 Jun 2014
-
tvbeek
Joined 8 Jan 2018
-
tomhatzer
Joined 28 Oct 2021
Laravel
Laravel News
Laracasts
Laravel Podcast