Dave Crosman wrote:
> Mohamed Moustafa wrote:
>> Hello Guys,
>> I'm looking for Login System to run it in my web site
>> - I have web site that PHP/MySQL
>> - read from database
>> So I need to make pages that Edit/Delete in my database but "of
>> course" I need User and password for this pages and full security
>> So I'm very confuse in how to make something like that
>> PLEASE, if any one know or have login system good for me
>> Thank u
>
> ...The above no longer works for me, I now require Multi login from one
> user name.
> I have not finished the multi login but will do it like this. The User
> Table has now been expanded to keep records of up to 10 logins
> table User_Login(
> Login_.....
> Login_name
> Login_SSIDx
> Login_IPx
> Login_datetimex)
> Skylinux
> http://www.Network-Technologies.org
>
I have tried to setup Multi login today and came to the conclusion that
a second table is needed. The second table approach should require less
database connections per script run AND should allow user defined
maximum simultaneous connection control.
The Main table (Users) will keep track of Username,password,rights,.....
The Second table (Users_login) will keep track of the user ssid,ip,login
time.
create table Users_login(
Login_id BIGINT AUTO_INCREMENT PRIMARY KEY,
Login_USER_ID INT NOT NULL,
Login_ssid varchar(200) NOT NULL,
Login_ip varchar(200) NOT NULL,
Login_time datetime NOT NULL)
I'll give this a try after some sleep but I'm confident it will work fine.
--
Skylinux
http://www.Network-Technologies.org
------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Groups gets a make over. See the new email design.
http://us.click.yahoo.com/XISQkA/lOaOAA/yQLSAA/HKFolB/TM
--------------------------------------------------------------------~->
Community email addresses:
Post message: php-list@yahoogroups.com
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
