在这里,我需要检查我的数据库,如果达到当前日期,那么我必须执行编码,否则必须跳过它
function list_hotel_default($country,$city,$location,$fromdate,$todate,$roomtype,$adults,$child_no)
{
$condition="country='$country' AND city='$city' AND location='$location' AND show2web='1' AND expiry_date is greater than current date";
$active_hotel_get_qry = mysql_query("SELECT * FROM hoteldetails WHERE ".$condition);
}
否则,则不应执行
怎么做?
如果您只想使用日期值进行检查,则可以使用
function list_hotel_default($country,$city,$location,$fromdate,$todate,$roomtype,$adults,$child_no)
{
$condition="country='$country' AND city='$city' AND location='$location' AND show2web='1' AND expiry_date > CURDATE()";
$active_hotel_get_qry = mysql_query("SELECT * FROM hoteldetails WHERE ".$condition);
}
您可以使用MySQL的inbuit日期函数 - 特别是返回当前时间和日期的now函数:
$condition="country='$country' AND city='$city' AND location='$location'
AND show2web='1' AND expiry_date > now()";
这是假设expiry_date
实际上是日期或日期时间字段。