This recipe shows how to use Containable
to change some of the parameters that affect model bindings.
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
profiles
, using the following SQL statement:CREATE TABLE `profiles`( `id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `user_id` INT UNSIGNED NOT NULL, `website` VARCHAR(255) default NULL, `birthdate` DATE default NULL, PRIMARY KEY(`id`), KEY `user_id`(`user_id`), CONSTRAINT `profiles__users` FOREIGN KEY(`user_id`) REFERENCES `users`(`id`) );
3. Create a table named
articles
, using the following SQL statement:CREATE TABLE `articles`( `id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `user_id` INT UNSIGNED NOT NULL, `title` VARCHAR(255) NOT NULL, `body...