一次插入多个记录

Question

Hello I have a form like below:

<form method="post" action="">
<fieldset><legend>Products List</legend>
    <ul>
    <li><input type='hidden' name='product[]' value='1'/>Product 1</li>
    <li><input type='hidden' name='product[]' value='2'/>Product 2</li>
    <li><input type='hidden' name='product[]' value='3'/>Product 3</li>
    <li><input type='hidden' name='product[]' value='4'/>Product 4</li>
    <li><input type='hidden' name='product[]' value='5'/>Product 5</li>
    </ul>
    <input type='submit' name='submit' value='Save'/>
</fieldset>
</form>

I want to know how to insert all the product id in the hidden field value.

Thanks in advance

Answer 1

<?php  
foreach($_POST['product'] as $key=>$val)
{ 
  $product_id = mysql_real_escape_string($val);
  $sql = "INSERT INTO table (id,product_id) VALUES (NULL,'".$product_id."')";
  mysql_query($sql) or die(mysql_error());
}
?>

Hope this will help you.