Hi , I am creating a form handler and am getting a Parse error: syntax error, unexpected T_VARIABLE, expecting '('
I have looked at the code many times and am miffed as to why this is happening
<style type="text/css" title="text/css" media="all">
.error {
font-weight: bold;
color:#C00;
}
</style>
</head>
<body>
<?php
if (!empty($_REQUEST['title'])) {
$title = $_REQUEST['title'];
} else {
$title = NULL;
echo '<p class="error">Please enter your title</p>';
}
if (!empty($_REQUEST['first_name'])) {
$first_name = $_REQUEST['first_name'];
} else {
$first_name = NULL;
echo '<p class="error">Please enter your first name</p>';
}
if (!empty($_REQUEST['surname'])) {
$surname = $_REQUEST['surname'];
} else {
$surname = NULL;
echo '<p class="error">Please enter your surname</p>';
}
if (!empty($_REQUEST['username'])) {
$username = $_REQUEST['username'];
} else {
$username = NULL;
echo '<p class="error">Please enter your chosen username</p>';
}
if (!empty($_REQUEST['password'])) {
$password = $_REQUEST['password'];
} else {
$password = NULL;
echo '<p class="error">Please enter your chosen password</p>';
}
if (!empty($_REQUEST['email'])) {
$email = $_REQUEST['email'];
} else {
$email = NULL;
echo '<p class="error">Please enter your email address</p>';
}
if (!empty($_REQUEST['house_name_no'])) {
$house_name_no = $_REQUEST['house_name_no'];
} else {
$house_name_no = NULL;
echo '<p class="error">Please enter your house name or number</p>';
}
if (!empty($_REQUEST['street'])) {
$street = $_REQUEST['street'];
} else {
$street = NULL;
echo '<p class="error">Please enter your street</p>';
}
if (!empty($_REQUEST['town'])) {
$town = $_REQUEST['town'];
} else {
$town = NULL;
echo '<p class="error">Please enter your town</p>';
}
if (!empty($_REQUEST['city'])) {
$city = $_REQUEST['city'];
} else {
$city = NULL;
echo '<p class="error">Please enter your city</p>';
}
if (!empty($_REQUEST['county'])) {
$county = $_REQUEST['county'];
} else {
$county = NULL;
echo '<p class="error">Please enter your county</p>';
}
if (!empty($_REQUEST['post_code'])) {
$post_code = $_REQUEST['post_code'];
} else {
$post_code = NULL;
echo '<p class="error">Please enter your post code</p>';
}
if (!empty($_REQUEST['country'])) {
$country = $_REQUEST['country'];
} else {
$country = NULL;
echo '<p class="error">Please enter the country you live in</p>';
}
if (!empty($_REQUEST['phone_number'])) {
$phone_number = $_REQUEST['phone_number'];
} else {
$phone_number = NULL;
echo '<p class="error">Please enter your phone number</p>';
}
if (!empty($_REQUEST['offers_services'])) {
$offers_services = $_REQUEST['offers_services'];
} else {
$offers_services = NULL;
echo '<p class="error">Please enter if you are interested in receiving special offers and other services from CES Ltd</p>';
}
$name = "$title $first_name $surname";
if ($title && $first_name && $surname && $username && $password && $email && $house_name_no && $street && $town && $city && $county && $post_code && $country && $phone_number && $offers_services) {
echo "<p>Thankyou <b>$name</b> for your registration, you can now proceed to log in.";
}
else { echo '<p class="error">Please go back and complete the form.</p> <div align="center"><FORM><INPUT TYPE="button" VALUE="Back" onClick="history.go(-1);return true;"> </FORM>
</div>
}';
?>
<?php
require_once
('mysqli_connect.php');
if
[B]$q = "INSERT INTO users (username, password, title, first_name, surname, house_name_number, street_address, town, city, county, post_code, country, telephone_number, email_address, marketing_offers') VALUES ('$username',MD5('$password'),'$title','$first_name','$surname','$house_name_no','$street','$town','$city','$county','$post_code','$country','$phone_number','$email','$offers_services')";[/B]
$r = mysqli_query ($dbc, $q);
if ($r) {
echo 'Thankyou you are now registered';
} else { echo '<h1>System error <p class="error">You could not be registered</p>';
echo '<p>' . mysqli_error($dbc) .
'<br><br>Query: ' . $q .
'</p>';
}
mysqli_close($dbc);
include ('footer.html');
exit()
?>
</body>
</html>
The bold INSERT TO line of text is the issue.
Thanks in advance
