Home >Backend Development >PHP Tutorial >php multi-select delete_PHP tutorial

php multi-select delete_PHP tutorial

WBOY
WBOYOriginal
2016-07-13 17:49:111061browse

SQL: $SQL="delete from `doing` where id in ('1,2,3,4')";
Data are separated by commas.
Form:








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

Excerpted from chaojie2009’s column

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/478360.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=...
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn