how to insert multiple rows from array values with input

Question

I have my table named i_table with columns:

id   name    req_qty  req_date     rcv_qty   rec_date
1    metal   1        2014-03-04
2    spring  5        2014-03-04

in my html/php:

<form action="insert.php" method="post">
<?php $resource2=mysql_query("SELECT * FROM i_table",$con);
    while($result2=mysql_fetch_array($resource2))
        { 
?>
<table>
<tr>
<td>
<input type="text" name="id" value="<?php echo $result2['id'];?>"/>
</td>
</tr>

<tr>
<td>
<input type="text" name="name" value="<?php echo $result2['name'];?>"/>
</td>
</tr>

<tr>
<td>
<input type="text" name="rcv[]" value="" />
</td>
</tr>

<tr>
<td>
<input type="date" name="rcv_date[]" value="" />
</td>
</tr>

</table>


<?php };?>

</form>

how can I insert in multiple arrays from an input according to their unique ID from db? pls help me here... huhu

Add the id as the key -> name="id[<?php echo $result2['id'];?>]",name="name[<?php echo $result2['id'];?>]", name="rcv[<?php echo $result2['id'];?>]",name="rcv_date[<?php echo $result2['id'];?>]". Then on post, using foreach() you can get the key id. — Sean
– Sean, Commented Mar 11, 2014 at 15:18
how can i do that? how to for each? please help... still learning php — user3117337
– user3117337, Commented Mar 11, 2014 at 15:23

Community · Accepted Answer · 2017-05-23 12:13:10Z

1

In your form, add the id as the key -

<form action="insert.php" method="post">
<?php $resource2=mysql_query("SELECT * FROM i_table",$con);
    while($result2=mysql_fetch_array($resource2))
        { 
?>
<table>
<tr>
<td>
<input type="text" name="id[<?php echo $result2['id'];?>]" value="<?php echo $result2['id'];?>"/>
</td>
</tr>

<tr>
<td>
<input type="text" name="name[<?php echo $result2['id'];?>]" value="<?php echo $result2['name'];?>"/>
</td>
</tr>

<tr>
<td>
<input type="text" name="rcv[<?php echo $result2['id'];?>]" value="" />
</td>
</tr>

<tr>
<td>
<input type="date" name="rcv_date[<?php echo $result2['id'];?>]" value="" />
</td>
</tr>

</table>

<?php };?>

</form>

Then on your insert.php where you post your form, get the id in your foreach -

<?php
 if(isset($_POST['id'])){
    foreach($_POST['id'] as $id=>$value){

    $sql = "UPDATE `i_table` SET `name` = '".$_POST['name'][$id]."', `rcv_qty` = '".$_POST['rcv'][$id]."', `rec_date` = '".$_POST['name'][$id]."' WHERE `id` = ".$id."";

    mysql_query($sql,$con);
    }
 }
?>

note the foreach() is just an example. You will want to sanitize your data before inserting/updating to prevent sql injection. see How can I prevent SQL injection in PHP?

edited May 23, 2017 at 12:13

CommunityBot

11 silver badge

answered Mar 11, 2014 at 15:47

Sean

12.4k3 gold badges31 silver badges49 bronze badges

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

2 Comments

user3117337 Over a year ago

where do i get the variable $value? where did this came from?

Sean Over a year ago

$value is just user defined variable inside a foreach() loop (it could also be $v, $x, $val, etc). It might be helpful for you to read the php manual foreach (array_expression as $key => $value) - php.net/manual/en/control-structures.foreach.php. I did not use it in my example, but it had to be there so I could access the $key, or it would produce a syntax error. Typically you would access/use the $value value.

Collectives™ on Stack Overflow

how to insert multiple rows from array values with input

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related