search.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 67 行

PHP
67
字号
<?
  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 + =
减小字号Ctrl + -
显示快捷键?