Dynamically Add Input Fields And Submit To Database With jQuery and PHP

Question

I want to Post Multiple values for foreach function because i have multiple dynamic textbox then how should i send the values in database?? how to write foreach function for dat.. the code below display 2 multiple textbox but didnt submit values in databse

<html>
<head>
<title></title>
<script type="text/javascript" src="jquery-1.9.1.js"></script>
<script type="text/javascript">
var counter = 0;
$(function(){
 $('p#add_field').click(function(){
 counter += 1;
 $('#container').append(
 '<strong>Hobby No. ' + counter + '</strong><br />'
 + '<input id="field_' + counter + '" name="dynfields[]' + '" type="text" /><br />'

+'<strong>HolidayReason ' + counter + '</strong>&nbsp;'
 + '<input id="holidayreason_' + counter + '" name="holireason[]' + '" type="text" />'
  );

 });
});
</script>

<body>

<?php
if (isset($_POST['submit_val'])) {
if (($_POST['dynfields'])&& ($_POST['holireason'])) {
//$aaa=array($_POST['dynfields']);
foreach ($_POST['dynfields'] as $key=>$value) 
{
$values = mysql_real_escape_string($value);
//$holireasons = mysql_real_escape_string($holireason);

$query = mysql_query("INSERT INTO my_hobbies (hobbies) VALUES ('$values')" );


}
}

echo "<i><h2><strong>" . count($_POST['dynfields']) . "</strong> Hobbies Added</h2></i>";

 mysql_close();
}
?>
<?php if (!isset($_POST['submit_val'])) { ?>
 <h1>Add your Hobbies</h1>
 <form method="post" action="">

 <div id="container">
 <p id="add_field"><a href="#"><span>Click To Add Hobbies</span></a></p>
 </div>

 <input type="submit" name="submit_val" value="Submit" />
 </form>
<?php } ?>

</body>
</html>

You can refer to this: stackoverflow.com/questions/20607405/… or check this fiddle: jsfiddle.net/ehx6M/1 — Logan Wayne
– Logan Wayne, Commented Mar 28, 2014 at 7:46

Dexter · Accepted Answer · 2014-03-28 08:34:19Z

2

try this

       <html>
            <head>
            <title></title>
           <script src="//code.jquery.com/jquery-1.10.2.js"></script>
            <script type="text/javascript">
            var counter = 0;
            $(function(){
             $('p#add_field').click(function(){
             counter += 1;
             $('#container').append(
             '<strong>Hobby No. ' + counter + '</strong><br />'
             + '<input id="field_' + counter + '" name="dynfields[]' + '" type="text" /><br />'

            +'<strong>HolidayReason ' + counter + '</strong>&nbsp;'
             + '<input id="holidayreason_' + counter + '" name="holireason[]' + '" type="text" />'
              );

             });
            });
            </script>

            <body>

            <?php
            if (isset($_POST['submit_val'])) {
            if (($_POST['dynfields'])&& ($_POST['holireason'])) {
            $no = count($_POST['dynfields']);
           for ($i=0; $i <$no ; $i++) { 
            echo $_POST['dynfields'][$i]."<br>";
            echo $_POST['holireason'][$i]."<br>";
        $abc = mysql_real_escape_string($_POST['dynfields'][$i]);
        $xyz = mysql_real_escape_string($_POST['holireason'][$i]);
       $sql =  "INSERT INTO my_hobbies (hobbies,Holidayreason) VALUES ('$abc','$xyz')";
mysql_query($sql);
        }

            }

            echo "<i><h2><strong>" . count($_POST['dynfields']) . "</strong> Hobbies Added</h2></i>";

             mysql_close();
            }
            ?>
            <?php if (!isset($_POST['submit_val'])) { ?>
             <h1>Add your Hobbies</h1>
             <form method="post" action="<?php echo $_SERVER['PHP_SELF'];?>">

             <div id="container">
             <p id="add_field"><a href="#"><span>Click To Add Hobbies</span></a></p>
             </div>

             <input type="submit" name="submit_val" value="Submit" />
             </form>
            <?php } ?>

            </body>
            </html>

edited Mar 28, 2014 at 8:34

answered Mar 28, 2014 at 7:45

Dexter

1,7964 gold badges27 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Dexter Over a year ago

remove comment from print_r statement check its printing or not values

user3359065 Over a year ago

no bt how to send both values $_POST['dynfields'] and $_POST['holireason'] in databse in foreach function

user3359065 Over a year ago

by print_r it only gives one textbox value

Dexter Over a year ago

whats your actual requirement you want to insert both data in hobbies filed

user3359065 Over a year ago

ya i want insert data bt in 2 columns in one row of two textbox values

|

dbmitch · Accepted Answer · 2016-06-27 21:14:53Z

1

Use array_combine as follows.

foreach(array_combine($_POST['dynfields'] , $_POST['holireason']) as $dyn => $holi) {

   $abc = mysql_real_escape_string($dyn);
   $xyz = mysql_real_escape_string($holi);

   $sql =  mysql_query ("INSERT INTO my_hobbies (hobbies,Holidayreason) VALUES ('".$abc."','".$xyz."')");

}

100% works fine.

edited Jun 27, 2016 at 21:14

dbmitch

5,3964 gold badges27 silver badges39 bronze badges

answered Jun 27, 2016 at 20:55

vnie89

111 bronze badge

4 Comments

dbmitch Over a year ago

Explain what you're doing and why it fits user question

vnie89 Over a year ago

For every loop count, $dyn and $holi take $_POST['dynfields'] value and $_POST['holireason'] value respectively till the loop counter says it is enough.

dbmitch Over a year ago

He says .. "no i want to add values in db as single row"

vnie89 Over a year ago

That block of code inserts values in db as a single row depending on the size of your array.

Collectives™ on Stack Overflow

Dynamically Add Input Fields And Submit To Database With jQuery and PHP

2 Answers 2

6 Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related