CakePHP - rapid application development framework for PHP ()

mohit | 10 Jul 2012 20:22

Working with Profiles

I have tried searching it over the internet also but I am bit confused.

I have to create an application which has to specify lot of checkboxes for profiles which display their skills(more than 80)
A user has to click a skill that he has.

I have a design issue, How to proceed with the schema, I can make a database field for each item, but that will not be feasible.

Any ideas or help will be appreciated.

Thanks,
Mohit

--
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/cake-php

headers

Harsha M V | 10 Jul 2012 21:28

Re: Working with Profiles

users(id, name, email,...)
skills (id, name, description..)
users_skills (id, user_id, skill_id) --> HABTM join table

headers

mohit kumar | 11 Jul 2012 09:01

Re: Working with Profiles

I have used HABTM to implement it. The problem that I am receiving is I am getting is

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'UsersCertification.user_id' in 'on clause'

Any ideas?

On Wed, Jul 11, 2012 at 12:58 AM, Harsha M V <harsha <at> mink7.com> wrote:

users(id, name, email,...)
skills (id, name, description..)
users_skills (id, user_id, skill_id) --> HABTM join table

--
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/cake-php

--
Best Regards,
Mohit Kumar

headers

lowpass | 11 Jul 2012 19:25

Re: Working with Profiles

On Wed, Jul 11, 2012 at 3:01 AM, mohit kumar <mohitkr05@...> wrote:
> I have used HABTM to implement it. The problem that I am receiving is I am
> getting is
>
> SQLSTATE[42S22]: Column not found: 1054 Unknown column
> 'UsersCertification.user_id' in 'on clause'
>
> Any ideas?

Not without knowing what the UsersCertification class is, its
relationship to other classes, and your code.

--

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

headers

mohit kumar | 11 Jul 2012 19:29

Re: Working with Profiles

i fixed it ,., thanks, it was a silly mistake

On Wed, Jul 11, 2012 at 10:55 PM, lowpass <zijn.digital-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:

On Wed, Jul 11, 2012 at 3:01 AM, mohit kumar <mohitkr05-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
> I have used HABTM to implement it. The problem that I am receiving is I am
> getting is
>
> SQLSTATE[42S22]: Column not found: 1054 Unknown column
> 'UsersCertification.user_id' in 'on clause'
>
> Any ideas?

Not without knowing what the UsersCertification class is, its
relationship to other classes, and your code.

--
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/cake-php

--
Best Regards,
Mohit Kumar