duanpang2751 2010-10-26 07:17
浏览 112
已采纳

删除数据不起作用

I want to delete some data use:

    $dbc=mysql_connect(_SRV,_ACCID,_PWD) or die(_ERROR15.": ".mysql_error());
    $db=mysql_select_db("qdbase",$dbc) or die(_ERROR17.": ".mysql_error());

    switch(postVar('action')) {
              case 'changedata': 
 changedata(postVar('id'),postVar('chlotno'),postVar('chrange'),postVar('chS'),postVar('chA'),postVar('chB'),postVar('chC'),postVar('chstatus'));
                break;
        case 'deldata':
                deldata(postVar('delid'));
                break;
              }

    function changedata($id,$chlotno,$chrange,$chS,$chA,$chB,$chC,$chstatus){
        $ID = mysql_real_escape_string($id);
        $Lot_no = mysql_real_escape_string($chlotno);
        $Range = mysql_real_escape_string($chrange);
        $S = mysql_real_escape_string($chS);
        $A = mysql_real_escape_string($chA);
        $B = mysql_real_escape_string($chB);
        $C = mysql_real_escape_string($chC);
        $Status = mysql_real_escape_string($chstatus);
        $Lot_no=strtoupper($Lot_no);
        $Range=strtoupper($Range);

        $sql = "UPDATE inspection_report SET Lot_no = '".$Lot_no."', Range_sampling = '".$Range."', S = '".$S."', ";
        $sql.= "A = '".$A."', B = '".$B."', C = '".$C."', Status = '".$Status."' ";
        $sql.= "WHERE id = ".$ID;

echo $sql;
$result=mysql_query($sql) or die(_ERROR26.": ".mysql_error());
//echo $result;
mysql_close($dbc);
}
function deldata($id){
        $ID = mysql_real_escape_string($id);
        $sql = "DELETE FROM inspection_report WHERE id = '".$ID."'";

echo $sql;
$result=mysql_query($sql) or die(_ERROR26.": ".mysql_error());
//echo $result;
mysql_close($dbc);
}

I have not found any error message in this query and show "200,OK". But the data still exist (not deleted). Why its happen? Is there something wrong in my query?

echo $sql:DELETE FROM inspection_report WHERE id = ''
  • 写回答

5条回答 默认 最新

  • duanmu1736 2010-10-27 02:04
    关注

    huft sorry...i have made a stupid mistake, this is my answer:

    $('#balupdate').click(function() {
              if ($("#editbaldata").valid()){
                         var params = $('#editbaldata').serialize();
                         $.ajax({
                                 async  : false,
                                 cache  : false,
                                 data   : params,
                                 success: function(res) {
    

    i miss the .serialize()

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(4条)

报告相同问题?

悬赏问题

  • ¥20 腾讯企业邮箱邮件可以恢复么
  • ¥15 有人知道怎么将自己的迁移策略布到edgecloudsim上使用吗?
  • ¥15 错误 LNK2001 无法解析的外部符号
  • ¥50 安装pyaudiokits失败
  • ¥15 计组这些题应该咋做呀
  • ¥60 更换迈创SOL6M4AE卡的时候,驱动要重新装才能使用,怎么解决?
  • ¥15 让node服务器有自动加载文件的功能
  • ¥15 jmeter脚本回放有的是对的有的是错的
  • ¥15 r语言蛋白组学相关问题
  • ¥15 Python时间序列如何拟合疏系数模型