您好,欢迎访问一九零五行业门户网

社区(php&&mysql)二

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 ;
echo ;
if($pgno!=0) {
$pu=$pgno-1;
echo []; 

if($pgno$pd=$pgno+1;
echo []; 

for($i=0;$iif($pgno==$i) {
echo ;
echo [.($i+1).];
echo ; 
} else {
echo ;
echo [.($i+1).];
echo ; 
}
}
echo ;
echo ;
echo ;
echo [祇ゅ彻];
echo ;
//echo ;
//echo ;
if($open_list) {
echo ;
echo [ぃ甶秨杠肈];
echo ;
}else {
echo ;
echo [甶秨杠肈];
echo ;
}
echo ; 
echo
;
}
//===============================================================================
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 ;
echo ;
echo ;
echo  $banner;
echo ;
//echo banner is $banner;
echo ;
echo ;
echo $poster;
echo ;
echo ;
echo  ;
echo ;
echo ;
echo $views;
echo ;
echo ;
echo $wdate;
echo ;
echo
;
}
}
//========================================================================
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 $banner;
echo ;
echo ;
 echo ;
echo ; 
 echo 穓碝ゅ彻:;
 echo ;
 echo ;
echo
;
echo
; 
echo ;
$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 ;
 echo ;
 echo ;
echo ;
echo 夹肈;
echo 祇癬;
echo 莱;
echo ;
echo ら戳;
echo
;
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 ;
echo ;
echo ;
if($sid==$id) echo 〈$banner;
else echo $banner;
echo ;
echo ;
echo ;
echo $poster;
echo ;
echo ;
echo $docs;
echo ;
echo ;
echo $views;
echo ;
echo ;
echo $wdate;
echo ;
echo
;
if($open_list) openlist($id);
}
 echo
;
echo
;
pagebar($pages);
}
待续........
其它类似信息

推荐信息