Phalcon Query Tips

A brief introduction to several tips for using Phalcon queries

1. Use Find, and in to query, as follows:

$orderIdList = Array_unique (Array_map (' intval ', $orderIdList)), if ($orderIdList) {$orderList = Childorder::find ([' Conditions ' + ' parents_id in ({Orderidlist:array}) ', ' bind ' =>[' orderidlist ' = = $orderIdList]]);}

Here the $orderidlist is an array, using this query method to query out a similar effect

SELECT * from ' Childorder ' where parents_id in ($orderIdList);

2. Skillfully use model to update data in batches

The above has queried the object $orderlist, next to bulk modify the value of a column in the object, you can do this

foreach ($orderList as $row) {$row->state = 0;if ($row->save () = = False) {foreach ($orderList->getmessages () as $m Essage) {throw new \Exception(' update failed ');}}}

This effect is similar to

Update ' Childorder ' set state = 0 where parents_id in ($orderIdList);

The above describes the Phalcon query skills, including the exception aspects of the content, I hope that the PHP tutorial interested in a friend helpful.

