Undefined Index Error Laravel 5.4 Where Clause

Question

I developed following code,

public function getInCalls($sip_id){  

      $resultsTotalInCalls =  DB::table('xxxx')
    ->whereDate('created', '=', date('Y-m-d'))
    ->where(function ($query) {

    $query->where([
    ['event', '=', 'ENTERQUEUE'],
    ['agent', '=', $sip_id]

]);
    })

    ->get();  

     $numberofInCalls =  count($resultsTotalInCalls);   

     return $numberofInCalls;

}

But I got undefined index $sip_id in ['agent', '=', $sip_id] line. How to pass $sip_id in to function? I have no idea.

Laraleg · Accepted Answer · 2017-11-23 08:40:13Z

1

Closures needs importing variables from outside.

->where(function ($query) use ($sip_id) {

answered Nov 23, 2017 at 8:40

Laraleg

5273 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

AddWeb Solution Pvt Ltd · Accepted Answer · 2017-11-23 08:38:36Z

0

You should try this:

public function getInCalls($sip_id){  

          $resultsTotalInCalls =  DB::table('xxxx')
        ->whereDate('created', '=', date('Y-m-d'))
        ->where(function ($query) use($sip_id) {

        $query->where([
        ['event', '=', 'ENTERQUEUE'],
        ['agent', '=', $sip_id]

    ]);
        })

        ->get();  

         $numberofInCalls =  count($resultsTotalInCalls);   

         return $numberofInCalls;

    }

answered Nov 23, 2017 at 8:38

AddWeb Solution Pvt Ltd

21.8k5 gold badges30 silver badges61 bronze badges

Comments

Guja1501 · Accepted Answer · 2017-11-23 08:51:41Z

0

If you'd rather use closures then you can import variable to the current scope (the use keyword):

https://stackoverflow.com/a/11086796/3520693

public function getInCalls($sip_id){

    $resultsTotalInCalls =  DB::table('xxxx')
        ->whereDate('created', '=', date('Y-m-d'))
        ->where(function ($query) use ($sip_id) {

            $query->where([
                ['event', '=', 'ENTERQUEUE'],
                ['agent', '=', $sip_id]

            ]);
        })

        ->get();

    $numberofInCalls =  count($resultsTotalInCalls);

    return $numberofInCalls;

}

answered Nov 23, 2017 at 8:51

Guja1501

1,0288 silver badges16 bronze badges

Comments

Surabhi · Accepted Answer · 2017-11-23 08:52:05Z

0

public function getInCalls($sip_id){
    $resultsTotalInCalls =  DB::table('abc')
        ->whereDate('created', '=', date('Y-m-d'))
        ->where(function ($query) use ($sip_id) {
            $query->where([ ['event', '=', 'ENTERQUEUE'], ['agent', '=', $sip_id]  ]); 
        })
        ->get();  
    $numberofInCalls =  count($resultsTotalInCalls);
    return $numberofInCalls;  
}

answered Nov 23, 2017 at 8:52

Surabhi

1791 silver badge6 bronze badges

Collectives™ on Stack Overflow

Undefined Index Error Laravel 5.4 Where Clause

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related