serialize() multiple rows in table with same name and send to php

Question

I'd like to serialzie multiple rows in my table using serialize() to update my database. The form data looks like this:

f_name=tom&l_name=riddle=&f_name=albus&l_name=dumbledore

If I send this data to php with $.post('file.php', formData, function(result) and log the returned result I can only see the last entry (f_name=albus&l_name=dumbledore). How can I send multiple rows with the same input fields to the php file?

Does this answer your question? [Multiple inputs with same name through POST in php](https://stackoverflow.com/questions/7880619/multiple-inputs-with-same-name-through-post-in-php) — gre_gor, May 22 '20 at 22:11

score 1 · Accepted Answer · answered May 22 '20 at 21:43

1

Give your inputs array-style names:

<input name="f_name[]" type="text">
<input name="l_name[]" type="text">

Then the correspoding $_POST variables will be arrays, with an element for each row. The form data will look like

f_name[]=tom&l_name[]=riddle=&f_name[]=albus&l_name[]=dumbledore

answered May 22 '20 at 21:43

Barmar

741,623
53
500
612

Thanks for your reply. Now I can loop through $_POST to update the datebase? – Mr. Potter May 22 '20 at 22:23
Yes, that's the usual technique. – Barmar May 22 '20 at 22:24
alright, and how do I know how many loops it needs? Should I count using `count($_POST['f_name'])`? So its no problem if I update the database x times after each other? – Mr. Potter May 22 '20 at 22:28
`foreach ($_POST['fname'] as $i => $fname)` – Barmar May 22 '20 at 22:28
Then you can use `$lname = $_POST['l_name'][$i];` – Barmar May 22 '20 at 22:29
This is no different from looping over any other array, which should be familiar territory. – Barmar May 22 '20 at 22:29
I use `bindParam` so I just loop through a for loop with a foreach loop for binding? Is this okay? Can we move this dicussion to chat? – Mr. Potter May 22 '20 at 22:58
Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/214453/discussion-between-barmar-and-mr-potter). – Barmar May 22 '20 at 22:59

serialize() multiple rows in table with same name and send to php

1 Answers1