phpexcel删除行_使用php删除表格的特定行

这个问题是非常基本的,我在stackoverflow中发现了许多类似的问题,但是没有一个问题适合我.

我设计了一个表,将显示如下数据：

ID name Delete

1 abc Delete

2 def Delete

上面显示的代码是

$con=mysqli_connect("abc","abc","abc","abc");

// Check connection

if (mysqli_connect_errno())

{

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

$result = mysqli_query($con,"SELECT * FROM student");

echo "

IDnamedelete";

while($row = mysqli_fetch_array($result))

{

echo "

";

echo "

";

echo "

" . $row['id'] . "";

echo "

" . $row['name'] . "";

echo "

Delete";

echo "

";

echo "

";

}

echo "

";

mysqli_close($con);

?>

delete.php的代码

$con=mysqli_connect("abc","abc","abc","abc");

// Check connection

if (mysqli_connect_errno()) {

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

mysqli_query($con,"DELETE FROM student WHERE id='$id'");

mysqli_close($con);

header("Location: index.php");

?>

数据库视图为

Id name

1 abc

2 cdf

问题是它没有删除数据,也没有显示任何错误

我是这个领域的新手,如果有人可以帮助我,将不胜感激