PHP - Parse Error: Syntax Error, Unexpected $end In /export/soi-50/students/m20

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
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();
   	}
   	}
   	?>