Following upon David's suggestion, you can achieve the functionality of a dynamic select box using this tutorial as a guide: http://www.willis-owen.co.uk/2011/11/dynamic-select-box-with-cakephp-2-0/. That is how I would do it as well.
On Monday, 22 April 2013 14:36:11 UTC-4, [email protected] wrote: > > I have a table of students with foreign keys of province_id and a > country_id. And the table of provinces has a foreign key of country_id just > like the students table. > > I want to make sure that a student doesn't get saved with a province that > doesn't match the country. I put this into my Student model and it works, > but I want to know if I'm following best practices. > > Can anyone suggest a better way to do this? > > public function beforeValidate(array $options = array()) { > if ($this->data['Student']['province_id']) { > $p = new Province(); > $this->set('province', > $p->findById($this->data['Student']['province_id'])); > if ($this->data['Student']['province']['Province']['country_id'] != > $this->data['Student']['country_id']) { > $this->invalidate('province_id', 'Invalid province for the selected > country'); > return false; > } > } > return true; > } > -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
