How to update multiple rows using array

Question

I have this form

<tr role="row" class="odd">
<td>Category Name</td>
<td> <input type="text" value=""  class="form-control"  name="eids[<?php echo $id?>]"></td>
</tr>

And here is how i update

include "config.php";
foreach($_POST['eids'] as $key=>$value){ 
    $updateq=$conn->prepare("UPDATE  `table_name` SET table_row='$value' WHERE sn='$key'");
    $updateq->execute();
    }

When I submit let say three records ie(A,B,C) Table updated like this (C,C,C). Please help

Basically keep the name the same and put the unknown in the `value` attribute `` See the DUP For more details — RiggsFolly, Jul 01 '21 at 13:23

score 0 · Accepted Answer · answered Jul 01 '21 at 13:20

0

on this page:

PHP: Possible to automatically get all POSTed data?

i found this:

Sure. Just walk through the $_POST array:

foreach ($_POST as $key => $value) {
    echo "Field ".htmlspecialchars($key)." is ".htmlspecialchars($value)."<br>";
}

answered Jul 01 '21 at 13:20

DafuQi

138
4

I got this error: Warning: htmlspecialchars() expects parameter 1 to be string, – Mamouz Jul 01 '21 at 13:51

How to update multiple rows using array

1 Answers1