Retrieve all data from one table, and some from another in CakePHP

Question

In my CakePHP site, I want to make a drop-down list of all Venues, and any Restaurants that have is_venue=1.

I've tried this in my events_controller:

        $venueOptions = array(
        'fields' => array('id', 'name_address'),
        'order' => array('name'),
        'join' => array(
            array(
                'table' => 'restaurants',
                'alias' => 'Restaurants',
                'type' => 'inner',
                                    'fields' => array('id', 'name'),
                'foreignKey' => false,
                'conditions' => array('restaurants.is_venue = 1')
            )
        ),
    );
    $venues = $this->Event->Venue->find('list', $venueOptions);

But it appears to still just be getting the venues. I don't really need an association between the two, since their associations will both be with an event, not each other.

Where have I gone wrong? Am I close, but just need to tweak this code, or am I just all-together doing it wrong?

Abba Bryant · Accepted Answer · 2011-06-20 17:45:25Z

1

I think you could do something along the lines of:

<?php
    ....
    $v = $this->Venue->find( 'list' );
    $r = $this->Restaurant->find( 'list' );
    $venues = Set::merge( $v, $r );
    natcasesort( $venues );
    // print_r( $venues );

    $this->set( 'venues', $venues );
    ...
?>

Which is quite like the code above - I just use the Set class and make sure to Controller::set the variable to the view.

Also added some basic sorting to show you one option even though array sorting has nothing really specific to do with CakePHP.

Also fixed some bad variable names where I had originally used $venues, and $restaurants - changed to be consistently $v and $r.

edited Jun 20, 2011 at 17:45

answered Jun 2, 2011 at 21:57

Abba Bryant

4,01224 silver badges18 bronze badges

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

11 Comments

Dave Over a year ago

What's the point of the Set::merge( as opposed to the array_merge mentioned below? (also - i assume you mean merge($v, $r), correct?)

Dave Over a year ago

@Abba - With some alterations, this pretty much works - the only issue now, is - all the restaurants show up at the bottom instead of being in alphabetical order - any thoughts on how to fix this?

Abba Bryant Over a year ago

It's an array - try using some of the handy sorting functions built into php. php.net/manual/en/array.sorting.php -- Example edited to show natural case-insensitive sorting but there are a ton of options.

Abba Bryant Over a year ago

Set::merge is not an exact functional copy of array_merge. I prefer to use cake's classes for such things when they exist as I assume they were written to handle any cake specific edge cases and to work with their data structuring.

Dave Over a year ago

I've tried just about every PHP sort, asort, ksort...etc I could think of - they all make the array print_r NOTHING - not sure why. I'll try natcasesort to see if that works, thanks!

|

Ish · Accepted Answer · 2011-06-03 16:22:14Z

1

Join will not work if there's no relation between. Venue and Restaurant. You should call them separately and merge the results

$venues = $this->Event->Venue->find('list', $venueOptions);
$restaurants = $this->Event->Restaurant->find('list', array('conditions' => array('is_venue' => '1')));
$results = array_merge($venues, $restaurants);

// sort results
asort($results);

edited Jun 3, 2011 at 16:22

answered Jun 2, 2011 at 21:40

Ish

29.8k11 gold badges62 silver badges78 bronze badges

5 Comments

Dave Over a year ago

@Ish Kumar With some alterations, this pretty much works - the only issue now, is - all the restaurants show up at the bottom instead of being in alphabetical order - any thoughts on how to fix this?

Dave Over a year ago

@Ish - I thought that'd work too, but it doesn't - when I try to print_r it, it prints nothing. :/

Ish Over a year ago

Make sure you are NOT doing it like this $results = asort($results); ? because asort is called by reference and return boolean.

Dave Over a year ago

unfortunately array_merge doesn't retain key=>value relationship

Ish Over a year ago

$results = $venues + $restaurants instead of array_merge

Collectives™ on Stack Overflow

Retrieve all data from one table, and some from another in CakePHP

2 Answers 2

11 Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

11 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related