Many of my friends often need to delete data in batches during Website Development. especially those who are used to asp, I feel that asp is really convenient. it is a little troublesome to use arrays in 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 are separated by commas.
Form:
The code is as follows:
Good $ ID_Dele = $ _ POST ['id _ Dele '] will be an array. Although PHP is of a weak type, ASP is not weak here.
ASP can be directly:
SQL = "delete from [doing] where id in ('" & ID_Dele. However, PHP cannot directly include $ ID_Dele. 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's just a function: implode (), right. A function is the opposite of the split () explode () function. The latter two are separated by a certain character (such as a comma), and the former can be spliced as a string.
Therefore:
The code is as follows:
$ ID_Dele = implode (",", $ _ POST ['id _ dele']);
$ SQL = "delete from 'doing' where id in ($ ID_Dele )";
The script home provides the test code:
The code is as follows:
If ($ _ POST ["action"] = "doing "){
$ Del_id = $ _ POST ["ID_Dele"];
$ ID_Dele = implode (",", $ _ POST ['id _ dele']);
Echo "merged:". $ 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 "submit ";
}
?>