Php batch delete data program code
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: |
|
<Form name = "del_form" action = "del. php" method = "post"> <? Php $ Result = mysql_query ("select * from news "); While ($ rs = mysql_fetch_array ($ result )){ ?> <Input name = "del_id []" type = "checkbox" id = "del_id []" value = "<? = $ Rs [id]?> "/> <? = $ Rs [title]?> <? Php } ?> </Form> 2. Processing page (del. php ): <? 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 ("<script type = 'text/javascript '> alert ('deleted successfully! '); History. back (); </script> "); } Else { Echo ("<script type = 'text/javascript '> alert (' select a project first! '); History. back (); </script> "); } ?> |
Case Analysis:
The core code in the above batch is the form name del_id [] and
The Code is as follows: |
|
For ($ I = 0; $ I <$ del_num; $ I ++ ){ Mysql_query ("Delete from news where id = '$ del_id [$ I]'"); } |
This is to retrieve the submitted array and then traverse the items to delete it. This is the same as our previous statement. In fact, we can improve it.
The Code is as follows: |
|
$ Ids = implode (',', $ _ POST ['del _ id']); $ SQL = "delete from aaaa where id in ($ ids )"; Mysql_query ($ SQL ); |
In this way, we can reduce the number of statements. Of course, we need to determine whether the submitted statements are arrays. Finally, we need to perform code optimization and deletion operations on the del. php file.
The Code is as follows: |
|
<? Php If (is_array ($ del_id )){
$ Ids = implode (',', $ _ POST ['del _ id']); $ SQL = "delete from aaaa where id in ($ ids )"; If (mysql_query ($ SQL )) { Echo 'deleted successfully '; } Else { Echo 'deletion failed '; } } } ?> |