I am working on a new application and I have a need to use an EAV table style for a few different tables. Primarily the one I am posting about is my users table. I need to use EAV so that custom user defined fields can be added/displayed easily.
So far I have a simple table structure(instead of pasting it, I made an ERD http://i.imgur.com/b3woQ.png) The approach I am thinking about using is similar to this post http://nuts-and-bolts-of-cakephp.com/2010/07/27/keyvalue-tables-and-how-to-use-them-in-cakephp-1-3/. A simple beforeSave() that matches up fields to the form name. There is only one issue with this that I am seeing, since I am not storing the field name(attribute_code from eav_attributes) with the value, how would I go about matching up the form field with the attribute_code and ultimately with the value the form field passed in? -- 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 [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
