当前位置:Gxlcms > PHP教程 > YII按照日期过滤不起作用,怎么回事?

YII按照日期过滤不起作用,怎么回事?

时间:2021-07-01 10:21:17 帮助过:6人阅读

Yii PHP 日期过滤

YII 按照日期过滤不起作用,怎么回事?

模型

true),			array('time', 'safe'),						// The following rule is used by search().			// Please remove those attributes that should not be searched.			array('id, time', 'safe', 'on'=>'search'),		);	}	/**	 * @return array relational rules.	 */	public function relations()	{		// NOTE: you may need to adjust the relation name and the related		// class name for the relations automatically generated below.		return array(		);	}	/**	 * @return array customized attribute labels (name=>label)	 */	public function attributeLabels()	{		return array(		'id'=> '编号',        'time'=> '时间',		);	}	/**	 * Retrieves a list of models based on the current search/filter conditions.	 * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.	 */	public function search()	{		// Warning: Please modify the following code to remove attributes that		// should not be searched.		$criteria=new CDbCriteria;		$criteria->compare('id',$this->id);		$criteria->compare('time','>='.$this->starttime);		$criteria->compare('time','<='.$this->endtime);		//是否开启模糊搜索,在后面true中实现		return new CActiveDataProvider($this, array(			'criteria'=>$criteria,		    			//'pagination'=>array('pagesize'=>$pagesize?pagesize:$page),		    //'pagination'=>array('pagesize'=>$page),		));	}}




视图
  


控制器

	public function actionTimefliter()	{			$model=new Timefliter();		$this->render('timefliter',array('model'=>$model,));	}


回复讨论(解决方案)

提交之后又没把获取的日期值赋值给模型,那在search方法中怎么会过滤

怎么复制给模型

可以用另外一种解决方案,自己新建一个dataprovinder 然后sql语句查询时间之间的记录

$model->startTime=$_POST['starttime'];    //传值给模型$model->endTime=$_POST['endtime'];  


谢谢楼上两位,都搞定了,两种方法都是可行的,不过第二种比较慢

人气教程排行