yii query

[nalin (Nalin Professional)]

MY query is:-

$sql = "SELECT * FROM backup_history WHERE DATE_FORMAT(datetime, ‘%Y-%m-%d’ ) = ‘$current_date’ AND site_id=’$data[site_id]’ ";

How can I convert this query to run in Yii?

does anyone solve it problem.

thanks!

[kiran123 (Sharmakiran71)]

you can use various way to execute custom query ,

just create a function in your model…

public function functionName(){

		$data = Yii::app()->db->createCommand()

			->select('*')

			->from('table')

			->queryAll();

		return $data;			

	}

or

$sql="Select * .... ....";

$command=Yii::app()->db->createCommand($sql);

$command->execute();

or

$sql="Select * .... ....";

$command=Yii::app()->db->createCommand($sql)->queryAll();

return $command;

[nalin (Nalin Professional)]

you can use various way to execute custom query ,

just create a function in your model…

public function functionName(){

		$data = Yii::app()->db->createCommand()

			->select('*')

			->from('table')

			->queryAll();

		return $data;			

	}

or

$sql="Select * .... ....";

$command=Yii::app()->db->createCommand($sql);

$command->execute();

or

$sql="Select * .... ....";

$command=Yii::app()->db->createCommand($sql)->queryAll;

return $command;

[nalin (Nalin Professional)]

I want convert my query in yii format.

[kiran123 (Sharmakiran71)]

There are many ways for this… one shown below,

$criteria = new CDbCriteria();

$criteria->select = array('price','shipping','stock');

$criteria->condition = "productId = $productId";

$result=Product::model()->find($criteria); // find/findAll  depends

I want convert my query in yii format.