Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
Forum
Support forum
FAQ
many-to-many db relations
  • Page:
  • 1

TOPIC:

many-to-many db relations 22 Dec 2012 12:59 #6221

  • Julien
  • Julien's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 8
  • Thank you received: 0
Hi there,

Thanks a lot for your work on Cook, this is an impressive component builder. Congratulations!

A question, please:
I would like to build a many-to-many relation between 2 tables. Is Cook able to design it? I didn't see anything about that in the builder, but only foreign keys (one-to-many relations).

Example:
I have 2 tables:
  1. 'Books' ('id', 'name', 'author')
  2. 'Tags' ('id', 'name')

Rule 1: A book can have none or several tags. Relation 0-n
Rule 2: A tag can be assigned to none or several books. Relation 0-n

How can I design this in Cook? Do I have to design an another table between these 2 tables?

Thanks for your answer.

Best.

Please Log in or Create an account to join the conversation.

Re: many-to-many db relations 22 Dec 2012 13:08 #6224

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
Hi and welcome to the community !
Thank you for your review. Don't forget the JED.

About your question, it is not possible from the builder.

You can follow here :
www.j-cook.pro/forum/9-coding-inside-you...-3rd-level-item#6222

It has been treated several times on the forum.

...and you can try the tutorial (in french for the moment) :
www.j-cook.pro/files/workshop.zip
Coding is now a piece of cake

Please Log in or Create an account to join the conversation.

Re: many-to-many db relations 22 Dec 2012 13:36 #6228

  • Julien
  • Julien's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 8
  • Thank you received: 0
Thanks Chief!

I'll have a look to this! :)
BTW, I'm french, so this is not a problem for the tutorials.

Best.

Please Log in or Create an account to join the conversation.
  • Page:
  • 1
Forum
Support forum
FAQ
many-to-many db relations
Time to create page: 0.256 seconds
“
”

Awards for the best Joomla app. This product is gonna win an award for this amazing job. Cook Self Service is the the best application from all over the Joomla universe ! It brings Joomla to a professional level really advanced for developers. It is a real fun to develop with it. The ACL part and security checks implementation are just... so much hours saved. I can now concentrate myself more on the design part and the creative works. Thank you so much. Guys I offer you all my congratulation ! Keep up the works because Joomla is needing it to increase the quality of extensions availables on the JED. I also learned a lot because I can see how to code at the proper place and I found all my answers reading the forum.
lack_hanson (JED)
          

Get Started

Log In Sign In