⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 search.php

📁 通达OA的PDA部分源代码
💻 PHP
字号:
<?

  include_once '../auth.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title>区号邮编查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

</head>
<body>
<font color=blue size=+2><b>区号邮编查询</b></font>
<br><br>

';
  $query = 'SELECT * from POST_TEL where 1=1 ';
  if ($AREA != '')
  {
    $query .= '' . ' and AREA like \'%' . $AREA . '%\'';
  }

  if ($TEL_NO != '')
  {
    $query .= '' . ' and TEL_NO like \'%' . $TEL_NO . '%\'';
  }

  if ($POST_NO != '')
  {
    $query .= '' . ' and POST_NO like \'%' . $POST_NO . '%\'';
  }

  $cursor = exequery ($connection, $query);
  $TEL_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$TEL_COUNT;
    if (20 < $TEL_COUNT)
    {
      break;
    }

    $PROVINCE = $ROW['PROVINCE'];
    $AREA = $ROW['AREA'];
    $TEL_NO = $ROW['TEL_NO'];
    $POST_NO = $ROW['POST_NO'];
    echo '
';
    echo $TEL_COUNT;
    echo '.<b>';
    echo $PROVINCE;
    echo ' - ';
    echo $AREA;
    echo '</b><br>
 区号:';
    echo $TEL_NO;
    echo '<br>
 邮编:';
    echo $POST_NO;
    echo '<br>
<hr>
';
  }

  if ($TEL_COUNT == 0)
  {
    echo '无符合条件的记录';
  }

  echo '
<a href="javascript:history.back()">返回</a>

</body>
</html>
';
?>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -