Use checkbox to delete multiple records at once_PHP tutorial

Answer a friend’s question: How to delete multiple records at once.
A simple example
There is a student information database and multiple records need to be deleted at one time
Create a file named del.php

The code is as follows:

Copy to ClipboardQuoted content: [www.bkjia.com]

< ;th>Options
$link=mysql_connect("localhost","root","");
mysql_select_db("zs");
$exec="select * from student";
$result=mysql_query($exec);
while($rs=mysql_fetch_object($result))
{
$id=$rs->sID;
$name=$ rs->sName;
$sex=$rs->sSex;
$phone=$rs->sPhone;
?>

< td> >


}
mysql_close();
?>

This file is mainly used to display the data in the database and display it.

Create a file named sc.php with the following code:

Copy to ClipboardQuoted content: [www.bkjia.com]$link=mysql_connect("localhost","root","");
mysql_select_db("zs");
$id=$_POST['de'];
foreach($id as $ide){
$exec="delete from student where sID=$ide";
$result=mysql_query($exec);
if((mysql_affected_rows()== 0) or (mysql_affected_rows==-1))
{
echo "No record found, or an error occurred while deleting";
exit;
}
else{
echo "Student The information has been deleted";
}
}
mysql_close();
?>

Use foreach to delete the records respectively.

Source: http://www.cnblogs.com/walkbro/

http://www.bkjia.com/PHPjc/364481.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/364481.htmlTechArticleAnswer a friend’s question: How to delete multiple records at one time. A simple example: There is a student information database and multiple records need to be deleted at one time. Create a file named del.php...

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

Previous article：Examples of defined() and strrchr() functions in PHP_PHP TutorialNext article：Examples of defined() and strrchr() functions in PHP_PHP Tutorial

Related articles

See more

• How to use cURL to implement Get and Post requests in PHP
• How to use cURL to implement Get and Post requests in PHP
• How to use cURL to implement Get and Post requests in PHP
• How to use cURL to implement Get and Post requests in PHP
• All expression symbols in regular expressions (summary)

Public welfare online PHP training，Help PHP learners grow quickly！

About usDisclaimerSitemap

© php.cn All rights reserved

Student Information Table

Student ID	Name< /th>	Gender	Phone number