SQL: $SQL="delete from `doing` where id in ('1,2,3,4')";
Data are separated by commas.
Form:
Well $ID_Dele=$_POST['ID_Dele'] will be an array. Although PHP is weakly typed, it is not as weak as ASP.
ASP can directly:
SQL="delete from [doing] where id in ('"&ID_Dele&"')" to delete. But PHP cannot put $ID_Dele directly into it. Because $ID_Dele is not '1,2,3,4', because $ID_Dele is an array with keys and values.
Well, it’s not difficult in PHP. There happens to be a function: implode(), that’s right. A function that has exactly the opposite function to split()explode(). The latter two are separated by a certain character (such as a comma), while the former can be spliced into a string.
Therefore:
$ID_Dele= implode(",",$_POST['ID_Dele']);
$SQL="delete from `doing` where id in ($ID_Dele)";
Excerpted from chaojie2009’s column
http://www.bkjia.com/PHPjc/478360.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/478360.htmlTechArticleSQL: $SQL=delete from `doing` where id in (1,2,3,4); data Separate with commas. Form: form action=?action=doing method=post input name=ID_Dele[] type=checkbox id=ID_Dele[] value=...