Jump to content

kazimmusani

Members
  • Content Count

    2
  • Joined

  • Last visited

Posts posted by kazimmusani

  1. 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 smiley_smile.gif

    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[]" />>
×
×
  • Create New...