CODEWITHSUNDEEP
phpmysqlsqlpdoprepared-statement
Maen
Maen

Reputation: 10698

PDO bindParam() with multiple named parameters

Can't PDO bind a value to multiple occurrences of a param in a query with a single bindParam()?

I'm surprised, I thought it was possible, but I didn't find any info on php's docs on this, neither on the web. Any clarification / alternative is welcome!

Note : I'm using php 5.3.6 / 5.3.8 (dev/prod)

Example :

Consider this prepared statement :

INSERT INTO table VALUES (:param1, 0), (:param1, 1);

Now, if I bind values to my query:

bindParam(":param1",$my_param1);

I have a PDO error :

SQLSTATE[HY093]: Invalid parameter number

Upvotes: 6

Views: 4106

Answers (1)

Manu
Manu

Reputation: 931

See PDO::prepare

You cannot use a named parameter marker of the same name twice in a prepared statement

Upvotes: 6

Related Questions