我想添加下拉列表优先选项手册,毕竟要从我的“游戏表”中添加。
在我的代码中,一切正常,但每次从游戏表中获得结果后,我的手动选项“选择”都会重复。
这是我的代码
<!DOCTYPE HTML>
<html>
<head>
<title>Update Result</title>
</head>
<body>
<?php
//Connect to Database Server
include 'secure.php';
//Select a Table from Database
$query = "SELECT * FROM game";
//Get Result from Table (all)
$result = mysqli_query($connect,$query);
?>
<!-- Head Line -->
<h3> Update Result</h3>
<!-- Create Result Form -->
<form action="rsave.php" method="post">
<label>Date:</label><input type="date" name="ResultDate" tabindex="1" min="1899-12-31" max="2100-12-31" title="Please Enter Correct Date" required ><br>
<!--Select Start with PHP-->
<label>Game:</label><select id="Select1" name="ResultName" tabindex="2" title="Select a GameName" required >
<?php
// PHP Again
while ($line = mysqli_fetch_array($result, MYSQL_ASSOC)) {
?>
<option value="">SELECT</option>
<option value="<?php echo $line['GameID'];?>"><?php echo $line['name'];?></option>
<?php
}
?>
</select><br>
<!--Select End with PHP-->
<label>ReNO:</label><input type="number" name="ResultNo" min="0" max="100" tabindex="3" pattern="[0-9]{2,3}" title="Add a Number Between 0 to 100"required ><br>
<input type="submit" value="Update" tabindex="4">
<input type="reset" value="Reset" tabindex="5"><br>
</form>
</body>
</html>
拉这条线:
<option value="">SELECT</option>
在您的while循环之上,如下所示:
<label>Game:</label>
<select id="Select1" name="ResultName" tabindex="2" title="Select a GameName" required >
<option value="">SELECT</option>
<?php
// PHP Again
while ($line = mysqli_fetch_array($result, MYSQL_ASSOC)) {
?>
<option value="<?php echo $line['GameID'];?>"><?php echo $line['name'];?></option>
<?php
....
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句