Zend db update value not being set

Question

I'm not sure what's missing with this update call, here's my code:

$table = new Application_Model_DbTable_ProductContaminant();
$db = $table->getAdapter();

$db->getProfiler()->setEnabled(true);
$data = array('value' => '999');
$where[] = $db->quoteInto('product_id = ?', $q['product_id']);
$where[] = $db->quoteInto('contaminant_id = ?', $k);
$table->update($data, $where);

print $db->getProfiler()->getLastQueryProfile()->getQuery();

And the profiler output is:

UPDATE `product_contaminants` SET `value` = ? WHERE (product_id = '4802') AND (contaminant_id = 69)

Why isn't 'value' being populated??

Tim Gautier · Accepted Answer · 2012-07-10 18:52:59Z

2

Value isn't populated because getQuery will only return a prepared statement with parameter placeholders. If you want the parameters used when it updates try this:

$db->getProfiler()->getLastQueryProfile()->getQueryParams()

More info here.

answered Jul 10, 2012 at 18:52

Tim Gautier

30.3k5 gold badges50 silver badges53 bronze badges

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

2 Comments

rladd Over a year ago

OK, that seems to be correct: [1] => 999. Why isn't it getting into the statement?

rladd Over a year ago

Of course, you cant update an empty row, can you?? Thanks for your help Tim!!

Collectives™ on Stack Overflow

Zend db update value not being set

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related