Php batch delete data program code. Php batch delete data program code I believe many of my friends do not know how to batch delete unwanted data, to delete data in batches using php, we need to use the mysql in condition to implement the code for batch data deletion in php.
I believe many of my friends still don't know how to batch delete unwanted data. to delete data in batches using php alone, we need to combine the mysql in condition to achieve this, after reading this sentence, we can understand how to do this. Next, I will explain the batch data deletion process to my friends who need to know it in detail.
We delete the required SQL syntax.
Delete from aaaa where id in (, 3) here, 1, 2, and 3 are the records we need to delete.
How to do this in php
1. on the article list page (list. php), name the multiple baskets "$ del_id []" and set the value to the article ID.
For example (list. php ):
The code is as follows: |
|
2. processing page (del. php ): If ($ del_id! = ""){ $ Del_num = count ($ del_id ); For ($ I = 0; $ I <$ del_num; $ I ++ ){ Mysql_query ("Delete from news where id = '$ del_id [$ I]'"); } Echo (" |