Auth page

[kiwis]

Hi All,

As you can see I've finally got my signup.php page working, I want to have a login.php page.

I've looked around hotscripts ect for a script but am not having any luck. I guess it will go something like this

<?php 
mysql_connect (localhost, user, password); 
mysql_select_db (nz); 
$qry = mysql_query("SELECT user_name, user_password FROM DB_Users");
$arr = mysql_fetch_array($qry);

if ($_POST['action'] == 'save') { 

if($_POST['user_name'] == $_POST ['user_name']){

\\ set cookie information
}
}else{
echo "Your passwords don't match.";  
}
} else { 
?>

this is way wrong but does anyone have a basic code that will help me??

[kows]

In your code you're comparing one value to itself.. nothing's going to happen.

This should work for you:

<?php  
  mysql_connect ('localhost', 'user', 'password');  
  mysql_select_db ('nz');  
  $qry = mysql_query("SELECT user_name FROM DB_Users WHERE user_name='$_POST[user_name]' AND user_password='$_POST[user_password]';"); 
  $arr = mysql_fetch_array($qry); 

  if($_POST['action'] == 'save'){  
    if($arr[0] != ""){ 
      echo "Authenticated.\n";
      //set cookie information 
    }else{ 
      echo "The server could not authenticate your account information.\n";   
    } 
  }else{  
    echo "stuff for action that isn't 'save'\n";
  }
?>

[The Hobo]

If this is for a login page, why is action 'save'?

[kiwis]

Originally posted by The Hobo
If this is for a login page, why is action 'save'?

it's a copy paste from the signup page, action maybe login