How to save array of records into the DB

[snakez]

Guyz... i really need your help so badly.This thing is really complicated for me.

I have these codes below for you to refer on what is going on with it but i think my problem is during saving only... Well anyway, basically I had a row with 3 elements or columns(Partname,Partnumber,version). Everytime I clicked the "Add Part" button, it will call the javascript addPart() function in which it will add another row of elements. The values on each element of every row is stored in an array variable. When Im going to click submit button, all the data inputted to every columns should be saved into the database. The problem is, it doesn't work.... maybe there something wrong with my code during saving.

This my Javascript code:

<script language="JavaScript" type="text/javascript">

    function addPart()
    {
            var tbl = document.getElementById('myTable')
            var nRow = tbl.rows.length - 13
            var row = tbl.insertRow(nRow)
            var blankCell = row.insertCell(0)
            var addCell = row.insertCell(1)
            var PartText = new Array(3)
            var Append = addCell.appendChild
            var Caption = document.createTextNode

            for(var i=1;i<=3;i++)
            {
                    PartText[i] = document.createElement('input')
                    PartText[i].type = 'text'
                    PartText[i].id = 'addPart[]'
                    PartText[i].name = 'addPart[]'
            }

            PartText[1].value ='<?=$addpartname?>'
            PartText[2].value ='<?=$addpartnumber?>'
            PartText[3].value ='<?=$addversion?>'

            blankCell.bgColor="#f1f1f1"
            addCell.bgColor="#f1f1f1"

            Append(Caption('       Part Name: '))
            Append(PartText[1])
            Append(Caption('       Part Number: '))
            Append(PartText[2])
            Append(Caption('       Version: '))
            Append(PartText[3])
    }

My HTML code:

<tr>
<td bgcolor='#f1f1f1'></td>
<td bgcolor='#f1f1f1' align='left'>

Part Name: <input type="text" class='bginput'name="addPart[]"  id='addPart[]' value='<?=$addpartname?>

Part Number: <input type="text" class='bginput' name="addPart[]" id='addPart[]' value='<?=$addpartnumber?>'/>

Version: <input type="text" class='bginput' name="addPart[]"  id='addPart[]' value='<?=$addversion?>'/>

</td>
</tr>

<tr>
                <td bgcolor='#f1f1f1' align='right'>
                        <input type="button" name='add' value="Add Part" onclick=addPart() />
                </td>
</tr>

<tr>
       <td>
                <input type='submit' name="submit" value="Submit">
                <input type='reset' value="Reset">
       </td>
</tr>

My code during saving...

for($i=1;$i<=3;$i++)
{
      $addpartname=$_POST['addPart'][$i];
      $addpartnumber=$_POST['addPart'][$i];
      $addversion=$_POST['addPart'][$i];

  $q= "INSERT INTO PARTS (partname, partnumber, version) VALUES ('$addpartname','$addpartnumber','$addversion')";

   mysql_query($q);
}

[NogDog]

I think you need to give each form field a different name:

Part Name: <input type="text" class='bginput'name="addPart[]"  id='addPart[]' value='<?=$addpartname?>
Part Number: <input type="text" class='bginput' name="addNumber[]" id='addNumber[]' value='<?=$addpartnumber?>'/>
Version: <input type="text" class='bginput' name="addVersion[]"  id='addVersion[]' value='<?=$addversion?>'/>

Adjust your JavaScript accordingly to use those input element names. Then in your PHP:

// remember that arrays normally start indexing at zero:
for($i = 0; $i < count $_POST['addPart']; $i++)
{
   $addpartname=$_POST['addPart'][$i];
   $addpartnumber=$_POST['addNumber'][$i];
   $addversion=$_POST['addVersion'][$i];

   $q= "INSERT INTO PARTS (partname, partnumber, version) VALUES ('$addpartname','$addpartnumber','$addversion')";

   mysql_query($q);}
}

[snakez]

You know what? i've been working this problem since last week and i didn't make it myself. Thanks a lot my friend... it really works although you forgot one thing, count() is a function so the $_POST['addPart'] should be enclosed with parenthesis. Well, that's not a big deal anyway... Thanks again... 🙂

[bradgrafelman]

Don't forget to mark this thread resolved (if it is).

[snakez]

Im sorry for that, im just a newbie here actually... tnx for reminding...

Anyway, i thought im finished with my problem... but no, not yet... well actually i already resolved the problem above particularly on how to save the array of records into the database(I appreciate that NogDog 🙂 ). The problem now is that how can i output the following array of records?