Horje
laravel when condition Code Example
laravel when condition 
$invisiblePosts = $request->query('invisible');

Article::query()
            ->when($invisiblePosts , function ($query){
                return $query->where('invisible' , true);
            },function ($query){
                return $query->where('invisible' , false);
            })
            ->get();
laravel where condition with if 
$query = DB::table('user_ads')
            ->join('ads', 'users_ads.ad_id', '=', 'ads.id')
            ->orderBy($column, $method);

if ($input['search']) {
    $query->where('short_description', $input['search']);
}

if ($input['category']) {
    $query->where('category', $input['category']);
}

$query->join('users', 'users_ads.user_id', '=', 'users.id')
    ->select('ads.id', 'ads.img1', 'ads.short_description', 'ads.category', 'ads.product', 'ads.price', 'users.city')

$result= $query->get();

return $result;
Source: stackoverflow.com
laravel if else condition in query 
$query = SocialMediaFeed::where('location_id', $location_id);
if(!$filters) {
    $query = $query->where('self', '<>', true);
} else {
    $query = $query->orWhere('self', true);
}
Source: stackoverflow.com



Php

Related
withsuccess laravel 8 Code Example withsuccess laravel 8 Code Example
like %% inside the string php Code Example like %% inside the string php Code Example
import faker in laravel Code Example import faker in laravel Code Example
laravel s3 download file Code Example laravel s3 download file Code Example
not equal in laravel blade Code Example not equal in laravel blade Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 9



 

Horje