The efficacy and function of Ganoderma lucidum spore powder and how to consume it. Analysis of the method of deleting data in batches using PHP

You can refer to the following article http://www.jb51.net/article/6488.htm
SQL: $SQL="delete from `doing` where id in ('1,2,3,4')" ;
　 Data is separated by commas.
　　Form:

Copy code The code is as follows:

　　

　　
　　
　　
　　
　
　

　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.
　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:

Copy the code The code is as follows:

　$ID_Dele= implode(",",$_POST['ID_Dele']);
　$SQL="delete from `doing` where id in ($ ID_Dele)";

This site provides test code:

Copy code The code is as follows:

if ($_POST["action"]="doing"){
$del_id=$_POST["ID_Dele"];
$ID_Dele= implode(",",$_POST['ID_Dele']);
echo "After merge :".$ID_Dele."
Before merging:";
if($del_id!=""){
$del_num=count($del_id);
for($i=0;$i< $del_num;$i++){
echo $del_id[$i];
}
}
}else{
echo "Please submit";
}
?>

1st
2nd
3rd
4th

The above introduces the efficacy and function of Ganoderma lucidum spore powder and the method of consumption. The analysis of the method of batch deleting data in PHP includes the efficacy and role of Ganoderma lucidum spore powder and the method of consumption. I hope it will be helpful to friends who are interested in PHP tutorials.