20,398
社区成员




<script type="text/javascript">
$(document).ready(function() {
$(".quxiao").each(function(){
$(this).click(function(){
quxiao($(this));
})
})
});
function quxiao(obj){
var oid = $(obj).val();
var oid = $(obj).parent().next().children(".oid").val();//获取节点
//alert(oid);
$.ajax({ //一个Ajax过程
type: "post", //以post方式与后台沟通
url : "xgkcg.php", //与此php页面沟通
dataType:'json', //从php返回的值以 json方式 解释
data: {oid:oid},
success: function()
{ //如果调用php成功
alert("成功取消订单!");
}
});
}
</script>
require_once("config.php");
header('content-type:application/json');
$oid=$_POST['oid'];
$sql="delete from `djs_shops_orders` where oid = '$oid'";
$result = mysql_query($sql);
$row = mysql_fetch_row($result);
<td><input id="quxiao" class="quxiao" type="button" value="取消"></td>
<td><input type="hidden" class="oid" id="oid" value="<?php echo $v['orderid']; ?>"></td>
success: function()
{
alert("成功取消订单!");
window.reload();
}
或者不刷新的话 调用代码删除
success: function()
{
alert("成功取消订单!");
$(obj).closest('tr').remove();
}
require_once("config.php");
header('content-type:application/json');
$oid = addcslashes($_POST['oid']);//转义字符
$sql = "delete from `djs_shops_orders` where oid = '$oid'";
mysql_query($sql);
if(mysql_affected_rows() > 0){//影响条数
return true;
}else{
return false;
}
require_once("config.php");
header('content-type:application/json');
$oid=$_POST['oid'];
$sql="delete from `djs_shops_orders` where oid = '$oid'";
$result = mysql_query($sql);
if($result){
return true;
}else{
return false;
}