multiple arrays data posting and mysql insert using foreach php

Question

i have form as below with same name text field columns, i want to insert multiple arrays data to mysql using this below form. pls tell me how to do this using foreach in php mysql

First Column

<input  name="date[]" type="text" class="datepicker">
<input type="text" name="local[]" />
<input type="text" name="desc[]" />
<input type="text" name="ta[]" />
<input type="text" name="car[]" />

Second Column

<input  name="date[]" type="text" class="datepicker">
<input type="text" name="local[]" />
<input type="text" name="desc[]" />
<input type="text" name="ta[]" />
<input type="text" name="car[]" />

Please show us what you have tried so far

lxop
– lxop

2013-04-25 05:12:44 +00:00
Commented Apr 25, 2013 at 5:12 — lxop
– lxop, Commented Apr 25, 2013 at 5:12

jraede · Accepted Answer · 2013-04-25 05:14:29Z

2

First of all I would rename your form fields to make this easier:

<?php
$number_of_columns = 2;
for($i=0;$i<$number_of_columns;$i++) :?>
    <input  name="col[<?=$i?>][date]" type="text" class="datepicker">
    <input type="text" name="col[<?=$i?>][local]" />
    <input type="text" name="col[<?=$i?>][desc]" />
    <input type="text" name="col[<?=$i?>][ta]" />
    <input type="text" name="col[<?=$i?>][car]" />
<?php endfor;?>

And then once you get the data, you can just loop through the $_POST['col'] array and insert each one individually into the database. I'm assuming here that you've already connected to your database and are using the mysql library.

$cols = $_POST['col'];
$table = 'table_name';
foreach($cols as $col) {
    $local = mysql_real_escape_string($col['local']);
    $desc = mysql_real_escape_string($col['desc']);
    $ta = mysql_real_escape_string($col['ta']);
    $car = mysql_real_escape_string($col['car']);
    mysql_query("INSERT INTO `{$table}` (`local`, `desc`, `ta`, `car`) VALUES('{$local}', '{$desc}', '{$ta}', '{$car}')") or die(mysql_error());
}

answered Apr 25, 2013 at 5:14

jraede

6,9165 gold badges31 silver badges33 bronze badges

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

1 Comment

Php Gemini Over a year ago

Thank You jraede it is working great. i am searching for two days for this. thank you.

Michael Sivolobov · Accepted Answer · 2013-04-25 05:14:13Z

0

Try this code:

extract($_POST);
$n = count($date);
for ($i = 0; $i < n; $i++) {
    $query = 'INSERT INTO `table` (`c1`, `c2`, `c3`, `c4`, `c5`) VALUES (\'' . $date[$i] . '\', \'' . $local[$i] . '\', \'' . $desc[$i] . '\', \'' . $ta[$i] . '\', \'' . $car[$i] . '\')';
    // Here you must execute your query
}

answered Apr 25, 2013 at 5:14

Michael Sivolobov

13.9k5 gold badges48 silver badges68 bronze badges

2 Comments

Php Gemini Over a year ago

Thank You Michael It is Working fine.

Php Gemini Over a year ago

Hai Michael can help me. Code working but inserting some blank rows in mysql table, because if we didn't type values in some rows in form.

Collectives™ on Stack Overflow

multiple arrays data posting and mysql insert using foreach php

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related