RE: [phplib] users From: Chris Johnson (chris <email protected>)
Date: 04/20/01

Actually, the correct way to do this IS to create another table.

PHPLIB is a generic library which implements a number of useful pieces
of functionality, such as sessions and authentication. These are common
to many applications.

Application-specific information, such as address and phone number,
should really be structured into additional application specific tables.
One of my applications, for example, uses 3 additonal tables for
information about the users.

Even a medium-sized client-server application could have 40 or 60 tables
(I've developed one of these). 3 or 4 tables is simple enough you can
keep the database design "in your head". If it seems like it is getting
messy to you, you need to start drawing diagrams, planning things in a
methodical way and documenting the result. You might want to take a
look at the following links about database design and normalizing
tables:

http://www.gslis.utexas.edu/~l384k11w/normover.html

http://databases.about.com/compute/databases/mbody.htm

http://www.cs.sfu.ca/CC/354/zaiane/material/notes/Chapter7/node1.html

www.student.math.uwaterloo.ca/~cs448/db2_doc/html/db2d0/frame3.htm#db2d0
37

> -----Original Message-----
> From: Faine, Mark [mailto:Mark.Faine <email protected>]

> It seems to me that auth_user should contain more than the
> few fields. I
> need to be able to recall user information such as address,
> first name, last
> name, phone number, etc. The usual information, nowhere is
> this implemented,
> I know I could create yet another table but I have 3 or 4 already it's
> getting hard to keep track of them and this seems a little messy.
>
> Should I extend the auth_user table to include the
> information I need or
> make yet another table or what? I'm just looking for
> suggestions on best
> possible implementation, how have you guys done it?
>
> -Mark
>

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>