RE: [fw-general] Newbie quesiton - How do queries that join multiple tables fit into the model in the MVC

2008-12-15 Thread A.J. Brown
t myself. I'll let others chime in on that... > > -mike tramontano > > -Original Message- > From: Daniel Latter [mailto:dan.lat...@gmail.com] > Sent: Friday, December 12, 2008 8:17 PM > To: A.J. Brown > Cc: fw-general@lists.zend.com > Subject: Re: [fw-general

Re: [fw-general] Newbie quesiton - How do queries that join multiple tables fit into the model in the MVC

2008-12-15 Thread Daniel Latter
l let others chime in on that... > > -mike tramontano > > -Original Message- > From: Daniel Latter [mailto:dan.lat...@gmail.com] > Sent: Friday, December 12, 2008 8:17 PM > To: A.J. Brown > Cc: fw-general@lists.zend.com > Subject: Re: [fw-general] Newbie quesiton - How

RE: [fw-general] Newbie quesiton - How do queries that join multiple tables fit into the model in the MVC

2008-12-15 Thread Michael Tramontano
fw-general] Newbie quesiton - How do queries that join multiple tables fit into the model in the MVC Yes, thanks, you are right, but say you were creating a specific XML file from scratch using domdocument for example, that involved creating / appending a lot of elements, and this was wr

Re: [fw-general] Newbie quesiton - How do queries that join multiple tables fit into the model in the MVC

2008-12-12 Thread Daniel Latter
Yes, thanks, you are right, but say you were creating a specific XML file from scratch using domdocument for example, that involved creating / appending a lot of elements, and this was wrapped up in the form of a custom class you created, wouldnt you store this in the model? And the use in

Re: [fw-general] Newbie quesiton - How do queries that join multiple tables fit into the model in the MVC

2008-12-12 Thread A.J. Brown
Generating XML and Feeds should NOT be done with the model. Those are representations of the data, and should be done with in the controller and view layers. The controller layer should determine which representation to use by selecting the correct view, and the view should render the data. --

Re: [fw-general] Newbie quesiton - How do queries that join multiple tables fit into the model in the MVC

2008-12-12 Thread Bill Karwin
On Dec 12, 2008, at 7:32 AM, Julian102 wrote: I think I was confused because a lot of the beginner tutorials I have read use methods like fetchAll and update in the controller. So I made the mistake of thinking that the controller is where the action happens and the model was some sort of d

Re: [fw-general] Newbie quesiton - How do queries that join multiple tables fit into the model in the MVC

2008-12-12 Thread Julian102
Thank you all for your replies I now have a good understanding of how the model works. I think I was confused because a lot of the beginner tutorials I have read use methods like fetchAll and update in the controller. So I made the mistake of thinking that the controller is where the action happ

Re: [fw-general] Newbie quesiton - How do queries that join multiple tables fit into the model in the MVC

2008-12-11 Thread Daniel Latter
As a very loose, and general rule of of thumb the things that should be part of your model would things like generating / creating XML feeds , ie the code that does this, processing data you've got from a database, ie to prepare the data so your app can more easily use it, and generally thi

Re: [fw-general] Newbie quesiton - How do queries that join multiple tables fit into the model in the MVC

2008-12-11 Thread PHPScriptor
Hmmm these are very basic questions and should take a lot of time to explain. All depends on what you have and what you want. If I were you, I would start with building the database. So you know what tabels you have, and the fields you need. Then you can start thinking about your website structure

Re: [fw-general] Newbie quesiton - How do queries that join multiple tables fit into the model in the MVC

2008-12-11 Thread Bill Karwin
On Dec 11, 2008, at 9:48 AM, Julian102 wrote: Can anyone explain to me or show me somewhere that explains on a very high level for a beginner how the model fits into a system and how one should think about it when designing an application. For example should the model be designed at the sa

Re: [fw-general] Newbie quesiton - How do queries that join multiple tables fit into the model in the MVC

2008-12-11 Thread Julian102
Thank you both for your replys they're very much appreciated. I am still however having some difficulty in understanding the model and would be very greatful if you could look at the following simple example and let me know where im going wrong. I am about to build a simple site where users can a

RE: [fw-general] Newbie quesiton - How do queries that join multiple tables fit into the model in the MVC

2008-12-10 Thread Guillaume BABIK
Hi, You could use a Zend_Db_Select object associated to your Zend_Db_Table object. For exemple: You have 3 tables (T1, T2, T3). You want to access T1's fields but you need to join T2 and T3. In your Zend_Db_Table T1, add this method: public static function getT1List() { $sel

Re: [fw-general] Newbie quesiton - How do queries that join multiple tables fit into the model in the MVC

2008-12-09 Thread Bill Karwin
On Dec 9, 2008, at 9:54 AM, Julian102 wrote: I understand that a class in the model is normally associated with a table in the database ... Whoah there. I don't know where you get that idea. The relationship between a Model class and a Table class (or multiple Table classes) is HAS-A, ra