Raw query to Laravel Query
SELECT * FROM plans_subscriptions WHERE starts_on BETWEEN "2019-07-30" AND "2019-07-26" or expires_on BETWEEN "2019-07-20" AND "2019-07-22"
-
laravel.com/docs/5.8/queriesapokryfos– apokryfos2019-07-02 07:37:02 +00:00Commented Jul 2, 2019 at 7:37
-
this link might helpAshish– Ashish2019-07-02 07:41:14 +00:00Commented Jul 2, 2019 at 7:41
-
What exactly is your question?Bram Verstraten– Bram Verstraten2019-07-02 09:15:08 +00:00Commented Jul 2, 2019 at 9:15
-
You are expected to put some effort in solving your problem yourself. If you have tried something but are stuck then share what you have tried and we can work with you from there. Dumping a query and asking "raw query to laravel query" is not even a real question. It's more like a demand.apokryfos– apokryfos2019-07-02 09:53:35 +00:00Commented Jul 2, 2019 at 9:53
Add a comment
|
3 Answers
If you want object response then use this :
PlansSubscriptions::whereBetween('starts_on', ["2019-07-30", "2019-07-26"]);
->orWhereBetween('expires_on', ["2019-07-20", "2019-07-22"]);
->get();
If you want array response then use this :
PlansSubscriptions::whereBetween('starts_on', ["2019-07-30", "2019-07-26"]);
->orWhereBetween('expires_on', ["2019-07-20", "2019-07-22"]);
->get()->toArray();
We can format the date like this :
$start = date("Y-m-d",strtotime($request->input('from_date')));
$end = date("Y-m-d",strtotime($request->input('to_date')));
and use that variable in query like this:
PlansSubscriptions::whereBetween('starts_on', [$start, $end]);
->orWhereBetween('expires_on', ["2019-07-20", "2019-07-22"]);
->get()->toArray();
4 Comments
a.ak
can we use above query with and rather than or
a.ak
here we are using or with second whereBetween condition can we use and with this
a.ak
Like this SELECT * FROM
plans_subscriptions WHERE starts_on BETWEEN "2019-06-02" AND "2019-07-26" and expires_on BETWEEN "2019-07-20" AND "2019-07-22"Rahul Rai
Yes, just remove the or from orWhereBetween and small w Like this: "PlansSubscriptions::whereBetween('starts_on', ["2019-07-30", "2019-07-26"])->whereBetween('expires_on', ["2019-07-20", "2019-07-22"]); ->get()->toArray();"
PlansSubscriptions::whereBetween('starts_on', ["2019-07-30", "2019-07-26"]);
->orWhereBetween('expires_on', ["2019-07-20", "2019-07-22"]);
->get();
Comments
Check this,
$users = DB::table('plans_subscriptions')
->where(function ($query){
$query->whereBetween('starts_on', ['2019-07-30', '2019-07-26'])
->orWhereBetween('starts_on', ['2019-07-20', '2019-07-22']);
})
->get();