I have the usual example about books and authors.
I have followed CakePHP naming convention and I'm on MySQL without
InnoDB so I can't write foreign key constraints directly on db.
I have 3 tables authors, books and authors_books. The last table has 3
fields: id as PK, author_id and book_id.
Two model for books and authors, associated by HABTM "link". All that
I want realize is: as soon I remove an author, even the book written
by this author must be deleted.
Book model:
<?php
class Book extends AppModel
{
var $name = 'Book';
var $hasAndBelongsToMany = 'Author';
}
?>
Author model:
<?php
class Author extends AppModel
{
var $name = 'Author';
var $hasAndBelongsToMany = array
(
'Album' => array
(
'className' => 'Book',
'dependent' => true
)
);
}
?>
delete() function in authors_controller.php (AuthorsController)
<?php
function delete($id)
{
$del = $this->Author->findById($id);
$this->Author->delete($id, true);
$this->Session->setFlash('The author \''.$del['Author']
['name'].'\' has been deleted.');
$this->redirect(array('action'=>'index'));
}
?>
Now, if I delete an author, in MySQL will be deleted the author from
authors table, the relative record in join table (authors_books) that
bind author deleted with his book, but nothin change in books table.
Why???
Check out the new CakePHP Questions site http://cakeqs.org and help others with
their CakePHP related questions.
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
