学院首页>网络编程>PHP>社区(php&&mysql)二

社区(php&&mysql)二

作者： 来源：不详 添加时间：2006-5-25 20:44:41
  function sdatetime($str){
 $str=ereg_replace("-","/",$str);
 $str=substr($str,5,strlen($str)-8);
 return $str;
}

function reAnum($sid){ //羆莱絞计
 $DROOT=getenv('DOCUMENT_ROOT');
 include("sql.php3");
 $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);  
 $qsql="SELECT id from bbs_docs where sid='$sid'";
 $rs=mysql_db_query($sql['db'],$qsql);
 return mysql_num_rows($rs);
}

function pagebar($pages) {
 global $pgno;
 //global $pages;
 global $PHP_SELF;
 global $aid;
 global $OPEN_LIST;
 echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center bgcolor='#6CA6CD'
 echo "<tr><td>";
 if($pgno!=0) {
  $pu=$pgno-1;
  echo "<a href=$PHP_SELF?aid=$aid&pgno=$pu>[]</a>";
 }  
 if($pgno<$pages) {
  $pd=$pgno+1;
  echo "<a href=$PHP_SELF?aid=$aid&pgno=$pd>[]</a>";
 }  
 for($i=0;$i<=$pages;$i++) {
  if($pgno==$i) {
echo "<b>";
echo "[".($i+1)."]";
echo "</b>";  
  } else {
echo "<a href=$PHP_SELF?aid=$aid&pgno=$i>";
echo "[".($i+1)."]";
echo "</a>";  
  }
 }
 echo "</td>";
 echo "<TD align=right>";
  echo "<a href=$PHP_SELF?proc=view&aid=$aid>";
 echo "[祇ゅ彻]";
 echo "</a>";
 //echo "</TD>";
 //echo "<TD align=right>";
if($OPEN_LIST) {
 echo "<a href=$PHP_SELF?proc=colloff&aid=$aid&pgno=$pgno>";
 echo "[ぃ甶秨杠肈]";
 echo "</a>";
}else {
 echo "<a href=$PHP_SELF?proc=collon&aid=$aid&&pgno=$pgno>";
 echo "[甶秨杠肈]";
 echo "</a>";
}
 echo "</TD>";
 echo "</tr></table>";  
  
}
//===============================================================================
function openlist($sid) {
 global $aid;
 global $PHP_SELF;
  
 $DROOT=getenv('DOCUMENT_ROOT');
 include("sql.php3");
 $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);  
 $qsql="SELECT * from bbs_docs where sid='$sid' order by wdate";
 $rs=mysql_db_query($sql['db'],$qsql);
 //if(mysql_num_rows($rs)==0) return;
 //echo  mysql_num_rows($rs);
 while($row=mysql_fetch_array($rs)) {
  $id=$row['id'];
$banner=$row['banner'];
$poster=$row['poster'];
$views=$row['views'];
$wdate=sdatetime($row['wdate']);
 
echo "<tr bgcolor='#F0F0F0'>";
 echo "<td>";
  echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$sid&rid=$id>";
  echo "&nbsp;&nbsp;<font color=#836FFF>$banner</font>";
  echo "</a>";
  //echo "banner is $banner";
 echo "</td>";
 echo "<td>";
  echo $poster;
 echo "</td>";
 echo "<td
  echo "&nbsp;";
 echo "</td>";
 echo "<td
  echo $views;
 echo "</td>";
 echo "<td
  echo $wdate;
 echo "</td>";
 
echo "</tr>";
 }
  
}

//========================================================================
function area() {
 global $PHP_SELF;
 global $aid,$sid,$pgno;
 global $OPEN_LIST;
 $showitems=20;
 $DROOT=getenv('DOCUMENT_ROOT');
 include("sql.php3");
 $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);  
 //============================================================
 if(!$aid) {
 $qsql="SELECT id from bbs_area";
 $rs=mysql_db_query($sql['db'],$qsql);
 $row=mysql_fetch_array($rs);
 $aid=$row['id'];
  }
 if(!$sid) {
  $qsql="SELECT id from bbs_subj where aid=$aid order by wdate DESC";
  $rs=mysql_db_query($sql['db'],$qsql);
  $row=mysql_fetch_array($rs);
  $sid=$row['id'];  
 }  
  
 if(!$pgno) {//礚﹚计
  //$pgno=0;  
  $items=0;
  $qsql="SELECT id from bbs_subj where aid=$aid order by wdate DESC";
  $rs=mysql_db_query($sql['db'],$qsql);
  while($row=mysql_fetch_array($rs)){
$id=$row['id'];  
if($id==$sid) break;
$items++;
  }
  $pgno=(INT)($items/$showitems);
 }
  
 //============================================================
 $qsql="SELECT * from bbs_area where id=$aid ";
 $rs=mysql_db_query($sql['db'],$qsql);
 $row=mysql_fetch_array($rs);
 $banner=$row['banner'];
 $body=$row['body'];
 $master=$row['master'];
 echo "<center><font color=GREEN size=5><b>$banner</b></font></center>";
  
 echo "<FORM  name=mtab  ENCTYPE=multipart/form-data METHOD=POST ACTION=$PHP_SELF?proc=search>";
 echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center
echo "<tr><td>";
  
  echo "<input type='hidden' name=aid value='$aid'>";  
  echo "穓碝ゅ彻:";
  echo "<INPUT TYPE='TEXT' NAME='key' size=25
  echo "<INPUT TYPE='Submit'value='琩高'
  
echo "</td></tr>";
 echo "</table>";  
 echo "</FORM>";  
  
 $qsql="SELECT * from bbs_subj where aid=$aid order by wdate DESC";
 $rs=mysql_db_query($sql['db'],$qsql);
 $all=mysql_num_rows($rs);  //how rows
 $pages=(INT)($all/$showitems); // how pages
 $pgcount=$pgno*$showitems;
 if($pgcount > $all) {  
  $pgno=$pages-1; // Page point over all pages
  $pgcount=$pgno*$showitems;
  }
 mysql_data_seek($rs, $pgcount);
 $cnt=0;
 pagebar($pages);
 echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center bgcolor='#6CA6CD'>";
echo "<tr><td>";
echo "<TABLE width=100% cellPadding=1 cellSpacing=1 bgcolor=white
  echo "<tr bgcolor=#F1E1FF>";
echo "<th >夹肈</th>";
echo "<th>祇癬</th>";
echo "<th width=30>莱</th>";
echo "<th width=30></th>";
echo "<th width=70>ら戳</th>";
  echo "</tr>";
  while($row=mysql_fetch_array($rs)) {
if(++$cnt > $showitems) break;
$id=$row['id'];
$banner=$row['banner'];
$poster=$row['poster'];
$views=$row['views'];
$wdate=sdatetime($row['wdate']);
$docs=reAnum($id);
echo "<tr bgcolor='#F0F8FF'>";
 echo "<td>";
  echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$id&rid=$id>";
if($sid==$id) echo "<font color=red>〈$banner</font>";
else echo $banner;
  echo "</a>";
 echo "</td>";
 echo "<td>";
  echo $poster;
 echo "</td>";
 echo "<td
  echo $docs;
 echo "</td>";
 echo "<td
  echo $views;
 echo "</td>";
 echo "<td
  echo $wdate;
 echo "</td>";
echo "</tr>";
if($OPEN_LIST) openlist($id);
  }
echo "</td></tr></table>";
 echo"</td></tr></table>"; 
  
 pagebar($pages);
}
待续........  
上一篇：社区(php&&mysql)一
下一篇：社区(php&&mysql)三
站内搜索