1. Laravel Query builder - Search Made Easy @freekspatie

Let's review #laravel #querybuilder from #spatie and created by Freek @freekspatie
This Laravel package helps you to make searching or filtering super easy, it can also be used to sort your sql result and add or remove attributes.
Package Links:
docs.spatie.be/laravel-query-...
github.com/spatie/laravel-que...
======================= Ad Free Tutorials ======================
Check bitfumes.com For ads-free and more advanced courses (use Coupon code WELCOME60 to get 60% discount)
==================FOLLOW ME ==================
Subscribe for New Releases!
Twitter - / bitfumes
Facebook - / bitfumes
Instagram - / bitfumes
(ask me questions!)
-- QUESTIONS? --
Leave a comment below and I or someone else can help you.
For quick questions you may also want to ask me on Twitter, I respond almost immediately.
Email me [e-mail]
Thanks for all your support!

[@AsanTutorials]

Nice tutorial sir, keep it up. Waiting for the next videos.

[@SpaceCoding]

Thanks youtube for recommending to me this video, now I've subscribed to this channel. And of course thanks to the author of this video and the channel!

[@azhari_my_id]

Awesome, that pacakge is Extreamly Coollll !! Thanks for sharing bro

[@stylersito]

Thanks for sharing, good vibes 🇲🇽

[@anygames069]

Cool man .. Never misses any update of laravel from you channel :D

[@albertsharp7754]

This helped me a lot. Thanks.

[@shahzadwaris7193]

Thanks for tutorial

[@nomanhanafi9551]

learned most of the laravel from you, you are nice

[@Bitfumes]

Thanks for your love and support, keep learning. Follow bitfumes on twitter.com/bitfumes or facebook.com/Bitfumes to get the latest updates. bitfumes.com

[@poopoo888888]

very helpful~! thanks a lot~!

[@Bitfumes]

Glad it was helpful!

[@kurumbot]

I love your laravel tutorial. Thank you. But I got this error -> Spatie\QueryBuilder\Exceptions\InvalidSubject Subject type `string` is invalid. Already updated my Laravel version. I'm not sure what's missing.

[@JLRuatpuia]

Maybe you should change from nulll to null

[@alimransujon6388]

Great video

[@suman_biswas]

What I really want to learn. Great resource, great explanation, thank you very much. My one request that, please make a vedio for how to filter dada from frontend ( Vue App ) with this larave package.

[@cultureofnepal2024]

Hi, sarthak can you make the tutorial on elastic search with elk stack with laravel. I haven't found good tutorial on it.

[@alvarezskinner]

nice video! thanks for the content!

[@Bitfumes]

Thanks for your love and support, keep learning. Follow bitfumes on twitter.com/bitfumes or facebook.com/Bitfumes to get the latest updates. bitfumes.com

[@tyroneonyebuagu2302]

What if I want to use the same search query to filter two columns that doesn't have to be exact? Example /?filter[city,location]=memphis. If I do /?filter[city]=memphis&filter[location]=memphis, it will interpret the search query as "AND". How can I achieve this?

[@yusufmirza2323]

Can we use with post method?

[@dark_star1]

How did you make the terminal look like this?

[@TravelCanadareels]

Appreciate it if you can tell me, How to encrypt that get URL. Because I give it to that field name it's going to be a security issue.

[@hectorvalentine9916]

This doesn't work for me, for .../users?filter[name]=John I get: "Requested filter(s) `filter` are not allowed. Allowed filter(s) are `name, email`." Does anyone has an idea of what is happening? Update: I had to clear the cache

[@CoffeeQuery]

I get this error, Undefined type 'Spatie\QueryBuilder\QueryBuilder' inside controller

[@nazar87ali]

what the VS code theme and what the auto complete extension ??

[@mubashirmalik817]

I learn a lot from your videos but I have 1 request that makes videos with front end we understand more clearly .....by the way, best channel to learn laravel

[@Goudendeurkruk]

As soon as i pass in allowedFilters('name') or any parameter it does not work anymore

[@asharmuhammad8686]

great video, but how to use it with input field, i mean whatever i type in search box it gave me that result???

[@legakwamotsamai5153]

I'm a beginner and I can't follow your process, all those changes you made to your User.php and User factory. what are they and why did you make them. how do they help you use the spartie query builder?

[@yazugaming5573]

Hello Can you tell me about filter starts_between ?

[@Goudendeurkruk]

My routes are defined with prefix and i cant seem to get this to work with $result = QueryBuilder::for(Log::class)->allowedFilters('component')->get(); return $result; Does any one know how i can?

[@MrDovanele]

Hey, thanks for video. The part were you tried to filter by email you have typed "nulll" with 3 'l' symbols that's why it wasn't working

[@Bitfumes]

Ohhh thanks for your support. Thanks for your love and support, keep learning. Follow bitfumes on twitter.com/bitfumes or facebook.com/Bitfumes to get the latest updates. bitfumes.com

[@engmustafa8946]

Important question! You implement functions directly form navigation bar ! Like ?fliter[name] = somename ... yes it works !! But how to do that in blade ? Or in controller !! How ? Thank you

[@susanasantamaria2713]

Hello!! After some trial and error, this is how it worked for me: My controller use App\User; use Spatie\QueryBuilder\QueryBuilder; class UserController extends Controller { public function index(Request $request) { $name = $request->get('name'); $email = $request->get('email'); $users = User::name($name)->email($email)->paginate(); $userSearch = QueryBuilder::for(User::class) ->allowedFilters(['name', 'email']) ->get(); return view('users.index', ['users' => $users]); } } My model class User { /** * @param Builder * @param string $name * @param mixed $query * * @return Builder */ public function scopeName($query, $name) { return $query->where('name', 'LIKE', "%{$name}%"); } /** * @param string $email */ public function scopeEmail(Builder $query, $email): Builder { if (null !== $email) { return $this->searchByField($query, 'email', $email, '='); } return $query; } /** * @param strin $value */ public function searchByField(Builder $query, string $field, string $value, string $operator = null): Builder { return $query->where($field, $operator, $value); } } My view Buscar Regresar I hope this helps someone!!

[@william254]

For simple name search *Blade* *Controller* QueryBuilder::for(User::class)->allowedFilters(['name'])

[@MarcelloPato]

Larravel has such cool features... how it is not mentioned as a 'must learn' technology to learn in 2020?

[@Bitfumes]

I have mentioned Laravel on 2020 technologies. Laravel Rocks :)

[@MarcelloPato]

@@Bitfumes yeahhhhhhh!"

[@mukeshrai4890]

Wow

[@mohamedabdelhalim9892]

it returns Call to undefined method App\Models\Tournment::get2Attribute(), documentations didn't mention anything about adding methods to models, any help would be appreciated

[@user-bc6ue3ri7o]

same issue

[@daniellogvin6609]

You typed "nulll" instead of "null" 😅 Great video tho!

[@AjayPatel-ip2dv]

can u make a video on laravel with vue spa authentication

[@Bitfumes]

Okay I will try that. Thanks

[@AjayPatel-ip2dv]

@@Bitfumes Thank bro

[@anygames069]

kzbin.info/www/bejne/fnjLYZaBeruLhqs check this out if you wanna learn . he uses laravel passport for token generation. well it would be cool if Bitfumes makes one :D

[@newprogrammer1811]

your english speaking have improve.

[@Bitfumes]

Thanks bro, I am working on it, It's all because of positive feedback your viewers like you.

[@abeautyqueenofonly18]

have improve = has improved*