Posted by Frank R. Jr. on 01/03/06 07:29

Was hoping to get more response before I reply, I semi understand what
your saying by session variable you do mean cookie? And do you know
where I could find an example of this? Thanks in advanced

Frank R. Jr.

-----Original Message-----
From: Geoff Berrow [mailto:blthecat@ckdog.co.uk]
Posted At: Sunday, January 01, 2006 3:22 AM
Posted To: alt.php
Conversation: mysql help
Subject: Re: mysql help

Message-ID: <n5Ltf.124652$WH.33949@dukeread01> from Frank R. Jr.
contained the following:

>Hey, All im learning mysql and i have read tuts on how to add data to a
>table and select the database. Also to connect, but what i dont know
how
>to do is how to check a form through mysql such as a login page to
check
>the database for the username and password. And if its true to login
>does anyone know where i can get a tut on this or someone who can over
>me some help thanks in advanced.
>
The steps are these:-

(Assuming a unique username and password combination in database.)

Collect username and password from a form

Check if there is a row in the database containing that username and
password.

If there is, set a session variable and show a menu or redirect to a
home page etc. , else redirect to an error page.

Check for existence of session variable on each page. If it exists,
show page, else redirect back to header page.



--
Geoff Berrow 0110001001101100010000000110
001101101011011001000110111101100111001011
100110001101101111001011100111010101101011

[Back to original message]