使用php和mysql中的下拉列表选择列表从数据库中检索数据(Retrieving data from databse using the dropdown selected list in php and mysql)
我有从mysql数据库填充的texbox和下拉列表。 我想从数据库中检索数据，并希望使用下拉列表选择列表在文本框中显示，而不刷新页面。 这是我的代码，并提前致谢。
<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/>I have texbox and dropdown list which is populated from mysql database. I want to retrieve data from database and wants to display in textbox using dropdown selected list, without refreshing the page. Here is my code and Thanks in Advance.
<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 Textbox:
<input type="text" id="field1" value="<?php echo $viewallcompanies['tccontact']?>" disabled/>最满意答案
像这样分开的东西：
<?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 } ?>Separate things out like this:
<?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 } ?>更多推荐
发布评论