Parse error: syntax error, unexpected variable "$sql" in C:\xampp\htdocs\ProjectIT12\LR\controller.php on line 38
<?php
include_once ("connection.php");
// connection created succesfullly
session_start();
//store all erros
$errors=[];
//When sign up button clicked
if(isset($_POST['signup'])){
$fname = mysqli_real_escape_string($conn , $_POST['fname']);
$mname = mysqli_real_escape_string($conn , $_POST['mname']);
$lname = mysqli_real_escape_string($conn , $_POST['lname']);
$street = mysqli_real_escape_string($conn , $_POST['street']);
$province = mysqli_real_escape_string($conn , $_POST['province']);
$city = mysqli_real_escape_string($conn , $_POST['city']);
$country = mysqli_real_escape_string($conn , $_POST['country']);
$bank_account = mysqli_real_escape_string($conn , $_POST['bank_account']);
$email = mysqli_real_escape_string($conn , $_POST['email']);
$contact_num = mysqli_real_escape_string($conn , $_POST['contact_num']);
$cust_username = mysqli_real_escape_string($conn , $_POST['cust_username']);
//check password length if password is less than 8 characters
if(strlen(trim($_POST['cust_password'])) < 8){
$errors['cust_password'] = 'Use 8 or more characters with a mix of letters, numbers & symbols';
}else{
// if password not matched so
if($_POST['cust_password'] != $_POST['confirmPassword']){
$errors['cust_password'] = 'Password not matched';
}else{
$cust_password = md5($_POST['cust_password']);
}
}
//generate random code
$code = rand(999999, 111111);
// set status
$email_status ="Not Verified";
$status = 1
$sql = "SELECT * FROM customer WHERE email='$email' ";
$res = mysqli_query($conn , $sql) or die('query failed');
if(mysqli_num_rows($res)> 0){
$errors['email'] = 'email is already taken';
}
//count errors
if(count($errors)===0){
$insertQuery = 'INSERT INTO customer(fname, mname, lname, street, province, city, country, contact_num, email, bank_account,cust_username,cust_password,email_status,code, cust_account_status)
VALUES('$fname' , '$mname', '$lname', '$street' , '$province' , '$city', '$country', '$contact_num', '$email', '$bank_account', '$cust_username','$cust_password','$email_status','$code', '$status' )';
$insertInfo = mysqli_query($conn, $insertQuery);
}
}
?>