Copy Code code as follows:
SQL: $SQL = "Delete from ' doing ' where ID in (' 1,2,3,4 ')";
Data is separated by commas.
Form:
Copy Code code as follows:
<form action= "? action=doing" method= "POST" >
<input name= "id_dele[]" type= "checkbox" id= "id_dele[]" value= "1"/>
<input name= "id_dele[]" type= "checkbox" id= "id_dele[]" value= "2"/>
<input name= "id_dele[]" type= "checkbox" id= "id_dele[]" value= "3"/>
<input name= "id_dele[]" type= "checkbox" id= "id_dele[]" value= "4"/>
<input type= "Submit"/>
</form>
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& '). 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 that is exactly the opposite of the split () \explode () function, which is separated by a character (such as a comma), and the former can be spliced into a string.
So:
Copy Code code as follows:
$ID _dele= implode (",", $_post[' Id_dele '));
$SQL = "Delete from ' doing ' where ID in ($ID _dele)";