php代码:
function tt_allzhan_TodayNum(){ global $zbp; $db = $zbp->db->sql->get(); $sql = $db->select('zbp_post')->count('log_id', 'num')->where(array(array('=','log_Status','0'),array('CUSTOM','log_PostTime>UNIX_TIMESTAMP(CAST(SYSDATE()AS DATE))')))->sql; $array = GetValueInArrayByCurrent($zbp->db->Query($sql), 'num'); echo $array; }
mysql代码:
SELECT COUNT(log_id) AS num FROM zbp_post WHERE log_Status = '0' AND log_PostTime>UNIX_TIMESTAMP(CAST(SYSDATE()AS DATE))
其中获取当天时间戳代码:
log_PostTime>UNIX_TIMESTAMP(CAST(SYSDATE()AS DATE))
注意:其中log_PostTime为时间戳字段
相对应获取当前时间24小时内的文章数量代码
$nowtime = time(); $settime = 1*24*60*60; $gettime = $nowtime-$settime; $db = $zbp->db->sql->get(); $sql = $db->select('zbp_post')->where(array(array('=','log_Status','0'),array('>','log_PostTime',$gettime)))->sql; $array = $zbp->GetListType('Post', $sql); echo count($array);