PHP laravel query

Question

How can I query all users whose last donation is more than 90 days. This is my query but when it is executed I get an error unknown column.

      $value = Session::get('key');
      $dateToday = new DateTime();
      $data = Users::where('userType','=', 'user' )
                ->where($dateToday->format('m/d/Y') - 'lastDonation', '=', 1)
                ->whereNotIn('username', [$value ])
                ->get();

To save your time, you could check your code by using dd($data->toSql()) and remove ->get() to re-check your query builder — Jonny Vu
– Jonny Vu, Commented Jan 29, 2016 at 3:48

jclyons52 · Accepted Answer · 2016-01-29 03:43:32Z

1

$data = Users::where('userType','=', 'user' )
->where('lastDonation', '<', Carbon::now()->subDays(90))
->whereNotIn('username', [$value ])
->get();

answered Jan 29, 2016 at 3:43

jclyons52

3163 silver badges8 bronze badges

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

Comments

microtony · Accepted Answer · 2016-01-29 03:45:25Z

0

You can use the TIMESTAMPDIFF mysql function to compute the difference between two datetimes.

To do that you need to add a clause using whereRaw

$value = Session::get('key');
$dateToday = new DateTime();
$data = Users::where('userType', '=', 'user')
          ->whereRaw('TIMESTAMPDIFF(DAY, lastDonation, NOW()) > 90')
          ->whereNotIn('username', [$value])
          ->get();

answered Jan 29, 2016 at 3:45

microtony

1927 bronze badges

Collectives™ on Stack Overflow

PHP laravel query

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