[Solved] Inserting data into mySQL table from mutlidimensional input form

by


What I’m assuming is..

SomePage.php

<input type="text" name="quantity[]">
<input type="text" name="description[]">
<input type="text" name="article[]">
<input type="text" name="price[]">
<input type="text" name="tax[]">
<input type="text" name="discount[]">

Submit_Some_Page.php

<?
extract($_POST);

$TotalArticle=sizeof($article);

for($i=0;$i<$TotalArticle;$i++)
{
    $Article=$article[$i];
    $Quanity=$quantity[$i];
    $Price=$price[$i];
    $Tax=$tax[$i];
    $Discount=$discount[$i];
    $Description=$description[$i];

    <-- Now, Write Insert Query Here..
    $Query="INSERT INTO TableName SET Col1Name=$Article,Col2Name=$Quanity,Col3Name=$Price,Col4Name=$Tax,Col5Name=$Discount,Col6Name=$Description";
      ..... Write Mysql Query To Execute It
}
?>

3

solved Inserting data into mySQL table from mutlidimensional input form