php的一些简单例程-bbs.日历.docVIP

简单BBS程序（需MySQL支持） HTML HEAD TITLEThis is my?BBS/TITLE /HEAD BODY?BGCOLOR=#FFFFFF ? ???? /****************************************************** ?????BBS?v1.0 ?????编码：?PHP?3??? ?????作者：?Leon?Atkinson? leon.atkinson@ ???? ?????简单?BBS?系统?需?MySQL。?????以下是BBS的表结构，用以下的语句就可以建立： ?? ????????CREATE?TABLE?bbsMessage ????????( ????????????ID?INT?NOT?NULL?AUTO_INCREMENT, ????????????Title?VARCHAR(64), ????????????Poster?VARCHAR(64), ????????????Created?DATETIME, ????????????Parent?INT, ????????????Body?BLOB, ????????????PRIMARY?KEY(ID) ????????); ????*******************************************************/ ????printf( H1Leons?BBS/H1\n); ???? /*?设置数据库?*/ ????mysql_pconnect( ,? httpd); ????$Database?=? yourdb; ???? /**************************************************************** ?????一个吐出派生信息的递归函数????****************************************************************/ ????function?showMessages($parentID) ????{ ????????global?$Database; ????????$dateToUse?=?Date( U); ????????echo? UL\n; ???????? /*?显示所有的类别?*/ ???????? ????????$Query?=? SELECT?*?FROM?bbsMessage?; ????????$Query?=?$Query?.? WHERE?Parent=$parentID?; ????????$Query?=?$Query?.? ORDER?BY?Created?; ????????$result?=?mysql($Database,$Query); ????????$numRows?=?mysql_NumRows($result); ????????$RowCount?=?0; ????????while($RowCount??$numRows) ????????{ ????????????$messageID?=?mysql_result($result,$RowCount, ID); ????????????$messageTitle?=?mysql_result($result,$RowCount, Title); ????????????$messageCreated?=?mysql_result($result,$RowCount, Created); ????????????$messageParent?=?mysql_result($result,$RowCount, Parent); ???????????? /*显示一行是什么类别的信息?*/ ???? ????????????printf( LI($messageCreated)?A?HREF=\bbs.htma?messageID=$messageID\$messageTitle/ABR\n); ???? ???????????? /*?调用?getWingContents?以得到它的分支?*/ ????????????showMessages($messageID); ????????????$RowCount++; ????????} ????????echo? /UL\n; ????} ???? /**************************************************