how to insert multiple array into database using PHP

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • vijay005
    New Member
    • Dec 2011
    • 10
    #1

    how to insert multiple array into database using PHP

    Code:
    <script type="text/javascript">
    function validate(frm)
    {
		var x=document.forms["form2"]["fname1"].value;
if (x==null || x=="")
    {
    alert("First name must be filled out");
    return false;
    }
    var y=document.forms["form2"]["lname1"].value;
if (y==null || y=="")
    {
    alert("last name must be filled out");
    return false;
    }
       
	    var w=document.forms["form2"]["std1"].value;
	    if(w == "")
    {
        alert("Please Enter Std-Code.");
        return false;
    }
    if(isNaN(w))
    {
        alert("Please Enter Valid Std-Code.");
        return false;
    }
    if(w.length < 3)
    {
        alert("Std-Code should be minimum 3 digits");
        return false;
    }
	
	 var p=document.forms["form2"]["phone1"].value;
    if(p == "")
    {
        alert("Please Enter Phone Number.");
        return false;
    }
    if(isNaN(p))
    {
        alert("Please Enter Valid Phone Number.");
         return false;
    }
    if(p.length < 7)
    {
        alert("Contact Number should of minimum 7 digits");
        return false;
    }
	
	 var b=document.forms["form2"]["mobile1"].value;
    if(b == "")
    {
        alert("Please Enter Mobile Number.");
        return false;
    }
    if(b!=""){
        if(isNaN(b))
        {
            alert("Please Enter Valid Mobile Number.");
            document.form1.b.value='';
             return false;
        }
        if(b.length < 10)
        {
            alert("Mobile Number should be minimum 10 digits");
            return false;
        }
    }
	
    } 
	 
	 
    
    function add_feed()
    {
        var div1 = document.createElement('div');
    
        // Get template data
        div1.innerHTML = document.getElementById('newlinktpl').innerHTML;
    
        // append to our form, so that template data
        //become part of form
        document.getElementById('newlink').appendChild(div1);
    
    }
    </script>

<?php
    if(isset($_POST['submit1']))
    {
     $sql="INSERT INTO `jos_callbackentry` (`fname1`, `lname1`, `std1`, `phone1`, `mobile1`) VALUES ( '$_POST[fname1]', '$_POST[lname1]', '$_POST[std1]', '$_POST[phone1]', '$_POST[mobile1]')";
mysql_query($sql);

    }
?>



<!--here we insert html code -->
<form method="post" action="" name="form2" id="form2"  onsubmit="return validate(this)">
    
    <table>
    <tr>
        <td valign=top>Submit Callback Entry</td>
        <td valign=top>
            <div id="newlink">
                <div class="feed">
                 <!-- <input type="text" name="feedurl[]" value="http://feeds.feedburner.com/satya-weblog/scripting" size="50"> <br > -->
                 <table width="100%" border="0"align="center" cellpadding="0" cellspacing="0" class="offwhite">
         <tr>
         <td> <table width="100%" border="0" align="center" cellpadding="5" cellspacing="1" class="white">
         <tr class="sidemenuebg">
            
            <td width="12%" align="right" nowrap><font color="#FF0000">*</font>First Name</td>
            <td width="39%"><input name="fname1" id="fname1" type="text" size="25" maxlength="100" ></td>
            <td width="20%" align="right"><font color="#FF0000">*</font> Last Name</td>
            <td width="31%"><input name="lname1" id="lname1" type="text" size="25" maxlength="100" ></td>
         </tr>
         <tr class="simplegraytable">
            <td colspan="2" align="right" nowrap>Phone</td>
            <td align="left"><input name="std1" id="std1"type="text" size="5" maxlength="5" >
             <input name="phone1" id="phone1" type="text" size="20" maxlength="10" >
             <br >
             <span class="style5">STD Code - Number</span></td>
            <td align="right"><font color="#FF0000">*</font>Mobile</td>
            <td align="left"><input name="mobile1" id="mobile1" type="text" size="25" maxlength="10" onkeyup="checkNumber(this);"></td>
         </tr>
        </table> </td></tr></table>
                    </div>
            </div>
        </td>
    </tr>
    </table>
    
        <p>
            <br>
            <input type="submit" name="submit1">
            <input type="reset" name="reset1">
        </p>
    
    <p id="addnew">
        <a href="javascript:add_feed()">Add New </a>
    </p>
    
    </form>
    
    <!-- Template. This whole data will be added directly to working form above -->
    <div id="newlinktpl" style="display:none">
        <div class="feed">
                
         <table width="100%" border="0"align="center" cellpadding="0" cellspacing="0" class="offwhite">
         <tr>
         <td> <table width="100%" border="0" align="center" cellpadding="5" cellspacing="1" class="white">
         <tr class="sidemenuebg">
            <td width="5%" align="right" nowrap class="simplegraytable">
             </td>
            <td width="12%" align="right" nowrap><font color="#FF0000">*</font>First Name</td>
            <td width="39%"><input name="fname1" id="fname1" type="text" size="25" maxlength="100" ></td>
            <td width="13%" align="right"><font color="#FF0000">*</font>Last Name</td>
            <td width="31%"><input name="lname1" id="lname1" type="text" size="25" maxlength="100" ></td>
         </tr>
         <tr class="simplegraytable">
            <td colspan="2" width="12%" align="right" nowrap>Phone</td>
            <td align="left"><input name="std1" id="std1"type="text" size="5" maxlength="5" >
             <input name="phone1" id="phone1" type="text" size="20" maxlength="10" >
             <br >
             <span class="style5">STD Code - Number</span></td>
            <td align="right"><font color="#FF0000">*</font>Mobile</td>
            <td align="left"><input name="mobile1" id="mobile1" type="text" size="25" maxlength="10" onkeyup="checkNumber(this);"></td>
         </tr>
        </table></td></tr></table>
                
        </div>
    </div>

    when i fill information in filed without click "add new"
    then information store in table
    but when i click on "add new" suppose there in 2 form filed then the second last entry information is store in table and first form entry not store in table .
    Plz........ guide me how i can store all information in table when i click on "add new" without redundancy of information.
    Last edited by Dormilich; Dec 23 '11, 09:15 AM. Reason: please use [CODE] [/CODE] tags when posting code
    Tags: None
    • Dormilich
      Recognized Expert Expert
      • Aug 2008
      • 8694
      #2
      with your current setup, you can’t. reason being that the template form elements overwrite each other while submitting. you would have to add [] to each name to get an array of values in PHP.

      passing data to the DB can be achieved easily:
      Code:
      // example code
try
{
  $pdo = new PDO($dsn, $login, $password);
  $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  // prepare the query
  $ins = $pdo->prepare("INSERT INTO mytable (field1) VALUES (?)");
  // bind parameter(s), assuming string type here
  $ins->bindParam(1, $field1, PDO::PARAM_STR);
  // loop
  // for multiple values, check out the list() construct
  foreach ($_POST['field1'] as $field1)
  {
    $ins->execute();
  }
}
catch (PDOException $e) 
{
  echo $e->getMessage();
}
      this way you’re even immune against SQL Injection attacks.

        Comment

        • vijay005
          New Member
          • Dec 2011
          • 10
          #3
          Hi Dormilich

          u r right but one prob with i am not getting a idea that how is that possible can u give me some php code that i used for that form .
          becoz i am new in this filed so plz give me some code that i apply for that ..............

            Comment

            • Dormilich
              Recognized Expert Expert
              • Aug 2008
              • 8694
              #4
              how that is possible, I have shown in the above code. anyways, here is help on the list() function.

                Comment

                • vijay005
                  New Member
                  • Dec 2011
                  • 10
                  #5
                  Code:
                  <script type="text/javascript">
    function validate(frm)
    {
        var x=document.forms["form2"]["fname1"].value;
if (x==null || x=="")
    {
    alert("First name must be filled out");
    return false;
    }
    var y=document.forms["form2"]["lname1"].value;
if (y==null || y=="")
    {
    alert("last name must be filled out");
    return false;
    }
    
        var w=document.forms["form2"]["std1"].value;
        if(w == "")
    {
        alert("Please Enter Std-Code.");
        return false;
    }
    if(isNaN(w))
    {
        alert("Please Enter Valid Std-Code.");
        return false;
    }
    if(w.length < 3)
    {
        alert("Std-Code should be minimum 3 digits");
        return false;
    }
    
     var p=document.forms["form2"]["phone1"].value;
    if(p == "")
    {
        alert("Please Enter Phone Number.");
        return false;
    }
    if(isNaN(p))
    {
        alert("Please Enter Valid Phone Number.");
         return false;
    }
    if(p.length < 7)
    {
        alert("Contact Number should of minimum 7 digits");
        return false;
    }
    
     var b=document.forms["form2"]["mobile1"].value;
    if(b == "")
    {
        alert("Please Enter Mobile Number.");
        return false;
    }
    if(b!=""){
        if(isNaN(b))
        {
            alert("Please Enter Valid Mobile Number.");
            document.form1.b.value='';
             return false;
        }
        if(b.length < 10)
        {
            alert("Mobile Number should be minimum 10 digits");
            return false;
        }
    }
    
    }
    var x = 1;
    function add_feed()
    {
        var div1 = document.createElement('div');
        div1.innerHTML = document.getElementById('newlinktpl').innerHTML;
        document.getElementById('newlink').appendChild(div1);
    }
    function count()
    {
        
        x += 1;
        document.getElementById( "counting" ).value = x;
    }
</script>
<?php
    if(isset($_POST['submit1']))
    {
            for($i=0;$i<$_POST['txtCount'];$i++)
        {
            $sql="INSERT INTO `tablename` (`fname1`, `lname1`, `std1`, `phone1`, `mobile1`) VALUES ( '".$_POST['fname1'][$i]."', '".$_POST['lname1'][$i]."', '".$_POST['std1'][$i]."', '".$_POST['phone1'][$i]."', '".$_POST['mobile1'][$i]."')";
            mysql_query($sql);
        }
    }
?>
<!--here we insert html code -->

<div valign=top class="titleheading">Submit Callback Entry</div>
<form method="post" action="" name="form2" id="form2" onsubmit="return validate(this)">
    <table>
    <tr>
          <td valign=top class="tablebody"><div id="newlink">
         <div class="feed">
            <!-- <input type="text" name="feedurl[]" value="http://feeds.feedburner.com/satya-weblog/scripting" size="50"> <br > -->
            <table width="100%" border="0"align="center" cellpadding="0" cellspacing="0" class="offwhite">
             <tr>
                <td><table width="102%" border="0" align="center" cellpadding="5" cellspacing="1" class="white">
                    <tr class="sidemenuebg">
                     <td width="5%" align="right" nowrap class="simplegraytable"></td>
                     <td width="12%" align="right" nowrap><font color="#FF0000">*</font>First Name</td>
                     <td width="39%"><input name="fname1[]" id="fname1" type="text" size="25" maxlength="100" ></td>
                     <td width="27%" align="right"><font color="#FF0000">*</font>Last Name</td>
                     <td width="31%"><input name="lname1[]" id="lname1" type="text" size="25" maxlength="100" ></td>
                    </tr>
                    <tr class="simplegraytable">
                     <td colspan="2" align="right" nowrap >Phone</td>
                     <td align="left" width="45%"><input name="std1[]" id="std1"type="text" size="5" maxlength="5" >&nbsp;
                        <input name="phone1[]" id="phone1" type="text" size="15" maxlength="10" >
                        <br >
                        <span class="style5">STD Code - Number</span></td>
                     <td align="right"><font color="#FF0000">*</font>Mobile</td>
                     <td align="left"><input name="mobile1[]" id="mobile1" type="text" size="25" maxlength="10" ></td>
                    </tr>
                 </table></td>
             </tr>
            </table>
         </div>
        </div></td>
    </tr>
    </table>
    <p> <br>
    <input class="submitbutton" type="submit" name="submit1" value="Submit">

<input class="resetbutton" type="reset" name="reset1">
    </p>
    <p id="addnew"><a href="javascript:add_feed();count();"><input class="addnewbutton" type="button" name="submit" value="Add New Entry"></a>&nbsp;&nbsp;<input size="1" name="txtCount" id = "counting" type = "text" value="1" readonly="readonly" /><strong>&nbsp;</strong>
</p>
</form>
<!-- Template. This whole data will be added directly to working form above -->
<div id="newlinktpl" style="display:none">
    <div class="feed">
    <table width="100%" border="0"align="center" cellpadding="0" cellspacing="0" class="offwhite">
     <tr>
        <td><table width="102%" border="0" align="center" cellpadding="5" cellspacing="1" class="white">
            <tr class="sidemenuebg">
             <td width="5%" align="right" nowrap class="simplegraytable"></td>
             <td width="12%" align="right" nowrap><font color="#FF0000">*</font>First Name</td>
             <td width="39%"><input name="fname1[]" id="fname1" type="text" size="25" maxlength="100" ></td>
             <td width="27%" align="right"><font color="#FF0000">*</font>Last Name</td>
             <td width="31%"><input name="lname1[]" id="lname1" type="text" size="25" maxlength="100" ></td>
            </tr>
            <tr class="simplegraytable">
             <td colspan="2" align="right" nowrap>Phone</td>
             <td align="left" width="45%"><input name="std1[]" id="std1"type="text" size="5" maxlength="5" >&nbsp;
                <input name="phone1[]" id="phone1" type="text" size="15" maxlength="10" >
                <br >
                <span class="style5">STD Code - Number</span></td>
             <td align="right"><font color="#FF0000">*</font>Mobile</td>
             <td align="left"><input name="mobile1[]" id="mobile1" type="text" size="25" maxlength="10" ></td>
            </tr>
         </table></td>
     </tr>
    </table>
    </div>
</div>
                  Last edited by Dormilich; Dec 28 '11, 01:20 PM. Reason: please use [CODE] [/CODE] tags when posting code

                    Comment

                    • Dormilich
                      Recognized Expert Expert
                      • Aug 2008
                      • 8694
                      #6
                      you are aware that this code is highly susceptible to SQL injection attacks?

                        Comment

                        Previous template Next
                        Working...