我的問(wèn)題是這兩個(gè)日期不會(huì)比較或至少不好。我嘗試了比較兩個(gè)日期的大部分答案。但沒(méi)有一個(gè)是成功的。我有權(quán)知道:else if ($_SESSION['org_id'] != "0" && $_SESSION['part_id'] == 0) { require '../conn.php'; $sql = "SELECT `end_date` FROM `partner_subscriptions` WHERE `user_id` = '" . $dUsrId . "'"; $result1 = mysqli_query($conn, $sql ); $row = mysqli_fetch_array($result1); if (date('Y-m-d') >= $row['end_date']) { header('Location: ../../index'); } else { header('Location: ../../partnersubscription'); }} 我嘗試過(guò)的一件事else if ($_SESSION['org_id'] != "0" && $_SESSION['part_id'] == 0) { require '../conn.php'; // header('Location: ../../partnersubscription'); $sql = "SELECT `end_date` FROM `partner_subscriptions` WHERE `user_id` = '" . $dUsrId . "'"; $result1 = mysqli_query($conn, $sql); $row = mysqli_fetch_array($result1); $today = date("Y-m-d"); $expire = $row['end_date']; //from database $today_time = strtotime($today); $expire_time = strtotime($expire); if ($expire_time > $today_time) { header('Location: ../../index'); } else { header('Location: ../../partnersubscription'); }} 我希望當(dāng)今天的日期小于行的日期時(shí),它將進(jìn)入索引,否則將進(jìn)入合作伙伴訂閱。我的行end_date看起來(lái)像這樣“2019-06-06”并且是DATE
將當(dāng)前日期與數(shù)據(jù)庫(kù)中的日期進(jìn)行比較
千萬(wàn)里不及你
2021-06-16 17:01:26