Complete No0b needs help setting up PHP + DB

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
slipstream
Forum Commoner
Posts: 86
Joined: Fri Apr 19, 2002 8:53 am
Location: Canada

Complete No0b needs help setting up PHP + DB

Post by slipstream »

ok I have PHP mysql installed on the server and am using phpMyAdmin to create my DB system. I suck at php and databases but need some help setting up this simple program.

First: I need a login and password verification so my employees can login.
Second: once they are logged in it displays their information they have stored which is only 7 fields or so.

Here is what I did.
I setup a table which has my username and password and a unique userid. I have another table that has the userid as the primary key and I want to retrieve the info based on this userid.

Is this making any sense so far? Am I on the right track?
User avatar
Joe
Forum Regular
Posts: 939
Joined: Sun Feb 29, 2004 1:26 pm
Location: UK - Glasgow

Post by Joe »

Well say the userid was 10283, then you would use GET:

$_GET['userid'];

Remember to use userid as the variable within the URL. Like:

profile.php?userid=10283

You will also need to query this information in order to view anything.
Post Reply