Found a couple of posts on the site regarding this, all of which were several years old so wanted to verify how to do this currently. I have an update query such as
update table1 set price = price*10 where xmasterid in :valuearray
If I want to prepare the statements, does pdo now handle arrays? Or do I need to insert (?,?,?) as placeholders instead of the :arrayname?
And if I insert the ? as placeholders, can I then use a numeric array with that many values in the prepare statement?
In this case it is also pretty easy and relatively safe for me just to modify the sql statement and insert the (1,2,3) clause directly in there. But would rather stay with prepared statements whenever possible.
Thanks for the input. That works great. I had gotten used to using named parameters which I really like but in this case I think this appears to be the way to go.