php删除数据库第一行数据库,PHP-使用复选框从数据库表中删除一行

我想在表的每行中都显示一个数据库中的记录.如果选中该行,则该复选框将确定用户是否要删除该特定行.我能够显示来自数据库的数据,但是当我按下删除按钮时,什么也没发生.我不确定,但我认为错误在于我删除了部分代码,但我可能是错的.我不确定.无论如何,这是代码,我只删除了几行

$link = mysql_connect("localhost","root", "123");

if(!$link) {

die('Failed to connect to server: ' . mysql_error());

}

$db= mysql_select_db("abc");

if(!$db) {

die("Unable to select database");

}

$search = $_POST['search'];

$searchbox = $_POST['searchbox'];

$query = ("SELECT $search FROM table where $search = '$searchbox'");

$result=mysql_query($query);

if($result)

{

if(mysql_num_rows($result)<=0)

{

echo "";

}

}

switch ($search)

{

case 'studentnumber':

$result = mysql_query("SELECT * FROM table WHERE $search = '$searchbox'");

if($result){

echo "

Student Records

Delete	Student Number	College	Course	Status	Last Name	First Name	Middle Name	Address	Gender	Civil Status	Religion	Email Address	Month	Day	Year	Father's Name	Father's Occupation	Mother's Name	Mother's Name

while($row = mysql_fetch_array($result))

{

echo "

";

?>

echo "

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

echo "

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

echo "

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

echo "

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

echo "

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

echo "

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

echo "

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

echo "

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

echo "

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

echo "

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

echo "

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

echo "

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

echo "

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

echo "

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

echo "

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

echo "

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

echo "

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

echo "

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

echo "

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

}

echo "

";

echo "

";