[redjohn]

how to do that please help...

this is my controller

http://pastebin.com/uFvkKjNc

[iainjames88]

I think this is what you could be looking for CActiveRecord::findAllByAttributes()

[alirz23]

There are many ways to approach this problem take look at this might help you

<?php
// first approach
... 
$criteria = new CDbCriteria;
$criteria->compare("price", 1);
$posts = Post::model()->find($criteria);
... 
 
// second approach
... 
$posts = Post::model()->find(array('price'=>1));
... 

https://gist.github.com/4520140

[redjohn]

alirz23, on 12 January 2013 - 02:41 PM, said:

There are many ways to approach this problem take look at this might help you

<?php
// first approach
... 
$criteria = new CDbCriteria;
$criteria->compare("price", 1);
$posts = Post::model()->find($criteria);
... 
 
// second approach
... 
$posts = Post::model()->find(array('price'=>1));
... 

https://gist.github.com/4520140

doesn't work, in which functions must put this code, what variable must have that function. Exists a clear example.

[fouss]

redjohn, on 13 January 2013 - 03:22 AM, said:

doesn't work, in which functions must put this code, what variable must have that function. Exists a clear example.

For exemple in your PostsController change your actionIndex() this way

	public function actionIndex()
	{       

                
		$dataProvider=new CActiveDataProvider('Post',array('criteria'=>array('condition'=>"price =1")));
		$this->render('index',array(
			'dataProvider'=>$dataProvider,
		));
	}

[fouss]

And don't forget to learn about CActiveDataProvider

[Dariusz Męciński]

alirz23, on 12 January 2013 - 02:41 PM, said:

There are many ways to approach this problem take look at this might help you

<?php
// first approach
... 
$criteria = new CDbCriteria;
$criteria->compare("price", 1);
$posts = Post::model()->find($criteria);
... 
 
// second approach
... 
$posts = Post::model()->find(array('price'=>1));
... 

https://gist.github.com/4520140

second approach is not valid
it should be:

$posts = Post::model()->findByAttributes(array('price'=>1));

or

$posts = Post::model()->find('price = :price, 'array(':price'=>1));

or

$posts = Post::model()->find(array('condition'=>'price = :price', 'params'=>array(':price'=>1)));

as say api for find function:

If an array, it is treated as the initial values for constructing a CDbCriteria object; Otherwise, it should be an instance of CDbCriteria.

[redjohn]

fouss, on 13 January 2013 - 05:09 AM, said:

For exemple in your PostsController change your actionIndex() this way

	public function actionIndex()
	{       

                
		$dataProvider=new CActiveDataProvider('Post',array('criteria'=>array('condition'=>"price =1")));
		$this->render('index',array(
			'dataProvider'=>$dataProvider,
		));
	}

It works......Billion of thanks.

[fouss]

redjohn, on 13 January 2013 - 06:16 AM, said:

It works......Billion of thanks.

happy to know that it helped you

[alirz23]

@kazio

Quote

second approach is not valid
it should be:
$posts = Post::model()->findByAttributes(array('price'=>1));

mybad It was late in the night sleep was hitting me bad thanks for the correction

[alirz23]

redjohn u must read the blog tutorial