How to delete employee information with specified number in php mysql_PHP tutorial

WBOY
Release: 2016-07-13 10:01:45
Original
784 people have browsed it

How to delete employee information with specified number in php mysql

This article mainly introduces the method of deleting employee information with specified number in php mysql. It involves mysql database operation skills and has certain reference. Value, friends in need can refer to it

The example in this article describes how to delete employee information with a specified number using php mysql. Share it with everyone for your reference. The specific analysis is as follows:

Use php to submit the employee number to mysql, and then mysql accepts the data and uses delete to delete the data. Here are some specific examples to share with you.

Example of delete statement:

The code is as follows:

delete from friends where user_name = 'simaopig';

In the syntax structure, we can see that, like the update syntax, we can omit the where clause, but this is a very dangerous behavior, because if the where clause is not specified, delete will delete all the items in the table. The record will be deleted immediately.

1. Delete the employee information with the specified number, the code is as follows:

The code is as follows:





Employee Information Form




header("Content-type:text/html; charset=utf-8");
$_SESSION['arr']=array('1'=>array('name'=>'Zhang San','age'=>18),'2'=>array('name'= >'李四','age'=>19),'3'=>array('name'=>'王五','age'=>20));
if(!emptyempty($_POST['num'])){
unset($_SESSION['arr'][$_POST['num']]); //Delete the employee information of the specified id
}
if(isset($_SESSION['arr'])){
foreach ($_SESSION['arr'] as $k => $v) {
echo "";
}
}

?>

".($k)."".$v['name']."".$ v['age']."





Enter employee number:







2. Example of batch deletion of employee information

Key technology: The key point of this example is the flexible use of while() loop statements. According to the submitted parameter values, the while() loop statement is executed, the deletion operation is performed in the loop body, and the loop deletion operation of the data is completed.

Design process:

(1) Create a PHP script file. First, connect to the MySQL database server, connect to the database named db_while in MySQL, and set the encoding format of the page. Then, define the loop variables $a and $b, and change the first layer The loop condition in the while loop is set to $b<$a, and then the while statement is used again to loop out the data in the data table and perform the data deletion operation. The code is as follows:

The code is as follows:

if($_POST[sub]){ //Get parameters via POST
$conn=mysql_connect("localhost","root","111"); //Connect to mysql database
mysql_select_db("db_while",$conn); //Connect to the database
mysql_query("SET NAMES GBK");//Define encoding format
$a=$_POST[te];//Receive text box parameters
$b=0;//Define variables
while($b<$a){//while loop
$rs=mysql_query("select * from tb_while");//Perform query operation
while($rst=mysql_fetch_array($rs)){//Save the query results in the array
$sql="delete * from tb_while where id=$b"; //sql statement
mysql_query($sql);//Perform deletion operation
echo "The employee named ".$rst[name]." has been deleted
";//Output the name of the deleted employee
$b
}
}
}
?>
(2) Store the file in the MR 2 66 folder and name it index.php.

I hope this article will be helpful to everyone’s php mysql program design.

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/971928.htmlTechArticlephp mysql method to delete specified number employee information This article mainly introduces php mysql method to delete specified number employee information , involving mysql database operation skills, with certain reference...
source:php.cn
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template