PHP利用Ajax连接到数据库
直接亮出来代码好了 这个是一个添加文章类别功能的页面
sortadd.php
<script language="javascript"><br>var http_request=false;<br>function createRequest(url){<br> http_request=false;<br> if(window.XMLHttpRequest){<br> http_request=new XMLHttpRequest();<br> if(http_request.overrideMimeType){<br> http_request.overrideMimeType("text/xml");<br> }<br> }else if(window.ActiveXObject){<br> try{<br> http_request=new ActiveXObject("Msxml2.XMLHTTP");<br> }catch(e){<br> try{<br> http_request=new ActiveXObject("Microsoft.XMLHTTP");<br> }catch(e){}<br> }<br> }<br> if(!http_request){<br> alert("不能创建XMLHTTP实例！");<br> return false;<br> }<br> http_request.onreadystatechange=alertContents;<br> http_request.open("GET",url,true);<br> http_request.send(null);<br>}<br>function alertContents(){<br> if(http_request.readyState==4){<br> if(http_request.status==200){<br> sort_id.innerHTML=http_request.responseText;<br> }else{<br> alert('您请求的页面发现错误！');<br> }<br> }<br>}<br></script>
<script><br>function checksort(){<br> var txt_sort=form1.txt_sort.value;<br> if(txt_sort==""){<br> window.alert("请填写文章类别！");<br> form1.txt_sort.focus();<br> return false;<br> }else{<br> createRequest('checksort.php?txt_sort='+txt_sort);<br> }<br>}<br></script>
|
|
|
然后是checksort.php
/*
添加分类信息处理页checksort.php
*/
$link=mysql_connect("localhost","root","8346322");
mysql_select_db("wp",$link);
$GB2312string=iconv('UTF-8','gb2312//IGNORE',$RequestAjaxString);
mysql_query("set names gb2312");
$sort=$_GET[txt_sort];
mysql_query("insert into wp_jargon(jargon_text) values('$sort')");
// header('Content-type:text/html;charset=GB2312');
?>
运行结果是：
如果添加的框是空的，还可以正常跳出提示对话框；但是如果不为空的时候就出错，几乎没什么相应。求求高手来解决下
