sql update query didn't execute but return no errror

Question

$id = 1; //temp

$promoTitle = trim($_POST['promoTitle']);
$imageURL = trim($_POST['imageURL']);
$affLink = trim($_POST['affLink']);
$couponCode = trim($_POST['couponCode']);

$stmt = $db->prepare('UPDATE dashboard SET promoTitle=?, image=?, url=?, couponCode=? WHERE id=?');

$q = $stmt->bind_param('ssssi', $promoTitle, $imageURL, $affLink, $couponCode, $id);

if($result = $db->query($q)){
    echo "updated";
}else{
    echo mysql_errno();
}

stuck for half an hour and still couldn't find out what's wrong. I has return no error. My table look like this https://i.stack.imgur.com/7I1xh.png

The third step of prepare, bind, execute is `$stmt->execute()`, not `$db->query()`. — VMai, Sep 19 '14 at 10:08
This should explode as `query()` wants a query string, not a prepared statement. If you're not getting errors, you may need to adjust your PHP configuration so you can find/see them. — tadman, Jan 25 '20 at 23:39
also put your code inside try catch to get actual exception. — udit rawat, Jan 31 '20 at 14:06

score -1 · Answer 1 · edited Jan 25 '20 at 22:45

you can use this for updation in mysql from php

if(isset($_POST['submit'])){
    try{
        $id = 1; //temp

        $promoTitle = trim($_POST['promoTitle']);
        $imageURL = trim($_POST['imageURL']);
        $affLink = trim($_POST['affLink']);
        $couponCode = trim($_POST['couponCode']);

        $stmt = $db->prepare('UPDATE  dashboard  SET promoTitle = :promoTitle, image = :image, url  = :url, couponCode=:couponCode WHERE id =:id');
        $stmt->execute(array(
          ':promoTitle' => $promoTitle,
          ':image' => $image,
          ':url' => $url,
          ':couponCode' => $couponCode,             
          ':id' =>$id                        
        ));

    //redirect to Your page page
   header('Location: page.php?action=updated');
   exit;
  }

  catch(PDOException $e) {
      echo $e->getMessage();
  }

}

That's PDO, but OP is using mysqli. – VMai Sep 19 '14 at 10:22 — VMai, Sep 19 '14 at 10:22

sql update query didn't execute but return no errror

1 Answers1