database server. We’re going to be using MySQL server in this tutorial. You’ll need to know enough about SQL in order to create a database: CakePHP will be taking the reins from there. Since we’re using MySQL posts. We’ll also throw in a few posts right now to use for testing purposes. Execute the following SQL statements into your database: /* First, create our posts table: */ CREATE TABLE posts ( id INT support composite primary keys. If you want to directly manipulate your join table data, use direct query calls or add a primary key to act on it as a normal model. For example: CREATE TABLE posts_tags (

database server. We’re going to be using MySQL server in this tutorial. You’ll need to know enough about SQL in order to create a database: CakePHP will be taking the reins from there. Since we’re using MySQL posts. We’ll also throw in a few posts right now to use for testing purposes. Execute the following SQL statements into your database: /* First, create our posts table: */ CREATE TABLE posts ( id INT UNSIGNED support composite primary keys. If you want to directly manipulate your join table data, use direct query calls or add a primary key to act on it as a normal model. For example: CREATE TABLE posts_tags (

Configuration Files Storing Runtime Configuration Restoring Runtime Configuration Configuration Engines Disabling Generic Tables Routing RouterBuilder Quick Tour Connecting Routes Route Elements Reserved Persistent URL Parameters Request & Response Objects Request ServerRequest Request Parameters Query String Parameters Request Body Data File Uploads PUT, PATCH or DELETE Data Environment Variables (from JSON and XML views Helpers Database Access & ORM Quick Example More Information Database Basics Query Builder Table Objects Entities Retrieving Data & Results Sets Validating Data Saving Data Deleting

. . . . . . . . . . . . . . . . . . . . . . . . . . . . 323 13 Caching 505 Configuring Cache Engines . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 506 Writing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 513 Using Cache to Store Common Query Results . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 514 Using Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 620 Creating Log Engines . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 620 Log

Configuration Files Storing Runtime Configuration Restoring Runtime Configuration Configuration Engines Bootstrapping CakePHP Application::bootstrap() Disabling Generic Tables Routing Quick Tour Connecting Named Parameters in URLs Dispatcher Filters Request & Response Objects Request Request Parameters Query String Parameters Request Body Data File Uploads PUT, PATCH or DELETE Data Environment Variables (from JSON and XML views Helpers Database Access & ORM Quick Example More Information Database Basics Query Builder Table Objects Entities Retrieving Data & Results Sets Validating Data Saving Data Deleting

Configuration Files Storing Runtime Configuration Restoring Runtime Configuration Configuration Engines Disabling Generic Tables Routing RouterBuilder Quick Tour Connecting Routes Route Elements Reserved Persistent URL Parameters Request & Response Objects Request ServerRequest Request Parameters Query String Parameters Request Body Data File Uploads PUT, PATCH or DELETE Data Environment Variables (from JSON and XML views Helpers Database Access & ORM Quick Example More Information Database Basics Query Builder Table Objects Entities Retrieving Data & Results Sets Validating Data Saving Data Deleting

. . . . . . . . . . . . . . . . . . . . . . . . . . . . 465 13 Caching 633 Configuring Cache Engines . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 634 Writing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 641 Using Cache to Store Common Query Results . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 641 Using Groups . . . TableRegistry::get('Users') $users = TableRegistry::getTableLocator()->get('Users'); $query = $users->find(); foreach ($query as $row) { echo $row->username; } You may notice that we didn’t have to write any

. . . . . . . . . . . . . . . . . . . . . . . . . . . . 421 13 Caching 605 Configuring Cache Engines . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 606 Writing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 613 Using Cache to Store Common Query Results . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 614 Using Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 728 Creating Log Engines . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 728 Log