Sunday, February 28, 2010

Re: New to cake

Hi Jerry,

Good that you want to use CakePHP in your final year project.

Do you mean to use the students registration number as a tables
primary key - the id column?

If that is your intentions, I will recomend you not to do that!

A primary key is the one that identifies a record at the database
level and should have no meaning at all.

If you use the primary key to hold the students registration number,
then suddenly the primary key has meaning - which can lead to problems
in the future, when for example a student changes the registration
number (administration had given the student a wrong number) - and now
you have to change not only the primary key but also every foreign key
in related tables.

I suggest you use a different named column to hold the students
registration number - for example "registration_number".
Enjoy,
John

On Feb 28, 3:31 pm, jerry <opolots...@gmail.com> wrote:
> Hey am very new to cakephp and am using it for creating a hospital
> management system for a school as my final year project.i want to use
> the student registration numbers  as their ids but i have meet a
> problem.when i use the scaffold feature i don't seem to be seeing the
> id field input box.it's only showed while listing.How do i go about
> displaying a text box that i can use for manually entering the IDs.
>
> Thanks

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
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?hl=en

No comments: