Multiple Inputs Insert

Question

I have an application that looks like this:

enter image description here

As you can see, each row contains either a group heading (the rows where there is just an input), or a ingredient form (where there is a small input, then a select, then another larger input).

I use Javascript to add the new spans. I use the following PHP to group each ingredient span into an array, determine the order (because each span can be moved to a different order), and insert into my database.

foreach($_POST as $key => $value) {
        $value = $this->input->post($key);
        $ingredientQTY = $this->input->post('ingredientQTY');
        $measurements = $this->input->post('measurements');
        $ingredientNAME = $this->input->post('ingredientNAME');
        $ingredientsROW[] = array($ingredientQTY, $measurements, $ingredientNAME);
      
        for ($i = 0, $count = count($ingredientQTY); $i < $count; $i++) {
            $rows[] = array(
                'ingredientamount'      => $ingredientQTY[$i],
                'ingredientType'        =>  $measurements[$i],
                'ingredientname'        => $ingredientNAME[$i],
                'recipe_id'             => $recipe_id,
                'order'                 => $i + 1,
                'user_id'               => $user_id
            );
            $sql = "INSERT `ingredients` (`ingredientamount`,`ingredientType`,`ingredientname`, `recipe_id`, `order`, `user_id`) VALUES ";
            $coma = '';
            foreach ($rows as $oneRow) {
                $sql .= $coma."('".implode("','",$oneRow)."')";
                $coma = ', ';
            }
            
        }
        $this->db->query($sql);
        break;
}

This works wonders for inserting the ingredient rows. But I'm not sure how to insert group headings (which must be placed in the for loop to keep the order, the $i + 1, going).

I think I've figured out two solutions(though there may be others, and these might not even work):

Have the group heading input field have the same name value as one of the ingredient text fields, and send a hidden value along with it, saying its a group heading?
Send it as different input field with a different name value?

My question is: how can I do this with my current code, and are either of these efficient solutions, or is there an even better solution?

Thanks for all help! If you need more details, just ask!

Joshua - Pendo · Accepted Answer · 2013-03-27 23:52:43Z

1

You could use an empty heading like <input type="hidden" name="groupheading[]" value="product" /> and the open one like <input type="text" name="groupheading[]" value="" />. The first one should be inside the product-span.

This way, you can continue your loop just the way you are doing now. And $_POST['groupheading'][$key] either returns a groupheading or the phrase 'product'. So, in your script it would be:

if($_POST['groupheading'][$key] == "product") {
  // insert product
} else {
  // insert group heading
}

I think I helped you this morning or yesterday with an answer.. it's still a bit a weird way you are using to get the effect you need. It can be achieved much easier.

edited Mar 27, 2013 at 23:52

answered Mar 27, 2013 at 23:47

Joshua - Pendo

4,4016 gold badges39 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Muhambi Over a year ago

Thanks for the answer! What do you mean by it can be achieved much easier?

Joshua - Pendo Over a year ago

Well, it seems that the setup you are using for your form (the HTML part) can be used in combination with much simpler code to achieve what you are trying to do. It has nothing to do with this question however and might be just a personal opinion on the way I tackle my programming problems :)

Muhambi Over a year ago

I'm fairly new at PHP, so if there's a better way, I'd love to hear about it!

Joshua - Pendo Over a year ago

That would invole a larger example including some HTML and jQuery functions. You'll learn the most from trial-error coding and solving the issues you run into :)

Collectives™ on Stack Overflow

Multiple Inputs Insert

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related