javascript - 使用php和mysql中的下拉选择列表从数据库检索数据

Question

我有 texbox 和下拉列表，它们是从 mysql 数据库填充的。我想从数据库检索数据，并希望使用下拉选定列表在文本框中显示，而不刷新页面。这是我的代码，提前致谢。

<select name="select1" class="form-control" id="dropdownlist1">
      <option id="0">-- Select the Company --</option>
      <?php
          require("dbcon.php");

          $getallcompanies = mysql_query("SELECT * FROM ifcandetails6");

          while($viewallcompanies = mysql_fetch_array($getallcompanies)){
              ?>
      <option id="<?php echo $viewallcompanies['tcuid']; ?>"><?php echo $viewallcompanies['tcname'] ?></option>
      <?php
          }
           ?>

  </select>

输入文本框:

 <input type="text" id="field1" value="<?php echo $viewallcompanies['tccontact']?>" disabled/>

Answer 1

像这样分开:

<?php

require("dbcon.php");

$query = mysql_query("SELECT tcuid, tcname, tccontact FROM ifcandetails6");
while($row = mysql_fetch_array($query)){
    $contacts[] = $row['tccontact'];
    $companies[] = $row;   
}
?>

<select name="select1" class="form-control" id="dropdownlist1">
    <option id="0">-- Select the Company --</option>
    <?php foreach($companies as $company) { ?>
        <option id="<?= $company['tcuid']; ?>"><?= $company['tcname'] ?></option>
    <?php }  ?>
</select>
<?php foreach($contacts as $contact) { ?>
    <input type="text" id="field1" value="<?= $contact['tccontact']?>"/>
<?php }  ?>