多个复选框到php中的数据库

Question

i have a code which allows the user to select multiple check-boxes.

while($data2=mysql_fetch_array($result))
{
echo "<input type=\"checkbox\" name=\"pid[]\" value=\"{$data2['product_id']}\">         {$data2['product_id']} {$data2['product_name']}</option>";
echo"<br/>";
}

i want to enter the checked values in database.

$pid=$_POST['pid'];
for ($i=0;$i<count($pid);$i++)
{

$information="INSERT INTO     orders(productid,product_discount,amount,customerid,order_date,quantity) VALUES('$pid','$discount','$amount','$custid',CURDATE(),'')";
$result=mysql_query($information) or die(mysql_error());
}

this is not working.please help/

Answer 1

Are posting this data how? You need to submit this data and get it.

Perhaps this article will help you:

http://corpocrat.com/2009/05/24/how-to-store-and-retreive-checkbox-value-in-mysql-with-php/

Cheers.