PHP - Sql Syntax Error With Quotations

The issue is there seems to be NO syntax error.

1. There is no relevant code before or after this line. 2. Yes, one would think a ! should be there as did I (I didn't write the code), however, even with the ! it still gives the same error.

if (function_exists('gzcompress')) die(FUNCTION_NOT_FOUND); is giving me a

syntax error, unexpected 'if', expecting 'function' or 'const'

I am updating this code from PHP5.3 to PHP7.4 and I can't figure out what the syntax problem is since PHP allows this. I am using Eclipse PHP to do the conversion.

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