判断时间是否过期
1 控制器判断时间是否过期
/* 时间字段判断 */ public function Activitysadds($request){ $database = new Medoo(myUser::getDBconf());
//首先是查询出时间 $sql="SELECT * FROM activity WHERE volume_state=1";
//执行sql $info=$database->query($sql)->fetchAll(PDO::FETCH_ASSOC);
//输出值 foreach ($info as $key => $value) {
//字符串截取 $str = substr($value['validity'],22,19);
//判断当前时间和表字段时间 if(date("Y-m-d H:i:s")>=$str){
//修改 $database->update('activity',['volume_state'=>3],['id'=>$value['id']]); } } return sfView::NONE; }
2 展示是调用方法
$this->Activitysadds();
3 修改方法里面加
$res = $database->update('activity',['name'=>$name,'img'=>$photos,'type'=>$types,'product_id'=>$pid,'status'=>$status,'validity'=>$validity,'volume_state'=>1,'link'=>$link,'updated_at'=>date('Y-m-d H:i:s')],['id'=>$id]);
4 看效果