Bind values in raw SQL query, symfony

Asked Nov 12 '17 at 21:23

Active Nov 12 '17 at 21:23

Viewed 1,004 times

I have problem with my query. It's working fine in this form:

$sql = "SET @i:=0; UPDATE movie m SET m.priority=@i:=@i+1 WHERE m.id IN (". $idsString . ") ORDER BY FIELD(m.id,". $idsString . ")";
$this->getEntityManager()->getConnection()->prepare($sql)->execute();

But imo it's not looking fine. When I'm trying to use bindParam() (ofc i'm changing parameters to :ids) I don't get error but priorities are not updated. Set parameters in execute don't work because it throw error about array to strig conversion. I'm doing something wrong or it's other way to do this?

asked Nov 12 '17 at 21:23

jager91

1

Looks like you are executing native SQL via the raw connection (PDO). As far as I know binding values with PDO for IN statements is not supported. But you could build the statement with the binding parameters yourself. – odan Nov 12 '17 at 22:25
1

Here is an example: https://stackoverflow.com/a/10808904/1461181 – odan Nov 12 '17 at 22:45
@DanielO. thanks m8, I'll try it :) – jager91 Nov 13 '17 at 07:43
@DanielO. it's working so rly thanks :) – jager91 Nov 15 '17 at 12:38
You're welcome :-) – odan Nov 15 '17 at 12:49

Bind values in raw SQL query, symfony

0 Answers0