Create a validation rule for colums of the join tables in CakePHP

Question

I have a hasAndBelongsToMany association between two tables(Recipes and Ingredients) in a CakePHP joined with a linking table(ingredients_recipes).

My ingredients_recipes table has an amount colum in order to save the value of the ingredient for the recipe but i dont know how or where create a validation rule for allow only numbers in that colum.

I already look here and in the documentation but i cant found nothing.
If you need more information please let me know
Thnks

Are you talking validation from a post before it inserts into the database? If so check http://book.cakephp.org/2.0/en/models/data-validation.html — Braunson, Jan 08 '14 at 17:39

score 1 · Accepted Answer · answered Jan 08 '14 at 17:58

If you're storing additional fields on the join table, you will have to deal with the join table explicitly, rather than in a hasAndBelongsToMany, where CakePHP takes care of the join table behind the scenes, and therefore the validation rule should be on ingredients_recipes.

This type of relationship, by the way, is known as a hasManyThrough, and is basically just expressed as recipes hasMany ingredients_recipes and ingredients_recipes has many ingredients.

http://book.cakephp.org/2.0/en/models/associations-linking-models-together.html#hasmany-through-the-join-model

Anubhav · Answer 2 · 2014-01-09T04:13:36.843

Create validation rules in Recipe.php and Ingredient.php Models, example is shown below:

Step 1: Open Ingredient.php

Step 2: Edit Ingredient.php

Class Ingredient extends AppModel{
    var $name = 'Ingredient';
    public $validate = array(
      'ingredients_recipes' => array(
        'rule'    => 'numeric',
        'message' => 'Please supply the number of ingredients recipes.'
       )
    );
}

Step 3: Save and execute your code.

Now your Ingredient model validates ingredients_recipes for numeric vaidation and if fails then returns the "message".

Same way way you can create multiple validation rules for other models.

For ref: http://book.cakephp.org/2.0/en/models/data-validation.html

Create a validation rule for colums of the join tables in CakePHP

2 Answers2