【php开源代码栏目提醒】:网学会员--在 php开源代码编辑为广大网友搜集整理了:check_form_research.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>
<br><br><br>
<body background="images/0021.gif" leftmargin="150">
<font face="标楷体">
<h2 align=left>验收单多条件查询</h2>
<form action="check_form_research.php" method="post" >
<strong><以文字.内容搜寻></strong><br>
查询条件:
<SELECT name="rule1">
<OPTION>
<OPTION value='chk_num'>作业序号
<OPTION value='chk_no'>资产编号
<OPTION value='chk_cate'>资产类别
<OPTION value='chk_name'>资产名称
<OPTION value='chk_owner'>保管人
<OPTION value='chk_out_dep'>成本中心
<OPTION value='chk_location'>所在位置
<OPTION value='chg_com'>验收备注
</SELECT>
算式:
<SELECT name="oper1">
<option>
<OPTION value='like'>like
<OPTION value='not like'>not like
</select>
关键字:
<input type="TEXT" name="keyword1" size='12'>
<? //这是将字元加上'% %'
if ($keyword1 !== "")
{
$sym1="%";
$sym2="%";
$sym3="'";
$keyword1= "$sym3$sym1$key
word1$sym2$sym3";
}
?>
<br><br>
查询关系:
<SELECT name="choice" >
<option>
<OPTION value='and'>and
<OPTION value='or'>or
</select>
<br><br>
<strong><以数字.日期搜寻></strong><br>
查询条件:
<SELECT name="rule2">
<option>
<OPTION value='chk_amt'>数量
<OPTION value='chk_price'>购入金额
<OPTION value='chk_chday'>验收日期
</SELECT>
算式:
<SELECT name="oper2">
<option>
<OPTION value='='>=
<OPTION value='!='>!=
<OPTION value='<'><
<OPTION value='<='><=
<OPTION value='>'>>
<OPTION value='>='>>=
</select>
关键字:
<input type="TEXT" name="keyword2" size='12'>
<br><br>
<input type="submit" value=" 确认 "> <input type="reset" value=" 清除 ">
</form>
<hr><br>
<form>
<b><查询结果></b><br>
<?
$link=mysql_connect('localhost','root','123456');
mysql_select_db('fams');
//秀出查询资料
$str=" select * from check_form where ".$rule1." ".$oper1." ".$keyword1." ".$choice." ".$rule2." ".$oper2." '".$keyword2."';";
echo "<br>";
$result=
mysql_query($str,$link);
while ($row=my
sql_fetch_array($result,MYSQL_NUM))
{
echo "<table border=2 cellspacing='1' cellpadding='1' width='400' bordercolor='#999999'>";
echo "<tr><td>资产编号</td><td>".$row[0]."</td>";
echo "<tr><td>资产类别</td><td>".$row[1]."</td>";
echo "<tr><td>资产名称</td><td>".$row[2]."</td>";
echo "<tr><td>购入金额</td><td>".$row[3]."</td>";
echo "<tr><td>数量</td><td>".$row[4]."</td>";
echo "<tr><td>保管人</td><td>".$row[5]."</td>";
echo "<tr><td>验收日期</td><td>".$row[6]."</td>";
echo "<tr><td>成本中心</td><td>".$row[7]."</td>";
echo "<tr><td>所在位置</td><td>".$row[8]."</td>";
echo "<tr><td>验收备注</td><td>".$row[9]."</td>";
echo "<tr><td>
作业序号</td><td>".$row[10]."</td>";
echo "</table>";
echo "<br><p>";
}
mysql_close($link); //关闭连结
?>
<INPUT onclick="document.execCommand('print','true','true')" type=button value=列印>
</form>
</font>
</body>
</html>