Problem with making array of text-boxes
Posted: Wed Apr 07, 2010 2:13 am
Hello guys, Please help me...
I am facing a problem while making array of 5 text-boxes of 4 specific products and also problem with save them to mysql (data inserted but not all)... here is html code
Product 1
<input name="demProDesc[]" id="demProDesc[]" type="text" size="15" />
<input name="pufsampling[]" id="pufsampling[]" type="text" size="15" />
<input name="openStock[]" id="openStock[]" type="text" size="15" />
<input name="closeStock[]" id="closeStock[]" type="text" size="15" />
<input name="sold[]" id="sold[]" type="text" size="15" />
Product 2
<input name="demProDesc[]" id="demProDesc[]" type="text" size="15" />
<input name="pufsampling[]" id="pufsampling[]" type="text" size="15" />
<input name="openStock[]" id="openStock[]" type="text" size="15" />
<input name="closeStock[]" id="closeStock[]" type="text" size="15" />
<input name="sold[]" id="sold[]" type="text" size="15" />
Product 3
<input name="demProDesc[]" id="demProDesc[]" type="text" size="15" />
<input name="pufsampling[]" id="pufsampling[]" type="text" size="15" />
<input name="openStock[]" id="openStock[]" type="text" size="15" />
<input name="closeStock[]" id="closeStock[]" type="text" size="15" />
<input name="sold[]" id="sold[]" type="text" size="15" />
Product 4
<input name="demProDesc[]" id="demProDesc[]" type="text" size="15" />
<input name="pufsampling[]" id="pufsampling[]" type="text" size="15" />
<input name="openStock[]" id="openStock[]" type="text" size="15" />
<input name="closeStock[]" id="closeStock[]" type="text" size="15" />
<input name="sold[]" id="sold[]" type="text" size="15" />
php code...
foreach ($_POST['demProDesc'] as $value1)
{
}
foreach ($_POST['pufsampling'] as $value2)
{
}
foreach ($_POST['openStock'] as $value3)
{
}
foreach ($_POST['closeStock'] as $value4)
{
}
foreach ($_POST['sold'] as $value5)
{
}
$sql2="insert into demo_products set demoID='$demoID', demProDesc='$value1', pufsampling='$value2', openStock='$value3', closeStock='$value4', sold='$value5' ";
mysql_query ($sql2);
I am facing a problem while making array of 5 text-boxes of 4 specific products and also problem with save them to mysql (data inserted but not all)... here is html code
Product 1
<input name="demProDesc[]" id="demProDesc[]" type="text" size="15" />
<input name="pufsampling[]" id="pufsampling[]" type="text" size="15" />
<input name="openStock[]" id="openStock[]" type="text" size="15" />
<input name="closeStock[]" id="closeStock[]" type="text" size="15" />
<input name="sold[]" id="sold[]" type="text" size="15" />
Product 2
<input name="demProDesc[]" id="demProDesc[]" type="text" size="15" />
<input name="pufsampling[]" id="pufsampling[]" type="text" size="15" />
<input name="openStock[]" id="openStock[]" type="text" size="15" />
<input name="closeStock[]" id="closeStock[]" type="text" size="15" />
<input name="sold[]" id="sold[]" type="text" size="15" />
Product 3
<input name="demProDesc[]" id="demProDesc[]" type="text" size="15" />
<input name="pufsampling[]" id="pufsampling[]" type="text" size="15" />
<input name="openStock[]" id="openStock[]" type="text" size="15" />
<input name="closeStock[]" id="closeStock[]" type="text" size="15" />
<input name="sold[]" id="sold[]" type="text" size="15" />
Product 4
<input name="demProDesc[]" id="demProDesc[]" type="text" size="15" />
<input name="pufsampling[]" id="pufsampling[]" type="text" size="15" />
<input name="openStock[]" id="openStock[]" type="text" size="15" />
<input name="closeStock[]" id="closeStock[]" type="text" size="15" />
<input name="sold[]" id="sold[]" type="text" size="15" />
php code...
foreach ($_POST['demProDesc'] as $value1)
{
}
foreach ($_POST['pufsampling'] as $value2)
{
}
foreach ($_POST['openStock'] as $value3)
{
}
foreach ($_POST['closeStock'] as $value4)
{
}
foreach ($_POST['sold'] as $value5)
{
}
$sql2="insert into demo_products set demoID='$demoID', demProDesc='$value1', pufsampling='$value2', openStock='$value3', closeStock='$value4', sold='$value5' ";
mysql_query ($sql2);