PHP - Error In Sql Syntax On Upload

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