MySQLi UPDATE query not working properly

Asked Mar 09 '16 at 03:31

Active Mar 09 '16 at 17:42

Viewed 20 times

My SQLi UPDATE query doesn't seem to be working, I have tried almost everything and I don't know where I am going wrong. I created a similar style PHP but for registering a person (using INSERT) and that worked fine. Here is my UPDATE code:

<?php
    $con=mysqli_connect("localhost","my_user","my_password","my_db");

    $firstname= $_POST["firstname"];
    $surname = $_POST["surname"];
    $info= $_POST["info"];

    $statement = mysqli_prepare("UPDATE `People` SET `firstname`=? , `surname`=? , `info`=? WHERE `personid`=79 ");
    mysqli_stmt_bind_param($statement, "sss", $firstname, $surname, $info);
    mysqli_stmt_execute($statement);
    mysqli_stmt_close($statement);
    mysqli_close($con);
?>

edited Mar 09 '16 at 17:42

asked Mar 09 '16 at 03:31

Nik

In yr query there are four params to bind, but you bind only three parameters (missing id). – fusion3k Mar 09 '16 at 03:33
[Enabling PHP errors](http://stackoverflow.com/q/1053424/660921) might help. – Martin Tournoij Mar 09 '16 at 03:38
Missing ID for `WHERE `personid`=?` – devpro Mar 09 '16 at 03:58

MySQLi UPDATE query not working properly

0 Answers0