从同一下拉列表中添加多个项目 - Adding multiple items from same drop down list

Adding multiple items from same drop down list

本文关键字：项目添加下拉列表 | 更新日期: 2023-10-15

我从数据库查询中填充了以下下拉列表。我正在努力想办法添加从下拉框中选择的项目本质上是一个类似购物车的列表，它允许我从这个下拉框中进行多个添加。你有人能指导我使用这个吗

    <?php
mysql_connect('localhost', 'blah', 'password');
mysql_select_db('reporting');
$sql = "SELECT DISTINCT ProductNumber, Description FROM Stock WHERE ProductGroup ='800'";
$result = mysql_query($sql);
echo "<select name='PRODS'>";
while ($row = mysql_fetch_array($result)) {
    echo "<option value='" . $row['Description'] . "'>" . $row['Description'] . "</option>";
}
echo "</select>";
?>

尝试：

echo "<select name='PRODS' multiple>";

这样，您就可以从选择框中选择多个值。

试试这个。。。。

<?php
    mysql_connect('localhost', 'blah', 'password');
    mysql_select_db('reporting');
    $sql = "SELECT DISTINCT ProductNumber, Description FROM Stock WHERE ProductGroup ='800'";
    $result = mysql_query($sql);
    echo "<select name='PRODS' multiple>";
    while ($row = mysql_fetch_array($result)) {
    echo "<option value='" . $row['Description'] . "'>" . $row['Description'] . "</option>";
    }
    echo "</select>";
    ?>