Function in query builder not working with request or variable

Question

I am try to learn how to use this to post properly. I am just starting on Laravel.... recently

Why this is NOT Working?

 public function getFunctionFromUserGroup(Request $request)
    {
        try
        {
            $abc = $request->get('usertypeid');
            return response() -> json(SystemFunction::whereNotIn('Function_ID', function($q){
                    $q->select('Function_ID')->from('TB_UserAccess')->Where('UserType_ID', $abc );})->get(), 200);

        }
        catch (\Exception $e)
        {
            return response(['error'=> $e->getMessage()], 422);
        }
    }

And Why this is working?

 public function getFunctionFromUserGroup(Request $request)
    {
        try
        {
            return response() -> json(SystemFunction::whereNotIn('Function_ID', function($q){
                    $q->select('Function_ID')->from('TB_UserAccess')->Where('UserType_ID', 1);})->get(), 200);

        }
        catch (\Exception $e)
        {
            return response(['error'=> $e->getMessage()], 422);
        }
    }

difference is ` $abc = $request->get('usertypeid');` in the second one you are not passing this variable to where clause — Mahdi Younesi
– Mahdi Younesi, Commented Mar 12, 2018 at 21:11

Jonas Staudenmeir · Accepted Answer · 2018-03-12 21:39:20Z

2

You have to make $abc available inside the closure:

... function($q) use($abc) { ...

answered Mar 12, 2018 at 21:39

Jonas Staudenmeir

26k7 gold badges70 silver badges114 bronze badges

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

Comments

Prashant Prajapati · Accepted Answer · 2018-03-13 06:32:15Z

0

To make your code run properly you need to use $abc inside your function using use() try below code

 public function getFunctionFromUserGroup(Request $request)
    {
        try
        {
            $abc = $request->get('usertypeid');
            return response() -> 
                 json (SystemFunction::whereNotIn('Function_ID', 
                 function ($q){
                    $q->select('Function_ID')
                        ->from('TB_UserAccess')
                        ->Where('UserType_ID', $abc );})->get(), 200);
        }
        catch (\Exception $e)
        {
            return response(['error'=> $e->getMessage()], 422);
        }
    }

edited Mar 13, 2018 at 6:32

answered Mar 13, 2018 at 3:46

Prashant Prajapati

1,0158 silver badges14 bronze badges

Collectives™ on Stack Overflow

Function in query builder not working with request or variable

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related