Phalcon query skills

Source: Internet
Author: User
: This article mainly introduces phalcon query skills. if you are interested in the PHP Tutorial, refer to it. Several tips on using phalcon for query

1. use find, and in to query, as shown below:

$ OrderIdList = array_unique (array_map ('intval', $ orderIdList); if ($ orderIdList) {$ orderList = ChildOrder :: find (['conditions' => 'Parents _ id IN ({orderIdList: array}) ', 'bind' => ['orderidlist' => $ orderIdList]);}
Here, $ orderIdList is an array. this query method is used to query the effect similar to this one.
Select * from 'childorder' where parents_id in ($ orderIdList );

2. use model to update data in batches

The above Object $ orderList has been queried. Next, you need to modify the values of a column in the object in batches. you can do this.

Foreach ($ orderList as $ row) {$ row-> state = 0; if ($ row-> save () = false) {foreach ($ orderList-> getMessages () as $ message) {throw new \Exception('Update failed ');}}}
The effect is similar
Update 'childorder' set state = 0 where parents_id in ($ orderIdList );

The above describes the phalcon query technique, including the Exception content, and hopes to help those who are interested in the PHP Tutorial.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.