PHP laravel Undefined variable: userid in controllers

Question

This is my sql query

select * from users us join EmailBox em on us.userid = em.suserid 
where em.status = "Delete" and (em.suserid="$userid" or em.riemailid="$user")

I want to check any one field if "suserid" or "riemailid" result only. So I changed this in laravel querybuilder.

$lists = EmailBox::join('users as us', 'EmailBox.suserid', '=', 'us.id')
                ->where('status' , 'Delete')
                ->where(function($query){
                 $query->where('suserid' , '$userid');
                 $query->orwhere('riemailid' , '$user');    
        })->paginate(5);

This query is working fine when the value will be directly passed, userid directly passed 1 means

$lists = EmailBox::join('users as us', 'EmailBox.suserid', '=', 'us.id')
                    ->where('status' , 'Delete')
                    ->where(function($query){
                    $query->where('suserid' , 1);
                    $query->orwhere('riemailid' , '$user'); 
        })->paginate(5);

This is my code in laravel. what is mistake?

    if(Auth::check()){
        //if(Auth::user()->email!="")
        $user=Auth::user()->email;
        $userid=Auth::user()->id;
        $lists = EmailBox::join('users as us', 'EmailBox.suserid', '=', 'us.id')
                            ->where('status' , 'Delete')
                            ->where(function($query){
                                $query->where('suserid' , '$userid');
                                $query->orwhere('riemailid' , '$user'); 
                            })->paginate(5);
        $links = $lists->render();
        return view('front.index', compact('lists', 'links'));
    }

I got error $userid variable is undefined.

it will return value 1 thats not problem

Balaguru Murugan
– Balaguru Murugan

2016-02-19 10:53:54 +00:00
Commented Feb 19, 2016 at 10:53 — Balaguru Murugan
– Balaguru Murugan, Commented Feb 19, 2016 at 10:53

utsav · Accepted Answer · 2016-02-19 10:57:51Z

4

->where(function($query) use($userid, $user){
    $query->where('suserid' , $userid);
    $query->orwhere('riemailid' , $user); 
}

answered Feb 19, 2016 at 10:57

utsav

6225 silver badges17 bronze badges

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

Comments

Ravi Hirani · Accepted Answer · 2016-02-19 11:06:39Z

0

You need to use 'use' keyword in your query.

Also write orwhere query as below:-

EmailBox::join('users as us', 'EmailBox.suserid', '=', 'us.id')
          ->where('status' , 'Delete')
          ->where(function($query) use ($userid, $user){
              $query->where('suserid' , $userid)
                    ->orwhere('riemailid' , $user); 
          })->paginate(5);

Hope it will help you :)

answered Feb 19, 2016 at 11:06

Ravi Hirani

6,5341 gold badge31 silver badges43 bronze badges

Comments

abhayendra · Accepted Answer · 2016-11-28 10:35:35Z

0

make sure variable not write in '' (single quote)

 if(Auth::check()){
        //if(Auth::user()->email!="")
        $user=Auth::user()->email;
        $userid=Auth::user()->id;
        $lists = EmailBox::join('users as us', 'EmailBox.suserid', '=', 'us.id')
                            ->where('status' , 'Delete')
                            ->where(function($query){
                                $query->where('suserid' , $userid);
                                $query->orwhere('riemailid' , $user); 
                            })->paginate(5);
        $links = $lists->render();
        return view('front.index', compact('lists', 'links'));
    }

answered Nov 28, 2016 at 10:35

abhayendra

1976 bronze badges

Collectives™ on Stack Overflow

PHP laravel Undefined variable: userid in controllers

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related