How To Write Query In Yii

Yii 1.1 General Discussion
1

how to write this in yii

SELECT schedule.checkin, schedule.checkout, schedule.days,

employee.firstname, employee.lastname, week.start_date, week.end_date

FROM schedule

INNER JOIN employee_schedule

ON schedule.id=employee_schedule.sched_id

INNER JOIN employee

ON employee.id=employee_schedule.emp_id

INNER JOIN week

ON week.id=employee_schedule.week_id

2

if you have tested sql query then you can use


$list = Yii::app()->db->createCommand('Your command as it is')->queryAll();

if you have an id for which you want to search in DB then u can use concatination like


"WHERE c.id=".$id
3

try this example…




            $criteria = new CDbCriteria;

            $criteria->select = 't.*, tu.* ';

            $criteria->join = ' LEFT JOIN `user_crew` AS `tu` ON t.id = tu.user_id';

            $criteria->addCondition("display_name LIKE '%a%' and blocked_by='76'");

            $resultSet    =    Customer::model()->findAll($criteria);

          

            return $resultSet;