全部代码在这里 http://blog.csdn.net/maqingbin8888/archive/2009/02/03/3860231.aspx以下这段关键代码只能实现编辑单元格,请问:当修改了数据按下回车键后,如何通过PHP更新数据到MySQL(AJAX方式)?
function tdclick()
{
var clickfunction = this ;
var td = $(this)
var text = td.text();
td.html("");
var input = $("<input>");
input.attr("value", text);
input.keyup(function(event) {
var myEvent = event || window.event;
var kcode = myEvent.keyCode;
if (kcode == 13)
{
var inputnode = $(this);
var inputext = inputnode.val();
var tdNode = inputnode.parent();
tdNode.html(inputext);
tdNode.click(tdclick);
}
if(kcode == 27)
{
var inputNode = $(this);
var inputText = text;
inputNode.attr("value",text);
}
});
td.append(input);
var inputdom = input.get(0);
inputdom.select();
td.unbind("click");
}
function tdclick()
{
var clickfunction = this ;
var td = $(this)
var text = td.text();
td.html("");
var input = $("<input>");
input.attr("value", text);
input.keyup(function(event) {
var myEvent = event || window.event;
var kcode = myEvent.keyCode;
if (kcode == 13)
{
var inputnode = $(this);
var inputext = inputnode.val();
var tdNode = inputnode.parent();
tdNode.html(inputext);
tdNode.click(tdclick);
}
if(kcode == 27)
{
var inputNode = $(this);
var inputText = text;
inputNode.attr("value",text);
}
});
td.append(input);
var inputdom = input.get(0);
inputdom.select();
td.unbind("click");
}
$.ajax({
type:'POST,
url:'xxx.php', //需要发送请求到哪个php文件
data:'', //数据
success:function(){
do something here; //你要做的事情
}
});
<?php
//abc.php
if($_GET){
echo $_GET['text'];
}else if($_POST){
echo $_POST['text'];
}else{
echo $_REQUEST['text'];
}
?><input type="text" id="text" value="我是中国人">
<input type="button" name="button" value="myAjax" onclick="post_test()"><script language="javascript">
var request;
function createxmlHttpRequest(){//判断浏览器类型,创建xmlHttpRequest对象
if(!request){
if(window.XMLHttpRequest){
request = new XMLHttpRequest();
}else{
request = new ActiveXObject("Microsoft.XMLHTTP");
}
}
}function get_test(){//get发送模式
createxmlHttpRequest();
var url = "abc.php?text=" + encodeURI(document.getElementById("text").value);
request.open("get", url, true);//true同步 false异步
request.onreadystatechange = callback;
request.send(null);
}function post_test(){//post发送模式
createxmlHttpRequest();
var url = "abc.php";
var send = "text=" + encodeURI(document.getElementById("text").value);
request.open("post", url, true);//true同步 false异步
request.onreadystatechange = callback;
request.setRequestHeader("content-type", "application/x-www-form-urlencoded");
request.send(send);
}function callback(){//回调函数
if (request.readyState == 4){
if (request.status == 200){
alert(request.responseText);
}else if(request.status == 404){
alert("该路径未找到");
}else if(request.status == 403){
alert("禁止访问");
}else{
alert("status is " + request.status);
}
}
}
</script>