adding data into MySQL database via forms

kkk

Hiii,

I'm having problems submitting data into my MySQL database via a form which adds new users. their details need to go into two tables.

I am getting the following error:
Parse error: syntax error, unexpected $end on line 69

this line is the last line: "?>"

Below is the code, please could someone tell me where I am going wrong:

<?php

session_start();
require_once ("Connections/connection_properties.php"); //database connection  


$forename = null;
$surname= null;
$phoneNumber = null;
$emailAddress = null;
$username= null;
$password = null;


$errors = array();

if (isset($_POST['submit']) && !empty($_POST['submit'])) {
	//form was submitted
	//let's validate

if(isset($_POST['forename']) && !empty($_POST['forename'])) {
	$forename = $_POST['forename'];
} else {
	$errors['forename'] = "No forname was supplied";
}

if(isset($_POST['surname']) && !empty($_POST['surname'])) {
	$surname = $_POST['surname'];
} else {
	$errors['surname'] = "No surname was supplied";
}

if(isset($_POST['phoneNumber']) && !empty($_POST['phoneNumber'])) {
	$phoneNumber = $_POST['phoneNumber'];
} else {
	$errors['phoneNumber'] = "No phone number was supplied";
}

if(isset($_POST['emailAddress']) && !empty($_POST['emailAddress'])) {
	$emailAddress = $_POST['emailAddress'];
} else {
	$errors['emailAddress'] = "No email address was supplied";
}

if(isset($_POST['username']) && !empty($_POST['username'])) {
	$username = $_POST['username'];
} else {
	$errors['username'] = "No username was supplied";
}

if(isset($_POST['password']) && !empty($_POST['password'])) {
	$username = $_POST['password'];
} else {
	$errors['password'] = "No password was supplied";
}

if (empty($errors)) {
	//no errors were encountered. New academic staff details can now be added to the database. 


$SQL = "INSERT INTO Staff (forename,surname,phoneNumber,emailAddress)
VALUES('$_POST [forename]','$_POST [surname]','$_POST [phoneNumber]',' $_POST [emailAddress]')";

$SQL = "INSERT INTO user (userName,password)
VALUES('$_POST [username]','$_POST [password]')";

echo "A new staff has been successfully added!";
		exit();
 ?>

dalecosp

Welcome to PHPBuilder!

Please wrap your code in [php] tags ... this helps us all when spotting errors.

For example, you have 14 opening curly brackets, but only 12 closing curly brackets, in your code. That's the source of the error you quote 🙂

kkk

thankyouuuu 🙂 ... How do I know where to put the extra two closing brackets? Thankyou for you help.

dalecosp

They should correspond with opening brackets, enclosing blocks of code.

One thing that might help ... in addition to using tags here on PHPBuilder, find a "style guide" for your code and stick with it. It's been discussed here many times (here's one example), and all experienced programmers stick to one of a few basic style of code layout. Here's mine:

<?php

if ($foo) {
   do_this();
} else {
   dont();
   if ($additonal_condition) {
      maybe();
   }
}

So each curly brace aligns with the beginning of its opening statement. Others are even stricter:

<?php

if ($foo) 
{
   do_this();
} 
else 
{
   dont();
   if ($something_else) 
   {
      another_function();
   }
}

So each curly brace is aligned from top to bottom with its corresponding brace. If you do this for all your code, you should be able to find this sort of error without much trouble.