PHP code example of chinpei215 / cakephp-stackable-finder

1. Go to this page and download the library: Download chinpei215/cakephp-stackable-finder library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php. 
    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

chinpei215 / cakephp-stackable-finder example snippets


$articles = $this->Article->q()
	->find('all', ['conditions' => ['Article.created >=' => '2015-01-01']])
	->findAllByUserId(1) // Magic finder
	->find('published') // Custom finder
	->find('list')
	->exec();


$this->Article->q()->read(); // Error 


$articles = $this->Article->q()
	->select(['Article.id', 'Article.title'])
	->contain('Author')
	->where(['Article.user_id' => 1])
	->order(['Article.id' => 'DESC'])
	->limit(10)
	->offset(0)
	->exec();


$q = $this->User->q()->select('id');

$articles = $this->Article->q()
	->where([
		'user_id IN ?' => [$q]
	])
	->exec();


$q = $this->Article->q()->find('list');
foreach ($q as $id => $title) {
	// ...
}


$articles = $this->Article->q()
	->find('published')
	->first();


$articles = $this->Article->q()
	->find('published')
	->find('first')
	->exec();


$articles = $this->Article->q()
	->find('list')
	->first();