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.

score 1 · Accepted Answer · answered Nov 23 '17 at 08:40

1

Closures needs importing variables from outside.

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

answered Nov 23 '17 at 08:40

Laraleg

519
3
7

score 0 · Answer 2 · answered Nov 23 '17 at 08:38

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;

    }

score 0 · Answer 3 · answered Nov 23 '17 at 08:51

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;

}

score 0 · Answer 4 · answered Nov 23 '17 at 08:52

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

Undefined Index Error Laravel 5.4 Where Clause

4 Answers4