CakePHP 1.3 Application Development Cookbook

CakePHP 1.3 Application Development Cookbook

Overview of this book

CakePHP is a rapid development framework for PHP that provides an extensible architecture for developing, maintaining, and deploying web applications. While the framework has a lot of documentation and reference guides available for beginners, developing more sophisticated and scalable applications require a deeper knowledge of CakePHP features, a challenge that proves difficult even for well established developers.The recipes in this cookbook will give you instant results and help you to develop web applications, leveraging the CakePHP features that allow you to build robust and complex applications. Following the recipes in this book you will be able to understand and use these features in no time. We start with setting up authentication on a CakePHP application. One of the most important aspects of a CakePHP application: the relationship between models, also known as model bindings. Model binding is an integral part of any application's logic and we can manipulate it to get the data we need and when we need. We will go through a series of recipes that will show us how to change the way bindings are fetched, what bindings and what information from a binding is returned, how to create new bindings, and how to build hierarchical data structures. We also define our custom find types that will extend the three basic ones, allowing our code to be even more readable and also create our own find type, with pagination support. This book also has recipes that cover two aspects of CakePHP models that are fundamental to most applications: validation, and behaviors.

CakePHP 1.3 Application Development Cookbook

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

Free Chapter

Authentication

Introduction

Setting up a basic authentication system

Using and configuring the Auth component

Allowing logins with username or e-mail

Saving the user details after login

Getting the current user's information

Using prefixes for role-based access control

Setting up Access Control Layer-based authentication

Integrating with OpenID

Model Bindings

Introduction

Adding Containable to all models

Limiting the bindings returned in a find

Modifying binding parameters for a find

Modifying binding conditions for a find

Changing the JOIN type of one-to-one associations

Defining multiple associations to the same model

Adding bindings on the fly

Pushing the Search

Introduction

Performing GROUP and COUNT queries

Using virtual fields

Building queries with ad-hoc JOINs

Searching for all items that match search terms

Implementing a custom find type

Paginating a custom find type

Implementing AJAX based pagination

Validation and Behaviors

Introduction

Adding multiple validation rules

Creating a custom validation rule

Using callbacks in behaviors

Using behaviors to add new fields for saving

Using the Sluggable behavior

Geocoding addresses with the Geocodable behavior

Datasources

Introduction

Improving the SQL datasource query log

Parsing CSV files with a datasource

Consuming RSS feeds with a datasource

Building a Twitter datasource

Adding transaction and locking support to the MySQL datasource

Routing Magic

Introduction

Using named and GET parameters

Using routes with prefixes

Working with route elements

Adding catch-all routes for profile pages

Adding validation for catch-all routes

Creating custom Route classes

Creating and Consuming Web Services

Introduction

Creating an RSS feed

Consuming a JSON service

Building REST services with JSON

Adding authentication to REST services

Implementing token-based authorization for API access

Working with Shells

Introduction

Building and running a shell

Parsing command line parameters

Creating reusable shell tasks

Sending e-mails from shells

Non-interactive tasks with the robot plugin

Internationalizing Applications

Introduction

Internationalizing controller and view texts

Internationalizing model validation messages

Translating strings with dynamic content

Setting and remembering the language

Testing

Introduction

Setting up the test framework

Creating fixtures and testing model methods

Testing controller actions and their views

Using mocks to test controllers

Running tests from the command line

Utility Classes and Tools

Introduction

Working with the Set class

Manipulating strings with the String class

Sending an e-mail

Detecting file types with MagicDb

Throwing and handling exceptions

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Performing GROUP and COUNT queries

This recipe shows how to use CakePHP's built-in find types to perform relatively complex GROUP and COUNT queries, including the combination of both.

Getting ready

To go through this recipe we need some sample tables to work with.

1. Create a table named users, using the following SQL statement:

CREATE TABLE `users`(
`id` INT UNSIGNED AUTO_INCREMENT NOT NULL,
`name` VARCHAR(255) NOT NULL,
`email` VARCHAR(255) NOT NULL,
PRIMARY KEY(`id`)
);

2. Create a table named blogs, using the following SQL statement:

CREATE TABLE `blogs`(
`id` INT UNSIGNED AUTO_INCREMENT NOT NULL,
`user_id` INT UNSIGNED NOT NULL,
`name` VARCHAR(255) NOT NULL,
PRIMARY KEY(`id`),
KEY `user_id`(`user_id`),
CONSTRAINT `blogs__users` FOREIGN KEY(`user_id`) REFERENCES `users`(`id`)
);

3. Create a table named posts, using the following SQL statement:

CREATE TABLE `posts`(
`id` INT UNSIGNED AUTO_INCREMENT NOT NULL,
`blog_id` INT UNSIGNED NOT NULL,
`title` VARCHAR(255) NOT NULL,
`body` TEXT NOT NULL...

CakePHP 1.3 Application Development Cookbook

CakePHP 1.3 Application Development Cookbook

Overview of this book

Related Content you might be interested in

Current Title:

CakePHP 1.3 Application Development Cookbook

Performing GROUP and COUNT queries

Getting ready