Thanks, Chris.
I'll try looking at some Ruby stuff, also. I've poured over the manual
so many times, as well as doing searches on this group listing, and
checked out the wiki. I'm just not seeing what I've done wrong.
If anyone sees my mistake, I'm more than willing to learn from it. I
just don't see what it is. At this point, I don't know if it is
something I don't understand, a syntax error, etc.
Thanks again for taking the time to help out a noobie...
Chris Hartjes wrote:
> I would definitely go over all the model associations stuff in the
> Cake manual and even sneak a peek at how the Rails group handles habtm
> relationships. A quick glance at your code makes me think you're very
> close. :)
>
> On 8/16/06, j o e l <[EMAIL PROTECTED]> wrote:
> >
> > Hello, All.
> >
> > I hope you don't mind my posting another HABTM issue here. I've been
> > trying to get this to work, and I'm sure I'm just missing something
> > basic. I've been a little confused reading the manual, the google
> > groups, etc. If you don't mind, I'll just post what I'm trying to do
> > and then my dbase structure and code.
> >
> > I am trying to create a photo album for my personal site. I would like
> > users to be able to search for specific categories. I've started out
> > with 3 tables: one for photos, one for categories, and one for the
> > join. I've created the models and controllers according to what I've
> > seen in the manual, but it doesn't work. When I perform findAll() via
> > the index view, it does not pull in the associated category (there is
> > data in all tables). So, that is the issue. Now, here is the code...
> >
> >
> > TABLES:
> >
> > * categories: id INT, name VARCHAR, description text, parent_id
> > INT, created DATETIME, modified DATETIME
> > * photos: id INT, file_name VARCHAR, description text, caption
> > text, created DATETIME, modified DATETIME
> > * categories_photos: category_id INT, photo_id INT
> >
> >
> > MODELS:
> >
> > category.php:
> >
> > class Category extends AppModel
> > {
> > var $name = 'Category';
> > var $hasAndBelongsToMany = array('Photo' =>
> > array('className' => 'Photo',
> > 'joinTable' => 'categories_photos',
> > 'foreignKey' => 'category_id',
> > 'associationForeignKey' => 'photo_id',
> > 'conditions' => '',
> > 'order' => '',
> > 'limit' => '',
> > 'unique' => '',
> > 'finderSql' => '',
> > 'deleteQuery' => ''));
> > }
> >
> >
> > photo.php:
> >
> > class Photo extends AppModel
> > {
> > var $name = 'Photo';
> > var $hasAndBelongsToMany = array('Category' =>
> > array('className' => 'Category',
> > 'joinTable' => 'categories_photos',
> > 'foreignKey' => 'photo_id',
> > 'associationForeignKey' => 'category_id',
> > 'conditions' => '',
> > 'order' => '',
> > 'limit' => '',
> > 'unique' => '',
> > 'finderSql' => '',
> > 'deleteQuery' => ''));
> > }
> >
> >
> > Photo Controller:
> >
> > Everything works in my category views, so I will just paste a portion
> > of my Photo Controller.
> >
> >
> > class PhotosController extends AppController
> > {
> > var $name = 'Photos';
> >
> > function index()
> > {
> > $this->set('data', $this->Photo->findAll());
> > }
> > ....
> >
> >
> > In my index view for the photo table, I have a table with the
> > appropriate association which displays all of the data from the photo
> > table just fine. However, nothing from the category table displays.
> > I've tried defining it several different ways. Currently, I have this
> > in the view...
> >
> >
> > <?php foreach ($data as $photo): ?>
> >
> > <tr>
> > <td><?php echo $photo['Photo']['id']; ?></td>
> > <td><?php echo $photo['Photo']['file_name']; ?></td>
> > <td><?php echo $photo['Photo']['description']; ?></td>
> > <td><?php echo $photo['Photo']['caption']; ?></td>
> > <td><?php echo $photo['Category']['name']; ?></td>
> >
> >
> > This gives me an error stating 'name' is an 'undefined index'. I
> > obviously do not have a complete understanding of how this is supposed
> > to work. Would someone mind kindly explaining this to me?
> >
> >
> > Thanks in advance. I greatly appreciate it.
> >
> >
> > -- j o e l
> >
> >
> > >
> >
>
>
> --
> Chris Hartjes
>
> "The greatest inefficiencies come from solving problems you will never have."
> -- Rasmus Lerdorf
>
> @TheBallpark - http://www.littlehart.net/attheballpark
> @TheKeyboard - http://www.littlehart.net/atthekeyboard
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
