Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
Forum
Support forum
Design your application
[SOLVED] How to make one to many relation in brick
  • Page:
  • 1

TOPIC:

[SOLVED] How to make one to many relation in brick 12 Oct 2011 19:26 #214

Hello,

First, thanks for this fantastic tool !

Here what i want to do :

I create two tables : product [ id, label] and picture[ id, pathToFile, product_id]

I well understand how to link my picture table to the product. I made a form to create picture and i can choose the associated product by a dropdown.

But that's not really what i would : i would prefered have the possibility to create several pictures directly in the product form.

Is it possible ?

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

Last edit: by admin.

Re: How to make one to many relation in the form brick 13 Oct 2011 02:32 #215

Hi axoloth. It is indeed a fantastic tool!

Well, I think you may have to create an associative table to do what you need here. Would be something like: product( product_id , label ), picture( picture_id , pathToFile ) and, the associative table, product_pictures( picture_id , product_id ). In that way we would be able to associate 'n' pictures to any product.

But I'm also trying to figure out how to "manage" that kind of relationship in the form brick,sry :dry:

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

Re: How to make one to many relation in the form brick 13 Oct 2011 05:59 #216

Good morning,

Sorry for my poor english, i think i didn't well expose my problem.

Deenison, that's not a database relations' problem. Having a product_picture will only permit to re-use a photo for others products. Having a foreign key in product_id in picture is suffisant to join n pictures to one product ;) .

My problem, is how can i do in Cook to iterate the creation of my pictures, in the same view as the product's one.

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

Last edit: by axoloth.

Re: How to make one to many relation in the form brick 13 Oct 2011 16:45 #219

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
No, I facts, it is not possible for the moment.

You must write by yourself this functionality.


Look how Cook is dealing with Models...

Fiew lines in the view file :
$modelPictures =& JModel::getInstance('Pictures', 'XxxxsModel');
$modelPictures->addWhere("a.product = " . (int)$MyproductID);
$pictures = $modelPictures->getData();


Hope this will help you
Coding is now a piece of cake

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

Last edit: by admin.

Re: How to make one to many relation in the form brick 14 Oct 2011 06:19 #237

Yes, that's what i supposed regarding the code.

Maybe it's an interresting add for futurs versions of Cook...

I will write this by the hand.

Thanks for replies.

Please Log in or Create an account to join the conversation.
  • Page:
  • 1
Forum
Support forum
Design your application
[SOLVED] How to make one to many relation in brick
Time to create page: 0.089 seconds
“
”

This is what you call a component builder. I was able to master using this in a very short time and the resulting component works like a charm. Not just a basic component builder but a fully working component builder with forms fields tables all ready to go. You can make the list and item views to display in the front and back end. Also there is a great forum just starting to evolve and I'm sure this will grow very rapidly when you all realise how good this tool is.
Kevin (JED)

         

Get Started

Log In Sign In