Form handler

frankobi

I created a log-in form in html so that each user could log-in with his/her last_name and password. I also created another page “authenticate.php” to check the log-in attempt. However, when I click on the Log-in button, it takes me to the directory of all the files I have on the server. What am I doing wrong? Below is a part of the php file; it includes everything but the database connection section. Thanks:

$sql="select * from my_table where last_name=\"$last_name\"
and password = password( \"$password\" )";

$rs=mysql_query($sql,$dbh)
or die("Could not execute query");

$num = mysql_numrows($rs);

if($num != 0)
{ $msg = "Welcome $last_name - your log-in succeeded!"; }
else
{ header("Location:$HTTP_REFERER"); exit(); }

?>
<html> <head> <title>Check Log-in</title></head>
<body>
<?php
echo($msg);
?>
</body>

</html>

drag0n

its nothing to do with authenicate.php but with your html form, you have to make the action go to authenicate.php

BooRadLey

Hmm, maybe try this if the form isn't the problem:

if($num != 0) 
{ $msg = "Welcome $last_name - your log-in succeeded!"; } 
else 
{ header("Location:".$_SERVER['HTTP_REFERER']); exit(); }

Brad

*edit - it really does sound like the form is wrong though, probably a mispelling.

drag0n

from To Kill A Mocking Bird?

frankobi

Thanks to everyone who responded to my inquiry. Everyone suggested that the problem might be with the html form itself, as opposesd to the form handler, which I named "authenticate.php". I am creating a form so that a user will log-in with his/her last_name and password. But when I press "submit" I am taken to the directory of my files.

Thanks, and here is the code for the html form:

</head>

<body>
Please complete the following fields to log in.

<form action="authenticate.php" method="post">
Last Name:<br>
<input type="text" name="last_name">
<br><br>
Password:<br>
<input type="text" name="password">
<br><br>

</body>
</html>

Frankobi

drag0n

use $_POST to get lastname and anmes, u dont have register_globals on, tada!