how to insert multiple rows into mysql
Posted: Mon Feb 06, 2012 5:04 pm
Hi all, i have a form containing 11 fields in it. i have a javascript to duplicate the form. Basically it's a students group admission form. When a student fills this form and click 'Add More Student in Group' button the javascript insert the same whole form immediately below, Student can add as many as form they wanted. It works fine. Now i want to insert the all forms data into database. I am checking the values of the form using foreach loop like this and it works fine. Now the problem is that i have total 11 fields in my form like (myName[],myGender[],myCity[],myProvince[])etc, i am confused how to make a loop and place query inside the loop to insert these values into database.
Here is my form code
Code: Select all
$myName= $_POST["myName"];
foreach ($myNameas $eachName) {
echo 'Gender: '. $eachName. "<br>";
}Here is my form code
Code: Select all
<form method='POST' action='go.php'>
<div id='dynamicInput'>
Applicant Name: <br /><input type='text' name='myName[]'>
Applicant Gender:<br /> <input type='radio' name='myGender[]' value='Male'> Male <input type='radio' name='myGender[]' value='Female'> Female
Applicant DOB:
<select style='width:95px;' class='validate[required]' name='myDobM[]' id='myDobM[]'>
<OPTION value=''>Month</OPTION>
<OPTION value=1>January</OPTION>
<OPTION value=2>February</OPTION>
<OPTION value=3>March</OPTION>
<OPTION value=4>April</OPTION>
<OPTION value=5>May</OPTION>
<OPTION value=6>June</OPTION>
<OPTION value=7>July</OPTION>
<OPTION value=8>August</OPTION>
<OPTION value=9>September</OPTION>
<OPTION value=10>October</OPTION>
<OPTION value=11>November</OPTION>
<OPTION value=12>December</OPTION>
</select>
<select size='1' name='myDobD[]' id='myDobD[]' class='validate[required]' style='width:95px;'>
<OPTION value=''>Day</OPTION>
<OPTION value='1'>1</OPTION>
<OPTION value='2'>2</OPTION>
<OPTION value='3'>3</OPTION>
<OPTION value='4'>4</OPTION>
<OPTION value='5'>5</OPTION>
<OPTION value='6'>6</OPTION>
<OPTION value='7'>7</OPTION>
<OPTION value='8'>8</OPTION>
<OPTION value='9'>9</OPTION>
<OPTION value='10'>10</OPTION>
<OPTION value='11'>11</OPTION>
<OPTION value='12'>12</OPTION>
<OPTION value='13'>13</OPTION>
<OPTION value='14'>14</OPTION>
<OPTION value='15'>15</OPTION>
<OPTION value='16'>16</OPTION>
<OPTION value='17'>17</OPTION>
<OPTION value='18'>18</OPTION>
<OPTION value='19'>19</OPTION>
<OPTION value='20'>20</OPTION>
<OPTION value='21'>21</OPTION>
<OPTION value='22'>22</OPTION>
<OPTION value='23'>23</OPTION>
<OPTION value='24'>24</OPTION>
<OPTION value='25'>25</OPTION>
<OPTION value='26'>26</OPTION>
<OPTION value='27'>27</OPTION>
<OPTION value='28'>28</OPTION>
<OPTION value='29'>29</OPTION>
<OPTION value='30'>30</OPTION>
<OPTION value='31'>31</OPTION>
</select>
<select size='1' name='myDobY[]' id='myDobY[]' class='validate[required]' style='width:100px;'>
<OPTION value=''>Year</OPTION>
<OPTION value='2012'>2012</OPTION>
<OPTION value='2011'>2011</OPTION>
<OPTION value='2010'>2010</OPTION>
<OPTION value='2009'>2009</OPTION>
<OPTION value='2008'>2008</OPTION>
<OPTION value='2007'>2007</OPTION>
<OPTION value='2006'>2006</OPTION>
<OPTION value='2005'>2005</OPTION>
<OPTION value='2004'>2004</OPTION>
<OPTION value='2003'>2003</OPTION>
<OPTION value='2002'>2002</OPTION>
<OPTION value='2001'>2001</OPTION>
</select>
</div>
Applicant City:<br /> <input type='text' name='myCity[]'>
Applicant Province:
<select name='myProvince[]'>
<OPTION value='Province1'>Province 1</OPTION>
<OPTION value='Province2'>Province 2</OPTION>
<OPTION value='Province3'>Province 3</OPTION>
</select>
Applicant School:<br /> <input type='text' name='mySchool[]'>
Applicant Group (Class):<br /> <input type='text' name='myClass[]'>
Applicant Strengths: <textarea name='myStrenghts[]' rows='5' cols='25'></textarea>
Applicant Weakneses: <br /> <textarea name='myWeakneses[]' rows='5' cols='25'></textarea>
</div>