PHP JQuery Ajax insert not working

Question

Normally works but when trying for ajax insert does not work.

Here is my form(no form action in html):

name: <input type="text" name="name" id="name">
<input type="submit" name="submit" value="add" id="submit">

Here is the add.php file code

require_once('conn.php');
$name = $_POST['name'];
$query = mysql_query("insert into toy(name) values('$name')");
if ($query) {
    echo "Data inserted";
}else{
    echo mysql_error();
}

And here is the javascript code

$(document).ready(function() {
$('#submit').click(function(){
    $.ajax({
    url: "add.php",
    type: "POST",
    data: {
        name: $("#name").val()
    },
    success: function(data){
          alert("Data Save: " + data);
     }
});
});

});

Thanks in advance for suggestion.

Are you getting the MySQL error (failure to insert), or does the Ajax call fail before that? Edit: Nevermind. See you got it fixed! — bandaro
– bandaro, Commented Oct 5, 2015 at 21:26

charlietfl · Accepted Answer · 2015-10-05 21:19:04Z

1

You need to prevent default form submit:

$('#submit').click(function(e){
   e.preventDefault()
   // do your ajax

});

answered Oct 5, 2015 at 21:19

charlietfl

172k14 gold badges125 silver badges154 bronze badges

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

2 Comments

Russell Over a year ago

If I change my code data: $('#form').serialize(), dataType: 'json', Alert not working. How to fix that

charlietfl Over a year ago

you are returning text from server not json, so will cause a json parsing error

Collectives™ on Stack Overflow

PHP JQuery Ajax insert not working

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related