#LaravelEloquent

[codesolutionsstuff]

Laravel where and orWhere Condition Example

In this blog, we will give you Laravel where and orWhere Condition Example. we will give you an exceptionally simple illustration of Laravel where() and orWhere() condition and furthermore we will give you an illustration of where() and orWhere in a single query in Laravel 6/7/8. You can use the where and orwhere strategy in Laravel 6, Laravel 7, and Laravel 8. where() and orWhere() takes three parameter, let’s see one by one parameter. First parameter is the column name of the table, second parameter is optional bydefault it is equal to operator and last parameter is the value which we have to compare with the table column. Let’s see Laravel where() and orWhere() conditions with Query Builder.Syntax of where() query in Laravel 6/7/8where(Column Name, Value); Example of where condition in SQL SELECT * FROM employee WHERE id='12'; Example of where() condition in Laravel 6/7/8  $employees = DB::table('employee') ->where('id', 12) ->where('department', 'web development') ->where('age', '>', 30) ->get(); Now we will see the Syntax and example of orWhere() condition in Laravel 6/7/8 and SQL.Syntax of orWhere() query in Laravel 6/7/8 orWhere(Column Name, Value); Example of OR WHERE condition in SQLSELECT * FROM employee WHERE id='12' OR salary='20000'; Example of orWhere() condition in Laravel 6/7/8 $employees = DB::table('employee') ->where('salary', '>', 20000) ->orWhere('name', 'abc') ->get(); I hope you will like the content and it will help you to learn Laravel where and orWhere Condition Example If you like this content, do share. Read the full article

[vkreatejaipur]

Learn all about Laravel PHP Framework definition and its history.

What is Laravel?

Laravel is one of the free, open source PHP web frameworks which is created by Taylor Otwell. Here you will get knowledge and information regarding the same in an easy and understandable form by VKREATE which is an IT Company based in Jaipur, Rajasthan.

Learning a new framework can be terrifying, but it is also interesting. To make the procedure easy for your transition, we have tried to make a very clear, concise document including definition and all for Laravel.

Read Full Blog in etail: http://www.vkreate.in/blogs/learn-all-about-laravel-php-framework-definition-and-its-history

[codesolutionsstuff]

Laravel whereHas and orWhereHas Query Example

In this exercise, I will explain Laravel whereHas and orWhereHas query model, wherehas and orWhereHas query utilized in Laravel for relationships. In this way, here I will give you a model of how to utilize wherehas in Laravel, wherehas expressive in Laravel 8 work same as has() work. has() is to channel the choosing model dependent on a relationship. So it acts likewise to a typical WHERE condition. In the event that you basically use has(‘relation’) that suggests you just need to get the models that have no lesser amount of related model in this connection. whereHas() works essentially equivalent to has() yet permits you to determine extra channels for the connected model to check.

whereHas() Example - 1

$blogs = Blogs::whereHas('comments', function (Builder $query) { $query->where('content', 'like', 'code%'); })->get();

whereHas() Example - 2

$users = User::whereHas('posts', function($q){ $q->where('created_at', '>=', '2022-01-01 00:00:00'); })->get(); I hope you will like the content and it will help you to learn Laravel whereHas and orWhereHas Query Example If you like this content, do share. Read the full article