PHP issue with bind_param();

Question

Good day, I'm not really familiar with PHP and i get this error when i try to execute my query.

Warning:

Warning: mysqli_stmt::bind_param(): Number of variables doesn't match number of parameters in prepared statement in /Users/site/userpanel.php on line 10

Code:

$query="SELECT SUM(gebruiker_id) AS totalitems FROM inventory WHERE gebruiker_id = 1";
$stmt = $db->prepare($query);
$stmt->bind_param("s", $items);
$stmt->execute();
$result = $stmt->bind_result($col1);

Thanks in advance!

Mixing languages in code and/or database is considered a design flaw. — Sherlock
– Sherlock, Commented Jan 11, 2015 at 17:13

Rizier123 · Accepted Answer · 2015-01-11 17:01:15Z

3

You have to use a placeholder like this:

$query="SELECT SUM(gebruiker_id) AS totalitems FROM inventory WHERE gebruiker_id = ?";
$stmt = $db->prepare($query);
$stmt->bind_param("s", $items);
$stmt->execute();
$result = $stmt->bind_result($col1);

answered Jan 11, 2015 at 17:01

Rizier123

59.8k17 gold badges106 silver badges167 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

J.Koppen Over a year ago

Thanks for your help! if i use ? as placeholder result will be 1 while it has to be 8 because gebruiker_id is in there 8 times

J.Koppen Over a year ago

You to man! only it didn't fix my issue. it should return 8 as there are 8 rows in my table with gebruiker_id 1.

Rizier123 Over a year ago

@J.Koppen And you are sure that $items is 1 and you also did print_r($result);? And i think you want to use count()

J.Koppen Over a year ago

when i print $items it gives me nothing and when i print $result it gives me 1

Rizier123 Over a year ago

@J.Koppen Did you even defined $items anywhere?!

|

meda · Accepted Answer · 2015-01-11 17:05:57Z

1

Sometimes you don't need to bind:

$query="SELECT SUM(gebruiker_id) AS totalitems FROM inventory WHERE gebruiker_id = 1";
$stmt = $db->prepare($query);
//$stmt->bind_param("s", $items);
$stmt->execute();
$result = $stmt->bind_result($col1);

or

$query="SELECT SUM(gebruiker_id) AS totalitems FROM inventory WHERE gebruiker_id = 1";
$stmt = $db->query($query);
$result = $stmt->bind_result($col1);

But if you were trying to bind $items to gebruiker_id then follow @rizier123 answer.

answered Jan 11, 2015 at 17:05

meda

45.5k14 gold badges97 silver badges123 bronze badges

2 Comments

J.Koppen Over a year ago

Let me explain this. I have to sum up how many times "gebruiker_id" 1 is in the table "items" (which is 8) and then result has to be 8.

meda Over a year ago

@J.Koppen use COUNT()

Collectives™ on Stack Overflow

PHP issue with bind_param();

2 Answers 2

7 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related