PDO: Invalid parameter number

Question

I'm making an IS and I have a problem with updating mysql table. I'm using PHP 5.3 and PDO.

            $query_update = $this->db_connection->prepare('UPDATE Client SET name =: name, surname=:surname WHERE id=:id');
            $query_update->bindValue(':id', $id, PDO::PARAM_INT);
            $query_update->bindValue(':name', $name, PDO::PARAM_STR);
            $query_update->bindValue(':surname', $surname, PDO::PARAM_STR);
            $query_update->execute();

Warning: PDOStatement::execute() [pdostatement.execute]: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens in file on line X. The Warning is referencing line with execute().

Thanks for help.

EDIT: It's working now, again thanks for help.

Sirko · Accepted Answer · 2013-12-09 18:37:52Z

6

You have a space too much. Correct you query to this:

$this->db_connection->prepare('UPDATE Client SET name =:name, surname=:surname WHERE id=:id');
// -----------------------------------------------------^

This lead to only two variables being used in the query, which didn't match the 3 variables you provided.

(Your query in the current form should throw an error anyways at the same position.)

edited Dec 9, 2013 at 18:37

answered Dec 9, 2013 at 18:30

Sirko

74.3k19 gold badges157 silver badges194 bronze badges

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

Collectives™ on Stack Overflow

PDO: Invalid parameter number

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related