Select tag is inserting duplicate rows in sql












1















If click function is clicked for first time there are no duplicate rows



When it is clicked for second time 2 rows get inserted



for third time 3 rows and so on..



html



<select class="form-control" name="select" id="select">
<option value="pick">Select</option>
<option name="id" id="id" value="1">Name1</option>
<option name="id2" id="id2" value="2">Name2</option>
</select>


jquery..



$('#select').on('change', function (j){
$("#btn").click(function(e){
var selectedValue = $('#select').val();
$.ajax({
type: "POST",
url: "new.php",
data: '{"to":"'+selectedValue+'"}',
success: function(r){

}
});
});
});


Why is this happening..










share|improve this question



























    1















    If click function is clicked for first time there are no duplicate rows



    When it is clicked for second time 2 rows get inserted



    for third time 3 rows and so on..



    html



    <select class="form-control" name="select" id="select">
    <option value="pick">Select</option>
    <option name="id" id="id" value="1">Name1</option>
    <option name="id2" id="id2" value="2">Name2</option>
    </select>


    jquery..



    $('#select').on('change', function (j){
    $("#btn").click(function(e){
    var selectedValue = $('#select').val();
    $.ajax({
    type: "POST",
    url: "new.php",
    data: '{"to":"'+selectedValue+'"}',
    success: function(r){

    }
    });
    });
    });


    Why is this happening..










    share|improve this question

























      1












      1








      1








      If click function is clicked for first time there are no duplicate rows



      When it is clicked for second time 2 rows get inserted



      for third time 3 rows and so on..



      html



      <select class="form-control" name="select" id="select">
      <option value="pick">Select</option>
      <option name="id" id="id" value="1">Name1</option>
      <option name="id2" id="id2" value="2">Name2</option>
      </select>


      jquery..



      $('#select').on('change', function (j){
      $("#btn").click(function(e){
      var selectedValue = $('#select').val();
      $.ajax({
      type: "POST",
      url: "new.php",
      data: '{"to":"'+selectedValue+'"}',
      success: function(r){

      }
      });
      });
      });


      Why is this happening..










      share|improve this question














      If click function is clicked for first time there are no duplicate rows



      When it is clicked for second time 2 rows get inserted



      for third time 3 rows and so on..



      html



      <select class="form-control" name="select" id="select">
      <option value="pick">Select</option>
      <option name="id" id="id" value="1">Name1</option>
      <option name="id2" id="id2" value="2">Name2</option>
      </select>


      jquery..



      $('#select').on('change', function (j){
      $("#btn").click(function(e){
      var selectedValue = $('#select').val();
      $.ajax({
      type: "POST",
      url: "new.php",
      data: '{"to":"'+selectedValue+'"}',
      success: function(r){

      }
      });
      });
      });


      Why is this happening..







      jquery ajax






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 19 '18 at 8:42









      SachinSachin

      87




      87
























          2 Answers
          2






          active

          oldest

          votes


















          1














          you should unbind any existing event first



          $("#btn").off().click(function(){
          // ...
          })





          share|improve this answer































            3














            You are assigning the button click handler inside the change handler. So you end up adding an extra handler every time.
            You can get rid of the select change handler.



            $("#btn").click(function(e){
            var selectedValue = $('#select').val();
            $.ajax({
            type: "POST",
            url: "new.php",
            data: '{"to":"'+selectedValue+'"}',
            success: function(r){

            }
            });
            });


            This much is sufficient.






            share|improve this answer























              Your Answer






              StackExchange.ifUsing("editor", function () {
              StackExchange.using("externalEditor", function () {
              StackExchange.using("snippets", function () {
              StackExchange.snippets.init();
              });
              });
              }, "code-snippets");

              StackExchange.ready(function() {
              var channelOptions = {
              tags: "".split(" "),
              id: "1"
              };
              initTagRenderer("".split(" "), "".split(" "), channelOptions);

              StackExchange.using("externalEditor", function() {
              // Have to fire editor after snippets, if snippets enabled
              if (StackExchange.settings.snippets.snippetsEnabled) {
              StackExchange.using("snippets", function() {
              createEditor();
              });
              }
              else {
              createEditor();
              }
              });

              function createEditor() {
              StackExchange.prepareEditor({
              heartbeatType: 'answer',
              autoActivateHeartbeat: false,
              convertImagesToLinks: true,
              noModals: true,
              showLowRepImageUploadWarning: true,
              reputationToPostImages: 10,
              bindNavPrevention: true,
              postfix: "",
              imageUploader: {
              brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
              contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
              allowUrls: true
              },
              onDemand: true,
              discardSelector: ".discard-answer"
              ,immediatelyShowMarkdownHelp:true
              });


              }
              });














              draft saved

              draft discarded


















              StackExchange.ready(
              function () {
              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53370998%2fselect-tag-is-inserting-duplicate-rows-in-sql%23new-answer', 'question_page');
              }
              );

              Post as a guest















              Required, but never shown

























              2 Answers
              2






              active

              oldest

              votes








              2 Answers
              2






              active

              oldest

              votes









              active

              oldest

              votes






              active

              oldest

              votes









              1














              you should unbind any existing event first



              $("#btn").off().click(function(){
              // ...
              })





              share|improve this answer




























                1














                you should unbind any existing event first



                $("#btn").off().click(function(){
                // ...
                })





                share|improve this answer


























                  1












                  1








                  1







                  you should unbind any existing event first



                  $("#btn").off().click(function(){
                  // ...
                  })





                  share|improve this answer













                  you should unbind any existing event first



                  $("#btn").off().click(function(){
                  // ...
                  })






                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered Nov 19 '18 at 8:46









                  Darryl CeguerraDarryl Ceguerra

                  885




                  885

























                      3














                      You are assigning the button click handler inside the change handler. So you end up adding an extra handler every time.
                      You can get rid of the select change handler.



                      $("#btn").click(function(e){
                      var selectedValue = $('#select').val();
                      $.ajax({
                      type: "POST",
                      url: "new.php",
                      data: '{"to":"'+selectedValue+'"}',
                      success: function(r){

                      }
                      });
                      });


                      This much is sufficient.






                      share|improve this answer




























                        3














                        You are assigning the button click handler inside the change handler. So you end up adding an extra handler every time.
                        You can get rid of the select change handler.



                        $("#btn").click(function(e){
                        var selectedValue = $('#select').val();
                        $.ajax({
                        type: "POST",
                        url: "new.php",
                        data: '{"to":"'+selectedValue+'"}',
                        success: function(r){

                        }
                        });
                        });


                        This much is sufficient.






                        share|improve this answer


























                          3












                          3








                          3







                          You are assigning the button click handler inside the change handler. So you end up adding an extra handler every time.
                          You can get rid of the select change handler.



                          $("#btn").click(function(e){
                          var selectedValue = $('#select').val();
                          $.ajax({
                          type: "POST",
                          url: "new.php",
                          data: '{"to":"'+selectedValue+'"}',
                          success: function(r){

                          }
                          });
                          });


                          This much is sufficient.






                          share|improve this answer













                          You are assigning the button click handler inside the change handler. So you end up adding an extra handler every time.
                          You can get rid of the select change handler.



                          $("#btn").click(function(e){
                          var selectedValue = $('#select').val();
                          $.ajax({
                          type: "POST",
                          url: "new.php",
                          data: '{"to":"'+selectedValue+'"}',
                          success: function(r){

                          }
                          });
                          });


                          This much is sufficient.







                          share|improve this answer












                          share|improve this answer



                          share|improve this answer










                          answered Nov 19 '18 at 8:47









                          RoshanRoshan

                          1,7491921




                          1,7491921






























                              draft saved

                              draft discarded




















































                              Thanks for contributing an answer to Stack Overflow!


                              • Please be sure to answer the question. Provide details and share your research!

                              But avoid



                              • Asking for help, clarification, or responding to other answers.

                              • Making statements based on opinion; back them up with references or personal experience.


                              To learn more, see our tips on writing great answers.




                              draft saved


                              draft discarded














                              StackExchange.ready(
                              function () {
                              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53370998%2fselect-tag-is-inserting-duplicate-rows-in-sql%23new-answer', 'question_page');
                              }
                              );

                              Post as a guest















                              Required, but never shown





















































                              Required, but never shown














                              Required, but never shown












                              Required, but never shown







                              Required, but never shown

































                              Required, but never shown














                              Required, but never shown












                              Required, but never shown







                              Required, but never shown







                              Popular posts from this blog

                              Guess what letter conforming each word

                              Port of Spain

                              Run scheduled task as local user group (not BUILTIN)