Jump to content
kazimmusani

How dynamic textbox data insert in database without refresh?

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

  • Like 1

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...