how to insert multiple rows into mysql

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
Tassadduq
Forum Commoner
Posts: 60
Joined: Wed Dec 03, 2008 2:53 pm

how to insert multiple rows into mysql

Post by Tassadduq »

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

Code: Select all

$myName= $_POST["myName"];
foreach ($myNameas $eachName) {
     echo 'Gender: '. $eachName. "<br>";
}
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

<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>
Post Reply