如何在PHP中获取数据库填充组合框中所选项的id [英] How to get id of selected item in database populated combobox in PHP

问题描述

我有一个问题，就是从包含字段ID&数据库的数据库中填充客户名称的组合框中获取ID。名称。我想获取用户从组合框中选择的名称ID。以下是我用于填充组合框的代码：

I have a problem regarding obtaining id from Combo Box populating name of customer from a database containing field id & name. I want to get the id of name selected by user from Combo Box. Following is the code i have applied to populating Combo Box:

<input type="text" class="input-field" id="registerNumber" name="register_number" 

               list="register_number" placeholder="Select Register No" /></label>

<!-- Populating Editable ComboBox -->
    <datalist id="register_number" >
    <?php                               
        $result_set= mysqli_query( $connection, "Select  id,  customer_name from 
              service_register ");

       while($result = mysqli_fetch_assoc($result_set)){
            echo "<option value=\"{$result["customer_name "]}\" 
                          id=\"{$result["id"]}\"></option>";
        }   
?>

推荐答案

result_set = mysqli_query（

result_set= mysqli_query(

connection， 从$ b $中选择id，customer_name b service_register）;

while（

connection, "Select id, customer_name from service_register "); while(

result = mysqli_fetch_assoc（

result = mysqli_fetch_assoc(

这篇关于如何在PHP中获取数据库填充组合框中所选项的id的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！