Posted by Geoff Berrow on 01/01/06 11:21

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]