Laravel where in

Laravel join

Inner Join 	: ->join('contacts', 'users.id', '=', 'contacts.user_id')
Left Join 	: ->leftJoin('posts', 'users.id', '=', 'posts.user_id')
Right Join 	: ->rightJoin('posts', 'users.id', '=', 'posts.user_id')
Cross Join 	: ->crossJoin('colors')

Advance Queries : 
----------------- 
 		->join('contacts', function ($join) {
            $join->on('users.id', '=', 'contacts.user_id')
                 ->where('contacts.user_id', '>', 5);
        })

Laravel update from query

$affected = DB::table('users')
              ->where('id', 1)
              ->update(['votes' => 1]);

Source: laravel.com

Laravel orWhere

$camps = $field->camps()->where('status', 0)->where(function ($q) {
    $q->where('sex', Auth::user()->sex)->orWhere('sex', 0);
})->get();

Source: laracasts.com

Laravel not in query

DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();

Laravel where has

use Illuminate\Database\Eloquent\Builder;

// Retrieve posts with at least one comment containing words like foo%...
$posts = App\Post::whereHas('comments', function (Builder $query) {
    $query->where('content', 'like', 'foo%');
})->get();

// Retrieve posts with at least ten comments containing words like foo%...
$posts = App\Post::whereHas('comments', function (Builder $query) {
    $query->where('content', 'like', 'foo%');
}, '>=', 10)->get();

Source: laravel.com

Laravel where in

$users = DB::table('users')->whereIn('id', array(1, 2, 3))->get()

Similar codes

0 vote239 views2 answers
Install php 7.4 fpm
PHP
0 vote295 views1 answer
How to auto calculate price in mysql table and php
PHP
1 vote270 views1 answer
Laravel set config value dynamically
PHP
2 votes262 views1 answer
Go back URL in Laravel
PHP Laravel
35 votes237 views6 answers
Laravel db query
PHP
16 votes205 views10 answers
Php hash password
PHP
19 votes258 views5 answers
Php get random element from array
PHP
0 vote223 views1 answer
Joomla redirect
PHP
20 votes236 views4 answers
Print array items in php
PHP
1 vote280 views1 answer
Laravel pluralization text
PHP