Well a rather simple solution is:
$R_Check=mysql_query("select email from table where email='$email' and
password='$password'");
if(mysql_num_rows($R_Check)) { header("Location: log_in.php"); }
else
{
$Error="";
$R_Check=mysql_query("select email from table where email='$email'");
if(mysql_num_rows($R_Check)) { $Error="Email exists!\n"; }
$R_Check=mysql_query("select password from table where
password='$password");
if(mysql_num_rows($R_Check)) { $Error.="Password exists!\n"; }
if($Error) { header("Location: not_logged_in.php?error=$Error"); }
else
{
// Add info to DB here
// redirect with header() to proper page
}
}
I wrote this from the top of my head so it might not be the best solution,
or free from bugs for that matter 8), but it should give you a few pointers.
You can turn this into a function to make it easier to maintain and use in
multiple pages.
Hope it helps.
Best regards,
Martin Edelius
Spirex Digital Design
------------------------------------------------------------
WWW: http://www.spirex.se || MAIL: [EMAIL PROTECTED]
PHONE: +46-31-514651, 0708-113711 || FAX: +46-31-514331
Aröds Industriväg 3, S-422 43 Hisings Backa
------------------------------------------------------------
If I haven't got back to you or done what I'm supposed to, let me know again
as I have too much to do for my own good...
Got PHP4? http://www.php.net || http://www.zend.com
----- Original Message -----
From: "Marc Bragg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 14, 2001 1:22 PM
Subject: [PHP-DB] log in script // php-auth_user php_auth-pw
> Hi
>
> Does anyone have a simple php script for requiring entry of an email and
> password (settable by user) for access, that is logged in mysql for
> checking proper combination, and if new, creates new entry? I have a
> script that adds the info to database, but what I need to do:
>
> 1. is if the info is already in the database, then it logs user to
> specfic page, and
>
> 2. if not in database, then adds to db and then logs in to specific
> page, and
>
> 3. if wrong combo, then does not log in.
>
> can php_ auth_user and php_auth_pw help?
>
> Any help appreciated.
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]