PHP时间转日期查询??? 我的MYSQL 里存储为datetime类型:date('Y-m-d H:i:s') 如2009-07-01 15:31:04现在我想通过JS控件取日期:2009-07-01类型, 然后与数据库中的时间时行比较, 该如何比较??? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 public class dotime{ private year; private month; private day; private hour; private second; private miao; function dotime($date){ $data=explode(" ",$date); $datetime=$data[0]; $datesec=$data[1]; $detaildata=explode("-",$datetime); $detaildata1=explode(":",$datesec); $this->year=$detaildata[0]; $this->month=$detaildata[1]; $this->day=$detaildata[2]; $this->hour=$detaildata1[0]; $this->second=$detaildata1[1]; $this->miao=$detaildata1[2]; } function year(){ return $this->year; } function month(){ return $this->month; } function day(){ return $this->day; } function hour(){ return $this->hour; } function second(){ return $this->second; } function miao(){ return $this->miao; }}刚做了个封装类,改改就能用! <?php $time = '2009-07-31'; $start = $time.' 00:00:00'; $end = date('Y-m-d',(strtotime($time)+3600*24)).' 00:00:00'; $sql = 'select * from t where time>"'.$start.'" and time<"'.$end.'"';?>PHP的话,我会这样写SQL语句 是PHP版内哦,呵呵..以为在MYSQL版了 Drupal6问题 ucenter输出了 php文件同步 discuz2.5插件问题,新手求助,希望有人解决 PHP输出XML问题 php人才招聘 PHP实现高并发的类,负载平衡,能承受5W人同时访问 汉子乱码问题 菜鸟求教,这个怎么倒序排序 修改ECSHOP后台的商品列表里显示该商品品牌功能报错,大神帮我看下什么原因 snmpget -O fntev这个参数是什么意思 php webservices问题
private year;
private month;
private day;
private hour;
private second;
private miao;
function dotime($date){
$data=explode(" ",$date);
$datetime=$data[0];
$datesec=$data[1];
$detaildata=explode("-",$datetime);
$detaildata1=explode(":",$datesec);
$this->year=$detaildata[0];
$this->month=$detaildata[1];
$this->day=$detaildata[2];
$this->hour=$detaildata1[0];
$this->second=$detaildata1[1];
$this->miao=$detaildata1[2];
}
function year(){
return $this->year;
}
function month(){
return $this->month;
}
function day(){
return $this->day;
}
function hour(){
return $this->hour;
}
function second(){
return $this->second;
}
function miao(){
return $this->miao;
}
}刚做了个封装类,改改就能用!
<?php
$time = '2009-07-31';
$start = $time.' 00:00:00';
$end = date('Y-m-d',(strtotime($time)+3600*24)).' 00:00:00';
$sql = 'select * from t where time>"'.$start.'" and time<"'.$end.'"';
?>PHP的话,我会这样写SQL语句