form

tailorn

i keep getting an error with this script.

i just want to create a registration form.

can anyone help????????????

<body>
<H1><center>REGISTRATION FORM</H1><hr>
<h2>Please insert your details!</h2>
<h2>All text fields must be completed, before submitting!</h2>

if ($submit=="SUBMIT FORM") {

if(!($username)){
$error="Username Blank<br>";
}
if(!($password)){
$error="$error Password Blank<br>";
}
if(!($first)){
$error="$error First Name Blank<br>";
}
if(!($last)){
$error="$error Last Name Blank<br>";
}
if(!($address)){
$error="$error Address Blank<br>";
}
if(!($paostcode)){
$error="$error Post Code Blank<br>";
}
if(!($country)){
$error="$error Country Blank<br>";
}
if(!($email)){
$error="$error Email Blank<br>";
}
if(!($telno)){
$error="$error Telephone Number Blank<br>";
}

if(!($error)){

// process form
$db = mysql_connect("localhost", "root");
mysql_select_db("Football",$db);
$sql = "INSERT INTO members (username,password,firstname,lastname,address,postcode,country,emailaddress,telno) VALUES ('$username','$password','first','$last','$address','$postcode','$country','$emailaddress','$telno')";

$result = mysql_query($sql);

echo "THANK YOU!\n";
echo "YOUR DETAILS HAVE BEEN SUCCESSFULLY SUBMITTED! YOU ARE NOW A MEMBER\n <br><br><a href =\"main.php\">BACK TO MAIN PAGE</a> </body> ";
exit;

}

if($error){
echo "The following errors have occured:<br>$error<br><br>";
}

<form method="post" action="<?php echo $PHP_SELF?>">

<br>
Username: <input type="Text" name="username"><center>
<br>
Password: <input type="Text" name="password"><center>
<br>
First name: <input type="Text" name="first"><center>
<br>
Last name: <input type="Text" name="last"><center>
<br>
Address: <input type="Text" name="address"><center>
<br>
Postcode: <input type="Text" name="postcode"><center>
<br>
Country: <input type="Text" name="country"><center>
<br>
Email Address: <input type="Text" name="emailaddress"><center>
<br>
Tel No: <input type="Text" name="telno"><center>
<br> <br>
<input type="Submit" name="submit" value="SUBMIT FORM">
</form>

<a href ="main.php">BACK TO MAIN PAGE</a>
</body>";

carlosa69

What error did you get, on what line? always put a comment next to the line where your getting the error. Try the queries for your validation if statements without the parenthesis around the variable. (I mentioned this in your other post) IE if(!($username)) => if(!$username), I'm not sure if this could be the problem, but I never use these and I never get errors so... Oh and another thing to improve your script: instead of saying just "$error=" put it into an array by changing it to $error[]=, then you can entor a foreach statment (http://www.php.net/manual/en/control-structures.foreach.php) and you can print out everything that was not filled out instead of just one thing.

bretticus

Appears that your your html is within your php ?> delimiter.

(
<a href ="main.php">BACK TO MAIN PAGE</a>
</body>";

?> <--right here
)

either echo out those strings with the escaped characters or simply move your ?> delimiter to the point just before you write html.

bretticus

Also, if you wanna save time just use the concatenation operator (.=) to your error if statements:

if(!($password)){
$error.="$error Password Blank<br>";
}