INSERT INTO mysqli prepared statement error

Asked Jun 30 '16 at 03:11

Active Jun 30 '16 at 04:15

Viewed 40 times

So I have this query that gives me an error about the mysqli_bind_param() expects parameter 1 to be mysqli_stmt, boolean given

here is the query

$query = "INSERT INTO `users` (`user_name`, `password`, `first_name`, `last_name`) VALUES (?, ?, ?, ?)";
$stmt = mysqli_prepare($conn, $query);
mysqli_stmt_bind_param($stmt, 'ssss', $user_name, $pass, $first_name, $last_name);
mysqli_stmt_execute($stmt);

this is the code for my connection:

<?php

$mysql_error = 'Could not connect';
$mysql_host = 'localhost';
$mysql_user = 'root';
$mysql_pass = '';
$mysql_db = 'users';

$conn = @mysqli_connect($mysql_host, $mysql_user,$mysql_pass,$mysql_db) or die($mysql_error); 


?>

EDIT:

This is the database name: users This is the table name: user this is the column names: id, user_name, password, first_name, last_name

edited Jun 30 '16 at 04:15

asked Jun 30 '16 at 03:11

Adrian Pascua VivsTV

1

An error on `mysqli_bind_param()` while I don't see the function in your code? Secondly that specific function requires a connection, in your case `$conn` as first argument. Also, suppressing error reporting with `@` and requesting help on it is a no-go. Infact, anything related in PHP that has `@` in it is asking for trouble. – Xorifelse Jun 30 '16 at 03:15
1

have you tried to make checking the connection (success or not)? – Peternak Kode Channel Jun 30 '16 at 03:21
yes it is working in my other query. only in my `INSERT` query is not working – Adrian Pascua VivsTV Jun 30 '16 at 03:21
`$stmt` is `false` indicating an error on prepare. ("expects parameter 1 to be mysqli_stmt, boolean given"). What is `mysqli_error(mysqli $conn)` after prepare? – Pinke Helga Jun 30 '16 at 03:41
what do you mean error after prepare? – Adrian Pascua VivsTV Jun 30 '16 at 03:46
`mysqli_error($conn)` after preparing the statement. You have any idea what you are doing? – Pinke Helga Jun 30 '16 at 03:47
it gives me this error `Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given in C:\xampp\htdocs\practice1\super_admin\create_success.php on line 10` – Adrian Pascua VivsTV Jun 30 '16 at 03:49
Not after bind - after prepare – Pinke Helga Jun 30 '16 at 03:50
but i use that to all of my query such as `UPDATE` `SELECT` it gives me error only in `INSERT INTO` statement only – Adrian Pascua VivsTV Jun 30 '16 at 03:51
Read the error immediately after prepare. – Pinke Helga Jun 30 '16 at 03:52
im really sorry im confused right now – Adrian Pascua VivsTV Jun 30 '16 at 03:57
is it possible that the error is in my query? – Adrian Pascua VivsTV Jun 30 '16 at 04:08
Yes, e.g. table / column names. – Pinke Helga Jun 30 '16 at 04:12
i edited my post. i include all the information of my database – Adrian Pascua VivsTV Jun 30 '16 at 04:16
"This is the table name: **user**" / INSERT INTO **users** - Try ``INSERT INTO `users`.`user` `` – Pinke Helga Jun 30 '16 at 04:42

INSERT INTO mysqli prepared statement error

0 Answers0