subject:"Using Join Tables in Cakephp \- result in view.ctp"

Using Join Tables in Cakephp - result in view.ctp

2012-02-05 Thread TheMuller

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+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php

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

2012-02-05 Thread Stephen Speakman


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+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php

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

2012-02-05 Thread Team Kemster

Hi Stephen,

Thank you for your answer. 

Well I would say you are right, if it wasn't for that I am able to
use both the tables for it's self. But joining them gives the problems.

I also tried to use some examples on binding the tables with a model for both 
tables, but no luck.

Yes, the table has name for a column (tables shown in first mail). 

Is the pull out in the ctp files correct?

/TheMuller

Den 05/02/2012 kl. 18.54 skrev Stephen Speakman 
step...@ninjacodermonkey.co.uk:

 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+unsubscr...@googlegroups.com For more options, visit this group at 
 http://groups.google.com/group/cake-php

-- 
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+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php

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

2012-02-05 Thread Justin Edwards

There is a typo here. Do you have a table named port_groups_entity,
sport_groups_entities?  The errors should be followable.
   array(
   'table' = 'port_groups_entity',

You also seem to be  using some odd names on your tables.  I try to always
avoid using two plurals unless that table is a join table (habtm) for two
other tables.   If I do has association through tables, I name that table
logically for the relationship that it has.   Such as students, classrooms,
has a join table enrollments that has extra data based the many to many.

You should debug($var) on all of your variables to see what is actually
there.


On Sun, Feb 5, 2012 at 1:41 PM, Team Kemster
kundeservicekems...@gmail.comwrote:

 Hi Stephen,

 Thank you for your answer.

 Well I would say you are right, if it wasn't for that I am able to
 use both the tables for it's self. But joining them gives the problems.

 I also tried to use some examples on binding the tables with a model for
 both tables, but no luck.

 Yes, the table has name for a column (tables shown in first mail).

 Is the pull out in the ctp files correct?

 /TheMuller

 Den 05/02/2012 kl. 18.54 skrev Stephen Speakman 
 step...@ninjacodermonkey.co.uk:

  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+unsubscr...@googlegroups.com For more options, visit this
 group at http://groups.google.com/group/cake-php

 --
 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+unsubscr...@googlegroups.com For more options, visit this group
 at http://groups.google.com/group/cake-php


-- 
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

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

2012-02-05 Thread Team Kemster

Well I am joining a script with the table name port_group_entity, so it is 
not possible to change that table.

When I make an error in the table name, the error message shows a totally 
correct join query (except the table name of course). The only thing that is 
bothering me is the end WHERE 1=1. Why is that coming?

/TheMuller

Den 05/02/2012 kl. 23.13 skrev Justin Edwards justinledwa...@gmail.com:

 There is a typo here. Do you have a table named port_groups_entity, 
 sport_groups_entities?  The errors should be followable.
array(
'table' = 'port_groups_entity',
 
 You also seem to be  using some odd names on your tables.  I try to always 
 avoid using two plurals unless that table is a join table (habtm) for two 
 other tables.   If I do has association through tables, I name that table 
 logically for the relationship that it has.   Such as students, classrooms, 
 has a join table enrollments that has extra data based the many to many.  
 
 You should debug($var) on all of your variables to see what is actually 
 there.
 
 
 On Sun, Feb 5, 2012 at 1:41 PM, Team Kemster kundeservicekems...@gmail.com 
 wrote:
 Hi Stephen,
 
 Thank you for your answer.
 
 Well I would say you are right, if it wasn't for that I am able to
 use both the tables for it's self. But joining them gives the problems.
 
 I also tried to use some examples on binding the tables with a model for both 
 tables, but no luck.
 
 Yes, the table has name for a column (tables shown in first mail).
 
 Is the pull out in the ctp files correct?
 
 /TheMuller
 
 Den 05/02/2012 kl. 18.54 skrev Stephen Speakman 
 step...@ninjacodermonkey.co.uk:
 
  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+unsubscr...@googlegroups.com For more options, visit this group at 
  http://groups.google.com/group/cake-php
 
 --
 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

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

2012-02-05 Thread Richard Joo

WHERE 1=1 is by default.
You will see that everywhere if you do not provide any 'conditions'

You can change that by adding 'condition' to your query list.

for example:

$subscriberName = $this-Subscriber-find('list', array('conditions'
= array('id' = $mySubscriber), 'fields' = array('name')));

then cake will put out something like SELECT name FROM Subscribers WHERE id=6

If you do this,
$organizationStatusActive   = $this-OrganizationStatus-find('list',
array('conditions' = array('OrganizationStatus.name' = 'Active'),
'fields' = array('OrganizationStatus.id')));

you will get something like

SELECT OrganizationStatus.id FROM Organizations WHERE
OrganizationStatus.name = 'Active'


Sorry if you find any errors from this reply~  had to write real
quick...   and I am not a cake expert either~


On Sun, Feb 5, 2012 at 10:20 PM, Team Kemster
kundeservicekems...@gmail.com wrote:
 Well I am joining a script with the table name port_group_entity, so it is
 not possible to change that table.

 When I make an error in the table name, the error message shows a totally
 correct join query (except the table name of course). The only thing that is
 bothering me is the end WHERE 1=1. Why is that coming?

 /TheMuller

 Den 05/02/2012 kl. 23.13 skrev Justin Edwards justinledwa...@gmail.com:

 There is a typo here. Do you have a table named port_groups_entity,
 sport_groups_entities?  The errors should be followable.
    array(
            'table' = 'port_groups_entity',

 You also seem to be  using some odd names on your tables.  I try to always
 avoid using two plurals unless that table is a join table (habtm) for two
 other tables.   If I do has association through tables, I name that table
 logically for the relationship that it has.   Such as students, classrooms,
 has a join table enrollments that has extra data based the many to many.

 You should debug($var) on all of your variables to see what is actually
 there.


 On Sun, Feb 5, 2012 at 1:41 PM, Team Kemster kundeservicekems...@gmail.com
 wrote:

 Hi Stephen,

 Thank you for your answer.

 Well I would say you are right, if it wasn't for that I am able to
 use both the tables for it's self. But joining them gives the problems.

 I also tried to use some examples on binding the tables with a model for
 both tables, but no luck.

 Yes, the table has name for a column (tables shown in first mail).

 Is the pull out in the ctp files correct?

 /TheMuller

 Den 05/02/2012 kl. 18.54 skrev Stephen Speakman
 step...@ninjacodermonkey.co.uk:

  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

Using Join Tables in Cakephp - result in view.ctp

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

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

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

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

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

6 matches

Site Navigation

Mail list logo

Footer information