dynamic inputs through jquery and submit to mysql table

Question

I need some advice in the following code.

var count = 1;
$(function(){
    $('#addmore').click(function(){
        count += 1;
        $('ul').append("<li><input type='text' id='hd"+count+"' name='hd"+count+"' value='heading' onClick='this.select();'> <input type='text' id='amount"+count+"' name='amount"+count+"' value='amount' onClick='this.select();'></li>");
//      return false;
    });
});

what exact php code should i use to submit all the input into my test table of mysql.

<button id="addmore">+</button>
<form id="myForm" name="myForm" action="" method="post" onSubmit="return false;">
<ul>
    <li><input type="text" id="hd1" name="hd1" value="heading" onClick="this.select();">
    <input type="text" id="amount1" name="amount1" value="amount" onClick="this.select();"></li>
</ul>
<input type="submit" value="Submit" id="submit" name="submit">
</form>

<?php
if(isset($_POST['submit'])){

echo "h";
};
?>

keeping in mind that i've test table with two fields 'heading' and 'amount'.

if(isset($_POST['submit'])){
    foreach($_POST['hd'] as $hds){
        echo $hds;
        mysqli_query($con,"INSERT INTO test (hdg) VALUES ($hds)");
    };
};

and its not adding data into my table

This is a bit ambiguous - the PHP script that puts data into the table doesn't need to care about your JS function, it can just check to see what data it is given. But to give "exact php code" you would need to tell us something about your MySQL table's structure. Also remember that you can see if a form value is set with something like isset($_POST['hd1']). — Don McCurdy
– Don McCurdy, Commented May 28, 2013 at 3:18
What have you tried? Can you post your php code that you have so far? What are you using for your database connection - mysqli or PDO? — Sean
– Sean, Commented May 28, 2013 at 3:19
my mysql table structure is simple Id(int), hdg(varchar), amt(varchar) and table name is test. — Salman Razak Memon
– Salman Razak Memon, Commented May 28, 2013 at 3:22
JSON.stringify the values and send them to php. There run a loop for each set of value and insert into the db — hanut
– hanut, Commented May 28, 2013 at 3:23
// Create connection $con=mysqli_connect("localhost","root","","transport"); // Check connection if (mysqli_connect_errno($con)){ echo "Failed to connect to MySQL: " . mysqli_connect_error(); } — Salman Razak Memon
– Salman Razak Memon, Commented May 28, 2013 at 3:23

Ram · Accepted Answer · 2013-05-28 03:19:21Z

2

Use [] for the name attributes instead of the numbers:

<li><input type="text" id="hd1" name="hd[]" value="heading" onClick="this.select();">

On the server-side you will have an array of values.

$hd = $_POST['hd']; // Returns an array

answered May 28, 2013 at 3:19

Ram

145k16 gold badges174 silver badges201 bronze badges

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

1 Comment

Salman Razak Memon Over a year ago

if(isset($_POST['submit'])){ $hd = $_POST['hd']; echo $hd; };

Collectives™ on Stack Overflow

dynamic inputs through jquery and submit to mysql table

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related