Re: user defined table fields

Thanks, This is precisely the schema I was going to use. I guess I'm
not quite sure what I'm asking....or maybe it's that I already know
the answer.. heh.

Guess I'll just play with it and see what I come up with...I think my
concern is more around building the view. With the right
relationships, it should get all the data, it's just a matter of
passing the names of the attributes to the view. Maybe it's easier
than I thought. Thanks!

-Mike

On Apr 26, 7:42 pm, "Max H. Thayer" <maxtha...@gmail.com> wrote:
> Cake relies  heavily on pre-defined and configured schemas... for a system you describe you might create a relation (table) called "user_defined_attributes"
>
> with a schema like:
> table name: user_defined_attributes
> id (PK)
> user_id (FK to your user)
> attrb_title
> attrb_description
>
> table name: user_entries (table containing actual entries)
> id (PK)
> user_Id(FK to your user/s)
> user_defined_attribute_id (FK to the above table)
> entry_value
>
> a model like this keeps users out of the actual DB structure manipulation (which is a big issue to have to address)
> Cake can then handle this with its standard HABTM/HasMany construct.
>
> Max H. Thayer
> maxtha...@gmail.com
>
> On Apr 26, 2011, at 10:31 PM, turbo2ltr wrote:
>
> > I'm working on a system that needs to allow users to add their own
> > attributes to the DB.  For instance if you had a movies database, I
> > need to allow the user to go into the attribute configuration and add
> > "genre" which would allow every record in the movie DB to have a genre
> > field. When they view a movie, it would need to dynamically render a
> > view for all the custom attributes based on the attribute
> > configuration.
>
> > I've done this many times in PHP using link tables so I know how to do
> > it.  The biggest hurdle with learning cakePHP is knowing what it can
> > do.  I could code this up manually then find out there was an easy way
> > to do it.  I didn't see anything in the manual about it so I'm just
> > asking....are there any features of cake that would make this specific
> > task easy(er)?   Or will I have to handle it all manually?  Any tips
> > for those that have done it already?
>
> > Thanks,
> > Mike
>
> > --
> > Our newest site for the community: CakePHP Video Tutorialshttp://tv.cakephp.org
> > Check out the new CakePHP Questions sitehttp://ask.cakephp.organd 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 athttp://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+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php