How dynamic textbox data insert in database without refresh?

See more:

PHP

jQuery

TextBoxBase

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

<pre lang="PHP"><?php
include('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></pre>

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[]" />>