search.php

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

PHP

115 行

<?
  include_once 'inc/auth.php';
  include_once 'inc/check_type.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title>新闻查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript>
function open_notify(NEWS_ID)
{
 URL="read_news.php?NEWS_ID="+NEWS_ID;
 myleft=(screen.availWidth-650)/2;
 window.open(URL,"read_news","height=500,width=650,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=100,left="+myleft+",resizable=yes");
}
</script>
</head>
<body class="bodycolor" topmargin="5">
';
  $CUR_DATE = date ('Y-m-d', time ());
  if (($NEWS_TIME_MIN != ''))
  {
    $TIME_OK = is_date ($NEWS_TIME_MIN);
    if (!$TIME_OK)
    {
      message ('错误', ('"发布日期"的格式不对，应形如 '.$CUR_DATE));
      button_back ();
      exit ();
    }
    $NEWS_TIME_MIN = ($NEWS_TIME_MIN.' 00:00:00');
  }
  if (($NEWS_TIME_MAX != ''))
  {
    $TIME_OK = is_date ($NEWS_TIME_MAX);
    if (!$TIME_OK)
    {
      message ('错误', ('"发布日期"的格式不对，应形如 '.$CUR_DATE));
      button_back ();
      exit ();
    }
    $NEWS_TIME_MAX = ($NEWS_TIME_MAX.' 23:59:59');
  }
  $CONDITION_STR = '';
  if (($SUBJECT != ''))
  {
    ($CONDITION_STR .= ((' and SUBJECT like \'%'.$SUBJECT).'%\''));
  }
  if (($CONTENT != ''))
  {
    ($CONDITION_STR .= ((' and CONTENT like \'%'.$CONTENT).'%\''));
  }
  if (($NEWS_TIME_MIN != ''))
  {
    ($CONDITION_STR .= (((''.' and NEWS_TIME>=\'').$NEWS_TIME_MIN).'\''));
  }
  if (($NEWS_TIME_MAX != ''))
  {
    ($CONDITION_STR .= (((''.' and NEWS_TIME<=\'').$NEWS_TIME_MAX).'\''));
  }
  if (($FORMAT != ''))
  {
    ($CONDITION_STR .= (((''.' and FORMAT=\'').$FORMAT).'\''));
  }
  if (($TYPE_ID != ''))
  {
    ($CONDITION_STR .= (((''.' and TYPE_ID=\'').$TYPE_ID).'\''));
  }
  if (($TO_ID != ''))
  {
    ($CONDITION_STR .= (((''.' and find_in_set(PROVIDER,\'').$TO_ID).'\')'));
  }
  echo '
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/infofind.gif" width="24" height="24" align="absMiddle">';
  echo '<s';
  echo 'pan class="big3"> 新闻查询结果</span><br>
    </td>
  </tr>
</table>
';
  $query = (((((((''.'SELECT NEWS_ID,SUBJECT,NEWS_TIME,CLICK_COUNT,TYPE_ID,READERS from NEWS where PUBLISH=\'1\' and (TO_ID=\'ALL_DEPT\' or find_in_set(\'').$LOGIN_DEPT_ID).'\',TO_ID) or find_in_set(\'').$LOGIN_USER_PRIV).'\',PRIV_ID) or find_in_set(\'').$LOGIN_USER_ID).'\',USER_ID))');
  ($query .= ($CONDITION_STR.' order by NEWS_TIME desc'));
  $NEWS_COUNT = 0;
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$NEWS_COUNT;
    $NEWS_ID = $ROW['NEWS_ID'];
    $SUBJECT = $ROW['SUBJECT'];
    $TYPE_ID = $ROW['TYPE_ID'];
    $SUBJECT = htmlspecialchars ($SUBJECT);
    $NEWS_TIME = $ROW['NEWS_TIME'];
    $CLICK_COUNT = $ROW['CLICK_COUNT'];
    $READERS = $ROW['READERS'];
    $TYPE_NAME = get_code_name ($TYPE_ID, 'NEWS');
    $query1 = ((''.'SELECT count(*) from NEWS_COMMENT where NEWS_ID=').$NEWS_ID);
    $cursor1 = exequery ($connection, $query1);
    $COMMENT_COUNT = 0;
    if ($ROW1 = mysql_fetch_array ($cursor1))
    {
      $COMMENT_COUNT = $ROW1[0];
    }
    if (($NEWS_COUNT == 1))
    {
      echo '<table border="0" cellspacing="1" width="98%" class="small" bgcolor="#000000" cellpadding="3">
   <thead class="TableHeader">
      <td nowrap align="center">标题</td>
      <td nowrap align="center">类型</td>
      <td nowrap align="center">发布时间 <img border=0 src="/images/arrow_down.gif" width="11" height="10"></td>
      <td nowrap align="center">评论(条)</td>
      <td nowrap align="center">新闻

search.php - 源码说明

本页面展示了「通达OA2007SE源代码非常好的」中的 search.php 源码文件，采用 PHP 编程语言编写，共 115 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C

搜索代码Ctrl + F

全屏模式F11

增大字号Ctrl + =

减小字号Ctrl + -

显示快捷键?