代码之家 › 专栏 › 技术社区 › GoGoAllen

动态显示名字和姓氏作为选择选项

option dynamic select sql php

0

GoGoAllen · 技术社区 · 7 年前

我试图动态显示数据库中人员的名字和姓氏。我已经成功地显示了名字,但是我不知道如何使用姓氏。任何帮助都将不胜感激:)

菲律宾比索:

$swimmername_query = "SELECT * From Swimmers ORDER BY FirstName ASC";
$swimmername_results = mysqli_query($dbcon, $swimmername_query);
echo "<option value=>";
echo "Select Customer";
echo "</option>";

while ($displayname = mysqli_fetch_assoc($swimmername_results)){
echo "<option value = '".$displayname['FirstName']."'>".$displayname['FirstName']."</option>";
            }

2 回复 | 直到 7 年前

1

2

hungrykoala 7 年前

您可以直接在查询中连接它,如下所示:

$swimmername_query = "SELECT *, CONCAT(FirstName, '-', LastName) AS FullName From Swimmers ORDER BY FirstName ASC";
$swimmername_results = mysqli_query($dbcon, $swimmername_query);
echo "<option value=>";
echo "Select Customer";
echo "</option>";

while ($displayname = mysqli_fetch_assoc($swimmername_results)){
     echo "<option value = '".$displayname['FullName']."'>".$displayname['FullName']."</option>";
}

或连接while循环中的字符串:

$swimmername_query = "SELECT * From Swimmers ORDER BY FirstName ASC";
$swimmername_results = mysqli_query($dbcon, $swimmername_query);
echo "<option value=>";
echo "Select Customer";
echo "</option>";

while ($displayname = mysqli_fetch_assoc($swimmername_results)){
    $fullname = $displayname['FirstName']."-".$displayname['LastName'];
    echo "<option value = '".$fullname."'>".$fullname."</option>";
}

2

0

Otgonbold Batzorig 7 年前

$swimmername_query = "SELECT SwimmersID, Firstname || ' ' || Lastname SwimmerName From Swimmers ORDER BY FirstName ASC";
$swimmername_results = mysqli_query($dbcon, $swimmername_query);
echo "<option value=>";
echo "Select Customer";
echo "</option>";

while ($displayname = mysqli_fetch_assoc($swimmername_results)){
echo "<option value = '".$displayname['SwimmersID']."'>".$displayname['SwimmerName']."</option>";