Zend DB inserting relational data

Posted by Wimbjorno on Stack Overflow See other posts from Stack Overflow or by Wimbjorno
Published on 2012-09-04T08:49:17Z Indexed on 2012/09/04 9:38 UTC
Read the original article Hit count: 152

Filed under:

zend-framework

|

zend-db

I'm using the Zend Framework database relationships for a couple of weeks now. My first impression is pretty good, but I do have a question related to inserting related data into multiple tables. For a little test application I've related two tables with each other by using a fuse table.

      +---------------+      +---------------+      +---------------+
      |     Pages     |      |     Fuse      |      |    Prints     |
      +---------------+      +---------------+      +---------------+
      | pageid        |      | fuseid        |      | printid       |
      | page_active   |      | fuse_page     |      | print_title   |
      | page_author   |      | fuse_print    |      | print_content |
      | page_created  |      | fuse_locale   |      | ...           |
      | ...           |      | ...           |      +---------------+
      +---------------+      +---------------+

Above is an example of my DB architecture

Now, my problem is how to insert related data to two separate tables and insert the two newly created ID's into the fuse table at the same time. If someone could could maybe explain or give me a topic related tutorial. I would appreciate it!

© Stack Overflow or respective owner

Related posts about zend-framework

Zend framework Zend_Controller_Action_HelperBroker::addPath does not work

as seen on Stack Overflow - Search for 'Stack Overflow'
I get this message regardless of the path used and even if I place the class file in the default directory location. Zend_Controller_Action_HelperBroker::addPath('./Plugins/Helpers','Helper'); Sorry, An error has occured: Application Error:exception 'Zend_Loader_PluginLoader_Exception' with message… >>> More
Problem setting up Zend Framework to run with Netbeans

as seen on Server Fault - Search for 'Server Fault'
I am trying to get Zend Framework working with netbeans, but every time there is the error "php.exe"' is not recognized as an internal or external command, operable program or batch file. I am using WAMP server 2.0 it is installed in e:\wamp My Zend framework is inside e:\wamp\www\ZendFramework-1… >>> More
How do I use PHPUnit with Zend Framework?

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to know how to write PHPUnit tests with Zend_Test and in general with PHP. >>> More
Code to plug into a Zend Framework project

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello everyone, Im currently working on a website in the Zend Framework and finding it very useful indeed. I want both a blog and a forum in this website and wondered if there are any open-source projects of this nature that I would be able to simply copy and paste into my modular project. I was… >>> More
Displaying locale percentage number with Zend Framework

as seen on Stack Overflow - Search for 'Stack Overflow'
Does anyone know how to display a percentage format based on the locale using the zend framework? I've tried this below and it doesn't work for some reason: $xx = Zend_Locale::getTranslation(null, 'PercentNumber'); // This outputs: "#,##0%" for locale 'en_us' $percentage = Zend_Locale_Format::getNumber(133… >>> More

Related posts about zend-db

ZF2 Zend\Db Insert/Update Using Mysql Expression (Zend\Db\Sql\Expression?)

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there any way to include MySQL expressions like NOW() in the current build of ZF2 (2.0.0beta4) through Zend\Db and/or TableGateway insert()/update() statements? Here is a related post on the mailing list, though it hasn't been answered: http://zend-framework-community.634137.n4.nabble.com/Zend-Db-Expr-and-Transactions-in-ZF2-Db-td4472944… >>> More
Zend DB returning NULL value

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following query that extends from Zend_DB_Table_Abstract $select = $this->select() ->from('expense_details', array('SUM(expense_details_amount) AS total')) ->where('YEAR(expense_details_date) = ?', '2010') ->where('MONTH(expense_details_date)… >>> More
Zend DB MYSQL Wrapper

as seen on Stack Overflow - Search for 'Stack Overflow'
All, I have a PHP application written in Zend Framework with MVC style. I plan to use Zend_DB to connect to the MySQL database and process queries. I am looking for a wrapper class which makes it easy to use Zend_DB class. This wrapper class will have a constructor that connects to the Mysql db using… >>> More
Deleting Multiple Rows with Zend DB Table Problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I have this data in my db Col1 Col2 DA Data1 DA Data2 DA Data3 DA Data4 DA Data5 I would like to delete all the values WHERE col1 = DA using my Zend DB Table adapter. The code below does not seem to work for multiple rows public function delete($key) { … >>> More
Selecting arbitrary strings with Zend DB Select?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using the fluent interface to create a Zend DB Select object/query. As part of the query, I would like to select an arbitrary string, like "SELECT 'foo' AS 'type' FROM ...". foo is not a column, it's just a string literal. When I select an arbitrary number, the query works as expected. When… >>> More