Call to a member function bind_param() on boolean table and columns are correct

Question

cOkay So I'm having an issue when running this code

           $techsig        = $_POST['Tech'];
           $clientsig      = $_POST['Client'];
           $satisfaction   = $_POST['optradio'];
           $summary        = $_POST['summary'];
           $asummary       = $_POST['accom_summary'];
           $rating         = $_POST['accom_rating'];
           $complete = "Completed";
           var_dump($woID);
           var_dump($asummary);
           var_dump($rating);

          $stmt = $conn->prepare("UPDATE accommodation SET rating = ?, summary = ? WHERE work_order = ?");
          $stmt->bind_param("isi", $rating, $asummary, $woID);
          $stmt->execute();

Now when I run the code as follows in my database UPDATE accommodation SET summary = 'Testing', rating = '5' WHERE work_order = '12345' it works without any issues same as if I run it on the page, Also if I do the following code like

$stmt = "UPDATE accommodation SET rating = '$rating', summary = '$asummary' WHERE work_order = '$wonum' ";
$update_accom = mysqli_query($connection,$stmt);

it also works but when I do it as $stmt = $conn->prepare("query") then bind the params it throws a boolean error.

now it might be a simple error but i cant find the issue

basically you need to ask your database, what's wrong with your query. we cannot know what it could be — Your Common Sense, Oct 23 '17 at 13:30
Since you're not doing any error checking your error logs might have the information. — Jay Blanchard, Oct 23 '17 at 13:31
You don't have commas between your SET columns/variable placeholders. `SET rating = ? summary = ?` should be `SET rating = ?, summary = ?` — GrumpyCrouton, Oct 23 '17 at 13:41
`$rating` and `$woID` are integers, so your bind_param should be `$stmt->bind_param("isi", $rating, $asummary, $woID);` — GrumpyCrouton, Oct 23 '17 at 13:43
Yeah i recently altered them Ive tried isi and also there is a comma in my code just forgot to add it here @GrumpyCrouton — Martin James, Oct 23 '17 at 13:44
@GrumpyCrouton actually, it does no harm if you bind an integer as a string. — Your Common Sense, Oct 23 '17 at 13:50

Call to a member function bind_param() on boolean table and columns are correct

0 Answers0