PHP简单查询界面

时间：2022-09-18 14:29:47
<html>

<style type='text/css'>

table {border-collapse:collapse;}

td {border:solid 1px #ddd;}

</style>

<body>

<?php

$link=mysql_connect("IP","User","Pwd");

if(!$link) echo "没有连接成功!";

else echo "连接成功!";

?>

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">

<label for="A">客户编号 </label>

<input type="text" id="A" name="cust" />

<br />

<label for="B">客户订单号</label>

<input type="text" id="B" name="cust_id" />

<input type="submit" name="submit" value="查询" />

</form>

<?php

if (isset($_POST['submit'])) {

$cust = $_POST['cust'];

$cust_id = $_POST['cust_id'];

mysql_select_db("myoabird", $link); //选择数据库

$q = "SELECT a,b,a FROM c where a='$cust' or b='$cust_id'"; //SQL查询语句

mysql_query("SET NAMES GB2312");

$rs = mysql_query($q, $link); //获取数据集

if(!$rs){die("查无数据!");}

echo "<table>";

echo "<tr><td>客户</td><td>客户订单号</td><td>订单数量</td></tr>";

while($row = mysql_fetch_row($rs)) echo "<tr><td>$row[0]</td><td>$row[1]</td><td>$row[2]</td></tr>"; //显示数据

echo "</table>";

mysql_free_result($rs); //关闭数据集

}

?>

</body>

</html>

相关文章