append conditions for criteria

Archives Yii 1.0.x Discussions
1

I wanted to use 2 conditions, but the 2nd one always overwrite the first one. I believe its my sytnax error. I will need help to help me correct it.




$criteria=new CDbCriteria;

		$schedule_run=new schedule_run;

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

		{

			$criteria->condition="sch_script like :input_script";

			$criteria->params=array(":input_script"=>"%".$_POST['sch_script']."%");

		}

		if(isset($_GET['sch_stat']))

		{

			$criteria->condition="sch_stat like :input_stat";

			$criteria->params=array(":input_script"=>"%".$_GET['sch_stat']."%");

		}


		if (!isset($_GET['sort']))

		{

			

			$criteria->order="schrun_start desc";

		}
2

$criteria=new CDbCriteria;

            $schedule_run=new schedule_run;


            [b]$criteria->condition = "1 ";[/b]


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


            {


                    $criteria->condition[b].=" AND[/b] sch_script like :input_script";


                    $criteria->params=[b]array_merge($criteria->params,[/b]array(":input_script"=>"%".$_POST['sch_script']."%")[b])[/b];


            }


            if(isset($_GET['sch_stat']))


            {


                    $criteria->condition[b].=" AND[/b] sch_stat like :input_stat";


                    $criteria->params=[b]array_merge($criteria->params,[/b]array(":input_script"=>"%".$_GET['sch_stat']."%")[b])[/b];


            }





            if (!isset($_GET['sort']))


            {


                    


                    $criteria->order="schrun_start desc";


            }
3

thanks. got it right.

4

You can also use $criteria->addCondition() - it automatically appends conditions to $criteria->condition.