MYSQLI UPDATE prepared statement not updating my table

Asked Jun 19 '16 at 21:46

Active Jun 19 '16 at 23:19

Viewed 45 times

I have a problem with my PHP updating script. I'm using prepared statements with mysqli, but the code isn't working although I see no error.

$c=mysqli_connect('localhost','client','','bdd');
if (!$c) {    
    echo 'Erreur de connexion a la base de donnees';
} else {    
   if (isset($_POST['submit'])) {
     $faite=1;        
     for($i=0;$i<sizeof($idg);$i++){
        $var=$idg[$i]; 
        $update="UPDATE  graissage SET   faite= ? where  id=?";
        echo $update;
        $stmt2= mysqli_prepare($c, $update);
        echo mysqli_error($c);
        mysqli_stmt_bind_param($stmt2, "is", $faite,$var);
        echo mysqli_error($c);
        mysqli_stmt_execute($stmt2);
        echo mysqli_error($c);
    }
}}

edited Jun 19 '16 at 23:19

halfer

19,824
17
99
186

asked Jun 19 '16 at 21:46

HvíturFirvaldur Pétale Perdue

Are you bind params the wrong way around? I.e. string _then_ int? – Jonnix Jun 19 '16 at 21:47
the type of variables is same as in the database @Jon – HvíturFirvaldur Pétale Perdue Jun 19 '16 at 21:56
You're trying to tell me that `faite` is an `int` and `id` is a string? – Jonnix Jun 19 '16 at 21:56
yes exactly ! @Jon – HvíturFirvaldur Pétale Perdue Jun 19 '16 at 22:01
I don't believe that I'm afraid. – Jonnix Jun 19 '16 at 22:01
even if i change id to integer in the table and bind it as integer is still not working – HvíturFirvaldur Pétale Perdue Jun 19 '16 at 22:02
I don't get it why @Jon – HvíturFirvaldur Pétale Perdue Jun 19 '16 at 22:04
@HvíturFirvaldurPétalePerdue can you provide us with a `var_dump()` of your `$idg` array please. – Matt Jun 19 '16 at 22:06
`array (size=1) 0 => string '1' (length=1)` ! @Jon @Matt – HvíturFirvaldur Pétale Perdue Jun 19 '16 at 22:12
@HvíturFirvaldurPétalePerdue Follow my answer here to add some error handling. Currently you are only attempting to show an error for the connection not the preparing etc. http://stackoverflow.com/a/37135658/3140646 (also make sure error reporting is set => `error_reporting(E_ALL & ~E_NOTICE)` is a good one to set it too) – Matt Jun 19 '16 at 22:17
i don't see that this is helping :/ @Matt – HvíturFirvaldur Pétale Perdue Jun 19 '16 at 22:38

MYSQLI UPDATE prepared statement not updating my table

0 Answers0