multiple input fields with same name. how to save them all into db

Question

i am trying to store data from with same name fields of three different types

like

<td><input name="itemname[]" value="ball" ></td>
<td><input name="itemname[]" value="racket" ></td>
<td><input name="itemname[]" value="shoes" ></td>
<td><input  name="subitem[]" value="big"></td> 
<td><input  name="subitem[]" value="grenn"></td>
<td><input  name="subitem[]" value="sports"></td>
<td><input name="quantity[]" value="10"></td>
<td><input name="quantity[]" value="10"></td>
<td><input name="quantity[]" value="10"></td>

and now i trying to insert them into the table 'selected_items' and i want somethinglike

itemname | subitem | quantity

ball------- big------10

racket----- green ----10

shoes------ sports ----10

please help me

edited

i tried doing with foreach

foreach($_POST['quantity'] as $val) {

$sql2 = "INSERT INTO items_selected (jobsheet_id,item_name,subitem,quantity) VALUES ('$jobid','aaa', 'bbb', '{$val}')";

if (!mysqli_query($this->con,$sql2))
                {
                    die('Error: ' . mysqli_error($this->con));
                }

}

the problem in the above code, i can only insert one column values. how can i insert the values for other column from post array

thank you

Can you post the PHP code you currently have to do this, and any issues etc you have with it. — James
– James, Commented Sep 5, 2013 at 1:37
hi james i have edited my question please have a look thank you — user2748868
– user2748868, Commented Sep 5, 2013 at 2:32

user2748868 · Accepted Answer · 2013-09-05 12:21:27Z

2

Ok i have solved it. Thanks to others who tried to help me

$quanity = count($_POST['quantity']);

$item = $_POST['itemname'];
$sub = $_POST['subitem'];
$qty = $_POST['quantity'];

for($i=0;$i<$quanity;$i++){
echo $item[$i].' '.$sub[$i].' '.$qty[$i];
// you can also use insert sql query
}

answered Sep 5, 2013 at 12:21

user2748868

311 silver badge5 bronze badges

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

Comments

user1641165 · Accepted Answer · 2013-09-05 01:55:50Z

1

This is very easy.... You are posting all the information as an array.

You obviously want 3 database entries to be inserted each time. (You could make life simpler by just having three different names)

So on the php retrieval page you would do the following.

<?php

CONNECT TO DATABASE

$itemname = $_POST['ball'];
$subitem = $_POST['racket'];
$quantity = $_POST['racket'];

foreach($itemname as $itemname):
foreach($subitem as $subitem):
foreach($quantity as $quantity):

SQL QUERY HERE INSERTING $itemname, $subitem, $quantity

endforeach;
endforeach;
endforeach;

Close SQL Connection

?>

The above code will shoot off nine sql queries which is the ammount of combinations you could get. You could of course check to see is any value is empty and than skip inserting. Not quite sure what the point of this, let me know if you need more help.

edited Sep 5, 2013 at 1:55

answered Sep 5, 2013 at 1:48

user1641165

4332 gold badges4 silver badges18 bronze badges

4 Comments

user2748868 Over a year ago

thanks for the response mate. I have tried your code. the problem is it is insert the same values in a all rows

user2748868 Over a year ago

$itemname = $_POST['itemname']; $qualifier = $_POST['qualifier']; $quantity = $_POST['quantity']; foreach($itemname as $itemname): foreach($qualifier as $qualifier): foreach($quantity as $quantity): $sql2 = "INSERT INTO items_selected (jobsheet_id,item_name,qualifier,quantity) VALUES ('$jobid','{$itemname}', '{$qualifier}', '{$quantity}')"; if (!mysqli_query($this->con,$sql2)) { die('Error: ' . mysqli_error($this->con)); } endforeach; endforeach; endforeach;

user1641165 Over a year ago

Can you confirm that you actually want 9 inserts? If you don't then specify what you what the outcome to be.. And that code should work correctly. If you like, just print_r($value); and this will show you what is going into the database

user1641165 Over a year ago

Oh ok... so you've simplified it for the question. Wow... that could get a bit messy than with so many loops. For the second lets just get it working though. I'm still waiting for the output of the print_r???

Collectives™ on Stack Overflow

multiple input fields with same name. how to save them all into db

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related