Re: Using Join Tables in Cakephp - result in view.ctp

Hi

I may not know the answer to your question but shouldn't your model be
named:

sport_group.php and SportGroup extends AppModel ?

port_groups_entity table should be named "port_group_entities" ---- PortGroupEntities

I would personally correct all the filenames, class names and $this->Model lines etc to represent proper CakePHP conventions, then I would use pr($this->SportGroup->findByUrl($url)); etc to view the results retrieved from the query...

If name isn't in there maybe it's an error with your MySQL table? Maybe check recursive? (Apologies if I missed any info, my thunderbird client isn't threading mail list topics =/)

Kind Regards
Stephen

On 05/02/2012 17:18, TheMuller wrote:
> Hi,
>
> I have looked, search and founded, but not the answer to my questions:
> How do I get the result of my join table in my view.ctp? Am I doing
> something wrong?
>
> I have followed some guides from bakery and other blogs, and created a
> setup like shown below. But why does the error in view.ctp say:
> "Notice (8): Undefined index: name"
>
> Code:
>
> models/sportsgroup.php
> <?php
> class SportsGroup extends Appmodel {
> var $name = 'SportsGroup';
> }
> ?>
>
> controllers/sports_groups_controllers.php
> <?php
>
> class SportsGroupsController extends AppController {
> var $helpers = array ('Html', 'Form', 'Js' => array('Jquery'),
> 'Javascript', 'GoogleMapView');
> var $name = 'SportsGroups';
>
> function index() {
> $this->SportsGroup->recursive = 0;
> $this->set('sportsgroups', $this->SportsGroup->find('all',
> array('joins' => array(
> array(
> 'table' => 'port_groups_entity',
> 'alias' => 'GroupsEntity',
> 'type' => 'inner',
> 'conditions'=> array('SportsGroup.group_id =
> GroupsEntity.guid')
> )
> )
> )));
> $this->set('title_for_layout', 'Sportsclubs online');
>
> }
> function view($url = null) {
> if (!$url) {
> $this->Session->setFlash('Invalid id for Post.');
> $this->redirect('/sportsclub/');
> }
> $this->set('post', $this->SportsGroup->findByUrl($url));
> }
> }
>
> ?>
>
> view/sportsgroups/index.ctp (or view.ctp)
> <?php foreach ($sportsgroups as $post): ?>
> <?php echo $post['SportsGroup']['title']?> (it catches this one)
> <?php echo $post['SportsGroup']['name']?> (but not this one)
> <?php endforeach; ?>
>
> view/sportsgroups/view.ctp
> <?php echo $post['SportsGroup']['title']?> (it catches this one)
> <?php echo $post['SportsGroup']['name']?> (but not this one)
>
> The database table are like:
> sports_groups: id | group_id | title
> groups_entity: guid | name
>
> Please help me, I used 2-3 days on this one..
>
> /TheMuller
>

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.

To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php