Posting data to sql database without reloading page

Question

the problem is that i am unable to insert data in my database without reloading i have tested it without the note_sql.js and my note_sql.php works fine but there seems to be a problem in my js file if some body could point me in the right direction it would be wonderful

Index.php

    <form id="noteform" action="note_sql.php" method="POST">
    <input type="text" name="note"></input>
    <input id="sub" type="submit" value="Save Note" />
    </form>
    <span id="result_note"><span>
   <script type ="text/javascript" src="jquery/note_sql.js"></script>

note_sql.js

$("#sub").click(function(){

var data = $("#noteform: input").serializeArray();
$.post($("#noteform").attr("action"),data,function(info){$("result_note").html(info); });
    clearInput();
}); 

$("#noteform").submit(function(){
    return false;
});

function clearInput(){
    $("#noteform :input").each(function(){
        $(this).val('');
    });
}

Use $("#noteform" ).submit(function( event ) { instead of $("#sub").click(function(){ — Saty
– Saty, Commented Nov 30, 2015 at 10:11
Maybe this is helpful : stackoverflow.com/questions/13064179/… — Alex
– Alex, Commented Nov 30, 2015 at 10:15

Rajveer gangwar · Accepted Answer · 2015-11-30 10:34:20Z

5

Use Jquery Ajax the working code is given below : please add ID to Note Form Element :

<pre>
      <script>
            $(document).ready(function () {
                $("#sub").click(function () {

                    var name = $("#note").val();
                    var message = $("#message").val();

                    $.ajax({
                        type: "post",
                        url: "note_sql.php",
                        data: "name=" + name,
                        success: function (data) {
                            alert(data);
                        }

                    });

                });
            });
        </script>
</pre>

answered Nov 30, 2015 at 10:34

Rajveer gangwar

7355 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

kunz Over a year ago

i did try the above code but i get redirected to note_sql.php

Rajveer gangwar Over a year ago

SO remove note_sql.php from form action

kunz Over a year ago

okay it works now but i do not need it in a alert box it needs to come in a span area <span id="result_note"><span> how would i dothis

Rajveer gangwar Over a year ago

use $('span#result_note').html(data); in place of alert(data);

kunz Over a year ago

Thanks for your hel @rajveer u have been great

|

Collectives™ on Stack Overflow

Posting data to sql database without reloading page

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related