php - Laravel Advanced Wheres how to pass variable into function? -


example in doc:

db::table('users')         ->whereexists(function($query)         {             $query->select(db::raw(1))                   ->from('orders')                   ->whereraw('orders.user_id = users.id');         })         ->get();

but if need use external variable that:

            ->where('city_id', '=', $this->city->id)             ->where(function($query)                 {                     $query->where('name', 'like', '%'.$searchquery.'%')                     ->orwhere('address', 'like', '%'.$searchquery.'%')                  })

for created new property , accessed through $this->, there more convenient way?

you can pass necessary variables parent scope closure use keyword.

for example: 

db::table('users')->where(function ($query) use ($activated) {     $query->where('activated', '=', $activated); })->get();

more on here.


-

Popular posts from this blog

debugging - Reference - What does this error mean in PHP? -

what this? this number of answers warnings, errors , notices might encounter while programming php , have no clue how fix. community wiki, invited participate in adding , maintaining list. why this? questions "headers sent" or "calling member of non-object" pop on stack overflow. root cause of questions same. answers questions typically repeat them , show op line change in his/her particular case. these answers not add value site because apply op's particular code. other users having same error can not read solution out of because localized. sad, because once understood root cause, fixing error trivial. hence, list tries explain solution in general way apply. what should here? if question has been marked duplicate of this, please find error message below , apply fix code. answers contain further links investigate in case shouldn't clear general answer alone. if want contribute, please add "favorite" error message, warning or notic...
Read more

How to parse output from sse.client in Python? -

i new python , trying ahead around parsing sse client code. using sse client library . code basic , follows sample exactly. here is: from sseclient import sseclient devid = "xxx" atoken = "xxx" sparkurl = 'https://api.spark.io/v1/devices/' + devid + '/events/?access_token=' + atoken messages = sseclient(sparkurl) msg in messages: print(msg) print(type(msg)) the code runs without problem , see blank lines , sse data coming through. here sample output: <class 'sseclient.event'> {"data":"0 days, 0:54:43","ttl":"60","published_at":"2015-04-09t22:43:52.084z","coreid":"xxxx"} <class 'sseclient.event'> <class 'sseclient.event'> {"data":"0 days, 0:55:3","ttl":"60","published_at":"2015-04-09t22:44:12.092z","coreid":"xxx"} <class ...
Read more