# PHP Syntax Error Issues

**URL:** <https://forum.kirupa.com/t/php-syntax-error-issues/321542>\
**Category:** programming\
**Created:** [April 22, 2011, 1:29pm UTC](https://forum.kirupa.com/t/php-syntax-error-issues/321542 "2011-04-22T13:29:46Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![liaminax](https://avatars.discourse-cdn.com/v4/letter/l/8edcca/32.png) [@liaminax](https://forum.kirupa.com/u/liaminax)\
**Post date:** [April 22, 2011, 1:29pm UTC](https://forum.kirupa.com/t/php-syntax-error-issues/321542/1 "2011-04-22T13:29:46Z")

</div>

Hi,

I’m having an issue with the php file below. Line 350, just after the final ?\> is showing a syntax error and i can’t work out what the issue is. If i delete some coding, the syntax error just moves to the last line. I’ve tried copy-pasting it into another file but the same issue occurs. Any help would be greatly appreciated. Sorry the file is quite long.

\<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “[http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd](http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd)”\>  
\<html xmlns=“[http://www.w3.org/1999/xhtml](http://www.w3.org/1999/xhtml)” xml:lang=“en” lang=“en”\>  
\<head\>  
\<meta http-equiv=“Content-Type” content=“text/html; charset=iso-8859-1” /\>  
\<title\>Add Booking\</title\>  
\</head\>  
\<?php  
include (’./mainMenuUser.php’);  
?\>  
\<body\>  
\<?php # Script 13.1 - add\_booking.php  
//This page allows admin to add facility booking

require\_once (’…/mysql\_connect.php’);

if(isset($\_POST[‘submitted’])) {

```
//Validate data
$errors = array();

//Check for customer first name
if(!empty($_POST['firstname'])) {
    $pn = trim($_POST['firstname']);
} else{
    $errors[] = 'Please enter the customer\'s First Name.';
}

//Check for customer last name
if(!empty($_POST['lastname'])) {
    $pn = trim($_POST['lastname']);
} else{
    $errors[] = 'Please enter the customer\'s Last Name.';
}

// Check for e-mail address
if (!empty($_POST['email'])) {
    $e[] = trim($_POST['email']);
}else {
    $errors[] = 'You forgot to enter the customer\'s e-mail address.';
}

// Check for telephone number
if (!empty($_POST['tel'])) {
    $tn = trim($_POST['tel']);
}else {
    $errors[] = 'You forgot to enter the customer\'s telephone number.';
}

// Check for function type
if (!empty($_POST['function_type'])) {
    $ft = trim($_POST['function_type']);
}else {
    $errors[] = 'You forgot to enter the function type.';
    
} // Check for function room
if (!empty($_POST['function_room'])) {
    $fr = trim($_POST['function_room']);
}else {
    $errors[] = 'You forgot to enter the function room.';
}

// Check for date
if (!empty($_POST['date'])) {
    $d = trim($_POST['date']);    
}else {
    $errors[] = 'You forgot to enter the date of the function.';
}

// Check for time
if (empty($_POST['time'])) {
    $t = trim($_POST['time']);
}else {
    $errors[] = 'You forgot to enter the time of the function.';
}

// Check for bar requirement
if (!empty($_POST['bar'])) {
    $b = trim($_POST['bar']);
}else {
    $errors[] = 'You forgot to enter whether a bar is required.';
}

// Check for bar extension requirement
if (!empty($_POST['extension'])) {
    $ex = trim($_POST['extension']);
}else {
    $errors[] = 'You forgot to enter whether a bar extension is required.';
}

// Check for catering requirement
if (!empty($_POST['catering'])) {
    $c = trim($_POST['catering']);
}else {
    $errors[] = 'You forgot to enter whether catering is required.';
}

// Check for DJ requirement
if (!empty($_POST['dj'])) {
    $dj = trim($_POST['dj']);
}else {
    $errors[] = 'You forgot to enter whether a DJ is required.';
}

//Validate booking
if(isset($_POST['booking']) && ($_POST['booking'] == 'new') ) {
    //If new booking, add to database
    
    //Check for firstname
    if(!empty($_POST['firstname'])) {
        $fn = trim($_POST['firstname']);
    
    //Check for lastname
    if(!empty($_POST['lastname'])) {
        $ln = trim($_POST['lastname']);
        
    //Check for e-mail
    if(!empty($_POST['email'])) {
        $e = trim($_POST['email']);
        
    //Check for telephone number
    if(!empty($_POST['tel'])) {
        $tn = trim($_POST['tel']);
            
    //Check for function type
    if(!empty($_POST['function_type'])) {
        $ft = trim($_POST['function_type']);
    
    //Check for function room
    if(!empty($_POST['function_room'])) {
        $fr = trim($_POST['function_room']);
            
    //Check for date
    if(!empty($_POST['date'])) {
        $d = trim($_POST['date']);
    
    //Check for time
    if(!empty($_POST['time'])) {
        $t = trim($_POST['time']);
        
    //Check for bar requirement
    if(!empty($_POST['bar'])) {
        $b = trim($_POST['bar']);
    
    //Check for extension requirement
    if(!empty($_POST['extension'])) {
        $ex = trim($_POST['extension']);
    
    //Check for catering requirement
    if(!empty($_POST['catering'])) {
        $c = trim($_POST['catering']);
    
    //Check for DJ requirement
    if(!empty($_POST['dj'])) {
        $dj = trim($_POST['dj']);
                            
        //Add booking to database
        $q = 'INSERT INTO Booking (firstname, lastname, email, tel, function_type, function_room, date, time, bar, extension, catering, dj) VALUE (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)';
        $stmt = mysqli_prepare($db, $q);
        mysqli_stmt_bind_param($stmt, 'sss', $fn, $ln, $e, $tn, $ft, $fr, $d, $t, $b, $ex, $c, $d);
        mysqli_stmt_execute($stmt);
        
        //Check results
        if(mysqli_stmt_affected_rows($stmt) == 1) {
            echo '&lt;p&gt;The booking has been added.&lt;/p&gt;';
            $a = mysqli_stmt_insert_id($stmt);
        } else{
            $errors[] = 'The booking could not be added to the database.';
        }
        
        //Close statement
        mysqli_stmt_close($stmt);
        
    }else {
        $errors[] = 'Please enter the booking details.';
    }

```

}elseif (isset($\_POST[‘lastname’]) AND isset($\_POST[‘function\_type’]) AND isset($\_POST[‘date’]) && ($\_POST[‘lastname’] AND ($\_POST[‘function\_type’]) AND ($\_POST[‘date’]) == ‘existing’) && ($\_POST[‘existing’] \> 0) ) {  
$a = (int) $\_POST[‘existing’];  
} else{  
$errors[] = ‘Please enter or select booking.’;  
}

//if(empty($errors)) {  
//Validate booking  
if(isset($\_POST[‘customers’]) && ($\_POST[‘customers’] == ‘new’) ) {  
//If new booking, add to database

```
    //Check for firstname
    if(!empty($_POST['firstname'])) {
        $fn = trim($_POST['firstname']);
    
    //Check for lastname
    if(!empty($_POST['lastname'])) {
        $ln = trim($_POST['lastname']);
        
    //Check for e-mail
    if(!empty($_POST['email'])) {
        $e = trim($_POST['email']);
        
    //Check for telephone number
    if(!empty($_POST['tel'])) {
        $tn = trim($_POST['tel']);

//Add customer to database
$q = 'INSERT INTO customers (cust_id, firstname, lastname, email, tel) VALUES (?, ?, ?, ?, ?)';
$stmt = mysqli_prepare($dbc, $q);
mysqli_stmt_bind_param($stmt, 'isdsss', $fn, $ln, $e, $tn);
mysqli_stmt_execute($stmt);

//Check results
if(mysqli_stmt_affected_rows($stmt) == 1) {
    
    //Print message
    echo '&lt;p&gt;The customer has been added.&lt;/p&gt;';
    
    $_POST = array();
    
} else{
    echo '&lt;p style="font-weight: bold; color: #C00"&gt;Your entry could not be processed due to a system error.&lt;/p&gt;';
}

mysqli_stmt_close($stmt);

```

}

//Display form  
?\>  
\<h2\>Add Booking\</h2\>  
\<form enctype=“multipart/form\_data” action=“add\_booking.php” method=“post”\>  
\<fieldset\>\<legend\>Please fill complete the form to add a booking to the database:\</legend\>

\<div\>\<b\>Customer:\</b\>  
\<p\>\<input type=“radio” name=“customer” value=“existing” \<?php if (isset($\_POST[‘customers’]) && ($\_POST[‘customers’] == ‘existing’) ) echo ’ checked=“checked”’; ?\>/\> Existing =\>  
\<select name=“existing”\>\<option\>Select One\</option\>  
\<?php  
$q = “SELECT cust\_id, COCNAT\_WS(’ ', firstname, lastname, tel, email) FROM customers ORDER BY lastname, firstname ASC”;  
$r = mysqli\_query($db, $q);  
if(mysqli\_num\_rows($r) \> 0) {  
while ($row = mysqli\_fetch\_array ($r, MYSQL\_NUM)) {  
echo “\<option value=”$row[0]"";  
//Check for stickyness  
if(isset($\_POST[‘existing’]) && ($\_POST[‘existing’] == $row[0]) ) echo ’ selected=“selected”’;  
}  
} else{  
echo ‘\<option\>Please add a new customer.\</option\>’;  
}  
mysqli\_close($db);  
?\>  
\</select\>\</p\>

\<p\>\<input type=“radio” name=“artist” value=“new” \<?php if (isset($\_POST[‘customers’]) && ($\_POST[‘customers’] == ‘new’) ) echo ’ checked=“checked”’; ?\>" /\> New =\>  
First Name: \<input type=“text” name=“firstname” size=“10” maxlength=“15” value="\<?php if (isset($\_POST[‘firstname’])) echo $\_POST[‘firstname’]; ?\>" /\>  
Last Name: \<input type=“text” name=“lastname” size=“10” maxlength=“30” value="\<?php if (isset($\_POST[‘lastname’])) echo $\_POST[‘lastname’]; ?\>" /\>  
Telephone Number: \<input type=“text” name=“tel” size=“11” maxlength=“11” value="\<?php if (isset($\_POST[‘tel’])) echo $\_POST[‘tel’]; ?\>" /\>  
E-mail Address: \<input type=“text” name=“email” size=“30” maxlength=“60” value="\<?php if (isset($\_POST[‘email’])) echo $\_POST[‘email’]; ?\>" /\>  
\</div\>

\<p\>\<b\>Function Type:\</b\> \<input type=“text” name=“function\_type” size=“30” maxlength=“50” value="\<?php if (isset($\_POST[‘function\_type’])) echo $\_POST[‘function\_type’]; ?\>" /\>\</p\>

\<p\>\<b\>Function Room:\</b\>  
\<select name=“function\_room” value="\<?php if (isset($\_POST[‘time’])) echo $\_POST[‘time’]; ?\>" \</p\>\>  
\<option value=“Bradley Room”\>Bradley Room\</option\>  
\<option value=“Back Bar”\>Back Bar\</option\>  
\<option value=“Members Bar”\>Members Bar\</option\>  
\<option value=“Pitch”\>Pitch\</option\>  
\</select\>

\<p\>\<b\>Time of function:\</b\>  
\<select name=“time” value="\<?php if (isset($\_POST[‘time’])) echo $\_POST[‘time’]; ?\>" \</p\>  
\<option value=“7pm til 12am”\>Evening\</option\>  
\<option value=“9am til 1pm”\>Morning\</option\>  
\<option value=“1pm til 6pm”\>Afternoon\</option\>  
\<option value=“All Day”\>All Day\</option\>  
\</select\>

\<p\>\<b\>Bar Required?:\</b\>\<input type=“radio” name=“bar” value="\<?php if (isset($\_POST[‘bar’])) echo $\_POST[‘bar’]; ?\>" \</p\>  
\<select name=“bar”\>  
\<option value=“Yes”\>Yes\</option\>  
\<option value=“No”\>No\</option\>  
\</select\>

\<p\>\<b\>Bar Extension Required?:\</b\>\<input type=“radio” name=“extension” value="\<?php if (isset($\_POST[‘extension’])) echo $\_POST[‘extension’]; ?\>" \</p\>  
\<select name=“extension”\>  
\<option value=“Yes”\>Yes\</option\>  
\<option value=“No”\>No\</option\>  
\</select\>

\<p\>\<b\>Catering Required?:\</b\>\<input type=“radio” name=“catering” value="\<?php if (isset($\_POST[‘catering’])) echo $\_POST[‘catering’]; ?\>" \</p\>  
\<select name=“catering”\>  
\<option value=“Yes”\>Yes\</option\>  
\<option value=“No”\>No\</option\>  
\</select\>

\<p\>\<b\>DJ Required?:\</b\>\<input type=“radio” name=“dj” value="\<?php if (isset($\_POST[‘dj’])) echo $\_POST[‘dj’]; ?\>" \</p\>  
\<select name=“dj”\>  
\<option value=“Yes”\>Yes\</option\>  
\<option value=“No”\>No\</option\>  
\</select\>

\<p\>\<b\>Date of function:\</b\>  
\<?php # Script 2.5 - calendar.php  
function make\_calendar\_pulldowns($m = NULL, $d = NULL, $y = NULL) {

// Creates array for months  
$months = array (1 =\> ‘January’, ‘February’, ‘March’, ‘April’, ‘May’, ‘June’, ‘July’, ‘August’, ‘September’, ‘October’, ‘November’, ‘December’);

// Creates months pull-down menu  
echo ‘\<select name=“months”\>’;  
foreach ($months as $key =\> $value) {  
echo “\<option value=”$key"";  
if ($key == $m) {  
echo ’ selected=“selected”’;  
}  
echo "\>$value\</option\>  
";  
}  
echo ‘\</select\>’;

// Create days pull-down menu  
echo ‘\<select name=“days”\>’;  
for ($days = 1; $days \<= 31; $days++) {  
echo “\<option value=”$days"";  
if ($days == $d) {  
echo ’ selected=“selected”’;  
}  
echo "\>$days\</option\>  
";  
}  
echo ‘\</select\>’;

// Create years pull-down menu  
echo ‘\<select name=“years”\>’;  
for ($years = 2011; $years \<= 2020; $years++) {  
echo “\<option value=”$years"";  
if ($years == $y) {  
echo ’ selected=“selected”’;  
}  
echo "\>$years\</option\>  
";  
}  
echo ‘\</select\>’;  
}

// Get today’s information and call function  
$dates = getdate();  
make\_calendar\_pulldowns ($dates[‘mon’], $dates[‘mday’], $dates[‘year’]);

// Print current day and time  
echo '\<p\>Today is ’ . date (‘l’) . ’ . The current time is ’ . date (‘g:i a’) .  
‘.\</p\>’;

?\>

\</fieldset\>

\<div align=“center”\>\<input type=“submit” name=“submit” value=“Submit” /\>\</div\>  
\<input type=“hidden” name=“submitted” value=“TRUE” /\>

\</form\>

\</body\>  
\</html\>