Welcome to WebmasterWorld Guest from 18.206.48.142

Forum Moderators: open

Message Too Old, No Replies

Database integration.

Database integration connected at a user ID

     
2:57 pm on Aug 3, 2004 (gmt 0)

Junior Member

10+ Year Member

joined:June 17, 2003
posts:50
votes: 0


Hallo,
since I'm a newbie concerning database integration I would like to ask you experts for advice :-)
I do have a database constructed out of two parameters : a UserID and a password. I do have a webpage with a login procedure and the UserID with correct password is verified in the database. When the combination is true, there is a protected page loaded. That all works just fine. BUT ... I would like to have a different page loaded for each user (so they can check certain private information) and I would like to put these people also in four big usergroups. Can you give me some advise please. Thank you.
Regards, Karl
8:23 pm on Aug 3, 2004 (gmt 0)

Senior Member

WebmasterWorld Senior Member ergophobe is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Apr 25, 2002
posts:8637
votes: 283


Sure, you just need to add some columns to your database of user level (or type) for your four groups, and some preference columns, one of which could be "start page". You can also have their names in the DB and greet them.

Basically, when you get the password and userid out of the DB, you grab the other stuff too and use that to put content on the welcome/post-login page.

Sorry to be so vague, but I don't know at all what you're trying to do, with what software or anything.

One very common toolkit for this is PHP and MySQL. You might start by browsing the PHP forum library [webmasterworld.com]. It might just confuse you, but hopefully it will get you headed in the right direction.

10:00 am on Aug 4, 2004 (gmt 0)

Junior Member

10+ Year Member

joined:June 17, 2003
posts:50
votes: 0


Thank you for the quick respons.
I'm trying to set up a system for a RMA procedure were customers can check the status, but one may not see the status of the other. Our customers do also have to be grouped in four groups according the pricelist they may see for their group. I'm using an access database with a simple ODBC connection. The pages are programmed in ASP. All the help I can get is welcome. I will also check the PHP link. Thank you.
Best regards.
Karl
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members