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

社区(php&&mysql)二_PHP教程

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

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 "";
echo "";
//echo "";
echo "
";
if($pgno!=0) {
$pu=$pgno-1;
echo "[]";
}
if($pgno<$pages) {
$pd=$pgno+1;
echo "[]";
}
for($i=0;$i<=$pages;$i++) {
if($pgno==$i) {
echo "";
echo "[".($i+1)."]";
echo "
";
} else {
echo "";
echo "[".($i+1)."]";
echo "";
}
}
echo "
";
echo "";
echo "[祇ゅ彻]";
echo "";
//echo "
";
if($OPEN_LIST) {
echo "";
echo "[ぃ甶秨杠肈]";
echo "";
}else {
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 "";

$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 "";
echo "";
echo "";
echo "";
echo "";
if($OPEN_LIST) openlist($id);
}
echo "
夹肈祇癬莱ら戳
";
echo "";
if($sid==$id) echo "〈$banner";
else echo $banner;
echo "";
echo "
";
echo $poster;
echo "
";
echo $docs;
echo "
";
echo $views;
echo "
";
echo $wdate;
echo "
";
echo"
";

pagebar($pages);
}
待续........

www.bkjia.comtruehttp://www.bkjia.com/PHPjc/315621.htmlTechArticlefunction sdatetime($str){ $str=ereg_replace(-,/,$str); $str=substr($str,5,strlen($str)-8); return $str; } function reAnum($sid){ //羆莱絞计 $DROOT=getenv('DOCUMENT_ROOT'); in...

人气教程排行