Hello Carlos,
Yes, it would be the same. You'll have some double info in your DB,
though.
--
With best regards from Ukraine,
Andre
Skype: Francophile; Wlm&MSN: arthaelon @ yandex.ru; Jabber: arthaelon @
jabber.org
Yahoo! messenger: andre.polykanine; ICQ: 191749952
Twitter: m_elensule
----- Original message -----
From: Carlos Sura <carlos_s...@hotmail.com>
To: an...@oire.org <an...@oire.org>
Date: Tuesday, June 29, 2010, 11:13:08 PM
Subject: [PHP] Login form + User level access
Hello Andre,
Thank you so much, Now I really get the idea.
Oh, can I replace that adding inthe table of access_level a field called:
'level_numbers' ?? would it be the same thing??
Carlos Sura.
> Date: Tue, 29 Jun 2010 23:08:51 +0300
> From: an...@oire.org
> To: an...@oire.org
> CC: carlos_s...@hotmail.com; php-general@lists.php.net
> Subject: Re[2]: [PHP] Login form + User level access
>
> Hello Carlos,
>
> What I forgot to add is the following:
> I'd suggest you to put in the integers and not the strings
> (1 instead of PURCHASER, 2 instead of SALES etc.). It will
> quicken the process.
> --
> With best regards from Ukraine,
> Andre
> Skype: Francophile; Wlm&MSN: arthaelon @ yandex.ru; Jabber: arthaelon @
> jabber.org
> Yahoo! messenger: andre.polykanine; ICQ: 191749952
> Twitter: m_elensule
>
> ----- Original message -----
> From: Andre Polykanine <an...@oire.org>
> To: Carlos Sura <carlos_s...@hotmail.com>
> Date: Tuesday, June 29, 2010, 11:04:53 PM
> Subject: [PHP] Login form + User level access
>
> Hello Carlos,
>
> Something like this (assuming that the field with the type of the user
> - admin, sales, etc. - is called `Status`, and the table is called
> `Users`):
> $f=mysql_fetch_assoc(mysql_query("SELECT `Status`, COUNT(*) AS
> `UserExists` FROM `Users` WHERE
> `Name`='".$_POST['name']."' AND
> `Password`='".md5($_POST['pass'])."'"));
> if ($f['UserExists']>0) { // name and password are correct
> switch ($f['Status']) {
> case 'ADMIN': include "adminmenu.php"; break;
> case 'SALES': include "salesmenu.php"; break;
> // ...
> }
> } else {
> die ("You entered either an incorrect login or an
> incorrect password.");
> }
>
> I assume you store crypted passwords in your
> database, and the algorythm is md5 (there are
> better solutions, but I used it simply for this
> example).
>
> --
> With best regards from Ukraine,
> Andre
> Skype: Francophile; Wlm&MSN: arthaelon @ yandex.ru; Jabber: arthaelon @
> jabber.org
> Yahoo! messenger: andre.polykanine; ICQ: 191749952
> Twitter: m_elensule
>
> ----- Original message -----
> From: Carlos Sura <carlos_s...@hotmail.com>
> To: php-general@lists.php.net <php-general@lists.php.net>
> Date: Tuesday, June 29, 2010, 10:46:14 PM
> Subject: [PHP] Login form + User level access
>
>
>
>
> Hello everyone.
>
> I have this question: I'm developing a login system but what I need is to do
> is access levels
>
> I mean, in my database I have this users:
>
> Admin
> Superusers
> sales
> purchase
> etc
>
> So, What I do basically need is, when a user from sales log in.. I want him
> to see just the menu from SALES, He cannot see others menu options, and he
> can't get access, I was reading that I can do that with Switch, but really
> I have no idea about it... Any help?
>
> Thank you.
>
> Carlos Sura.
>
>
>
>
>
> _________________________________________________________________
> http://clk.atdmt.com/UKM/go/197222280/direct/01/
> Do you have a story that started on Hotmail? Tell us now
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
_________________________________________________________________
http://clk.atdmt.com/UKM/go/197222280/direct/01/
Do you have a story that started on Hotmail? Tell us now
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
