StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POjquery not adding the values to database, readystate=0, and status=0
text
Body
copied!<p>My script does not seem to be working. Every time i try to use the form i've get the error with readystate=0, and status=0. Any help will be appreciated. I've got the following form:</p> <pre><code><form action="" method="post" > <input type="text" name="name" id="tekst"/><br/> <input type="text" name="name" id="autor"/><br/> <input type="submit" name="<?php echo $id; ?>" value="Send" id="submit"/> </form> <div class="response"></div> </code></pre> <p>the values from input fields are then processed by the following code:</p> <pre><code>$("input#submit").click(function(){ var id = $("input#submit").attr("name"); var autor = $('input#autor').val(); var tresc = $('input#tekst').val(); $.ajax({ type: "POST", url: "add_comment.php", data: {id: id, autor: autor, tresc: tresc}, success: function(data){ $(".response").text(data); }, error:function(xhr,err){ alert("readyState: "+xhr.readyState+"\nstatus: "+xhr.status); alert("responseText: "+xhr.responseText); } }); }); </code></pre> <p>Here is my add_comment.php:</p> <pre><code><?php $id = $_POST['id']; $autor= $_POST['autor']; $tresc = $_POST['tresc']; if(isset($id) && isset($autor) && isset($tresc)){ include("db/connection.php"); $zapytanie= "INSERT INTO komentarze(id_ref, autor, tresc) values ('$id', '$autor', '$tresc')"; $wynik = $db->query($zapytanie); echo "Added"; }else{ echo "Problem"; } ?> </code></pre> <p>EDIT: id_ref is not auto_increment field. The script is running on the localhost</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload