SQLSTATE[HY093] how to fix error?

Question

PHP

UPDATE. PHP build sql query:

$query = $conn->update('myapp_state')->set('prodid', '?')->where('objid = ?')->setParameter(0, $el['prod_id'])->setParameter(1, $el['object_id']);

Mistake:

SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens,

What am I doing wrong?

Answer 1

set expression requires a pre-created parameter, can't use setParameter

$prodid= $el['prod_id'];
$prodidParam = $conn->createNamedParameter($prodid);
$objid = $el['object_id']
objidParam = $conn->createNamedParameter($objid );

$query= $conn->update('myapp_filestate')->set('prodid', $prodidParam)->where('objid = ' . $objid . '');

Answer 2

$query = $conn->update('myapp_state')->
set('prodid', '?1')->
where('objid = ?2')->
setParameter(1, $el['prod_id'])->
setParameter(2, $el['object_id']);