code for counting the total no of records in a table

Yii 1.1 General Discussion
1

Hi all,

anyone plz help me to get the count of total no of records in a table

Thanks…

2

Hi,

You could use count method:




YourModel::model()->count();
3

Hi

As well

            $criteria=new CDbCriteria;


            $model = new YourModelName;


	$criteria->select='Feild Name';


	$criteria->addCondition('Condition');


	echo $model->count($criteria);
4

Try this








	public  function countModel($username)

	{

	    	$criteria=new CDbCriteria;

		$criteria->compare('user_name',$username,true);

		$criteria->compare('date_time',date('Y-m-d'),true);


		return $this->count($criteria); 

	      

	}
5

thanx for this article.