search.php

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

PHP
256 行
字号 
<?
  include_once 'inc/auth.php';
  echo '
<html>
<head>
<title>搜索文章</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript>
function delete_comment(COMMENT_ID)
{
  msg="确定要删除该文章吗?";
  if(window.confirm(msg))
  {
    URL="delete.php?BOARD_ID=';
  echo $BOARD_ID;
  echo '&COMMENT_ID=" + COMMENT_ID;
    window.location=URL;
  }
}
</script>
</head>
<body class="bodycolor" topmargin="5">
';
  $query = ((''.'SELECT * from BBS_BOARD where BOARD_ID=').$BOARD_ID);
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $BOARD_NAME = $ROW['BOARD_NAME'];
    $BOARD_HOSTER = $ROW['BOARD_HOSTER'];
    $BOARD_NAME = str_replace ('<', '&lt', $BOARD_NAME);
    $BOARD_NAME = str_replace ('>', '&gt', $BOARD_NAME);
    $BOARD_NAME = stripslashes ($BOARD_NAME);
  }
  echo '
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/bbs.gif" WIDTH="22" HEIGHT="20" align="absmiddle"> <a href="index.php">';
  echo '<s';
  echo 'pan class="big3">讨论区</span></a> ';
  echo '<s';
  echo 'pan class="big3">-</span> <a href="board.php?BOARD_ID=';
  echo $BOARD_ID;
  echo '">';
  echo '<s';
  echo 'pan class="big3">';
  echo $BOARD_NAME;
  echo '</span></a>';
  echo '<s';
  echo 'pan class="big3"> - 文章搜索结果</span></span><br>
    </td>
  </tr>
</table>
<br>
';
  $query = (((((((((''.'SELECT * from BBS_COMMENT where BOARD_ID=').$BOARD_ID).' and SUBJECT like \'%').$SUBJECT).'%\' and CONTENT like \'%').$CONTENT).'%\' and ATTACHMENT_NAME like \'%').$ATTACHMENT_NAME).'%\' and PARENT=0 order by TOP desc,SUBMIT_TIME desc');
  $cursor = exequery ($connection, $query);
  $COMMENT_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$COMMENT_COUNT;
    $COMMENT_ID = $ROW['COMMENT_ID'];
    $USER_ID = $ROW['USER_ID'];
    $AUTHOR_NAME = $ROW['AUTHOR_NAME'];
    $SUBJECT = $ROW['SUBJECT'];
    $SUBMIT_TIME = $ROW['SUBMIT_TIME'];
    $OLD_SUBMIT_TIME = $ROW['OLD_SUBMIT_TIME'];
    if (($OLD_SUBMIT_TIME == '0000-00-00 00:00:00'))
    {
      $OLD_SUBMIT_TIME = $SUBMIT_TIME;
    }
    $READ_CONT = $ROW['READ_CONT'];
    $REPLY_CONT = $ROW['REPLY_CONT'];
    $TOP = $ROW['TOP'];
    $JING = $ROW['JING'];
    $READEDER = $ROW['READEDER'];
    $CONTENT = $ROW['CONTENT'];
    $CONTENT_SIZE = strlen ($CONTENT);
    $CONTENT_SIZE = number_format ($CONTENT_SIZE, 0, '.', ',');
    $SUBJECT = str_replace ('<', '&lt', $SUBJECT);
    $SUBJECT = str_replace ('>', '&gt', $SUBJECT);
    $SUBJECT = stripslashes ($SUBJECT);
    if (($TOP == '1'))
    {
      $SUBJECT = (('<font color=red><b>'.$SUBJECT).'</b></font>');
    }
    $query1 = (((''.'SELECT * from USER where USER_ID=\'').$USER_ID).'\'');
    $cursor1 = exequery ($connection, $query1);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $AVATAR = $ROW['AVATAR'];
      $USER_NAME = $ROW['USER_NAME'];
    }
    else
    {
      $USER_NAME = $USER_ID;
      $AVATAR = '';
    }
    if (($COMMENT_COUNT == 1))
    {
      echo '<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
  <tr class="TableHeader">
      <td nowrap align="center">作者</td>
';
      if (($LOGIN_USER_PRIV == 1))
      {
        echo '      <td nowrap align="center">实名</td>
';
      }
      echo '      <td nowrap align="center">标题</td>
      <td nowrap align="center">字节</td>
      <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>
  </tr>
';
    }
    if ((($COMMENT_COUNT % 2) == 1))
    {
      $TableLine = 'TableLine1';
    }
    else
    {
      $TableLine = 'TableLine2';
    }
    echo '    <tr class="';
    echo $TableLine;
    echo '">
      <td width="80" nowrap>';
    if (($USER_NAME == $AUTHOR_NAME))
    {
      echo '<img src="/images/avatar/';
      echo $AVATAR;
      echo '.gif" align="absmiddle">';
    }
    echo ' ';
    echo $AUTHOR_NAME;
    echo '</td>
';
    if (($LOGIN_USER_PRIV == 1))
    {
      echo '     <td align="center" width="50" nowrap>';
      echo $USER_NAME;
      echo '</td>
';
    }
    echo '      <td><a href="comment.php?BOARD_ID=';
    echo $BOARD_ID;
    echo '&COMMENT_ID=';
    echo $COMMENT_ID;
    echo '">';
    echo $SUBJECT;
    echo '</a>
';
    if (!find_id ($READEDER, $LOGIN_USER_ID))
    {
      echo '<img src=\'/images/new.gif\' height=11 width=28>    ';
    }
    if (($JING == 1))
    {
      echo '<img src=\'/images/jing.gif\' height=11 width=15>';
    }
    echo '     </td>
      <td align="center" width="50" nowrap>';
    echo $CONTENT_SIZE;
    echo '</td>
      <td align="center" width="50" nowrap>';
    echo $READ_CONT;
    echo '</td>
      <td align="center" width="50" nowrap>';
    echo $REPLY_CONT;
    echo '</td>
      <td align="center" width="150" nowrap>';
    echo $OLD_SUBMIT_TIME;
    echo '</td>
      <td align="center" width="120" nowrap>
';
    if (((($USER_ID == $LOGIN_USER_ID) OR ($LOGIN_USER_PRIV == 1)) OR find_id ($BOARD_HOSTER, $LOGIN_USER_ID)))
    {
      echo '         <a href="javascript:;" onClick="window.open(\'move.php?BOARD_ID=';
      echo $BOARD_ID;
      echo '&COMMENT_ID=';
      echo $COMMENT_ID;
      echo '\',\'\',\'height=200,width=250,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=350,top=150,resizable=yes\');">转移</a>&nbsp;
         <a href="edit.php?BOARD_ID=';
      echo $BOARD_ID;
      echo '&COMMENT_ID=';
      echo $COMMENT_ID;
      echo '&PAGE_START=';
      echo $PAGE_START;
      echo '">编辑</a>&nbsp;
         <a href="javascript:delete_comment(';
      echo $COMMENT_ID;
      echo ');">删除</a><br>
';
      if ((($TOP == 0) AND (($LOGIN_USER_PRIV == 1) OR find_id ($BOARD_HOSTER, $LOGIN_USER_ID))))
      {
        echo '              <a href="set_top.php?COMMENT_ID=';
        echo $COMMENT_ID;
        echo '&TOP=1&BOARD_ID=';
        echo $BOARD_ID;
        echo '">置顶</a>&nbsp;
';
      }
      if ((($TOP == 1) AND (($LOGIN_USER_PRIV == 1) OR find_id ($BOARD_HOSTER, $LOGIN_USER_ID))))
      {
        echo '              <a href="set_top.php?COMMENT_ID=';
        echo $COMMENT_ID;
        echo '&TOP=0&BOARD_ID=';
        echo $BOARD_ID;
        echo '">取消置顶</a>
';
      }
      if ((($JING == 0) AND (($LOGIN_USER_PRIV == 1) OR find_id ($BOARD_HOSTER, $LOGIN_USER_ID))))
      {
        echo '              <a href="set_jing.php?COMMENT_ID=';
        echo $COMMENT_ID;
        echo '&JING=1&BOARD_ID=';
        echo $BOARD_ID;
        echo '">设置精华</a>&nbsp;
';
      }
      if ((($JING == 1) AND (($LOGIN_USER_PRIV == 1) OR find_id ($BOARD_HOSTER, $LOGIN_USER_ID))))
      {
        echo '              <a href="set_jing.php?COMMENT_ID=';
        echo $COMMENT_ID;
        echo '&JING=0&BOARD_ID=';
        echo $BOARD_ID;
        echo '">取消精华</a>&nbsp;
';
      }
    }
    echo '      </td>
  </tr>
';
  }
  if ((0 < $COMMENT_COUNT))
  {
    echo '  </table>
';
  }
  else
  {
    message ('', '<br>未找到符合条件的文章');
  }
  echo '
<br>
<div align="center">
  <input type="button" value="返回" class="BigButton" onclick="history.go(-2);">
</div>
</body>
</html>';
?>

search.php - 源码说明

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

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

⌨️ 快捷键说明

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