Databases
StackOverflow2013
Postsdbo
POHow do you work with a relational database in Zend Framework?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow do you work with a relational database in Zend Framework?
    primarykey
    data
    text
    <p>I'm using the zend framework to write an app and I'm having lots of problems getting my relational database models to work. I've read the quickstart and the docs several times and I'm still not sure how to do this. I post a picture of the relationships between the different tables involved to avoid having to explain everything since English is not my first language and I tend not to make myself clear when I try to explain...well complex things. <img src="https://i.stack.imgur.com/YqQul.png" alt="enter image description here"></p> <p>The tables press_releases, social_networking, blog_posts, rss_feed, directorios, users and articulos are all set as foreign keys in the table named planilla_users. I coded my table models the way the quickstart shows:</p> <pre><code>class Application_Model_DbTable_PlanillaUsers extends Zend_Db_Table_Abstract { protected $_name = 'planilla_users'; protected $_referenceMap = array( 'User' =&gt; array( 'columns' =&gt; 'users_id', 'refTableClass' =&gt; 'Application_Model_DbTable_Users', 'refColumns' =&gt; 'id' ), 'Articulo' =&gt; array( 'columns' =&gt; 'art_id', 'refTableClass' =&gt; 'Application_Model_DbTable_Articulos', 'refColumns' =&gt; 'id' ),...etc </code></pre> <p>...and the rest following the format of:</p> <pre><code>class Application_Model_DbTable_Users extends Zend_Db_Table_Abstract { protected $_name = 'users'; protected $_dependentTables = array('Application_Model_DbTable_PlanillaUsers'); </code></pre> <p>I also have a model Planilla.php with all the setters and getters for the information to be stored/updated/retrieved/deleted,...however...I'm completely blank on what to do with the mapper. I don't know how it's supposed to work and I honestly haven't found a good example on how to do something like this yet. So any help would be mostly appreciated.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USla_f0ka
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow do you work with a relational database in Zend Framework?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHave you seen this chapter: http://framework.zend.com/manual/en/zend.db.table.relationships.html ? It is from the reference guide and not from the quick start guide and it should give you all your answers.
      singulars
      1. POHow do you work with a relational database in Zend Framework?
      1. USRaffael Luthiger
    2. CO@Raffael Luthiger Yes, I've seen it. However I don't know how am I supposed to get the mapper to work when I have 8 different tables involved in a many-to-one relationship. How do I fetchAll() for example?
      singulars
      1. POHow do you work with a relational database in Zend Framework?
      1. USla_f0ka
    3. COHow does this relate to your [previous question](http://stackoverflow.com/questions/6177710/how-to-set-a-mapper-for-a-table-that-will-serve-as-a-record-for-other-7-table-ids)? Maybe delete that question if this one replaces it?
      singulars
      1. POHow do you work with a relational database in Zend Framework?
      1. USDavid Weinraub
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload