Php batch data deletion code _ PHP Tutorial

Source: Internet
Author: User
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 ("

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.