How to insert many records into a table from HTML form using php MySQL?

Question

I have a form with 640 cards each with a checkbox so the user can mark the ones he owns.

I'm wondering how to write the update SQL statement to take each of the 640 card ids and insert/update into the db.

Each row is created by this code:

echo "<td>"?>
         <form name="some form" action="editform.php" method="post">
         <input type="checkbox" name="<?php 
echo $row['stickerID'] ?>" value=" <?php echo $row['stickerStatus'] ?> ">
         <?php "</td>";
echo "</tr>"; 
}

I know I need some kind of for each loop in php. But how do I get the 640 individual checkboxes from the post?

Var_dump the $_post and look at the checkbox values. From there do a foreach post ... — ScottMcGready
– ScottMcGready, Commented Apr 9, 2014 at 3:36

user557846 · Accepted Answer · 2014-04-09 03:37:34Z

2

suggest you name them like so

<input type="checkbox" name="stickerid[<?php 
echo $row['stickerID'] ?>]" value=" <?php echo $row['stickerStatus'] ?> ">

then you can loop through the $_POST['stickerid'] array

foreach($_POST['stickerid'] as $k=>$v ){
//code
//$k=id
//$v=status
}

answered Apr 9, 2014 at 3:37

user557846

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

1 Comment

Bryan Over a year ago

beat me to the punch.

Collectives™ on Stack Overflow

How to insert many records into a table from HTML form using php MySQL?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related