AddBetweenCondition

mas bro

mohon bantuan nya .




public function actionCari()

	{

		

		$model=new Datarek;

                

                

                if(isset($_POST['Datarek']))

		{

			$model->attributes=$_POST['Datarek'];

                        //var_dump($_POST['Datarek']);

                        $nama = $_POST['Datarek']['nama'];

                        $bank = $_POST['Datarek']['bank'];

                        $tgl1 = $_post['Datarek']['tanggal'];

                        $tgl2 = $_post['Datarek']['tanggal_akhir'];

		}

                $criteria = new CDbCriteria;

                $criteria->AddSearchCondition('nama',$nama);

                $criteria->AddSearchCondition('bank',$bank);

                $criteria->AddBetweenCondition(array('tanggal', $tgl1 ,$tgl2 ,'AND'));

                

                

                

                $dataProvider=new CActiveDataProvider('Datarek', array(

                    'criteria'=>$criteria,

                    

                )); 

                

        print_r($dataProvider);

               

              

		$this->render('cari',array(

			'model'=>$model,

                        'dataProvider'=>$dataProvider,

		));

	}



tanggal bertype datetime

tp begitu variable nya diisi function search ga jalan ya

need Help

Regards

Arif

coba seperti gan…





public function actionCari()

{

	$model=new Datarek;

	if(isset($_POST['Datarek']))

	{

			$model->attributes=$_POST['Datarek'];

			//var_dump($_POST['Datarek']);

			$nama = $_POST['Datarek']['nama'];

			$bank = $_POST['Datarek']['bank'];

			$tgl1 = $_post['Datarek']['tanggal'];

			$tgl2 = $_post['Datarek']['tanggal_akhir'];

	}

	$criteria = new CDbCriteria(array(

		'condition'=>'nama=:vnama AND bank=:vbank AND tanggal BETWEEN :vtgl1 AND :vtgl2',

		'params'=>array(

			':vnama'=>$nama,

			':vbank'=>$bank,

			':vtgl1'=>strtr($tgl1,array('%'=>'\%', '_'=>'\_', '\\'=>'\\\\')),

			':vtgl2'=>strtr($tgl2,array('%'=>'\%', '_'=>'\_', '\\'=>'\\\\')),

		),

	));

	

	$dataProvider=new CActiveDataProvider('Datarek', array(

		'criteria'=>$criteria,

	)); 

	

	$this->render('cari',array(

		'model'=>$model,

		'dataProvider'=>$dataProvider,

	));

}



semoga berhasil…!

jangan lupa cendolnya ya