li3: simple search feature

CompaniesController.php

<?php
namespace app\controllers;

use lithium\data\Entity;
use app\models\Companies;

class CompaniesController extends \lithium\action\Controller {

    public function search() {
        
        // Entity stores data from any POST requests
        $search = new Entity(array('data' => $this->request->data));
        
        // Use the model schema to create a list of searchable fields
        $fields = array();
        foreach (Companies::schema() as $fieldKey => $fieldSchema) {
            $fields[$fieldKey] = \lithium\util\Inflector::humanize($fieldKey);
        }

        // Create query conditions from the search data
        $conditions = array();
        if ($search->field && $search->query) {
            $conditions += array($search->field => array('LIKE' => "%{$search->query}%"));
        }
        
        // Find any records
        $companies = Companies::find('all', compact('conditions'));
        
        return compact('search', 'fields', 'companies');
    }
}
?>

search.html.php

<fieldset>
    <legend>Search</legend>
    <?= $this->form->create($search); ?>
        <?= $this->form->field('field', array('type' => 'select', 'list' => $fields)); ?>
        <?= $this->form->field('query'); ?>
        <?= $this->form->submit('Search'); ?>
    <?= $this->form->end(); ?>
</fieldset>