How dynamic textbox data insert in database without refresh?

[kazimmusani]

Hello friends,

im using following code to insert data in database using dynamic text box. its work excellent but now i want to submit data in database without refresh page.kindly advise what and where i change my code.plz help. thanks in advance

output.php<?phpinclude('connection.php');include('links.php'); if(isset($_POST['save'])){ $conn = mysql_connect("localhost","root","");mysql_select_db("esol",$conn); $itemCount = count($_POST["item_name"]);$itemValues=0; $query = "INSERT INTO invoice (name,description,quantity) VALUES ";$queryValue = "";for($i=0;$i<$itemCount;$i++) {     if(!empty($_POST["item_name"][$i]) || !empty($_POST["item_price"][$i]) || !empty($_POST["quantity"][$i])) {        $itemValues++;        if($queryValue!="") {            $queryValue .= ",";        }        $queryValue .= "('" . $_POST["item_name"][$i] . "', '" . $_POST["item_price"][$i] . "', '" . $_POST["quantity"][$i] . "')";    }}$sql = $query.$queryValue;if($itemValues!=0) {    $result = mysql_query($sql);    if(!empty($result)) $message = "Added Successfully."; } }?>   <FORM name="frmProduct" method="post" action="">        <input type="button" name="add_item" value="Add More" onClick="addMore();" />    <input type="button" name="del_item" value="Delete" onClick="deleteRow();" />          <input type="submit" id="save" name="save" value="Save" /> </form> <SCRIPT src="http://code.jquery.com/jquery-2.1.1.js"></SCRIPT><script>    function addMore() {        $("").load("input.php", function() {            $("#product").append($(this).html());        });    }    function deleteRow() {        $('DIV.product-item').each(function(index, item){            jQuery(':checkbox', this).each(function () {                if ($(this).is(':checked')) {                    $(item).remove();                }            });        });    }</script>

INPUT.PHP<DIV class="product-item float-clear" style="clear:both;">                            <input type="checkbox" name="item_index[]" />                 <input type="text" name="item_name[]" />                <input type="text" name="item_price[]" />                <input type="text" name="quantity[]" />>

[justsomeguy]

If you don't want the page to refresh when the form submits then you'll need to use Javascript to get the form data and submit it to the server using ajax.

[kazimmusani]

ya but java scriipt code is not working here. can u plz help me.

[justsomeguy]

You don't have any code to get the form data and send an ajax request. If the Javascript code you have on the page is not working, check your error console. The div you have in input.php is not closed, that might be one issue.