Book Image

CakePHP 1.3 Application Development Cookbook

Book Image

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.
Table of Contents (17 chapters)
CakePHP 1.3 Application Development Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface

Changing the JOIN type of one-to-one associations


When we are querying a model that has other associated models, CakePHP will issue a new query to fetch the associated data, or use a LEFT JOIN SQL statement if the associated model has a one-to-one relationship with the main model (through a binding defined with belongsTo or hasOne.)

However there are times where we need to change the join type for one-to-one associations, to use either a RIGHT JOIN or an INNER JOIN. This recipe shows us how to change the join type for belongsTo and hasOne associations.

Getting ready

Follow the Getting ready section of the recipe, Limiting the bindings returned in a find.

How to do it...

  1. 1. Edit the Person model, and change the binding definitions for belongsTo and hasOne associations, as shown below:

    <?php
    class Person extends AppModel {
    public $belongsTo = array('Family' => array('type' => 'INNER'));
    public $hasOne = array('Profile' => array('type' => 'RIGHT'));
    public $hasMany = array('Post...