Thursday, 15 January 2015

mysql - Storing data in user table or a new table? -


What is the most effective, best and fastest way: Adding a 'restricted' (boolean) field to the user's table, or Preparing a new brand named 'Restricted'?

If your restricted users only have a single asset (they are banned), then a Go to the area. For example, when he can check that he can access a page, you will be able to do something (in PHP):

  if ($ f ['baned'] ']) {Die ("Get out of here, banned you!"); } Else {// your argument for general, i.e., non-restricted users}  

where $ f returned by PDO's fetch () Array is) or equivalent function.
If you need some special processing for restricted websites (count your tests for your IP logging - and only their people - or, for example, to access your website) that will include other data , Then go to a table that clearly should be in a UserId field in relation to the main user table. Then you must include this table in each query when checking a user.


No comments:

Post a Comment