7. Search and Pagination | CakePHP 2 Application Cookbook

Basic search and filter

Displaying paginated records can be great to allow your users to easily navigate through large sets of data. However, it is even better when you can give them the option to search directly.

In this recipe, we're going to add a new search box for our packages. We'll use a LIKE condition in SQL to filter the resulting packages. This will do the trick for small datasets as a starting point.

Getting ready

For our recipe, we'll assume that you still have the packages table, Package model, and PackagesController, with the paginated index() action with the index.ctp view created from our previous recipe.

How to do it...

Perform the following steps:

First, add the following search box to index.ctp in app/View/Packages/ right below the <h2> element:

<?php
  echo $this->Form->create('Package', array('action' => 'search'));
  if (!isset($searchQuery)) {
    $searchQuery = '';
  }
  echo $this->Form->input('searchQuery', array('value' => h($searchQuery)))...

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

CakePHP 2 Application Cookbook - Third Edition

By : Watts

CakePHP 2 Application Cookbook

By: Watts

Overview of this book

Basic search and filter

Getting ready

How to do it...

CakePHP 2 Application Cookbook - Third Edition

By : Watts

CakePHP 2 Application Cookbook

By: Watts

Overview of this book

Basic search and filter

Getting ready

How to do it...

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access