7. Search and Pagination | CakePHP 2 Application Cookbook

Advanced search

Searching through your data isn't always as simple as filtering a value on a single model; sometimes, you need to take into account the relationship of a model with other models.

In this recipe, we're going to search and filter using a model association. We'll configure the CakeDC Search plugin from our previous recipe to create a recipients filter by gift name. This allows us to display our gift recipients, filtering by the recipient name, address, and the gift title.

Getting ready

In this recipe, we'll continue using the CakeDC Search plugin, for which you can find some installation instructions in our previous recipe. Then, we'll create both gifts and recipients tables in our database, using the following SQL statements:

CREATE TABLE gifts (
  id INT NOT NULL AUTO_INCREMENT,
  title VARCHAR(255) NOT NULL,
  created DATETIME NOT NULL,
  modified DATETIME NOT NULL,
  PRIMARY KEY(id)
);

CREATE TABLE recipients (
  id INT NOT NULL AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL...

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

Advanced search

Getting ready

CakePHP 2 Application Cookbook - Third Edition

By : Watts

CakePHP 2 Application Cookbook

By: Watts

Overview of this book

Advanced search

Getting ready

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