Controller view for CDbCriteria (addSearchCondition)

Yii 1.1 General Discussion
1

Hi guys,

How to compare and filter the result if my view is using $data[‘model’]. Current my code at view can show the result in database.But how to match n filter the result inside the controller side.


  

View:

    <?php echo 'Model :' . $data['model']; ?><br/>

    <?php echo 'Serial No:' . $data['serial_no']; ?><br/>

    <?php echo 'Company Name :' . $data['company_name']; ?><br/>

    <?php echo 'Phone Number:' . $data['email']; ?><br/>

My previous code before using $data[‘variable’]. How to make the change n compare?


  public function actionStar_list($string='')

    {

        $criteria = new CDbCriteria();

        if(strlen($string) > 0)

        {

            $criteria->addSearchCondition('id', $string, true, 'OR');

            $criteria->addSearchCondition('model', $string, true, 'OR');

            $criteria->addSearchCondition('serial_no', $string, true, 'OR');

            $criteria->addSearchCondition('email', $string, true, 'OR');

           

        }

        $dataProvider = new CActiveDataProvider('star', array('criteria' => $criteria,));

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

            'dataProvider' => $dataProvider,

        ));

    }

thanks,=)

2

hi guys,

i now refer to url="http://www.yiiframework.com/doc/api/1.1/CSqlDataProvider"]CSqlDataProvider [/url] and Using a CDbDataReader (sql query result) in a zii widget (such as CGridView or CListView).

i can show the result from 2 tables inside CListView using $data[‘variable’].


View:

    <?php echo 'Model :' . $data['model']; ?><br/>

    <?php echo 'Serial No:' . $data['serial_no']; ?><br/>

    <?php echo 'Company Name :' . $data['company_name']; ?><br/>

    <?php echo 'Phone Number:' . $data['email']; ?><br/>

But how to make the filtering from 2 tables. How to change $criteria->addSearchCondition(‘model’) so that it will filter the value inside $data[‘model’].


public function actionStar_list($string='')

    {

        $criteria = new CDbCriteria();

        if(strlen($string) > 0)

        {

            $criteria->addSearchCondition('id', $string, true, 'OR');

            $criteria->addSearchCondition('model', $string, true, 'OR');

            $criteria->addSearchCondition('serial_no', $string, true, 'OR');

            $criteria->addSearchCondition('email', $string, true, 'OR');

           

        }

        $dataProvider = new CActiveDataProvider('star', array('criteria' => $criteria,));

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

            'dataProvider' => $dataProvider,

        ));

    }

Any helpss is very grateful… =) thanks

3

can anyone give me solution??