1 Topic by akongz

  • akongz
  • New member
  • Offline
  • Registered: 2010-02-13
  • Posts: 8

Topic: zc21: many-to-many-with-zend-form-and-zend-db-part-1

Hi John I'm little bit confused about syntax insert to database..

In previously video I saw that code insert to database at Class Services,

But in this tutorial that code insert to database at Form Class..

Thanks.

2 Reply by Jon Lebensold

  • Jon Lebensold
  • Administrator
  • Offline
  • Registered: 2009-06-27
  • Posts: 242

Re: zc21: many-to-many-with-zend-form-and-zend-db-part-1

Hi Akongz,

the Service layer is just a different architectural approach, where the service class acts as a Façade.

3 Reply by akongz

  • akongz
  • New member
  • Offline
  • Registered: 2010-02-13
  • Posts: 8

Re: zc21: many-to-many-with-zend-form-and-zend-db-part-1

Jon Lebensold wrote:

Hi Akongz,

the Service layer is just a different architectural approach, where the service class acts as a Façade.

Oh I got it.

So if I'm using architectural Facade, I put code insert DB or update DB or anything else in Service Class and  my Form Class only construct the form.

It is right?

Anyway thanks for the response

Last edited by akongz (2010-02-15 09:03:17)

4 Reply by Jon Lebensold

  • Jon Lebensold
  • Administrator
  • Offline
  • Registered: 2009-06-27
  • Posts: 242

Re: zc21: many-to-many-with-zend-form-and-zend-db-part-1

that's the general idea! Also, I would suggest taking a look at the Doctrine screencasts... Doctrine could save you a bunch of time.

5 Reply by jujubee

  • jujubee
  • New member
  • Offline
  • Registered: 2010-05-05
  • Posts: 1

Re: zc21: many-to-many-with-zend-form-and-zend-db-part-1

Jon, I just watched your vids on 1-many and many-many and I do have some questions.  Let me start by saying I am not a prof. developer.  I just play around with php/mysql/ and am new to zf.

1)  I noticed you created a UserService in Libarary/App and it seems to me that is really what is referred to as a Model?  Why not in the Model dir?

2)  I have a project I am working on (School Management System) and currently it uses MyISAM db .  Should I use innodb?  I really don't know much about transactions and my relationships are all dealt with in the code rather than the db.  Watching you vids I see you can put the constraints in the db itself... Cool.

Anyway, thanks for the vids.  Very nice.  I also like that you did not edit out the "Ooops's" as it shows what to do when errors arise, and they always do...

6 Reply by SocialEvil

  • SocialEvil
  • New member
  • Offline
  • Registered: 2010-05-26
  • Posts: 4

Re: zc21: many-to-many-with-zend-form-and-zend-db-part-1

Hi,
I have one question. If i have a $value = "some string".
How can i fetch all the records from BOTH tables. If i have
"select * from table1, table2 where table1.title like %$value% AND table2.subtitle like %$value%"

Please allow me to introduce myself
I'm a man of wealth and taste
I've been around for a long, long year
Stole many a man's soul and faith

7 Reply by Jon Lebensold

  • Jon Lebensold
  • Administrator
  • Offline
  • Registered: 2009-06-27
  • Posts: 242

Re: zc21: many-to-many-with-zend-form-and-zend-db-part-1

Hi SocialEvil,
please accept my apologies for the late response.

in such a situation, where the tables are disjoint, you would make two separate queries.