0

I can validate the captcha successfully, but when I set the button property 'Action' to 'Submit form, the captcha does not work, nor does the validation on username and password. When I set it back to 'None", Captcha works, Data not validated. The code below is quite long, but it will give an idea of what I am trying here.

<?PHP

$uname = "";
$pword = "";
$errorMessage = "";
//==========================================
//	ESCAPE DANGEROUS SQL CHARACTERS
//==========================================
function quote_smart($value, $handle) {

   if (get_magic_quotes_gpc()) {
       $value = stripslashes($value);
   }

   if (!is_numeric($value)) {
       $value = "'" . mysql_real_escape_string($value, $handle) . "'";
   }
   return $value;
}

if ($_SERVER['REQUEST_METHOD'] == 'POST'){
	$uname = $_POST['UserName'];
	$pword = $_POST['MemberPw'];

	$uname = htmlspecialchars($uname);
	$pword = htmlspecialchars($pword);

	//==========================================
	//	CONNECT TO THE LOCAL DATABASE
	//==========================================
	$user_name = "auctiontestuser"; //Limited access
	$pass_word = "********";
	$database = "login";
	$server = "127.0.0.1";

	$db_handle = mysql_connect($server, $user_name, $pass_word);
	$db_found = mysql_select_db($database, $db_handle);

	if ($db_found) {

		$uname = quote_smart($uname, $db_handle);
		$pword = quote_smart($pword, $db_handle);

		$SQL = "SELECT * FROM login WHERE L1 = $uname AND L2 = md5($pword)";
		$result = mysql_query($SQL);
		$num_rows = mysql_num_rows($result);

	//====================================================
	//	CHECK TO SEE IF THE $result VARIABLE IS TRUE
	//====================================================

		if ($result) {
			if ($num_rows > 0) {
				session_start();
				$_SESSION['login'] = "1";
				header ("Location: index.html");
			}
			else {
				session_start();
				$_SESSION['login'] = "";
				header ("Location: Register.php");
			}	
		}
		else {
			$errorMessage = "Error logging on";
		}

	mysql_close($db_handle);

	}

	else {
		$errorMessage = "Error logging on";
	}

}


?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<!--
	Copyright 2006 WebCheatsheet.com	
-->

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Login</title>
<link href="styles/LogMeIn.css" rel="stylesheet" type="text/css" />
<style type="text/css">
#LoginData #form1 label {
	font-family: Verdana, Geneva, sans-serif;
}
</style>
</head>

<body>
<div id="container">
  <div id="Logo"><a href="index.html"><img src="Images/Logo/Logo.png" alt="Login or register." width="968" height="110" title="Click to go back to the Home Page." /></a></div>
  <div id="LoginData">
    <div id="EmptySpacer">Please enter your Login Information below.</div>
    <script type="text/javascript"> 
	function setFocus(){ 
		document.getElementById("UserName").focus(); 
		} 
	</script>
    
    <script language="JavaScript" type="text/javascript" src="ajax_captcha.js"></script>
    <body onload="setFocus()">
    
    <form id="frmCaptcha" name="frmCaptcha">
	  <p>
        <label for="UserName">Username:</label>
        <strong>
          <input name="UserName" type="text" id="UserName" title="Enter your Username or E-Mail Address." size="50" maxlength="100" />
        </strong></p>
      <p>
        <label for="MemberPW">Password :<br />
        </label>
        <input name="MemberPW" type="password" id="MemberPW" title="Enter Password" size="50" maxlength="16" />
      </p>
      <table width="470"> 
			<tr>
				<td width="173" align="left">
					<label for="captcha">Security Code:</label>
				</td>
				<td width="238" align="justify">
					<input name="txtCaptcha" type="text" id="txtCaptcha" title="Enter Security Code" size="32" maxlength="10" />
				</td>
				<td width="43"> 
					<img src="create_image.php" name="imgCaptcha" id="imgCaptcha" />
				</td>               
			</tr>
			<tr>
				<td>&nbsp;</td>
                <td>
					<input id="btnCaptcha" type="button" value="     Login     " name="btnCaptcha" 
						onclick="getParam(document.frmCaptcha)" />
				</td>
				<td>&nbsp;</td>
			</tr>
		</table> 

		<div id="result">&nbsp;</div>
    </form>
  </div>
</div>

<?PHP print $errorMessage;?>
</body>
</html>

Any ideas?

Edited by AndreRet: n/a

1
Contributor
1
Reply
2
Views
6 Years
Discussion Span
Last Post by AndreRet
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.