php+mysql method to delete employee information with a specified number, mysql number_PHP tutorial

php+mysql method to delete employee information with a specified number, mysql number

The example in this article describes the method of deleting 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:

Copy code 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:

Copy code 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

Copy code 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 $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.

http://www.bkjia.com/PHPjc/942987.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/942987.htmlTechArticlephp+mysql method of deleting employee information with a specified number, mysql number This article describes an example of deleting an employee with a specified number using php+mysql information method. Share it with everyone for your reference. Specific analysis is as follows...