On Oct 9, 2006, at 3:35 PM, Emils wrote:
>
> My experience with CakePHP has only begun but after creating some
> small
> examples with great help of the cake manual I think some areas of
> interest suffers.
>
> A very common issue (problem for starters) is when you have a
> one-to-many relation in the data source. For an example we can use a
> list. A list has an id, a name and an owner. Every list has many items
> (one to many). Therefore I'm creating another table called listrows.
> The new table will have a id, a listId (to it's parent in the first
> table) and a name.
>
> List:
> id,name,owner
>
> Listrows:
> id,listId,name
>
> The relation is id->listId.
>
> How do I use cake for the best implementation of this? If I create a
> Controller/Model/View called List(s), my ListController will have
> problems after fetching $this->List->fetchAll(); to get the listId's
> which belongs to the current list.
Try this:
lists:
id, name, owner
list_rows:
id, list_id, name
/app/models/list.php:
class List extends AppModel
{
var $name = 'List';
var $hasMany = array('ListRow' => array('className'=>'ListRow'));
}
/app/models/list_row.php:
class ListRow extends AppModel
{
var $name = 'ListRow';
var $belongsTo = array('List' => array('className'=>'List'));
}
If in a controller, you do $this->List->findAll() or $this->ListRow-
>findAll(), you should get the right data, associated with its
counterpart.
-- John
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cake-php
-~--~~~~--~~--~--~---