【php开源代码栏目提醒】:以下是网学会员为您推荐的php开源代码-change_form_add.php,希望本篇文章对您学习有所帮助。
</html>
<head>
<title>更改单建立</title>
</head>
<meta http-equiv="Content-Language" content="zh-tw">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=big5">
<script language="JavaScript" src="navcond.js"></script>
<script language="
JavaScript" src="navbarmenu.js"></script>
<body background="images/0021.gif" leftmargin="150">
<font face="标楷体">
<br>
<h2 align=left>新增更改单</h2>
<b><步骤一></b><br>
<form action="change_form_add.php" method="post" >
请先输入资产编号:
<input type="TEXT" name="chg_no">
<br><br>
<input type="submit" value=" 确认 "> <input type="reset" value=" 清除 ">
</form>
<hr><br>
<b><步骤二></b><br>
<form action="change_form_add_ok.php" method="post">
<?
$link=mysql_connect('localhost','root','123456');
mysql_select_db('fams');
$str="select asset_no from creasset where asset_no='".$chg_no."';";
$result=mysql_query($str,$link);
while ($row=mysql_fetch_array($result,MYSQL_NUM))
{
?>
资产编号:<input type="TEXT" name="chg_no" readonly="" value=<?echo "$row[0]"?>>
<?
}
?>
<br>
<?
$str="select category from creasset where asset_no='".$chg_no."';";
$result=mysql_query($str,$link);
while ($row=mysql_fetch_array($result,MYSQL_NUM))
{?>
资产类别:<input type="TEXT" name="chg_cate" readonly="" value=<?echo "$row[0]"?>>
<?}
?>
<br>
<?
$str="select name from creasset where asset_no='".$chg_no."';";
$result=mysql_query($str,$link);
while ($row=mysql_fetch_array($result,MYSQL_NUM))
{?>
资产名称:<input type="TEXT" name="chg_name" readonly="" value=<?echo "$row[0]"?>>
<?}
?>
<br>
<?
$str="select amt from creasset where asset_no='".$chg_no."';";
$result=my
sql_query($str,$link);
while ($row=
mysql_fetch_array($result,MYSQL_NUM))
{?>
数量:<input type="TEXT" name="chg_amt" readonly="" value=<?echo "$row[0]"?>>
<?}
?>
<br>
<?
$str="select owner from creasset where asset_no='".$chg_no."';";
$result=mysql_query($str,$link);
while ($row=mysql_fetch_array($result,MYSQL_NUM))
{?>
保管人:<input type="TEXT" name="chg_owner" readonly="" value=<?echo "$row[0]"?>>
<?}
?>
<br>
更改日期:<input type="TEXT" name="chg_chday">
<请填入 year-month-day>
<br>
<?
$str="select dep from creasset where asset_no='".$chg_no."';";
$result=mysql_query($str,$link);
while ($row=mysql_fetch_array($result,MYSQL_NUM))
{?>
成本中心:<input type="TEXT" name="chg_out_dep" readonly="" value=<?echo "$row[0]"?>>
<?}
?>
<br>
移入单位:
<SELECT name="chg_in_dep">
<?
$str="select dep_name from department;";
$result=mysql_query($str,$link);
while ($row=mysql_fetch_array($result,MYSQL_NUM))
{
echo "<option>".$row[0];
}
?>
</SELECT> <请择一>
<br>
更改原因:
<SELECT name="chg_rean">
<?
$str="select sts_com from status;";
$result=mysql_query($str,$link);
while ($row=mysql_fetch_array($result,MYSQL_NUM))
{
echo "<option>".$row[0];
}
?>
</SELECT> <请择一>
<br>
更改备注: <可填可不填>
<br>
<textarea rows=8 cols=40 name="chg_com" >
</textarea>
<br>
<br>
<?//主管签核:<input type="TEXT" name="chg_sign">?>
<br>
<input type="submit" value=" 确认 "> <input type="reset" value=" 清除 ">
</form>
</font>
</body>
</html>