How to convert SQL to cakephp query to query from controller

Question

This is my SQL query that needs to be converted to cakephp type:

select `name` 
from `exams` 
left outer join `exam_results` on `exams`.id = `exam_results`.exam_id 
where `exam_results`.student_id = $sid

So how do I put it in controller and use find () etc. to query database.?

Mazba Kamal · Accepted Answer · 2016-02-11 06:03:41Z

1

you can use table registry or model of the table. here i am using table registry-

 TableRegistry::get('exams')->find('all')
    ->where(['exam_results.student_id'=>$sid])
    ->leftJoin('exam_results', 'exam_results.exam_id = exams.id');

you need to add the name space use Cake\ORM\TableRegistry;

more info http://book.cakephp.org/3.0/en/orm/query-builder.html

answered Feb 11, 2016 at 6:03

Mazba Kamal

5302 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to convert SQL to cakephp query to query from controller

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related