www.webdeveloper.com
Results 1 to 3 of 3

Thread: Insert Multiple Input using PHP and MySQL

  1. #1
    Join Date
    Apr 2005
    Posts
    70

    Question Insert Multiple Input using PHP and MySQL

    HTML Code:
    <script language="javascript">
    fields = 0;
    function addInput() {
    if (fields != 10) {
    document.getElementById('text').innerHTML += "<span class='teks03'>Name</span>&nbsp;:&nbsp;<input type='text' value='' name='name[]' size='30' class='mybox' />&nbsp;<span class='teks03'>Nationality</span>&nbsp;:&nbsp;<input type='text' value='' name='nationality[]' size='30' class='mybox' /><br><input type='button' onClick='addInput()' name='add' value='Add' /><br>";
    fields += 1;						
    } else {
    document.getElementById('text').innerHTML += "<br />Maximum 10 fields allowed.";
    document.frm.add.disabled=true;
    }
    }
    </script><table cellpadding="0" cellspacing="0" align="center">
    				
    				<tr>
    					<td height="15"></td>
    				</tr>
    				<tr>
    					<td>
    						<form method="post" name="frm" action="add.php">
    						<table cellpadding="1" cellspacing="0" width="100%" align="center">
    
    <tr>
    							<td><b>Board of Directors</b></td>
    							</tr>
    							<tr><td>&nbsp;&nbsp;</td><td></td></tr>
    							<tr>
    																
    								    <td colspan="2"><span class="teks03">Name</span>&nbsp;:&nbsp;<input type="text" class="mybox" name="name[]" value="" size="30" />
    									<span class="teks03">Nationality</span>&nbsp;:&nbsp;<input type="text" class="mybox" name="nationality[]" value="" size="30" /><br />
    									<input type="button" onClick="addInput()" name="add" value="Add" /><br />
    							<div id="text"></div>
    									</td>
    							<tr>
    								<td width="277"></td>
    								<td width="694">&nbsp;&nbsp;&nbsp;
    								  <input type="submit" name="sub" size="12" value="Submit">
    							  <input type="reset" name="reset" value="Reset" size="12"></td>
    							</tr>
    							</tr>
    							</table>
    							</form>
    							</td>
    							</tr>
    							</table>
    How can i insert this data using php & MySQL? User can insert more than one data for name and nationality.Im using javascript function for user to add multiple data.Hope someone can help me.Im not sure i should use foreach or not.

  2. #2
    Join Date
    Jan 2004
    Posts
    484
    on your add.php page you get something like this from the post

    PHP Code:
    array
      
    'name' => 
        array
          
    => string '123' (length=3)
          
    => string '1234' (length=4)
          
    => string '4312' (length=4)
          
    => string '65456' (length=5)
      
    'nationality' => 
        array
          
    => string 'sdfsd' (length=5)
          
    => string 'ddddddd' (length=7)
          
    => string 'ssssss' (length=6)
          
    => string 'aaaaa' (length=5)
      
    'sub' => string 'Submit' (length=6
    your sql statement should look like this
    PHP Code:
    INSERT INTO table
    (NameCol1,NameCol2)
    VALUES
    ($_POST['name'][0],$_POST['nationality'][0]),
    (
    $_POST['name'][1],$_POST['nationality'][1]),
    (
    $_POST['name'][2],$_POST['nationality'][2]) 

    you need to loop through the post sanitize and execute the my sql statement
    Natdrip :P
    "water go down the hole" - plucky duck

  3. #3
    Join Date
    Apr 2005
    Posts
    70

    Detect Problem

    Thanks for your reply..I just detect my javascript's script have problem.I will try your code after i settle with the javascript problem.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles