PHP Bulk Delete Data method Analysis _php Tutorial

You can refer to this article below 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 CodeThe code is as follows:
　　

Good $id_dele=$_post[' Id_dele ' will be an array, although PHP is a weak type, but there is no ASP weak.
ASP can directly:
Sql= "Delete from [doing] where ID in ('" &ID_Dele& ') "is deleted. But PHP can't put $id_dele directly in. Because $id_dele is not ' 1,2,3,4 ' Oh, because $id_dele is an array with keys and values.
Well, PHP is not difficult, just have a function: implode (), right. A function opposite to the split () explode () function, which is split with a character (such as a comma), while the former can be stitched together as a string.
So:
Copy CodeThe code is as follows:
$ID _dele= implode (",", $_post[' Id_dele ');
$SQL = "Delete from ' doing ' where ID in ($ID _dele)";


The script House provides the test code:
Copy CodeThe code is as follows:

if ($_post["action"]= "doing") {
$del _id=$_post["Id_dele"];
$ID _dele= implode (",", $_post[' Id_dele ');
echo "merged:" $ID _dele. "
Before the merger: ";
if ($del _id!= "") {
$del _num=count ($del _id);
for ($i =0; $i < $del _num; $i + +) {
echo $del _id[$i];
}
}
}else{
echo "Please submit";
}

?>

http://www.bkjia.com/PHPjc/320728.html www.bkjia.com true http://www.bkjia.com/PHPjc/320728.html techarticle You can refer to this 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. Forms: Copying Code ...

