CakePHP Custom Query

Question

Anybody knows how to execute this using the famous Cakephp ORM-based 'find' query function?

$sql = "SELECT id FROM users WHERE id IN (SELECT user_id 
                                          FROM classification 
                                          WHERE class_name = '".$classname."')";

What I want to do is to get the id of the user ( from users table ) whenever a class_name is submitted.

As you can see, the user_id is the foreign key of the classifications table.

gintas · Accepted Answer · 2012-02-23 13:29:48Z

1

If you have User and Classification models with Classification having hasMany relationship to User, you can go with

$result = $this->Classification->find('first', array('conditions' => array(
    'Classification.class_name' => $classname
)));

foreach ($result['Classification']['User'] as $user)
    echo 'User id: ' . $user['id'] . '<br />';

edited Feb 23, 2012 at 13:29

answered Feb 23, 2012 at 13:22

gintas

2,1781 gold badge19 silver badges28 bronze badges

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

2 Comments

foxns7 Over a year ago

Thanks, but I do have a question.. Can we execute ConnectionManager :: getDataSource('second_db') inside the User model? Because I'm using external connection to another non-cake app. Or do I need to create another fresh model that relates to that application but resides inside CakePHP? Or, am I silly enough to ask this? :)

dogmatic69 Over a year ago

better to use a model with the specific datasource specified.

Collectives™ on Stack Overflow

CakePHP Custom Query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related