我很难找到一种方法来创建一个由两个字段（名字和姓氏）填充的下拉列表。然而，当我尝试这样做时，只有姓氏显示。。。有什么想法/建议吗？
<!DOCTYPE html>
<html lang="en">
<head>
<title></title>
</head>
<body>
<form action="webfinal2.php"method="post">
<?php
define('DB_NAME', 'forms1');
define('DB_USER', 'test');
define('DB_PASSWORD', 'greatness');
define('DB_HOST', 'localhost');
$con=mysqli_connect(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME);
if(mysqli_errno($con))
{
echo "Can't Connect to mySQL:".mysqli_connect_error();
}
else
{
echo "Connected to mySQL</br>";
}
echo "<select name= 'FirstName'>";
echo '<option value="">'.'--- Please Select Person ---'.'</option>';
$query = mysqli_query($con,"SELECT first_name, last_name FROM demo");
$query_display = mysqli_query($con,"SELECT * FROM demo");
while($row=mysqli_fetch_array($query))
{
echo "<option value='". $row['first_name']."'>".$row['last_name']
.'</option>';
}
echo '</select>';
?> <input type="submit" name="submit" value="Submit"/>
</form>
<br/><br/>
</body>
</html>
<?php
while($row=mysqli_fetch_array($query))
{
echo "<option>".$row['first_name']." ".$row['last_name']."</option>";
}
?>
将first name与last name=>".$row['last_name']."".$row['last_name']." 合并
<?
.
echo "<select name= 'FirstName'>";
echo '<option value="">'.'--- Please Select Person ---'.'</option>';
$query = mysqli_query($con,"SELECT first_name, last_name FROM demo");
$query_display = mysqli_query($con,"SELECT * FROM demo");
while($row=mysqli_fetch_array($query))
{
echo "<option value='". $row['first_name']."'>".$row['first_name']." ".$row['last_name']."</option>";
}
echo '</select>';
更新的代码
<!DOCTYPE html>
<html lang="en">
<head>
<title></title>
</head>
<body>
<form action="webfinal2.php"method="post">
<?php
define('DB_NAME', 'forms1');
define('DB_USER', 'test');
define('DB_PASSWORD', 'greatness');
define('DB_HOST', 'localhost');
$con=mysqli_connect(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME);
if(mysqli_errno($con)) {
echo "Can't Connect to mySQL:".mysqli_connect_error();
}
else {
echo "Connected to mySQL</br>";
}
?>
<select name= 'FirstName'>
<option value="">--- Please Select Person ---</option>
<?php
$query = mysqli_query($con,"SELECT first_name, last_name FROM demo");
$query_display = mysqli_query($con,"SELECT * FROM demo");
while($row=mysqli_fetch_array($query))
{?>
<option value="<?php echo $row['first_name'];?>"><?php echo $row['first_name'].' '.$row['last_name'];?></option>
<?php }?>
</select>
<input type="submit" name="submit" value="Submit"/>
</form>
<br/><br/>
</body>
</html>