开发者

Delete data not working

开发者 https://www.devze.com 2023-01-22 12:44 出处:网络
I want to delete some data use: $dbc=mysql_connect(_SRV,_ACCID,_PWD) or die(_ERROR15.\": \".mysql_error());

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':
                deld开发者_JAVA技巧ata(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 = ''


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()


make sure that the $id variable is same case throughout, $id != $ID


postVar is not a variable. Try to use $postVar. If your postVar is a function, give us code of this function. I don't see a end of the switch function.


Based on the echo $sql it looks like postVar('delid') is returning null.

You should check your code and see if 'delid' is what you're actually passing to your script or if there is some other reason why it isn't set.

How is 'delid' set?


In PHP $id and $ID are two different variables.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号