Book Image

CakePHP 2 Application Cookbook

Book Image

CakePHP 2 Application Cookbook

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
CakePHP 2 Application Cookbook
Aug, 2014 | 346 pages
No titles found
Table of Contents (20 chapters)
CakePHP 2 Application Cookbook
CakePHP 2 Application Cookbook
Credits
Credits
Foreword
Foreword
About the Authors
About the Authors
About the Reviewer
About the Reviewer
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Lightning Introduction
Lightning Introduction
Introduction
Listing and viewing records
Adding and editing records
Deleting records
Adding a login
Including a plugin
2
Advanced Routing
Advanced Routing
Introduction
Adding a prefix
Handling languages
Custom route class
Dispatch filter
3
HTTP Negotiation
HTTP Negotiation
Introduction
Parsing extensions
Processing Ajax requests
Building a response
Uploading a file
Using a detector
Working with cookies
Cache control
Error handling
4
API Strategies
API Strategies
Introduction
RESTful resources
Exposing a web service
Consuming a service
Authentication API
API versioning
5
Using Authentication
Using Authentication
Introduction
The HTTP authentication
Custom authorize class
Facebook authentication
Custom RBAC
Working with ACL
6
Model Layer
Model Layer
Introduction
Has and belongs to many (HABTM)
Joining through
Containing models
Custom finders
On-the-fly associations
Using transactions
7
Search and Pagination
Search and Pagination
Introduction
Pagination
Basic search and filter
The Search plugin
Advanced search
8
Events System
Events System
Introduction
Listeners and subscribers
Event-driven process
Event stacking
Managing event priorities
9
Creating Shells
Creating Shells
Introduction
Console API
Import parser
Running cron shells
Using the I18n shell
10
View Templates
View Templates
Introduction
Using blocks
Building an XML view
Generating a PDF
Writing some PDF content to a file
Translations
View caching
The AssetCompress plugin
11
Unit Tests
Unit Tests
Introduction
Dependency Injection
Creating a fixture
Mock objects
Stub method configuration
Model unit testing
12
Migrations
Migrations
Introduction
Schema handling
Syncing changes
The Migrations plugin
Injecting data
Index
Index

Schema handling

CakePHP is packed with a console shell for schema management, which gives you the ability to keep your database structure defined in a schema file in your version control system. This schema file keeps track of the changes made to your database and applies schema changes without touching your current data.

A schema file is a regular PHP file, located by convention in app/Config/Schema/schema.php. This file describes your database tables using properties as one property per table. Each property holds an array with all the columns in your table, their type, and other metadata required to fully describe the table.

Getting ready

You'll need to create at least one table in your database and its associated model. The shell schema processes models defined in your application, not the actual tables in your database.

So, create a profiles table in your database, using the following SQL statement:

CREATE TABLE profiles (
  id INT NOT NULL AUTO_INCREMENT,
  title VARCHAR(100) NOT NULL,
...
Previous Section
End of Section 3
Next Section