PHP - Parse Error: Syntax Error, Unexpected T_elseif...

Hello everyone,
I am a total newbie in PHP and so do here. I am trying to build a table consisting foreign key and primary key and it is showing error like "Parse error: syntax error, unexpected 'cities' (T_STRING) in line number 29". I have marked up my lines according to sublime text 3 editor. I am trying to create a database. 

 

1 <?php
2 $servername = "localhost";
3 $username = "username";
4 $password = "password";
5 $dbname = "newDB";

7 // Create connection
8 $conn = new mysqli($servername, $username, $password, $dbname);

10 // Check connection
11 if ($conn->connect_error) {
12   die("Connection failed: " . $conn->connect_error);}

14 $firstname = $conn->real_escape_string($_REQUEST['firstname']);
15 $lastname = $conn->real_escape_string($_REQUEST['lastname']);
16 $address = $conn->real_escape_string($_REQUEST['address']);
17 $city = $conn->real_escape_string($_REQUEST['city']);
18 $country = $conn->real_escape_string($_REQUEST['country']);
19 $phone_number = $conn->real_escape_string($_REQUEST['phone_number']);
20 $email = $conn->real_escape_string($_REQUEST['email']);
 
22 // Attempt insert query execution
23 $sql1 = "INSERT INTO cities VALUES ('$city')";

25 $sql2 = "INSERT INTO countries VALUES ('$country')";

27 $sql3 = "INSERT INTO Contacts (firstname, lastname, address, city, country, phone, email) VALUES ('$firstname', '$lastname', '$address', $city, $country, '$phone_number','$email')";

29 SELECT * FROM cities;
SELECT * FROM countries;
SELECT * FROM Contacts;

if($conn->query($sql1) === true){
    echo "City added successfully.";
} else{
    echo "ERROR: Could not able to execute " . $conn->error;
}

if($conn->query($sql2) === true){
    echo "Çountry added successfully.";
} else{
    echo "ERROR: Could not able to execute " . $conn->error;
}

if($conn->query($sql3) === true){
    echo "Çontact added successfully.";
} else{
    echo "ERROR: Could not able to execute " . $conn->error;
}
 
// Close connection
$conn->close();
?>

<?php      
 
define('THEME_URI', get_stylesheet_directory_uri());
define('THEME_IMAGES', THEME_URI . '/assets/img');
define('THEME_CSS', THEME_URI . '/assets/css');
define('THEME_JS', THEME_URI . '/assets/js');
define('THEME_TEMPLATES', THEME_URI . '/assets/templates');   
 
$GLOBALS['content_width'] = 900;
 
/* Define Theme Defaults */
$options = get_option('turnkey_theme_options'); 
if($options['templatestyle'] == null)
$options['templatestyle'] = 'modern';     
if($options['typography'] == null)
$options['typography'] = 'typography1';
 
function turnkeySlider() {   
 
 
  $options = get_option('turnkey_theme_options');  
                
if($options['sliderTimer'] != null)
$rotateTimer = $options['sliderTimer'];
else
$rotateTimer = 5000;
 
   ?>    
          
<script type="text/javascript" charset="utf-8">     
jQuery(document).ready(function($) {  
$('.slide-container').cycle({ fx: 'scrollHorz',next: '#slide-nav .next',prev: '#slide-nav .prev',pause: 1, timeout:<?php echo $rotateTimer; ?>});    
});
</script>
 
<?php
}    
 
add_action('wp_head', 'turnkeySlider');
 
require_once ( get_stylesheet_directory() . '/theme-options.php' );
require_once ( 'slider/turnkey-slider.php' );
 
if (function_exists('register_sidebar')) {
register_sidebar(array(
'name'=> 'Homepage Widgets',
'id' => 'homepage_widgets',
'before_widget' => '<div class="widget group %2$s">',
'after_widget' => '</div>',
'before_title' => '<h3>',
'after_title' => '</h3>'
));
register_sidebar(array(
'name'=> 'Sidebar 1',
'id' => 'sidebar_1',
'before_widget' => '<div class="widget group %2$s">',
'after_widget' => '</div>',
'before_title' => '<h4>',
'after_title' => '</h4>'
));
register_sidebar(array(
'name'=> 'Sidebar 2',
'id' => 'sidebar_2',
'before_widget' => '<div class="widget group %2$s">',
'after_widget' => '</div>',
'before_title' => '<h4>',
'after_title' => '</h4>'
));
register_sidebar(array(
'name'=> 'Footer Widgets',
'id' => 'footer-widgets',
'before_widget' => '<div class="widget group %2$s">',
'after_widget' => '</div>',
'before_title' => '<h3>',
'after_title' => '</h3>'
));
}
 
if ( function_exists( 'register_nav_menus' ) ) {
register_nav_menus(
array(
'turnkey_mainnav' => 'TurnKey Main Navigation',
'turnkey_secondary' => 'TurnKey Secondary Navigation'
)
);
};
 
add_theme_support( 'post-thumbnails' );
 
// Makes Sure thumbnails show up in RSS
function do_post_thumbnail_feeds($content) {
global $post;
if(has_post_thumbnail($post->ID)) {
$content = '<div>' . get_the_post_thumbnail($post->ID) . '</div>' . $content;
}
return $content;
}
add_filter('the_excerpt_rss', 'do_post_thumbnail_feeds');
add_filter('the_content_feed', 'do_post_thumbnail_feeds');
 
// Define Thumbnail Images Sizes
if ( function_exists( 'add_image_size' ) ) {
add_image_size( 'post-thumb-threecol', 390, 200, true );
add_image_size( 'post-thumb-onetwocol', 520, 200, true );
/* Slide Image */ add_image_size( 'special', 580, 340, true );
}
 
if ( !is_admin() ) { // instruction to only load if it is not the admin area
 
function googlejquery() {
   wp_deregister_script( 'jquery' );
   wp_register_script( 'jquery', 'http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js');
}    
 
add_action('init', 'googlejquery');
 
wp_register_script('functions',
     get_bloginfo('template_directory') . '/assets/js/functions.js');
  wp_register_script('cycle',
     get_bloginfo('template_directory') . '/assets/js/cycle.min.js');
  wp_register_script('lightbox',
     get_bloginfo('template_directory') . '/assets/js/lightbox_me.js');
   // enqueue the script
   wp_enqueue_script('jquery'); 
   wp_enqueue_script('functions');
   wp_enqueue_script('cycle');
   wp_enqueue_script('lightbox'); 
};
 
function the_breadcrumb() {
if (!is_home()) {
echo '<a href="';
echo get_option('home');
echo '">';
bloginfo('name');
echo "</a> &raquo; ";
if (is_category() || is_single()) {
the_category('title_li=');
if (is_single()) {
echo " &raquo; ";
the_title();
}
} elseif (is_page()) {
echo " <span class='current'> ";
echo the_title();
echo " </span> ";
 
}
}
}
 
function rap_register_sidebars() {
 
    register_sidebar(array(
 
        'name'              => 'Scheduling campaign sidebar',
        'id'                => 'rap-scheduling-sidebar',
        'description'       => 'Sidebar for Scheduling Campaign template pages only.',
        'before_widget'     => '<div class="widget">',
        'after_widget'      => '</div>',
        'before_title'      => '<h2 class="widget-title">',
        'after_title'       => '</h2>'
 
 
    ));
 
}
 
// Add Automatic Feed Links
add_theme_support('automatic-feed-links');
 
add_filter('widget_text', 'do_shortcode');
add_action('widgets_init', 'rap_register_sidebars');
 
// Below added by Jessica 6/24/13 to display Salesforce lookup fields on Gravity Forms field mapping page
add_filter('gf_salesforce_skip_reference_types', '__return_false'); 
 
// Below added by Jessica to change the field value on the Join Us and Training forms
add_action("gform_pre_submission_1", "pre_submission_JoinUs");
add_action("gform_pre_submission_8", "pre_submission_Training");
add_action("gform_pre_submission_15", "pre_submission_HCAP");
 
function pre_submission_JoinUs($form){
if ($_POST["input_15"] == 'Former Retail Worker') $_POST["input_15"] = 'Retail Worker';
}
 
function pre_submission_Training($form){
if ($_POST["input_18"] == 'Former Retail Worker') $_POST["input_18"] = 'Retail Worker';
}
 
function pre_submission_HCAP($form){
if ($_POST["input_15"] == 'Former Retail Worker') $_POST["input_15"] = 'Retail Worker';
}
 
   ?>    

<?php
error_reporting(E_ALL);
include_once("conninfo2.php"); 
include_once('classes/bcrypt.php'); 

class User 
	{
  	 private $_bcrypt;
	$this->_bcrypt = new Bcrypt;	
	if($this->_bcrypt->verify($password, $this->data()->password)){
	}

if(isset($_POST['username'])) {
   $firstname = strip_tags($_POST['firstname']);
   $surname = strip_tags($_POST['surname']);
   $pnumber = strip_tags($_POST['pnumber']);
   $username = strip_tags($_POST['username']);
   $email1 = strip_tags($_POST['email1']);
   $email2 = strip_tags($_POST['email2']);
   $password1 = $_POST['password1'];
   $password2 = $_POST['password2'];
    

   //code below will make sure all fields are filled in
   if(trim($firstname) == "" || trim($surname) == "" || trim($pnumber) == "" || trim($username) == "username" || trim($email1) == "" || trim($email2) == "" ||trim($password1) == "" || trim($password2) == "") {
   echo "Error, all fileds need to be filled in";
   $db = null;
   exit();
   }

   
   //code below checks that the emails entered both match one another
   if($email1 != $email2) {
   echo "Emails do not match, please try again";
   $db = null;
   exit();
   }
   
   //code below matches the passwords entered
   else if($password1 != $password2) {
   echo "Passwords do not match please try again";
   exit();
   }
   
   if(!filter_var($email1, FILTER_VALIDATE_EMAIL)) {
   echo "Your email is invalid, please try again";
   $db = null;
   exit();
   }
   
   //checks if the email exists within the database
   $stmt = $db->prepare("SELECT email FROM login WHERE email=:email1 LIMIT 1");
   $stmt->bindValue(':email1',$email1, PDO::PARAM_STR);
   try{
   $stmt->execute();
   $count = $stmt->rowCount();
   }
   catch(PDOException $e) {
   echo $e->getMessage();
   $db = null;
   exit();
   }
   
   //checks if the username exists
   $usernameSQL = $db->prepare("SELECT username FROM login WHERE username=:username LIMIT 1");
   $usernameSQL->bindValue(':username',$username,PDO::PARAM_STR);
   try{
   $usernameSQL->execute();
   $usernameCount = $usernameSQL->rowCount();
   }
   catch(PDOExemption $e) {
   echo $e->getMessage();
   $db = null;
   exit();
   }
   
   //checks if the email is already within the database
   if($count > 0) {
   echo "This email already exists";
   $db = null;
   exit();
   }
   
   //checks the username
   if($usernameCount > 0) {
   echo "This username is unavailable please try another";
   $db = null;
   exit();
   }
   
    $user = new User;
    $bcrypt = new Bcrypt;
    
    try {
        $email1->create(array(
            'username' => Input::get('username'),
            'password1' => $bcrypt->hash(Input::get('password')),
            'firstname' => Input::get('name'),
            'surname' => Input::get('surname'),
            'pnumber' => Input::get('pnumber'),
            'email1' => Input::get('email'),
            'ipaddress' => Input::get('ipaddress'),
            'signup_date' => date('Y-m-d H:i:s'),
            'group' => 1
        ));

   	//grab the last id used within the database
   	$lastId = $db->lastInsertId();
   	$stmt3 = $db->prepare("INSERT INTO activated (user, token) VALUES ('$lastId', :token)");
   	$stmt3->bindValue(':token',$token,PDO::PARAM_STR);
   	$stmt3->execute();
   	
   	//email activation
   	$from = "From Auto Responder @ Mediaedit <admin@mediaedit.com>";
   	$subject = "IMPORTANT: Please activate your account";
   	$link = 'http://mediaed.it/roxanne/activate.php?user='.$lastId.'&token='.$token.'';
   	
   	//email body
   	$message = "
   	Thanks for register with Mediaedit, before your able to use our services you will need to verify your email so that we know your human
   	
   	$link
   	";
   	
   	//headers
   	$headers = 'MIME-Version: 1.0' . "rn";
   	$headers .= "Content-type: textrn";
   	$headers .= "From: Mediaedit";
   	
   	//send email now
   	mail($email1, $subject, $message, $headers, '-f noreply@mediated.it');
   	$db->commit();
   	echo "Thanks for registering, before you can us our services you need to activate your account an email has been sent which you will recieve shortly";
   	$db = null;
   	exit();
   	}
   	
   	catch(PDOException $e){
   	$db->rollBack();
   	echo $e->getMessage();
   	$db = null;
   	exit();
   	}
   	}
   	?>