如何使用<；选择>；php中用于导航数据库的元素 - How to use <select> element in php for navigating database?

我制作了一个这样的html页面。用户可以从下拉列表中选择，是要下载大厅门票还是结果。但我无法将标记中的选项与数据库链接起来。请帮我处理php代码。

<html>
  <body>
    <table width="200" border="0"  class="download">
      <form name="download" action="downloadhalltickets.php" method="post">
        <caption align="top">
          Downloads:
        </caption>
        <tr>
          <td>Select:</td>
          <td>
            <select name="select">
            <option value="Hall Tickets">Hall Tickets</option>
            <option value="Results">Results</option>
            </select>
          </td>
        </tr>
        <tr>
          <td>Seat no.</td>
          <td><input type="text" name="seatno" maxlength="10" />
          </td>
        </tr>
        <tr>
          <td><input type="submit" name="download1" value="Download" /></td>
        </tr>
      </form>
    </table>
  </body>
</html>

现在，我想在上面html页面的select选项上选择以下两个php页面中的任何一个。。

下载hallstickets.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link href="downloadhalltickets.css" type="text/css" rel="stylesheet"/>
<title>Download Halltickets</title>
</head>
<body>
<?php
$host="localhost"; // Host name 
$username="mt_prakash"; // Mysql username 
$password="h.patil"; // Mysql password 
$db_name="mt_test"; // Database name 
$tbl_name="members"; // Table name 
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");
?>
<?php
                        $select = $_POST['select'];
						$seatno = $_POST['seatno'];
						if ($select=='Hall Tickets'){
                        $query1 ="select * from hallticket where seatno='$seatno'";
						$query2= mysql_query($query1);
                        while ($row1 = mysql_fetch_array($query2)) {
?>                    
<input type="button" value=" Print this page " onclick="window.print();return false;" style="border-bottom-style:double;background-color:#FF6600;" align="right"/>
<form name="hallticket" id="hallticket" method="post" action="">
  <table width="763" id="hallticket1" border="1">
    <tr>
      <td colspan="4" align="center" style="color:#3300FF"><h1>Maharashtra Tantra Niketan Shikshan Mandal</h1>
          <h3>(Established Under Govt. of Maharashtra PT Act)</h3>
        <br />
          <span style="padding:3px 5px; background-color:#3366FF; border-radius:10px; color:#FFFFFF">HALL TICKET</span>
        <p></p></td>
    </tr>
    <tr>
      <td width="37"> </td>
      <td width="170">Name:</td>
      <td width="373"><?php echo $row1['name']; ?></td>
      <td width="165" rowspan="3"><img src="" alt="Photo" name="Photo" width="86" height="92" id="Photo" style="background-color: #FFFFFF" /></td>
    </tr>
    <tr>
      <td> </td>
      <td>Exam Date: </td>
      <td><?php echo $row1['examdate']; ?></td>
    </tr>
    <tr>
      <td> </td>
      <td>Exam Time: </td>
      <td><?php echo $row1['examtime']; ?></td>
    </tr>
    <tr>
      <td> </td>
      <td>Exam Center: </td>
      <td><?php echo $row1['examcenter']; ?></td>
      <td> </td>
    </tr>
    <tr>
      <td> </td>
      <td>Seat No: </td>
      <td><?php echo $row1['seatno']; ?></td>
      <td><img src="" alt="Signature" name="Signature" width="87" height="32" id="Photo" style="background-color: #FFFFFF" /></td>
    </tr>
</table>
</form>  
<?php
}
}
?>
</body>
</html>

下载结果.pp

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Download Results</title>
<link href="downloadhalltickets.css" type="text/css" rel="stylesheet"/>
</head>
<body>
<?php
$host="localhost"; // Host name 
$username="mt_prakash"; // Mysql username 
$password="h.patil"; // Mysql password 
$db_name="mt_test"; // Database name 
$tbl_name="members"; // Table name 
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");
                        $select = $_POST['select'];
						$seatno = $_POST['seatno'];
						if ($select=='Results'){
                        $query1 ="select * from result where resultseatno='$seatno'";
						$query2= mysql_query($query1);
                        while ($row1 = mysql_fetch_array($query2)) {
?>                    
<table width="806"  cellpadding="10" class="upload" border="1" style="border-radius:0; background-color:#FFFFFF; border-collapse:collapse;">
  <form action="upload.php" method="post" >
  <caption align="top">
    Result upload
  </caption>
  <tr>
    <td height="62" colspan="4" align="center"><h2 style=""><img src="mtnsm.JPG" width="84" height="103" style="float:left; clear:left"/>MAHARASHTRA TANTRA NIKETAN SHIKSHAN MANDAL</h2>
      <p style="float:left" align="center"> </p>
      <h3 style="">*ONLINE RESULT</h3></td>
  </tr>
  <tr>
    <td width="260"> Name of Student: </td>
    <td colspan="3"><?php echo $row1['resultname']; ?></td>
  </tr>
  <tr>
    <td>Examination held in: </td>
    <td colspan="3"><?php echo $row1['resultlocation']; ?></td>
  </tr>
  <tr>
    <td>Institute Code : </td>
    <td colspan="2"><?php echo $row1['resultinstitute']; ?></td>
    <td width="327"> Seat No:    
      <?php echo $row1['resultseatno']; ?></td>
  </tr>
  <tr>
    <td>NAME OF SUBJECT: </td>
    <td width="267">MAXIMUM MARKS </td>
    <td width="302">OBTAINED MARKS </td>
    <td>GRADE</td>
  </tr>
  <tr>
    <td>Talent search Exam </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td><p>A1  - 91 to 100</p>
      <p>A+  - 81 to 90</p>
      <p>A    - 71 to 80</p>
      <p>B+  - 61 to 70</p>
      <p>B    - 51 to 60</p>
      <p>C+  - 41 to 50</p>
    <p>C    - 1 to 40</p></td>
    <td colspan="3"> </td>
  </tr>
  <tr>
    <td>Date of Result: </td>
    <td colspan="3"><?php echo $row1['resultdate']; ?></td>
  </tr>
  <tr>
    <td> </td>
    <td colspan="3" align="right">
    </td>
  </tr>
  </form>
</table>
<?php
}
}
?>
</body>
</html>

我在这里更新我的第一个html代码。。。。它发出了警告。。警告：无法修改标头信息-标头已由/home/mtnsmin/public_html/updates for centers.php第27行的/home/mmnsmin/public_html/updates发送

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<link href="updates for centers.css" type="text/css" rel="stylesheet"/>
<link rel="icon" href="logo.jpg" type="image/x-icon">
<title>updates for centers</title>
<?php
// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");
if($_POST[select] == 'Hall Tickets'){
header('Location: downloadhalltickets.php');
}
elseif($_POST[select] == 'Results'){
header('Location: downloadresults.php');
}
?>
</head>
<body>
<div class="wrapper"><span style="opacity:1"><marquee behavior="alternate" scrollamount="5">Welcome To Maharashtra Tantra Niketan Shikshan Sansthan</marquee></span>
</div>
<div id="tabsE">
        <ul>
                                        <!-- CSS Tabs -->
			<li><a href="Home.php"><span>Home</span></a></li>
			<li><a href="Services.php"><span>Services</span></a></li>
			<li><a href="Updates.php"><span>Updates</span></a></li>
			<li><a href="Login.html"><span>login</span></a></li>
			<li><a href="About.html"><span>About</span></a></li>
         </ul>
</div>

<table width="200" border="0"  class="download">
  <form name="download" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
  <caption align="top">
    Downloads:
  </caption>
  <tr>
    <td>Select:</td>
    <td><select name="select">
	<option value="Hall Tickets" selected="selected">Hall Tickets</option>
    <option value="Results">Results</option>
    </select>
    </td>
  </tr>
  <tr>
    <td>Seat no.</td>
    <td><input type="text" name="seatno" maxlength="10" /></td>
  </tr>
  <tr>
    <td><input type="submit" name="download1" value="Download"/></td>
  </tr>
  </form>
</table>

<table width="200" border="0"  class="download">
  <form name="upload" action="students.php" method="post">
  <caption align="top">
    Uploads:
  </caption>
  <tr>
    <td>Name:</td>
    <td><input type="text" name="name" maxlength="30"/></td>
  </tr>
  <tr>
    <td>Education:</td>
    <td><input type="text" name="education" maxlength="30" /></td>
  </tr>
  <tr>
    <td>Address:</td>
    <td><input type="text" name="education" maxlength="100"/></td>
  </tr>
  <tr>
    <td><input type="submit" name="upload" value="Upload" /></td>
  </form>
</table>
</body>
</html>

最后，我把两个php页面都放在一个php页面上，并使用if…else条件，结果成功了。。！！

<html>
<body>
<input type="button" value=" Print this page " onclick="window.print();return false;" style="border-bottom-style:double;background-color:#FF6600;" align="right"/>
<?php
$host="localhost"; // Host name 
$username="mt_prakash"; // Mysql username 
$password="h.patil"; // Mysql password 
$db_name="mt_test"; // Database name 
$tbl_name="members"; // Table name 
// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");
                        $select = $_POST['select'];
						$seatno = $_POST['seatno'];
						if ($select=='Hall Tickets'){
                        $query1 ="select * from hallticket where seatno='$seatno'";
						$query2= mysql_query($query1);
                        while ($row1 = mysql_fetch_array($query2)) {
?>                    
<form name="hallticket" id="hallticket" method="post" action="">
  <table width="763" id="hallticket1" border="1">
    <tr>
      <td colspan="4" align="center" style="color:#3300FF"><h1>Maharashtra Tantra Niketan Shikshan Mandal</h1>
          <h3>(Established Under Govt. of Maharashtra PT Act)</h3>
        <br />
          <span style="padding:3px 5px; background-color:#3366FF; border-radius:10px; color:#FFFFFF">HALL TICKET</span>
        <p></p></td>
    </tr>
    <tr>
      <td width="37"> </td>
      <td width="170">Name:</td>
      <td width="373"><?php echo $row1['name']; ?></td>
      <td width="165" rowspan="3"><img src="" alt="Photo" name="Photo" width="86" height="92" id="Photo" style="background-color: #FFFFFF" /></td>
    </tr>
    <tr>
      <td> </td>
      <td>Exam Date: </td>
      <td><?php echo $row1['examdate']; ?></td>
    </tr>
    <tr>
      <td> </td>
      <td>Exam Time: </td>
      <td><?php echo $row1['examtime']; ?></td>
    </tr>
    <tr>
      <td> </td>
      <td>Exam Center: </td>
      <td><?php echo $row1['examcenter']; ?></td>
      <td> </td>
    </tr>
    <tr>
      <td> </td>
      <td>Seat No: </td>
      <td><?php echo $row1['seatno']; ?></td>
      <td><img src="" alt="Signature" name="Signature" width="87" height="32" id="Photo" style="background-color: #FFFFFF" /></td>
    </tr>
</table>
</form>  
<?php
}
}
else {
$query3 ="select * from result where resultseatno='$seatno'";
$query4= mysql_query($query3);
while ($row2 = mysql_fetch_array($query4)) {
?>
<table width="806"  cellpadding="10" class="upload" border="1" style="border-radius:0; background-color:#FFFFFF; border-collapse:collapse;">
  <form action="upload.php" method="post" >
  <caption align="top">
    Result upload
  </caption>
  <tr>
    <td height="62" colspan="4" align="center"><h2 style=""><img src="mtnsm.JPG" width="84" height="103" style="float:left; clear:left"/>MAHARASHTRA TANTRA NIKETAN SHIKSHAN MANDAL</h2>
      <p style="float:left" align="center"> </p>
      <h3 style="">*ONLINE RESULT</h3></td>
  </tr>
  <tr>
    <td width="260"> Name of Student: </td>
    <td colspan="3"><?php echo $row2['resultname']; ?></td>
  </tr>
  <tr>
    <td>Examination held in: </td>
    <td colspan="3"><?php echo $row2['resultlocation']; ?></td>
  </tr>
  <tr>
    <td>Institute Code : </td>
    <td colspan="2"><?php echo $row2['resultinstitute']; ?></td>
    <td width="327"> Seat No:    
      <?php echo $row2['resultseatno']; ?></td>
  </tr>
  <tr>
    <td>NAME OF SUBJECT: </td>
    <td width="267">MAXIMUM MARKS </td>
    <td width="302">OBTAINED MARKS </td>
    <td>GRADE</td>
  </tr>
  <tr>
    <td>Talent search Exam </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td><p>A1  - 91 to 100</p>
      <p>A+  - 81 to 90</p>
      <p>A    - 71 to 80</p>
      <p>B+  - 61 to 70</p>
      <p>B    - 51 to 60</p>
      <p>C+  - 41 to 50</p>
    <p>C    - 1 to 40</p></td>
    <td colspan="3"> </td>
  </tr>
  <tr>
    <td>Date of Result: </td>
    <td colspan="3"><?php echo $row2['resultdate']; ?></td>
  </tr>
  <tr>
    <td> </td>
    <td colspan="3" align="right">
    </td>
  </tr>
  </form>
</table>
<?php
}
}
?>
</body>
</html>

嗯。。。我可能误解了你的挑战，但我认为你让它变得比你需要的更复杂。

您可以使用ajax（从页面调用数据库）来实现它，并通过这种方式获取结果或票证。但如果你是编码新手，那么我建议你只使用链接。

下载结果下载门票

它没有精选那么花哨，但更容易。如果你想使用你输入的代码，那么你需要发布你尝试过的PHP代码。类似的东西，需要在downloadhallttickets.php文件中：

<?php
if ($_POST[select] == 'Hall Tickets'){
   // PHP-code-that-lets-you-download-the-tickets
} elseif ($_POST[select] == 'Results'){ 
    // PHP-code-that-lets-you-download-the-tickets
}
?>

这段PHP代码还没有经过测试，自从我用PHP编码以来，已经有一段时间了。所以要注意错误。

但我会从链接开始。回想起过早的优化是万恶之源！：-）