Sign in with
New Customer?
Detailed seller ratings(Out of 5)
Item as Described:
Communication:
Shipping Speed:
Detailed Seller Ratings information is unavailable when there're less than 10 ratings.
Store opened
-- Main items:Championship Ring,Mermaid Blanket
1 of 21 Page
US $9.49 / piece
US $9.99 / piece
US $6.49 / piece
US $9.99 / piece
Orders(62)
US $22.04 / piece
US $23.70 / piece
US $22.04 / piece
US $23.70 / piece
US $27.99 / piece
US $39.99 / piece
US $27.99 / piece
US $39.99 / piece
US $27.99 / piece
US $39.99 / piece
Orders(16)
US $22.04 / piece
US $23.70 / piece
US $27.99 / piece
US $39.99 / piece
US $35.91 / piece
US $60.87 / piece
US $27.99 / piece
US $39.99 / piece
US $22.04 / piece
US $23.70 / piece
US $22.04 / piece
US $23.70 / piece
US $27.99 / piece
US $39.99 / piece
US $27.99 / piece
US $39.99 / piece
US $28.02 / piece
US $29.49 / piece
US $33.25 / piece
US $35.00 / piece
Min. Order : 3 pieces
US $22.04 / piece
US $23.70 / piece
Orders(13)
US $22.04 / piece
US $23.70 / piece
US $27.99 / piece
US $39.99 / piece
US $22.04 / piece
US $23.70 / piece
US $27.99 / piece
US $39.99 / piece
US $27.99 / piece
US $39.99 / piece
US $37.99 / piece
US $39.99 / piece
US $61.98 / set
US $65.24 / set
US $35.91 / piece
US $60.87 / piece
US $37.99 / piece
US $39.99 / piece
US $22.04 / piece
US $23.70 / piece
US $22.04 / piece
US $23.70 / piece
US $22.04 / piece
US $23.70 / piece
US $27.99 / piece
US $39.99 / piece
US $22.04 / piece
US $23.70 / piece
US $28.02 / piece
US $29.49 / piece
US $27.99 / piece
US $39.99 / piece
US $178.01 / set
US $301.72 / set
US $22.04 / piece
US $23.70 / piece
Go to Page
Service Center
Store Categories
AliExpress Multi-Language Sites
, , , , , , , , , , , , , ,
Browse by Category
, , , , , , ,
Alibaba Group
, , , , , , , , , , , , , ,CakePHP find conditions (plus find all, find list, and find count)
By Alvin Alexander. Last updated: June 3 2016
CakePHP find FAQ: Can you share some "CakePHP find conditions" examples?
One thing you need to get used to when working with CakePHP is the CakePHP find method. To that end, I thought I'd put together this page of CakePHP find conditions and find query examples.
CakePHP find conditions
To get started, here's a list of the possible CakePHP find conditions you can use:
Description
can be 'all', 'first', or 'list'. determines what type of
find operation to perform. (TODO - more info here)
conditions
array containing the find (select) conditions as
key/value pairs
array specifying which fields should be retrieved
in the resulting select query
sql 'order by conditions. field name must be
followed by ASC or DESC
page number, used for paged data
a limit on the number of results returned, like
'select * from orders limit 20'.
sql offset value (i haven't used this query much
myself, but i think it refers to skipping X
number of rows returned in a query)
the cakephp recursive value, relating to associated
model data
CakePHP find condition examples
Given that reference information, let's take a look at some CakePHP find conditions examples.
First, a very simple CakePHP find query that retrieves all records from the Post model (probably not something you'll want to do in a production application):
$this-&Post-&find('all');
Next, a "CakePHP find all" query with one find condition:
$this-&Post-&find('all',
array('conditions'=&array('User.id'=&5)));
A CakePHP find query with one "not equal to" find condition:
$this-&Post-&find('all',
array('conditions'=&array('User.id'=&'&& 5')));
A find query with multiple CakePHP find conditions:
# this is a little lame, but i'm trying to avoid dates
$this-&Post-&find('all',
array('conditions'=&array('User.id'=&1,
'Post.id'=&'& 50')));
A CakePHP find query that uses all the find function parameters:
# TODO - i'm not sur i think 'fields' is supposed to be an array
$this-&Post-&find('all',
array('conditions'=&array('User.id'=&5),
'fields'=&'Post.name',
'order'=&'Post.id ASC',
'limit'=&20,
'recursive'=&0));
A CakePHP find conditions query using a date:
# note: you can search for date or datetime fields by enclosing the table's field name
in the SQL DATE() function.
$this-&Post-&find('all',
array('conditions'=&array('User.id'=&5,
'DATE(Post.date)'=&'CURDATE()')));
# TODO demonstrate "date &" and "date &" conditions
CakePHP find conditions arrays with ORDER BY examples:
array('order'=&'date ASC')
array('order'=&'date DESC')
array('order'=&'User.id DESC')
A collection of other CakePHP find conditions/examples:
These CakePHP find examples are lines of code that would be used in an OrderController class:
$this-&Order-&find('all');
$this-&Order-&find(null, null, 'date DESC');
$this-&Order-&find('all', array('conditions'=&array('User.id'=&1)));
$this-&Order-&find('all', array('conditions'=&array('User.id'=&array(1,2,3,4))));
$this-&Order-&find('all', array('conditions'=&array('User.id'=&'&& 1')));
$this-&Order-&find('all', array('conditions'=&array('User.id'=&1, 'DATE(Post.date)'=&'CURDATE()')));
$this-&Order-&find('all', array('order'=&'date ASC', 'limit'=&20, 'recursive'=&0);
Here are some CakePHP find examples from the :
$params can contain all these:
'conditions' =& array('Model.field' =& $thisValue), //array of conditions
'recursive' =& 1, //int
'fields' =& array('Model.field1', 'DISTINCT Model.field2'), //array of field names
'order' =& array('Model.created', 'Model.field3 DESC'), //string or array defining order
'group' =& array('Model.field'), //fields to GROUP BY
'limit' =& n, //int
'page' =& n, //int
'offset'=&n, //int
'callbacks' =& true //other possible values are false, 'before', 'after'
Here's a CakePHP function showing several different CakePHP find examples:
# find('first', $params) syntax
function some_function() {
$this-&Article-&order = // resetting if it's set
$semiRandomArticle = $this-&Article-&find();
$this-&Article-&order = 'Article.created DESC'; // simulating the model having a default order
$lastCreated = $this-&Article-&find();
$alsoLastCreated = $this-&Article-&find('first', array('order' =& array('Article.created DESC')));
$specificallyThisOne = $this-&Article-&find('first', array('conditions' =& array('Article.id' =& 1)));
CakePHP find count examples
Here's a CakePHP find count example:
# find('count', $params)
# more cakephp find count examples
function some_function() {
$total = $this-&Article-&find('count');
$pending = $this-&Article-&find('count',
array('conditions' =& array('Article.status' =& 'pending')));
$authors = $this-&Article-&User-&find('count');
$publishedAuthors = $this-&Article-&find('count',
array('fields' =& 'DISTINCT Article.user_id',
'conditions' =& array('Article.status !=' =& 'pending')
CakePHP find all examples
Here is a list of some CakePHP find all examples:
# find('all', $params) syntax
# a cakephp find all example
function some_function() {
$allArticles = $this-&Article-&find('all');
$pending = $this-&Article-&find('all',
array('conditions' =& array('Article.status' =& 'pending')));
$allAuthors = $this-&Article-&User-&find('all');
$allPublishedAuthors =
$this-&Article-&User-&find('all',
array('conditions' =& array('Article.status !=' =& 'pending')));
CakePHP find list examples
Here are some CakePHP find list examples, useful for creating select boxes:
# find('list', $params) syntax
function some_function() {
$allArticles = $this-&Article-&find('list');
$pending = $this-&Article-&find('list', array(
'conditions' =& array('Article.status' =& 'pending')
$allAuthors = $this-&Article-&User-&find('list');
$allPublishedAuthors = $this-&Article-&find('list', array(
'fields' =& array('User.id', 'User.name'),
'conditions' =& array('Article.status !=' =& 'pending'),
'recursive' =& 0
for many more CakePHP find examples, including:
find threaded
find neighbors
More complex CakePHP find examples
CakePHP find conditions, find all, and find list
I hope this collection of CakePHP find conditions, including CakePHP find all and find list examples, has been helpful. If you have any example you'd like to share, feel free to use the Comments section below.
books i’ve writtenSign in with
New Customer?
Detailed seller ratings(Out of 5)
Item as Described:
Communication:
Shipping Speed:
Detailed Seller Ratings information is unavailable when there're less than 10 ratings.
Store opened
1 of 15 Page
US $0.64 / piece
Min. Order : 20 pieces
Orders(53)
US $1.40 / piece
Min. Order : 10 pieces
Orders(15)
US $1.20 / piece
Min. Order : 20 pieces
US $0.90 / piece
Min. Order : 100 pieces
US $0.33 / piece
Min. Order : 2000 pieces
US $1.60 / piece
Min. Order : 100 pieces
US $0.72 / piece
Min. Order : 50 pieces
US $0.53 / piece
Min. Order : 50 pieces
US $0.41 / piece
Min. Order : 1000 pieces
US $0.45 / piece
Min. Order : 400 pieces
US $0.47 / piece
Min. Order : 1000 pieces
US $0.45 / piece
Min. Order : 200 pieces
US $2.07 / piece
Min. Order : 300 pieces
US $1.19 / piece
Min. Order : 500 pieces
US $0.46 / piece
Min. Order : 1000 pieces
US $0.81 / piece
Min. Order : 100 pieces
US $0.33 / piece
Min. Order : 1000 pieces
US $0.35 / piece
Min. Order : 1000 pieces
US $0.38 / piece
Min. Order : 1000 pieces
US $0.53 / piece
Min. Order : 500 pieces
US $0.44 / piece
Min. Order : 200 pieces
US $0.33 / piece
Min. Order : 2000 pieces
US $1.50 / piece
Min. Order : 10 pieces
US $0.70 / piece
Min. Order : 20 pieces
US $0.54 / piece
US $0.57 / piece
Min. Order : 500 pieces
US $0.92 / piece
Min. Order : 100 pieces
US $0.80 / piece
Min. Order : 100 pieces
US $0.63 / piece
Min. Order : 2000 pieces
US $1.52 / piece
US $1.60 / piece
Min. Order : 50 pieces
US $1.25 / piece
Min. Order : 200 pieces
US $1.71 / piece
US $1.80 / piece
Min. Order : 100 pieces
US $1.90 / piece
US $2.00 / piece
Min. Order : 10 pieces
US $3.04 / piece
US $3.20 / piece
Min. Order : 5 pieces
US $1.33 / piece
US $1.40 / piece
Min. Order : 200 pieces
US $1.23 / piece
US $1.29 / piece
Min. Order : 500 pieces
US $0.90 / piece
US $0.95 / piece
Min. Order : 100 pieces
Go to Page
Store Categories
Service Center
Top Selling
US $0.64 / piece
Orders(53)
US $1.40 / piece
Orders(15)
US $1.30 / piece
US $1.50 / piece
US $2.55 / piece
US $0.33 / piece
US $0.70 / piece
US $0.80 / piece
US $0.92 / piece
US $1.00 / piece
US $3.36 / piece
US $1.19 / piece
US $1.33 / piece
US $1.71 / piece
US $1.90 / piece
AliExpress Multi-Language Sites
, , , , , , , , , , , , , ,
Browse by Category
, , , , , , ,
Alibaba Group
, , , , , , , , , , , , , ,Sign in with
New Customer?
Detailed seller ratings(Out of 5)
Item as Described:
Communication:
Shipping Speed:
Detailed Seller Ratings information is unavailable when there're less than 10 ratings.
Store opened
Seller Discount
On all products
Get $2.00 off on orders over US99.00
(Incl. shipping costs)
If you want to purchase more than one product, please add everything to your Cart first. When you proceed to the checkout page, the Seller Discount will be automatically calculated.
1 of 4 Page
US $13.26 / piece
US $26.00 / piece
Orders(94)
US $9.28 / piece
US $18.20 / piece
Orders(52)
US $0.07 / piece
US $0.13 / piece
Min. Order : 100 pieces
Orders(24)
US $8.82 / piece
US $14.46 / piece
Orders(186)
US $9.08 / piece
US $17.80 / piece
Orders(390)
US $0.34 / piece
US $0.66 / piece
Min. Order : 24 pieces
Orders(129)
US $8.98 / piece
US $17.60 / piece
Orders(28)
US $6.97 / piece
US $13.66 / piece
US $1.95 / piece
US $3.00 / piece
Orders(64)
US $2.24 / piece
US $4.40 / piece
Orders(287)
US $2.19 / piece
US $4.30 / piece
Orders(531)
US $5.92 / piece
US $11.60 / piece
US $6.94 / set
US $13.60 / set
US $7.51 / piece
US $7.90 / piece
Orders(72)
US $7.75 / piece
US $15.20 / piece
US $8.06 / piece
US $15.80 / piece
Orders(12)
US $3.57 / pack
US $7.00 / pack
Orders(30)
US $1.53 / piece
US $3.00 / piece
Orders(33)
US $2.81 / piece
US $5.50 / piece
US $6.63 / piece
US $13.00 / piece
Orders(41)
US $6.73 / piece
US $13.20 / piece
US $6.37 / piece
US $9.80 / piece
Orders(42)
US $0.30 / piece
US $0.60 / piece
Min. Order : 42 pieces
US $12.69 / piece
US $20.80 / piece
Orders(174)
US $14.15 / piece
US $23.20 / piece
Orders(14)
US $4.58 / piece
US $7.50 / piece
US $4.90 / piece
US $9.60 / piece
US $6.63 / piece
US $13.00 / piece
US $16.83 / piece
US $33.00 / piece
US $7.19 / piece
US $7.90 / piece
Orders(23)
US $1.71 / set
US $3.36 / set
US $12.14 / piece
US $23.80 / piece
Orders(11)
US $7.65 / piece
US $15.00 / piece
US $3.93 / piece
US $7.70 / piece
US $6.02 / piece
US $11.80 / piece
US $8.67 / piece
US $17.00 / piece
Orders(26)
Go to Page
Store Categories
Service Center
US $2.19 / piece
Orders(531)
US $9.08 / piece
Orders(390)
US $2.24 / piece
Orders(287)
US $2.54 / piece
Orders(238)
US $8.82 / piece
Orders(186)
US $12.69 / piece
Orders(174)
US $0.34 / piece
Orders(129)
US $13.26 / piece
Orders(94)
US $7.51 / piece
Orders(72)
US $1.95 / piece
Orders(64)
US $9.28 / piece
Orders(52)
US $6.37 / piece
Orders(42)
US $6.63 / piece
Orders(41)
US $1.89 / piece
Orders(33)
US $1.53 / piece
Orders(33)
US $5.92 / piece
US $6.97 / piece
US $6.73 / piece
US $6.63 / piece
US $7.75 / piece
US $7.65 / piece
US $4.90 / piece
US $6.94 / Set
US $2.81 / piece
US $8.67 / Set
US $1.71 / Set
US $1.43 / piece
US $0.75 / piece
US $1.73 / piece
US $8.06 / piece
US $3.57 / piece
US $3.93 / piece
US $1.58 / piece
US $1.58 / piece
Orders(26)
US $0.31 / piece
AliExpress Multi-Language Sites
, , , , , , , , , , , , , ,
Browse by Category
, , , , , , ,
Alibaba Group
, , , , , , , , , , , , , ,