Retrieve a user's check-in date: a step-by-step guide-PHP Chinese Network Q&A

prepare($sqlQuery);$recipesStatement->execute();$r"> Retrieve a user's check-in date: a step-by-step guide-PHP Chinese Network Q&A

Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

Retrieve a user's check-in date: a step-by-step guide

P粉423694341 2023-09-12 15:49:35

362

Hello, I would like to be able to display the registration date of users after January 25, 2022 But my query always shows the same date

$sqlQuery = 'SELECT * FROM _users WHERE user_registered > "2022-01-25"'; $recipesStatement = $bdd->prepare($sqlQuery); $recipesStatement->execute(); $recipes = $recipesStatement->fetchAll(); // On affiche chaque date une à une foreach ($recipes as $recipe) { ?>

P粉423694341

reply all (1)

P粉9589860702023-09-13 09:08:11 1 floor

sqlQuery = 'SELECT * FROM _users WHERE user_registered > "2022-01-25 00:00:00"'; $recipesStatement = $bdd->prepare($sqlQuery); $recipesStatement->execute(); $recipes = $recipesStatement->fetchAll(); // On affiche chaque date une à une foreach ($recipes as $recipe) { ?>