Zend Db update and delete method and quoting

Question

In documenation in

Since the table update() method proxies to the database adapter update() method, the second argument can be an array of SQL expressions. The expressions are combined as Boolean terms using an AND operator. Note: The values and identifiers in the SQL expression are not quoted for you. If you have values or identifiers that require quoting, you are responsible for doing this. Use the quote(), quoteInto(), and quoteIdentifier() methods of the database adapter.

But when I checked source update method and I saw something strange (chain of method executing):

• Zend_Db_Table_Abstract::update()
• Zend_Db_Adapter_Abstract::update()
• Zend_Db_Adapter_Abstract::_whereExpr()
• Zend_Db_Adapter_Abstract::quoteInto()

and in Zend_Db_Adapter_Abstract::quoteInto() there is quoting. Can anybody explain this? Maybe documentation is outdated?

Answer 1

The values are quoted, the note in the documentation refers to the WHERE clause that you pass in, which you need to quote yourself. Typical usage would be:

$table->update(array(
    'name' => $name, // this gets quoted
    'email' => $email // as does this
), $db->quoteInto('id = ?', $id));