Warning message in Mysqli: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given?

Question

I am using this code and i try to run it but it shows this error and try to fix it but i don't know how? Can anyone help me? :

Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given in /home/u330779411/public_html/Register.php on line 10

Warning: mysqli_stmt_execute() expects parameter 1 to be mysqli_stmt, boolean given in /home/u330779411/public_html/Register.php on line 11

Warning: mysqli_stmt_close() expects parameter 1 to be mysqli_stmt, boolean given in /home/u330779411/public_html/Register.php on line 13

Here is my code:

$name = $_POST['name'];
$matric_number = $_POST['matric_number'];
$username = $_POST['username'];
$password = $_POST['password'];

$statement = mysqli_prepare($con, "INSERT INTO Users (name, matric_number, username, password) VALUES (?, ?, ?, ?)");
mysqli_stmt_bind_param($statement, "siss", $name, $matric_number, $username, $password);
mysqli_stmt_execute($statement);

mysqli_stmt_close($statement);

mysqli_close($con);

Is it

`var_dump($statement);` its probably going to say false – Oct 14 '15 at 02:10 — , Oct 14 '15 at 02:10
@Dagon means? the code is not correct? – rafein Oct 14 '15 at 02:12 — rafein, Oct 14 '15 at 02:12
is it false? is so there is an error with mysqli_prepare() – Oct 14 '15 at 02:13 — , Oct 14 '15 at 02:13

score 0 · Answer 1 · answered Oct 14 '15 at 04:49

According to the PHP Docs:

mysqli_prepare() returns a statement object or FALSE if an error occurred.

Since your warning states that a boolean was given, it is likely that an error occurred. I would suggest doing var_dump($statement) as @Dagon suggested to check if $statement is set to false.

You might also want to check $con. I am assuming that you omitted that part and that you initialized it properly earlier in the code, but make sure you are checking for mysqli_connect_error() as well.

Warning message in Mysqli: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given?

1 Answers1