Laravel when condition

 <?php

            

        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;

                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();

                    when in larevel

                    $role = $request->input('role');

                        $users = DB::table('users')

                        ->when($role, function ($query, $role) {

                            return $query->where('role_id', $role);

                        })

                        ->get();

                        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);

                        }

Read More

Laravel where and where

 <?php

                $camps = $field->camps()->where('status', 0)->where(function ($q) {

                    $q->where('sex', Auth::user()->sex)->orWhere('sex', 0);

                })->get();  

                laravel where

                $users = DB::table('users')

                                ->whereMonth('created_at', '12')

                                ->get();

                laravel with and where

                $projects = Project::whereHas('projectOffers', function ($offer) {

                    $offer->where('teacher_id', "Ahmed");

                    $offer->where('status_id', "Accepted");

                })->where('status_id', "inprogress")->get();

                laravel where and where

                Table::where('Column', Value)->where('NewColumn', Value)->get();

Read More

Laravel where condition on relationship

 <?php

App\Request::where('id',4)

->whereHas('quotes', function ($query) {

    $query->where('status','=','3');

})

->with('quotes','sourceTable','destinationTable')

->get(); 

class Game extends Eloquent {

    // many more stuff here

    // relation without any constraints ...works fine 

    public function videos() {

        return $this->hasMany('Video');

    }

    // results in a "problem", se examples below

    public function available_videos() {

        return $this->videos()->where('available','=', 1)->get();

    }

}

Read More

Laravel where condition with if

Laravel where condition with if

<?php

$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;

Read More

Laravel if syntax

 <?php

@if (foo)

// do something

@elseif (bar)

// do something else

@else

// do some other thing;

@endif

Read More

Laravel extends if

 Laravel extends if

<?php

@extends(Auth::user() ? 'template/index' : 'template/login');

Read More

Laravel eloquent where two conditions

 Laravel eloquent where two conditions

<?php

$query->where([

    ['column_1', '=', 'value_1'],

    ['column_2', '<>', 'value_2'],

    [COLUMN, OPERATOR, VALUE],

    ...

])

// here, i have used two different where condition on a single column

$data = Users::where('type',1)

        ->where(function($query) {

            return $query->whereDate('updated_at','!=', Carbon::today())

            ->orWhere('updated_at',null);

         })

         ->get();

Read More

Laravel check if eloquent just created

 <?php

laravel check if eloquent just created

$item = Item::firstOrCreate(['title' => 'Example Item']);

if ($item->wasRecentlyCreated === true) {

    // item wasn't found and have been created in the database

} else {

    // item was found and returned from the database

}

Read More

Laravel blade @if 3 varabile

 <?php

laravel blade @if 3 varabile

@forelse ($users as $user)

    <li>{{ $user->name }}</li>

@empty

    <p>No users</p>

@endforelse

using get in laravel blade

{{ request()->has('faq') ? request()->get('faq') : '' }}

laravel blade @if 3 varabile

@if(is_null($key['p3']))

        {{--*/$p3 = $key['p3']/*--}}

    @else

        {{ 0 }}

    @endif

    @if(is_null($key['wabku']))

        {{--*/$wabku = $key['wabku']/*--}}

    @else

        {{ 0 }}

    @endif

    <td class="tg-rv4w" width="5%">

        {{ number_format($p3 - $wabku,0,',','.') }}

    </td>

    

    @php

    $p3 = $key['p3']

    @endphp

Read More

Laravel where multiple conditions

Laravel where multiple conditions

$query->where([

    ['column_1', '=', 'value_1'],

    ['column_2', '<>', 'value_2'],

    [COLUMN, OPERATOR, VALUE],

    ...

])

// here, i have used two different where condition on a single column

$data = Users::where('type',1)

        ->where(function($query) {

            return $query->whereDate('updated_at','!=', Carbon::today())

            ->orWhere('updated_at',null);

         })

         ->get();

Read More