제출 후 데이터를 삽입할 수 없습니다. Ajax로 작성했기 때문인가요?
tt.php
<code><!DOCTYPE html> <html> <head> <title></title> <script type="text/javascript"> function ajax(url,data,funsucc){ var oAjax=new XMLHttpRequest(); oAjax.open('POST',url,true); oAjax.setRequestHeader("Content-Type","application/x-www-form-urlencoded;charset=UTF-8"); oAjax.send("aa="+data); oAjax.onreadystatechange=function(){ if(oAjax.readyState==4){ if(oAjax.status==200){ funsucc(oAjax.responseText); } } } } </script> <script type="text/javascript"> window.onload=function(){ var oTxt=document.getElementById('txt1'); var oBtn=document.getElementById('btn1'); oBtn.onclick=function(){ ajax("ajax.php",oTxt.value,function(){ window.location.reload(); }); } } </script> </head> <body> <form method="post"> <input type="text" id="txt1"> <button id="btn1" type="submit">提交</button> </form> </body> </html></code>
ajax.php
<code><?php $pdo=new PDO("mysql:host=localhost;dbname=t1","root",""); $txt=$_POST["aa"]; $stmt=$pdo->prepare("insert into ajax(txt)values(?)"); $stmt->execute(array($txt)); ?></code>
제출 후 데이터를 삽입할 수 없습니다. Ajax로 작성했기 때문인가요?
tt.php
<code><!DOCTYPE html> <html> <head> <title></title> <script type="text/javascript"> function ajax(url,data,funsucc){ var oAjax=new XMLHttpRequest(); oAjax.open('POST',url,true); oAjax.setRequestHeader("Content-Type","application/x-www-form-urlencoded;charset=UTF-8"); oAjax.send("aa="+data); oAjax.onreadystatechange=function(){ if(oAjax.readyState==4){ if(oAjax.status==200){ funsucc(oAjax.responseText); } } } } </script> <script type="text/javascript"> window.onload=function(){ var oTxt=document.getElementById('txt1'); var oBtn=document.getElementById('btn1'); oBtn.onclick=function(){ ajax("ajax.php",oTxt.value,function(){ window.location.reload(); }); } } </script> </head> <body> <form method="post"> <input type="text" id="txt1"> <button id="btn1" type="submit">提交</button> </form> </body> </html></code>
ajax.php
<code><?php $pdo=new PDO("mysql:host=localhost;dbname=t1","root",""); $txt=$_POST["aa"]; $stmt=$pdo->prepare("insert into ajax(txt)values(?)"); $stmt->execute(array($txt)); ?></code>
1. 제출 버튼을 클릭하면 기본적으로 onsubmit 이벤트가 실행되지만, 여기에 바인딩된 onclick 이벤트는 기본 이벤트를 취소하지 않습니다.
<code>oBtn.onclick=function(e){ var e=window.event||e; e.preventDefault&&e.preventDefault(); e.returnValue&&e.returnValue=false; }</code>2. 기본 onsubmit을 사용하고 ajax를 무시하고 txt1에 name="aa"를 추가합니다.
<code>function ajax(url,data,funsucc){ var oAjax=new XMLHttpRequest(); oAjax.open('POST',url,true); oAjax.setRequestHeader("Content-Type","application/x-www-form-urlencoded;charset=UTF-8"); oAjax.send("aa="+data);//在这里打个断点看看 oAjax.onreadystatechange=function(){ if(oAjax.readyState==4){ if(oAjax.status==200){ funsucc(oAjax.responseText); } } } }</code>다음과 같이 ajax 기능을 변경하세요.
비동기 호출, 그렇지 않으면 데이터를 보낼 수 없습니다
<code>function ajax(url,data,funsucc){ var oAjax=new XMLHttpRequest(); oAjax.open('POST',url,true); oAjax.setRequestHeader("Content-Type","application/x-www-form-urlencoded;charset=UTF-8"); oAjax.onreadystatechange=function(){ if(oAjax.readyState==4){ if(oAjax.status==200){ funsucc(oAjax.responseText); } } } oAjax.send("aa="+data); }</code>