如何用数据库中的数据自动填写文本框？
如何用数据库中的数据自动填写文本框？
提问于 2015-05-03 18:17:53
我想用对应于下拉框中选择的名称的数据填充所有文本框。我一直在寻找代码才能工作，但不幸的是，这些代码都不起作用。
<?php
include("webconfig.php");
session_start();
?><!doctype html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">
<link rel="shortcut icon" href="img/logo_trans.png">
<link rel="stylesheet" href="css/iconFont.css">
<link rel="stylesheet" href="css/metro-bootstrap.css">
<link rel="stylesheet" href="css/metro-bootstrap-responsive.css">
<script src="js/jquery/jquery.min.js"></script>
<script src="js/jquery/jquery.widget.min.js"></script>
<script src="js/load-metro.js"></script>
<!-- Local JavaScript -->
<script src="js/docs.js"></script>
<script src="js/github.info.js"></script>
<script src="js/Chart.js"></script>
<script src="js/metro-dropdown.js"></script>
<title>AS_SIGNS</title>
</head>
<body class="metro">
<nav class="horizontal-menu" style="background:#037E04;">
<ul>
<center><li><a href="index.php"><h1><font color="#FFFFFF">AS Signs</font></h1></a></li></center>
</ul>
</nav>
<div style="width:70%; height:60%; position:absolute; left:0;">
<div style="width:100%; height:100%;overflow:scroll; overflow-x:hidden; overflow-y:auto;">
<div style="width:50%; float:left;">
<h2>New Service Call</h2>
<form method="post" name="form">
<table class="table bordered" width="100%">
<tr>
<td>Customer ID</td>
<td><input type="text" name="custid" /></td>
</tr>
<tr>
<td>Customer Name</td>
<td>
<select name="CUSTOMER_NAME" style="width:205px" required>
<option value="default"></option>
<?php
$sql1 = "SELECT * FROM CUSTOMER_MASTER";
$sth = ibase_query($conn, $sql1) or die(ibase_errmsg());
$num = '';
while($row = ibase_fetch_assoc($sth))
{
$name = $row["ACCOUNT_NAME"];
echo "<option value=\"$name\">$name</option>";
}
?>
</select>
</td>
</tr>
<tr>
<td>Address</td>
<td><input type="text" name="ADDRESS" value="<?php echo "$add"?>"></td>
</tr>
</table>
</div>
<div style="width:50%; float:right;">
<h2 style="visibility:hidden;">cqcqcqcqc</h2>
<table class="table bordered" width="100%">
<tr>
<td>Contact Person</td>
<td><input type="text" name="CONTACT_PERSON" value="<?php echo "$contperson"?>"></td>
</tr>
<tr>
<td>Contact Number</td>
<td><input type="text" name="CONTACT_NUMBER" value= "<?php echo "$contnum"?>"> </td>
</tr>
</table>
<input type="submit" name="btnSave" value="SAVE" />
<input type="button" name="load" value="LOAD" />
<?php
if(isset($_POST['load']))
{
$sql = "SELECT * FROM CUSTOMER_MASTER WHERE CUSTOMER_NAME = '$name'";
$result = ibase_query($query, $conn);
$details = ibase_fetch_assoc($result);
$sth = ibase_query($conn, $sql) or die(ibase_errmsg());
$add = $details["ADDRESS"];
$name = $_POST["ACCOUNT_NAME"];
$servicenum = $details["SERVICE_CALL_NUMBER"];
$contperson = $details["CONTACT_PERSON"];
$contnum = $details["CONTACT_NUMBER"];
}
?>
<?php
$sql = "SELECT * FROM SERVICE_REPORTS";
$sth = ibase_query($conn, $sql) or die(ibase_errmsg());
$add = $_POST["ADDRESS"];
$name = $_POST["CUSTOMER_NAME"];
$servicenum = $_POST["SERVICE_CALL_NUMBER"];
$contperson = $_POST["CONTACT_PERSON"];
$contnum = $_POST["CONTACT_NUMBER"];
if(isset($_POST['btnSave']))
{
ibase_query($conn, "INSERT INTO SERVICE_REPORTS (CUSTOMER_NAME, ADDRESS, CONTACT_PERSON, CONTACT_NUMBER) VALUES('$name', '$add', '$contperson', '$contnum')") or die (ibase_errmsg());
echo "Record Saved";
}
?>
</form>
</div>
</div>
</div>
<div class="span5" style="position: absolute;right:0; top:100px;">
<nav class="sidebar dark">
<ul>
<li class="active"><a href="#"><i class="icon-home"></i>Home</a></li>
<li class="stick bg-red">
<a class="dropdown-toggle" href="#"><i class=""></i>Service Call</a>
<ul class="dropdown-menu" data-role="dropdown" data-effect="slide">
<li><a href="servicecallnew.php">New Service</a></li>
<li><a href="#">Service Call List</a></li>
</ul>
</li>
<li class="stick bg-red">
<a class="dropdown-toggle" href="#"><i class="icon-sale"></i>File Maintenance</a>
<ul class="dropdown-menu" data-role="dropdown" data-effect="slide">
<li><a href="items.php?itd=&action">Items</a></li>
<li><a href="categories.php">Categories</a></li>
<li><a href="contractors.php">Contractors</a></li>
<li><a href="suppliers.php">Suppliers</a></li>
</ul>
</li>
<li class="stick bg-red">
<a class="dropdown-toggle" href="#"><i class="icon-box-add"></i>Production</a>
<ul class="dropdown-menu" data-role="dropdown">
<li><a href="estimatelist.php">Estimate / Quotation</a></li>
<li><a href="bomlist.php">Bill of Materials</a></li>
<li><a href="bomposting.php">BOM Posting</a></li>
<li><a href="issuancelist.php">Issuance</a></li>
<li><a href="adjplist.php">Adjustment</a></li>
</ul>
</li>
<li class="stick bg-red">
<a class="dropdown-toggle" href="#"><i class="icon-box-add"></i>Inventory</a>
<ul class="dropdown-menu" data-role="dropdown">
<li><a href="receiving.php">Receiving</a></li>
</ul>
</li>
<li class="stick bg-red">
<a class="dropdown-toggle" href="#"><i class="icon-printer"></i>Reports</a>
<ul class="dropdown-menu" data-role="dropdown">
<!-- <li><a onClick="<?php echo "window.open('report_prod.php?type=estimate','mywindow3')"; ?>">Estimate / Quotation</a></li>
<li><a onClick="<?php echo "window.open('report_prod.php?type=bom','mywindow3')"; ?>">Bill of Materials</a></li>
<li><a onClick="<?php echo "window.open('report_prod.php?type=issuance','mywindow3')"; ?>">Issuance</a></li>
<li><a onClick="<?php echo "window.open('report_prod.php?type=adj','mywindow3')"; ?>">Adjustment</a></li>
<li><a onClick="<?php echo "window.open('rptinventory.php?','mywindow8','menubar=0,location=1,status=1,scrollbars=1,width=1000,height=500,left=0,top=0,screenX=50,screenY=100')"; ?>">Inventory</a></li>-->
<li><a href="signspec.php">Sign Spec</a></li>
<li><a href="warehouse.php">Warehouse</a></li>
</ul>
</li>
<li class="stick bg-red"><a href="#"><i class="icon-cog"></i>Settings</a></li>
<li class="stick bg-red"><a href="logout.php"><i class="icon-switch"></i>Logout</a></li>
</ul>
</nav>
</div>
</body>
</html>回答 2
Stack Overflow用户
回答已采纳
发布于 2015-05-03 18:30:35
如果我正确理解，您需要javascript为您完成此操作。您需要做的是触发一个事件，该事件会在所选内容发生更改时更改文本输入值。例如，对于客户名称，您可以这样做：
$("#customer-name-select").change(function(){
var customerName = $("option:selected").text();
$("#customer-name-select").val(customerName);
});Stack Overflow用户
发布于 2015-05-03 18:27:57
我会给你一些提示。
1)在doctype之上执行查询，而不是在页面中间进行查询。
2)在select菜单中使用onchange属性来执行一个javascript函数，该函数预置数据。
3)使用json_encode()将查询结果转换为json字符串，然后将该字符串分配给您的函数可以用来填充字段的javscript变量。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/30021666
复制相关文章
相似问题
Orchard CMS自定义小部件视图
如何导入小部件-- Orchard CMS
Orchard CMS小部件显示类型
Orchard CMS相关帖子小部件
Orchard CMS:未显示内容部件
添加站长 进交流群
领取专属 10元无门槛券
AI混元助手 在线答疑
关注 腾讯云开发者公众号
洞察 腾讯核心技术
剖析业界实践案例
腾讯云开发者
