PHP mysql error when updating database

Question

I'm getting the following error

Warning: PDOStatement::execute(): SQLSTATE[HY093]: 
Invalid parameter number: number of bound variables does not match number of tokens

When I'm trying to update MySQL database.

Here is the code my using.

public function update() {
    global $db;
    $stmt = $db->prepare("UPDATE products SET Name='?', Cate_id='?', Price='?', Image='?', Special='?', Special_price='?', Disable='?' WHERE PID = ?;");
    $stmt->execute(array($this->name, $this->category, $this->price, $this->image, $this->special, $this->special_price, $this->disable, $this->id));
}

did you try removing ; from "UPDATE products SET Name='?', Cate_id='?', Price='?', Image='?', Special='?', Special_price='?', Disable='?' WHERE PID = ?;" and running again? i have seen issues caused by ; while binding the parameters — anurupr
– anurupr, Commented Mar 13, 2014 at 10:39

Abhik Chakraborty · Accepted Answer · 2014-03-13 10:39:44Z

3

SET Name='?', Cate_id='?', Price='?', Image='?'  etc

does not need quotes in the ?

should be

SET Name=?, Cate_id=?, Price=?, Image=? etc...

answered Mar 13, 2014 at 10:39

Abhik Chakraborty

44.9k6 gold badges56 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dan Nite Over a year ago

@meda yeah sorry about that. I was going to do it but it said I have to wait 10 minutes.

dipendra · Accepted Answer · 2014-03-13 10:48:39Z

0

Please follow the following:

$stmt = $db->prepare("UPDATE products SET Name='?', Cate_id=?, Price=?, Image=?, Special=?, Special_price=?, Disable=? WHERE PID = ?;");

$stmt->bind_param($this->name, $this->category, $this->price, $this->image, $this->special, $this->special_price, $this->disable, $this->id);

$stmt->execute();

answered Mar 13, 2014 at 10:48

dipendra

2611 gold badge3 silver badges9 bronze badges

Collectives™ on Stack Overflow

PHP mysql error when updating database

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related