Day: November 30, 2021

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