Show database entries by todays date plus 7 days

[EarthDay]

Hi there,

I am trying to show entries in my database that have todays date plus seven days.

My code is currently 

$stmt = $pdo->prepare('SELECT * FROM care_plan_review where reminder_date > ? order by id desc');

This does not work sadly.

Any thoughts?

Cheers, ED.

Edited November 24, 2022 by EarthDay

[Barand]

Try

$stmt = $pdo->query("SELECT * FROM care_plan_review WHERE reminder_date > CURDATE() + INTERVAL 7 DAY");

[EarthDay]

9 minutes ago, Barand said:

Try

$stmt = $pdo->query("SELECT * FROM care_plan_review WHERE reminder_date > CURDATE() + INTERVAL 7 DAY");

Hi Barand,

Thank you for this.

I have updated my code and get the following error message;

Quote

Fatal error: Uncaught PDOException: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens in /reminders.php:6 Stack trace: #0 /reminders.php(6): PDOStatement->execute() #1 {main} thrown in /reminders.php on line 6

Any ideas?

Cheers, ED.

[EarthDay]

The full code is 

$now = date("Y-m-d h:i:sa");
$stmt = $pdo->prepare('SELECT * FROM care_plan_review where reminder_date > ? order by id desc');
$stmt->execute([$now]);
$allReview = $stmt->fetchAll(PDO::FETCH_ASSOC);

$now = date("Y-m-d h:i:sa");
$stmt = $pdo->prepare('SELECT * FROM care_plan_review where reminder_date > ? order by id desc');
$stmt->execute([$now]);
$allReview = $stmt->fetchAll(PDO::FETCH_ASSOC);

 

[ginerjm]

Why does your code not look like what Barand gave you???

[Barand]

My query didn't involve any external variables as the date+7 is calculated in the query. I therefore used query() instead of prepare() - there is no execute() required with query().

Incidentally, your code just compares against now, now 7 days from now,

[EarthDay]

Hi All,

Thank you all for your help on this

I have figured this out by using the below code

$stmt = $pdo->query("SELECT * FROM care_plan_review WHERE reminder_date between now() and now() + INTERVAL 7 DAY");

Cheers,

ED.