[SOLVED] Multiple inserts into one records

[Merdok]

Hi Guys,

 

This question is actually part PHP, Part MySQL and part AJAX so I hope I'm ok posting it in here, if not feel free to move it to its rightful home.

 

Bascially, I've built an e-commerce site and the client wants the option to create product sets, whereby he can add a selection of products together to form one 'meta product'.

 

I figured the best way of doing this would be to create an array called 'setItems[]' and the form to create new instances of 'setItems[]' whenever the user clicks on an 'add new product' link.

 

This would then add item ID's to the array which will then be inserted into the DB... I presume this is the right way of doing it, the one place I'm kinda stuck on is the AJAX'y part, I've no idea on how to make the 'add new product' link create another form entry. I've used JQuery exactly once and even then it was basically cut'n'paste.

[ohdang888]

i don;t understand your problem...are the items being inserted into the database successfully? or is it JUST adding another element to the form thats throwing you off?

[Merdok]

Yeah its just adding another entry to the form, Thinking about it, that title wasnt really the best one to give was it

[Merdok]

Ok I've made some progress using jQuery but it is inserting the field at the bottom of the page rather than below the previous element like I want it to do. Here is the code:

 

 function addAnother() {  
jQuery('#addSetForm').append('<input type="text" name="setItems[]" id="setItems[]" />');
}

[ohdang888]

so you want it to perform an ajax function, then add another element?

[Ken2k7]

Merdok,

There's nothing wrong with the jQuery. I would probably just check what #addSetForm element is and make sure that is the element you want to add the input. If it's adding to the bottom of the page, you probably don't want to add to #addSetForm but something else. In any case, please know that you should have only one ID per page so you'll have to change id="setItems[]" to something else. You can use a class like class="setItems" but IDs should be unique so if you have more than one on the same page, it's not good.

[Merdok]

Ah!

 

Yeah that makes sense, it was appending the box to the end of the form, I added a named div around the box and it worked.

 

Re: the form ID, I actually know that, clearly just a moment of stupidity, Thanks for pointing it out.