Orsdxy

Please help! I keep getting the below error message from my browser from the code below it. Any help would be appreciated.

Fatal error: Uncaught Error: Call to a member function bind_param() on bool in C:xampp2htdocsinsert.php:28 Stack trace: #0 {main} thrown in C:xampp2htdocsinsert.php on line 28

<?php

$user_name = $_POST['user_name'];

$user_password = $_POST['user_password'];

$phone_number = $_POST['phone_number'];

$user_email = $_POST['user_email'];

if (!empty($user_name) || !empty($user_password) || !empty($phone_number) || !empty($user_email)) {

    $host = "localhost";

    $dbUsername = "root";

    $dbPassword = "";

    $dbname = "loginsystem";

    //create connection

    $conn = new mysqli($host, $dbUsername, $dbPassword, $dbname);

    if (mysqli_connect_error()) {

     die('Connect Error('. mysqli_connect_errno().')'. mysqli_connect_error());

    } else {

     $SELECT = "SELECT user_email From users Where user_email = ? Limit 1";

     $INSERT = "INSERT Into users (user_name, user_password, phone_number, user_email,) values(?, ?, ?, ?)";

     //Prepare statement

     $stmt = $conn->prepare($SELECT);

     $stmt->bind_param("s", $user_email);

     $stmt->execute();

     $stmt->bind_result($user_email);

     $stmt->store_result();

     $rnum = $stmt->num_rows;

     if ($rnum==0) {

      $stmt->close();

      $stmt = $conn->prepare($INSERT);

      *$stmt->bind_param("ssis", $user_name, $user_password, $phone_number, $user_email);*

      $stmt->execute();

      echo "New record inserted sucessfully";

     } else {

      echo "Someone already registered using this email";

     }

     $stmt->close();

     $conn->close();

    }

} else {

 echo "All field are required";

 die();

}

?>

First, we need to look at the error message. Specifically, your error is this:

Call to a member function bind_param() on bool

Your error message also gives us a line number (and it looks like your pasted code includes asterisks around that line). So lets look at the line where the error occurred:

$stmt->bind_param("ssis", $user_name, $user_password, $phone_number, $user_email);

Your error message is saying that you've called bind_param on a bool (boolean), which means your variable $stmt is not the mysqli object you're expecting. Next we look at the line before to find out why $stmt is a boolean. On that line you called the function prepare(). If we look at the PHP documenation for that function, we can see that it will return FALSE if there was an error.

So now we know there was an error when preparing your insert statement. If we go up and look at your insert statement
$INSERT = "INSERT Into users (user_name, user_password, phone_number, user_email,) values(?, ?, ?, ?)";
you'll notice an extra comma after user_email. Delete the comma, and your code should work.

Most coding environments should pick up and flag that type of error for you, so that you don't have to go through a long debugging process. There are a number of free ones out there, and I strongly recommend looking into using one of them.