List:General Discussion« Previous MessageNext Message »
From:mikesz Date:November 22 2009 3:36am
Subject:Optimizing Project Requirements - question
View as plain text  
Hello and Greetings,

I have an idea for a project that I am putting together and was
wondering about the best way to store the information. I am looking
for suggestions concerning the formatting and storing of information.

I have three different groups that I need to track and use
information. The "Profile" information, i.e contact and personal info,
is slightly different depending on which group is registering for
membership.

I was thinking that I would have a two part registration form where I
did and email verification before I collected the rest of their
personal information. So, I am thinking that I need a USER table that
just tracks a minimal amount of info and a USERGROUP or PROFILE table that stores
the Profile information and is related on the USERID.

I was also thinking to just have three different registration tables
and collect all the information, then send the email verification
after all the data is collected and stored. I am thinking that idea
isn't very efficient which got me to thinking about a single USER
table as described above.

I am using this practice project to try to get my head around PHP OOP
so its a learning tool. I have been doing hierarchical PHP coding for a
long time and have resisted learning and using OOP for years so I am
still pretty much in the PHP Stone Age in terms of coding. This has
become a real handicap now that all of the code bases for products that I
support are now heavily OOP so writing hacks for them has become a bit
of a hassle for me at this point without the ability to integrate OOP
solutions.

I am seeing that database configuration is an important consideration
when building an PHP object oriented site so I am hoping to get some
thoughts on the best approach I should use to set up the database.

TIA for the favor of a reply.

  

-- 
Best regards,
 Mikesz                          mailto:mikesz@stripped

Thread
Optimizing Project Requirements - questionmikesz22 Nov
  • Re: Optimizing Project Requirements - questionmos22 Nov