Find is the  data-retrieval functions in cakephp.
Below is the list of CakePHP find conditions :-
	
		
			| Name | 
			Default | 
			Description | 
		
	
	
		
			|    type | 
			  'first' | 
			it can be 'all', 'first', or 'list' by default it is first. | 
		
		
			| conditions | 
			  null | 
			array containing the find (select) conditions as key/value pairs | 
		
		
			|  fields | 
			 null | 
			it specify which fields should be fetch from database. | 
		
		
			|  order | 
			  null | 
			it will sort data using sql 'order by conditions either in ASC DSC | 
		
		
			|  page | 
			 null | 
			page number, used for paged data. | 
		
		
			|  limit | 
			 null | 
			it will limit the number of records to be fetch. | 
		
		
			|  recursive | 
			  1 | 
			this is cakephp recursive value. | 
		
	
 
Below is CakePHP find condition example:-
 
 
$this->User->find('all'),array(
  '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   
 
)
$this->User->find() :- in this line User is our model name.
 
                       
                    
0 Comment(s)