Send multidimensional form array via .ajax post to PHP prepared statement

Question

I understand how to send this form normally with a regular submit. I however am confused as to how to send my multidimensional form array via .ajax.

My form:

<form action="week_update.php" id="theform" method="post">   
 <input type="text" name="data[][wednesday_crew]" value=""/>
 <input type="text" name="data[][thursday_crew]" value=""/>
 <input type="text" name="data[][friday_crew]" value=""/>
 <input type="text" name="data[][saturday_crew]" value=""/>
 <input type="text" name="data[][sunday_crew]" value=""/>

My PHP:

$stmt = $connection->stmt_init();

if($stmt->prepare("UPDATE tableName SET ... = ?, ... = ?,)) {

// Bind your variables
$stmt->bind_param('ss', $.., $..,);

// get the multi array from form
$returnedData = $_POST['data'];

//let's loop through it.
for($i=0;$i<count($returnedData);$i+=2){
  $log_dates_ID = $returnedData[$i]['...'];
  $crew_chief = $returnedData[$i+1]['...'];
  $stmt->execute();
}

If you do a form serialization that should work, since you just need to send the urlencoded string to your script — Carlos Rocha
– Carlos Rocha, Commented Feb 5, 2014 at 21:04

Kevin Lynch · Accepted Answer · 2014-02-05 21:05:31Z

1

This is relatively easy, if i have understood you correctly. I answered a question similar to this a while back.

$("#theform").submit(function() {

    var url = "path/to/your/script.php"; // the script where you handle the form input.

    $.ajax({
           type: "POST",
           url: url,
           data: $("#theform").serialize(), // serializes the form's elements.
           success: function(data)
           {
               alert(data); // show response from the php script.
           }
         });

    return false; // avoid to execute the actual submit of the form.
});

answered Feb 5, 2014 at 21:05

Kevin Lynch

24.7k3 gold badges38 silver badges39 bronze badges

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

5 Comments

user1040259 Over a year ago

Thanks! What about on the server side?

Kevin Lynch Over a year ago

Server side - The php in your example works, as you said. As this is the case put that code in a file path/to/your/script.php and it will execute on form submission.

user1040259 Over a year ago

The form is submitting, but the data is not being inserted into my database. Any other quick ideas? Thanks again!

Kevin Lynch Over a year ago

For the purpose of error checking, use a form with one input field with a basic value and also ensure your script has a DB connection.

user1040259 Over a year ago

Yes, I can also use the print_r function and see the array. No worries, I'll figure it out. Thanks for your time.

Marc B · Accepted Answer · 2014-02-05 21:06:33Z

1

You've almost got it, but your input elements should be

<input .... name="data[friday_crew][]" />
                                   ^^--

That'll produce a sub-array under `data for every type you've got. Right now yours will be build some hideous franken-array that'll be really ugly to traverse/analyze. By comparison, the above version you can simply have

foreach($_POST['data']['friday_crew'] as $key => $val) {
    $fri_crew = $val;
    $sat_crew = $_POST['data']['sat_crew'][$key];
    etc...
}

answered Feb 5, 2014 at 21:06

Marc B

362k44 gold badges433 silver badges508 bronze badges

Collectives™ on Stack Overflow

Send multidimensional form array via .ajax post to PHP prepared statement

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related