📄 searchb.php
字号:
<?
include "../check.php"
?>
<?
include "../sql.php"
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<link href="../tablelike.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
@import url("../nmisall.css");
-->
</style>
</head>
<body>
<p align="center">查询结果</p>
<p align="center"> </p>
<?php
//$idn 传送到详细页面的记录ID号
if($yhlsh!="")//流水号判断唯一条件查询
{
$sql="select * from user where user_serialno=$yhlsh";
$result = mysql_query($sql);
// echo mysql_error()."<br>";
if (!$row = mysql_fetch_row($result))
{
// echo mysql_error()."<br>";
echo '<p align="center">无此用户</p>';
}
else
{
//echo mysql_error()."<br>";
$sql = "SELECT * FROM user where user_serialno=$yhlsh ORDER BY $select";
//echo var_dump($idn);
}
}
else
{ $sql = "SELECT * FROM user where name like BINARY '%$yhm%' and address like BINARY '%$yhdz%' and admin_address like BINARY '%$gldz%' ORDER BY $select";
$resultd = mysql_query($sql);
if (!$rowd = mysql_fetch_row($resultd))
{
// echo mysql_error()."<br>";
echo '<p align="center">无此用户</p>';
}
}
?>
<table border="1" align="center" cellpadding="1" cellspacing="0">
<tr>
<td rowspan="2"> <div align="center">姓名</div></td>
<td rowspan="2"> <div align="center">流水号</div></td>
<td colspan="2"> <div align="center">nas</div></td>
<td rowspan="2"> <div align="center">开户日期</div></td>
<td rowspan="2"> <div align="center">服务有效期</div></td>
<td rowspan="2"> <div align="center">管理地址</div></td>
<td rowspan="2"> <div align="center">状态</div></td>
</tr>
<tr>
<td> <div align="center">Ip</div></td>
<td> <div align="center">Port</div></td>
</tr>
<?
$relust = mysql_query($sql);
while ($row = mysql_fetch_row($relust))
{
echo '<tr>
<td>
<div align="center"><a href="searchbb.php?id='.$row[0].'" class="unnamed1">'.$row[1].'</a></div></td>
<td>
<div align="center"><a href="searchbb.php?id='.$row[0].'" class="unnamed1">'.$row[0].'</a></div></td>
<td>
<div align="center"><a href="searchbb.php?id='.$row[0].'" class="unnamed1">'.$row[19].'</a></div></td>
<td>
<div align="center"><a href="searchbb.php?id='.$row[0].'" class="unnamed1">'.$row[20].'</a></div></td>
<td>
<div align="center"><a href="searchbb.php?id='.$row[0].'" class="unnamed1">'.$row[21].'</a></div></td>
<td>
<div align="center"><a href="searchbb.php?id='.$row[0].'" class="unnamed1">'.$row[12].'</a></div></td>
<td>
<div align="center"><a href="searchbb.php?id='.$row[0].'" class="unnamed1">'.$row[9].'</a></div></td>
<td>
<div align="center"><a href="searchbb.php?id='.$row[0].'" class="unnamed1">'.$row[11].'</a></div></td>
</tr>';
}
?>
</table>
<?
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -