php删除行,在php中删除整行

我很难删除整行。 这是我的department.php代码:<?php

include 'DB.php';

$sqlquery = 'SELECT*FROM work WHERE DepID=1';

$result = $conn->query($sqlquery);

if ($result->n_rows>0){

while($rows=$result->fetch_assoc()) {

$id = $row["id"];

$sql_get_Emp = "SELECT*FROM emp WHERE id = '$id'";

$emp = $conn->query($sql_get_Emp)->fetch_assoc();

$sql_get_mgr = "SELECT*FROM department WHERE ManagerID = '1'";

$mgr = $conn->query($sql_get_mgr)->fetch_assoc();

echo "

".

"

".$emp["id"]."".

"

".$emp["name"]."".

"

".$emp["age"]."".

"

".$emp["salary"]."".

"

".$emp["datehired"]."";

if ($mgr["ManagerID"] == $emp["EmpID"]) {

echo "

Manager ";

}else{

echo "

Employee ";

}

echo "

".

"

".

"".

"Delete".

"

".

"

";

echo "

";

}

}else{

echo "0 results";

}

$conn->close();

?>

这是index.php中的一些代码，显示在提交删除按钮之后。

ID	Name	Age	Salary	Date Hired	Designation	Action

include 'department.php';

?>

这是我的delete.php，它只删除id，姓名，年龄，工资和雇用日期。 它不会删除“指定”和“操作”按钮。<?php

include('DBConnector.php');

$EmpID = $_POST['EmpID'];

$delquery="DELETE FROM employee WHERE EmpID='$_POST[EmpID]';";

$delresult = $conn->query($delquery);

header('location:index.php');

?>

如何删除表的整行？ 如有任何答复，不胜感激。