Use checkbox to delete multiple records at once_PHP tutorial-PHP Tutorial-php.cn

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/

Related labels：

。 one Disposable delete how friend use Example answer Simple Record question

source：php.cn

Previous article：Examples of defined() and strrchr() functions in PHP_PHP Tutorial Next article：Interview questions a friend asked when applying for a job at Sina Leju_PHP Tutorial

Statement of this Website

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