Hi
Please help, my registration page is not submitting. Keeps coming back to the same registration form.
Language: PHP
<body>
<div align="center"> | <a href="index.php">Index<a/> |
<a href="register.php">Register<a/> |
<a href="login.php">Login<a/> |
<a href="insert.php">Insert<a/> |
<a href="list.php">List<a/> |
</div>
<h2>
<div align="center">Property Agents Registrations</div>
<div align="center">
<form action="register.php" method="post">
<table>
<tr><td colspan="2"><hr></td></tr>
<tr><td>Title:</td><td><select name="title" id "Title" size="1" ><option>Mr</option>
<option>Mrs</option><option>Miss</option></select></td></tr>
<tr><td>Name:</td><td><input type="text" name="name" id="name" size="30" /></td></tr>
<tr><td>Surname:</td><td><input type="text" name="surname" id="surname" size="30" /></td></tr>
<tr><td>Agency:</td><td><input type="text" name="agency" id="agency" size="30" /></td></tr>
<tr><td>Username:</td><td><input type="text" name="username" id="username" size="30" /></td></tr>
<tr><td>Password: </td><td><input type="text" name="password" id="password" size="30" /></td></tr>
<tr><td>Confirm Password:</td><td><input type="text" name="Confirm Password" id="confPassword" size="30" /></td></tr>
<tr><td colspan="2"><hr></td></tr>
<tr><td align="center" colspan="2"><input type="submit"value="Register" id="submit" /><input type="reset" value="Clear"</td><td></tr>
<tr><td colspan="2"><hr></td></tr>
</table>
</form>
</div>
<?php
include("connect.php"); // connect to database
$Submit=$_POST["submit"];
$Title=$_POST["title"];
$Name=$_POST["name"];
$Surname=$_POST["Surname"];
$Agency=$_POST["agency"];
$Username=$_POST["username"];
$Password1=$_POST["password"];
$Password2=$_POST["confPassword"];
if($Submit=="Yes"){ // if submit button is clicked
$Check=mysql_query("SELECT * FROM prop_agents WHERE username=';$Username';");// check for existing username
$Rows=mysql_num_rows($Check);
if($Rows>0){
header("Location: index.php?msg=The username $Username already exists!"); // back to index
}
else{
if($Password1==$Password2){ //testing passwords
$Insert=("INSERT INTO 535132, prop_agents (user_id, title, name, surname, agency, username, password)VALUES(';';, ';$Title';, ';$Name';, ';$Surname';, ';$Agency';, ';$Username';, ';$Password';)");// save to database
$Result=mysql_query($Insert,$Connect) or die(mysql_error());
header("Location: login.php?msg=Registration Sucessful"); // goes to login page
}
else{
echo "passwords doesnt match";
}
}
}
?>