Home > Article > Backend Development > Use checkbox to delete multiple records at once_PHP tutorial

Use checkbox to delete multiple records at once_PHP tutorial

WBOYOriginal: 2016-07-21 14:55:09998browse

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 Clipboard Liehuo.Net Codes

Quoted 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 Clipboard Liehuo.Net Codes

Quoted 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/

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

See more

Student Information Table
Student ID	Name< /th>	Gender	Phone number

Use checkbox to delete multiple records at once_PHP tutorial

Related articles