Re: CakePHP models with multiple tables
Thanks for the help. You know, I read that section so many times, but couldn't figure out how to make it work right. Then I tried it using scaffolding and it works perfectly. So, now I have to figure out how to do the same without scaffolding. -- 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
CakePHP models with multiple tables
Hi folks, I imagine a good search would help me find the answer to my problem, but unfortunately, I don't know the words to use to describe my problem. So, I'll describe it here and seek either the terminology I need to learn more or possibly the solution. I'm completely new to CakePHP but somewhat familiar with PHP and MySQL. Familiar enough with the later, that I've decided I need to first to make a better application. Imagine I have the following database tables. TABLE job_title id desc level TABLE job_levels id desc A record in the job_title table would look something like: id = 1 desc = CakePHP Developer level = 3 And the job_levels table has the following data id = 3 desc = Senior So, in this case, when I do a join in MySQL, I'd get a job_title record that looks something like: id = 1 desc = CakePHP Developer level = 3 desc = Senior Basically, I'm substituting the job level id for the job level desc. Now, how do I do the same in CakePHP? I built put an association in the model for Job but that doesn't return exactly what I want. Essentially, for each job, I'd like to have the level description available in the model. At least I think this is what I want. Maybe there is some concept I'm missing that would make this unnecessary. Hopefully this makes sense. Any help or advice is greatly appreciated. robbie -- 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: CakePHP models with multiple tables
Hi, I think you should specify the relation in the `job_title` model http://book.cakephp.org/2.0/en/models/associations-linking-models-together.html#hasone Then the find() method should return you the related values as associative arrays. To adapt normalize the results, eg. a single array, look at model callback (eg. afterFind) http://book.cakephp.org/2.0/en/models/callback-methods.html Il 28/12/2011 02:18, robbie ha scritto: Hi folks, I imagine a good search would help me find the answer to my problem, but unfortunately, I don't know the words to use to describe my problem. So, I'll describe it here and seek either the terminology I need to learn more or possibly the solution. I'm completely new to CakePHP but somewhat familiar with PHP and MySQL. Familiar enough with the later, that I've decided I need to first to make a better application. Imagine I have the following database tables. TABLE job_title id desc level TABLE job_levels id desc A record in the job_title table would look something like: id = 1 desc = CakePHP Developer level = 3 And the job_levels table has the following data id = 3 desc = Senior So, in this case, when I do a join in MySQL, I'd get a job_title record that looks something like: id = 1 desc = CakePHP Developer level = 3 desc = Senior Basically, I'm substituting the job level id for the job level desc. Now, how do I do the same in CakePHP? I built put an association in the model for Job but that doesn't return exactly what I want. Essentially, for each job, I'd like to have the level description available in the model. At least I think this is what I want. Maybe there is some concept I'm missing that would make this unnecessary. Hopefully this makes sense. Any help or advice is greatly appreciated. robbie -- 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