You are here: Re: Table schema for user login system? « PHP Programming Language « IT news, forums, messages
Re: Table schema for user login system?

Posted by Bruno Barros on 09/29/07 13:57

I, for my framework, put:

ID
USERNAME
PASSWORD
EMAIL

That is for the simple login / logout / register data.
Then, according to the application, there is another user table, which
holds all the user's information. It is always made from scratch as I
never know which fields my customer requires or my code needs ;). For
example, for a social networking site you need about me, musical
interests, ..., but for a customer account on a shop, you needn't such
things. The main users table only stores what is essential in ALL
users. Then I make a relation between them, connecting users by ID.
The record with ID X on main table belongs to ID X on the other table.

By the way, PHPBB3, MediaWiki and such are not frameworks, they are
not made to be as broad as possible. They are ONLY made for themselves
and their specific needs, while a framework needs us to remember that
it has to work with all websites from top to bottom.

---
Bruno Rafael Moreira de Barros

Adobe Photoshop CS2 and CS3
-
XML / XSLT
-
MySQL / SQLite / TerraDB
-
PHP 3, 4, 5 and 6

:: Looking For A Permanent Job ::
---

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация