PHP Tutorial: Study the method of deleting data in batches_PHP Tutorial

SQL: $SQL="delete from `doing` where id in (1,2,3,4)";

Data separated by commas.

Form:

Okay $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.

Okay, 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)";

http://www.bkjia.com/PHPjc/486469.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/486469.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...