社区(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[‘ur’] , $sql[‘passwd’]);

$qsql=”lect 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_lf;

global $aid;

global $open_list;

echo “<table width=85% border=0 cellpadding=0 cellspacing=1 align=center bgcolor=’#6ca6cd’ class=’num’>”;

echo “<tr><td>”;

if($pgno!=0) {

$pu=$pgno-1;

echo “<a href=$php_lf?aid=$aid&pgno=$pu>[]</a>”;

}

if($pgno<$pages) {

$pd=$pgno+1;

echo “<a href=$php_lf?aid=$aid&pgno=$pd>[]</a>”;

}

for($i=0;$i<=$pages;$i++) {

if($pgno==$i) {

echo “<b>”;

echo “[“.($i+1).”]”;

echo “</b>”;

} el {倾听作文

echo “<a href=$php_lf?aid=$aid&pgno=$i>”;

echo “[“.($i+1).”]”;

echo “</a>”;

}

}

echo “</td>”;

echo “<td align=right>”;

echo “<a href=$php_lf?proc=view&aid=$aid>”;

echo “[祇ゅ彻]”;

echo “</a>”;

//echo “</td>”;

//echo “<td align=right>深圳中学排名221;;

if($open_list) {

echo “<a href=$php_lf?proc=colloff&aid=$aid&pgno=$pgno>”;

echo “[ぃ甶秨杠肈]”;

echo “</a>”;

}el {

echo “<a href=$php_lf?proc=collon&aid=$aid&&pgno=$pgno>”;

echo “[甶秨杠肈]”;

echo “</a>”;

}

echo “</td>”;

echo “</tr></table>”;

}

//===============================================================================

function openlist($sid) {

global $aid;

global $php_lf;

$droot=getenv(‘document_root’);

include(“sql.php3”);

$db=mysql_connect($sql[‘host’], $sql[‘ur’] , $sql[‘passwd’]);

$qsql=”lect * from bbs_docs where sid=’$sid’ order by wdate”;

$rs=mysql_db_query($sql[‘db’],$qsql);

//if(mysql_num_rows($rs)==0) return;

//echomysql_num_rows($rs);

while($row=mysql_f计划生育只生一个打一成语etch_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_lf?proc=view&aid=$aid&sid=$sid&rid=$id>”;

echo ”<font color=#836fff>$banner</font>”;

echo “</a>”;

//echo “banner is $banner”;

echo “</td>”;

echo “<td>”;

echo $poster;

echo “</td>”;

echo “<td class=’num’>”;

echo ”“;

echo “</td>”;

echo “<td class=’num’>”;

echo $views;

echo “</td>”;

echo “<td class=’num’>”;

echo $wdate;

echo “</td>”;

echo “</tr>”;

}

}

//========================================================================

function area() {

global $php_lf;

global $aid,$sid,$pgno;

global $open_list;

$showitems=20;

$droot=getenv(‘document_root’);

include(“sql.php3”);

$db=mysql_connect($sql[‘host’], $sql[‘ur’] , $sql[‘passwd’]);

//============================================================

if(!$aid) {

$qsql=”lect id from bbs_area”;

$rs=mysql_db_query($sql[‘db’],$qsql);

$row=mysql_fetch_array($rs);

$aid=$row[‘id’];

}

if(!$sid) {

$qsql=”lect 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=”lect 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=”lect * 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 “<formname=mtabenctype=multipart/form-data method=post action=$php_lf?proc=arch>”;

echo “<table width=85% border=0 cellpadding=0 cellspacing=1 align=center class=’tablefont’>”;

echo “<tr><td>”;

echo “<input type=’hidden’ name=aid value=’$aid’>”;

echo “穓碝ゅ彻:”;

echo “<input type=’text’ name=’key’ size=25 class=’tablefont’>”;

echo “<input type=’submit’value=’琩高’ class=’tablefont’>”;

echo “</td></tr>”;

echo “</table>”;

echo “</form>”;

$qsql=”lect * 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_ek($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 class=’tablefont’>”;

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_lf?proc=view&aid=$aid&sid=$id&rid=$id>”;

if($sid==$id) echo “<font color=red>〈$banner</font>”;

el echo $banner;

echo “</a>”;

echo “</td>”;

echo “<td>”;

echo $poster;

echo “</td>”;

echo “<td class=’num’>”;

echo $docs;

echo “</td>”;

echo “<td class=’num’>”;

ech 漂亮妈妈 o $views;

echo “</td>”;

echo “<td class=’num’>”;

echo $wdate;

echo “</td>”;

echo “</tr>”;

if($open_list) openlist($id);

}

echo “</td></tr></table>”;

echo”</td></tr></table>”;

pagebar($pages);

}

待续……..