Login

[wanted420]

Ok i have a db that has username and password. how would i go about getting the info from a form and checking the username and password with what i have in my db? sry if i didnt explain well enough. thank for any help.

[baffled_in_UK]

try this. (ignore the session stuff if you don't want to use it)

session_start();
$error="";
if ($_POST['submit']) {
$pass = $_POST['pass'];
$user = $_POST['user'];
$db = @mysql_connect("localhost","db_user","db_password") or header("Location: db_error.php");
mysql_select_db("dbase_name",$db) or header("Location: db_error.php");
$result = mysql_query("SELECT * FROM table  WHERE user= \"$user\" AND pass= \"$pass\"",$db); 
$num = @mysql_num_rows($result);
if ($num != 0)  { $_SESSION[login] = "1";  header("Location: redirect.php]"); 
}else{
$error="Details not found, try again.";
}
}

Set your form tag to :
<FORM NAME="security" ACTION="<? PHP_SELF ?>" METHOD=POST>
and have two text fields called user and pass

Probably not the neatest code you'll ever see but it works.