当前位置:Gxlcms > PHP教程 > 社区(php&&mysql)三

社区(php&&mysql)三

时间:2021-07-01 10:21:17 帮助过:81人阅读

function PRev_subj($id){
  $DROOT=getenv('DOCUMENT_ROOT');
  include("sql.php3");
  $db=MySQL_connect($sql['host'], $sql['user'] , $sql['passwd']); 
  $qstr="select id,aid from bbs_subj where id='$id'";
  $rs=mysql_db_query($sql['db'],$qstr);  
  $row=mysql_fetch_array($rs);
  $aid=$row['aid'];
  
  $qstr="select id from bbs_subj where aid='$aid' order by wdate DESC";
  $rs=mysql_db_query($sql['db'],$qstr);
  $pid=$id;  
  while($row=mysql_fetch_array($rs)){
    $tid=$row['id'];  
    if($id==$tid) break;
    $pid=$tid;
  }
  
  return $pid;
}
// 絞
function next_subj($id){
  $DROOT=getenv('DOCUMENT_ROOT');
  include("sql.php3");
  $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']); 
  $qstr="select id,aid from bbs_subj where id='$id'";
  $rs=mysql_db_query($sql['db'],$qstr);  
  $row=mysql_fetch_array($rs);
  $aid=$row['aid'];
  
  $qstr="select id from bbs_subj where aid='$aid' order by wdate DESC";
  $rs=mysql_db_query($sql['db'],$qstr);
  $pid=$id;  
  while($row=mysql_fetch_array($rs)){
    $pid=$row['id'];  
    if($id==$pid) break;
  }
  if($row=mysql_fetch_array($rs)) {
    $pid=$row['id'];
  }
  return $pid;
}

//======================================================================
function viewbar() {
  global $pgno;
  global $PHP_SELF;
  global $aid,$sid;
  //global $OPEN_LIST;
  echo "";
  echo "";
      
  echo "
";
    $nextid=next_subj($sid);
    $previd=prev_subj($sid);
    echo "[夹肈跋]";
    echo "[莱セ絞]";
    echo "[祇穝ゅ彻]";
    echo "[絞]";
    echo "[絞]";
    //echo "[程絞]";
    
  echo "
";  
  
}
//======================================================================
function view() {
  global $PHP_SELF,$aid,$sid,$rid;
  global $c_poster,$c_email;
  //echo "$PHP_SELF,$aid,$sid,$rid,$pgno";
  $type=0; //秨穝杠肈
 if($sid && $rid) {
   addhitviews($sid,$rid);
  $type=1; //莱
  $db_table="bbs_subj";
  if($sid!=$rid)  $db_table="bbs_docs";
  $DROOT=getenv('DOCUMENT_ROOT');
  include("sql.php3");
  $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']); 
  $qstr="select banner from bbs_area where id='$aid'";
  $rs=mysql_db_query($sql['db'],$qstr);
  echo mysql_error();
  $row=mysql_fetch_array($rs);
  $abanner=$row['banner'];
  
  $qsql="SELECT * from $db_table where id='$rid' ";
  $rs=mysql_db_query($sql['db'],$qsql);
  $row=mysql_fetch_array($rs);
  $poster=$row['poster'];
  $pip=$row['pip'];
  $wdate=$row['wdate'];
  $rebanner=$banner=$row['banner'];
  $body=$row['body'];
  $body=htmlspecialchars($body);
  $pbody=ereg_replace("n","
",$body);
  $pbody =preg_replace( "/[www *]([\x0-\xff]*?)[/www *]/", '\1', $pbody ); 
  $pbody =preg_replace( "/[www +([a-zA-Z0-9.:/_-]+)]([\x0-\xff]*?)[/www *]/", '\2', $pbody ); 
  
  echo "
";
  echo "[$abanner]
";
  echo "$banner
";
  echo "";
      echo "";
      echo "";
      echo "";
      echo "";
    echo "
";
        viewbar();
      echo "
";
      //====ゅ彻==============
      echo "";
      echo "";
        echo "";
          echo ":";
        echo "";
        echo "
";
      echo "";
      echo "";
        echo "";
        echo "";
      echo "";
      echo "";
        echo "";
        echo "";
      echo "";
      echo "";
      echo "
";
          echo $poster;
        echo "
";
          echo "ㄓ:";
        echo "
";
          echo $pip;
        echo "
";
          echo "ゅ彻ず甧:";
        echo "
";
              echo $pbody;
              echo "
";
        echo "
";
      echo "
";
      
        //=======籔狟ねだㄉ===============
        echo "";  
        echo "";  
        echo "";        
      echo "
";
        //=======mail List===============
      echo "";  
      echo "";
      echo "";  
    
      echo "
";
        viewbar();
      echo "
";
    
    
待续........
    

人气教程排行