First of all, Happy New Year! :) I’ve been busy these past weeks. But I would like to spare some time today and share a little but useful tip on how to remove null or empty array values before finally saving it to the database. I recently stumble upon this issue and have found the set::filter core utility really helpful.
In certain situations that you encounter this.
[Product] => Array (  => Array ( [id] => 35 [url] => item35.php )  => Array ( [id] => [url] => ) )
Basically you just add the utility before saving the data to remove the array values.
<?php $this->data = Set::filter($this->data); $this->Product->save($this->data); ?>
That’s about it. :)