[SOLVED] Joing tables using a classs in the Zend Framework?

[littlevisuals]

Hi everyone,

 

I have a database with the looks like the following;

 

 

I have created the model below

 

<?php
/**
* Description of gallery
*
* @author lv
*/
class Model_DbTable_Artist extends Zend_Db_Table_Abstract
{
    protected $_name = 'artist';
    
}

class Model_DbTable_Image extends Zend_Db_Table_Abstract
{
    protected $_name = 'image';
}

class Model_DbTable_Category extends Zend_Db_Table_Abstract
{
    protected $_name = 'category';
    protected $_referenceMap    = array(
        'ArtistCategory' => array(
        'columns'           => 'artist_id' , 'category_id',       
        'refTableClass'     => 'Artist', 'Category',
        'refColumns'        => 'artist_id' , 'category_id',     
        ),
    
        'ImageCategory' => array(
        'columns'           => 'image_id' , 'category_id',      
        'refTableClass'     => 'Category', 'Image',
        'refColumns'        => 'image_id' , 'category_id',      
        
        ),
        'Artist' => array(
        'columns'           => 'artist_id',      
        'refTableClass'     => 'Image',  
        'refColumns'        => 'image_id'    
        )         
    ); 

    
}

 

Is the right way to join tables in zend???

 

 

 

[448191]

Can't do it. I am a big fan of ZF, but Zend_Db_Table sucks. Try Doctrine instead.

[RichardRotterdam]

I agree with that try Doctrine (or Propel) you might get addicted.

I think I read one of 448191's blog articles that coverd this exact subject.

 

 

Other then that I think your db design could use some work.

For example why not have a foreign key in your image table instead of joining artist_id with image_id?

 

[gluck]

I think you should redesign your database. You can easily eliminate the two category_cross tables. Just add a foreign key in the artist and image tables as someone suggested. Actually you need 3  master tables - Artist, Image and Category. One cross table where you associate artists with images. Add category id just to image master table. Also I would keep image urls should in images because an artist will have multiple images.

[littlevisuals]

Thanks a bunch!  Got the db sorted now gluck!