PHP Syntax error (bind_param)

Question

Helo! I'm trying to execute a mysql query but I've ran into the problem above.

This is my code:

$query = ("UPDATE cegek SET CegNev='".$cegnev."', Kozpont='".$kozpont."', Bevetel='".$bevetel."', Alkalmazottak='".$alkalmazott."', Iparag='".$iparag."' WHERE id=".$id."'");
$conn = $db->prepare($query);
$conn->bind_param("ssiisi", $cegnev, $kozpont, $bevetel, $alkalmazott, $iparag, $id);
$db->close();

And it's result is:

Fatal error: Call to a member function bind_param() on boolean in...

I have found some similar questions but I couldn't figure out the solution. Anyone can help me?

There's a syntax error in the query. Since you haven't shown what it is, it's impossible for us to tell you more. You need to check the result from `$db->prepare()` and echo `$db->error` when it's false. — Barmar, Nov 21 '16 at 17:52
and the API to connect with is what exactly? variables are what? — Funk Forty Niner, Nov 21 '16 at 17:54
btw, you never executed that query, so there you go; part of the bigger problem. — Funk Forty Niner, Nov 21 '16 at 17:55
$query = ("UPDATE cegek SET CegNev='".$cegnev."', Kozpont='".$kozpont."', Bevetel='".$bevetel."', Alkalmazottak='".$alkalmazott."', Iparag='".$iparag."' WHERE id=".$id."'"); This is the query. — TheyCallMeSont, Nov 21 '16 at 17:56

score 1 · Answer 1 · answered Nov 21 '16 at 17:52

1

You should use following syntax:

$stmt = $mysqli->prepare("INSERT INTO CountryLanguage VALUES (?, ?, ?, ?)");
$stmt->bind_param('sssd', $code, $language, $official, $percent);

So in your code it will be like:

$conn = $db->prepare('INSERT INTO Table VALUES (?, ?, ?, ?, ?, ?)');
$conn->bind_param("ssiisi", $cegnev, $kozpont, $bevetel, $alkalmazott, $iparag, $id);

Also it can return boolean (false) if there is error in your query (f.ex. wrong table name).

answered Nov 21 '16 at 17:52

Karol Gasienica

2,665
21
33

Still can't get it to work. My query is: $query = ("UPDATE cegek SET CegNev='".$cegnev."', Kozpont='".$kozpont."', Bevetel='".$bevetel."', Alkalmazottak='".$alkalmazott."', Iparag='".$iparag."' WHERE id=".$id."'"); – TheyCallMeSont Nov 21 '16 at 18:16
You are binding params so in place of variable in `$query` you should put `?`. – Karol Gasienica Nov 21 '16 at 18:17
Try: `"UPDATE cegek SET CegNev='?', Kozpont='?', Bevetel='?', Alkalmazottak='?', Iparag='?' WHERE id='?'"` – Karol Gasienica Nov 21 '16 at 18:18

PHP Syntax error (bind_param)

1 Answers1