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