我正在嘗試通過更新將當(dāng)前日期與 MYSQL 中的事件日期進行比較的狀態(tài)來更新“事件”表中每個事件的狀態(tài)。我的所有日期都顯示為“已通過”，盡管其中一個活動日期在未來。我嘗試了多種不同的方法，但我似乎無法弄清楚為什么這種情況會繼續(xù)發(fā)生。$sql = "SELECT Event_id, title, event_date, location, description, status FROM events";$result = $conn->query($sql);if ($result->num_rows > 0) { // Show each data returned by mysql while($row = $result->fetch_assoc()) { // date_default_timezone_get('America/indiana');// foreach ($row as $row['events']) { // // $time = strtotime('10/16/2003'); // // $newformat = date('Y-m-d',$time);$current_datetime = date('Y-m-d 23:59:59');$sqldate = date("Y-m-d 23:59:59", strtotime($row['event_date'])); if (strtotime($current_datetime) > strtotime($sqldate)) { mysqli_query($conn, "UPDATE events SET status = 'Passed'"); } elseif (strtotime($current_datetime) === strtotime($sqldate)) { mysqli_query($conn, "UPDATE events SET status = 'Ongoing'"); } else { mysqli_query($conn, "UPDATE events SET status = 'Upcoming'"); //}}?><div class="event"> <p> Title : <?php echo $row["title"]; ?> </p> <p> Date: <?php echo $row["event_date"]?> </p> <p> Location: <?php echo $row["location"]?> </p> <p> Description: <?php echo $row["description"]?> </p> <p> Status: <?php echo $row["status"]?> </p></div></body><?php}} else { echo "0 results";}// Closing mysql connection$conn->close();?>
2 回答
撒科打諢
TA貢獻1934條經(jīng)驗 獲得超2個贊
我認為您不需要在這里使用循環(huán)，您可以像這樣單獨運行這些查詢。
$current_datetime = date('Y-m-d 23:59:59');
mysqli_query($conn, "UPDATE events SET status = 'Passed' WHERE event_date < $current_datetime");
mysqli_query($conn, "UPDATE events SET status = 'Ongoing' WHERE event_date == $current_datetime");
mysqli_query($conn, "UPDATE events SET status = 'Upcoming' WHERE event_date > $current_datetime");
請檢查語法我很長時間沒有使用 PHP 我只是與你分享基本的想法。
冉冉說
TA貢獻1877條經(jīng)驗 獲得超1個贊
// 還要檢查從 SQL 查詢中獲取的日期并更改當(dāng)前日期時間格式
<?php
$current_datetime = date('Y-m-d H:i:s');
print_r(strtotime($current_datetime));
$sqldate = date("Y-m-d H:i:s", strtotime(date('2019-12-06 12:27:54'))); // I have hardcoded the date time here
print_r(strtotime($sqldate));
if (strtotime($current_datetime) > strtotime($sqldate)) {
// mysqli_query($conn, "UPDATE events SET status = 'Passed'");
echo "passed";
}
elseif (strtotime($current_datetime) == strtotime($sqldate)) {
// mysqli_query($conn, "UPDATE events SET status = 'Ongoing'");
echo "Ongoing";
}
else {
// mysqli_query($conn, "UPDATE events SET status = 'Upcoming'");
echo "Upcoming";
}
- 2 回答
- 0 關(guān)注
- 202 瀏覽
添加回答
舉報
0/150
提交
取消