Submit multiple fields of the same name to php

Question

I want to create a table that users can fill with values and submit to a database. Each row of the table should be saved as an individual row in the table. Table example is shown below.

First | Last  | Phone
Steve | Jones | 1234
Jason | Smith | 4567
Mark  | Black | 6789

Submit

I'm creating my table as a form and submitting using POST. How can I submit each row as an individual row to my database, using only 1 submit button?

show some code you've written – jitendrapurohit Dec 23 '15 at 10:49 — jitendrapurohit, Dec 23 '15 at 10:49

score 1 · Answer 1 · answered Dec 23 '15 at 10:56

<form method='POST' action='submitPage.php'>
    <table>
        <tr>
            <td><input name='first[]'></td>
            <td><input name='last[]'></td>
            <td><input name='phone[]'></td>
        </tr>
        <tr>
            <td><input name='first[]'></td>
            <td><input name='last[]'></td>
            <td><input name='phone[]'></td>
        </tr>
        .
        .
    </table>
    <input type='submit' value='submit details'>
</form>

submitPage.php

<?
$first = $_POST['first'];
$last = $_POST['last'];
$phone = $_POST['phone'];

$totalFirstName = sizeof($first);

for($i=0;$i<$totalFirstName;$i++)
{
    $FirstName = $first[$i];
    $LastName = $last[$i];
    $Phone = $phone[$i];

    $Query = "INSERT INTO TableName SET first='$FirstName', last='$LastName', phone='$Phone'";
    //Execute Your Query 
}

?>

Please Tell Reason Of Downvote ?? **Don't Simply Downvote and escape** — Nana Partykar, Dec 23 '15 at 11:00

score 0 · Accepted Answer · edited May 23 '17 at 12:31

0

<input ... name="contact[1][first]">
<input ... name="contact[1][last]">
<input ... name="contact[1][phone]">
...
<input ... name="contact[2][first]">
<input ... name="contact[2][last]">
<input ... name="contact[2][phone]">

Also check out this question.

P.S. you need to google better.

edited May 23 '17 at 12:31

Community

1
1

answered Dec 23 '15 at 10:49

Alexander Mikhalchenko

4,525
3
32
56

I didn't use your working but I did use the working in the question you linked so thanks for the help. I shall improve my googling skills before my next question. – monkeyman Dec 23 '15 at 11:16

Jack hardcastle · Answer 3 · 2015-12-23T10:59:36.077

<form>
    <fieldset>
        <input name="first[]" type="text"/>
        ....

May be useful to you, having the field names as arrays allows you to iterate over them, such as:

<?php 
    $firsts = $_POST["first"];
    $lasts = $_POST["lasts"];
    $num = $_POST["numbers"];

    if(count($firsts) == count($lasts) == count($num) {
        for($i = 0; $i < count($firsts); $i++) {
            $toSubmit = [$firsts[$i], $lasts[$i], $num[$i]];
            // put that into your SQL inserts w/e.
        }
    }
?>

Submit multiple fields of the same name to php

3 Answers3