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
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
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.