澳门新葡亰平台游戏网站基于mysql的论坛(4)

html head meta “Content-Type” content=”text/html; charset=gb2312″
title山水盈盈之Content Linking组件应用 /title /head body center font
color=redContent Linking组件应用示范 /font /center ul % Set
Link=Server.CreateObject(“MSWC.NextLink”)
lcount=Link.GetListCount(“conlink.txt”)

1.guestbook.php html head script language=JavaScript !– !– var
hellotext=为了您的最佳浏览效果请您使用IE4.0以上的版本和800*600分辨率
var thetext= var started=false var step=0 var times=1 function
welcometext() { times– if (times==0) { if (started==false) { started =
true; window.status = hellotext; setTimeout(anim(),1); } thetext =
hellotext; } } function showstatustext(txt) { thetext = txt;
setTimeout(welcometext(),4000) times++ } function anim() { step++ if
(step==7) {step=1} if (step==1) {window.status=’===’+thetext+’===’} if
(step==2) {window.status=’===’+thetext+’===’} if (step==3)
{window.status=’==’+thetext+’==’} if (step==4)
{window.status=’==’+thetext+’==’} if (step==5)
{window.status=’===’+thetext+’===’} if (step==6)
{window.status=’===’+thetext+’===’} setTimeout(anim(),200); } // —
welcometext(); function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+.location=’+selObj.options[selObj.selectedIndex].value+’);
if (restore) selObj.selectedIndex=0; } //– /script
title天地网络留言版/title meta content=text/html; charset=gb2312 /head
style type=text/css !– a:link {font-size: 9pt; color: #FFFFFF} —
/style body ? $PAGESIZE=5; $db=mysql_connect(localhost,root,);
mysql_select_db(lyanban,$db); $result=mysql_query(SELECT * FROM
message order by date desc,$db); $rowcount=mysql_num_rows($result);
$PAGES=CEIL($rowcount/$PAGESIZE); if($rowcount==0) {echo 目前没有留言!a
href=guestbook.htm欢迎您留言!/a;} if($rownum == ) { $rownum = 1; }
$AA=CEIL($rownum/5); $i=0 ; echo TABLE WIDTH=100%tddiv font size=2
color=#000000B共有留言:$rowcount 条共:$PAGES 页right现在是第 $AA
页/right/B/font/div/td; echo hr size=1 color=#ccccffwidth=75%; while
($myrow=mysql_fetch_array($result)){ $i++;
if(($i=$rownum)&&($i$rownum+5)){ echo table width=75% border=1
cellspacing=0 cellpadding=0 bordercolordark=#FFFFFF
bordercolorlight=#000000 background=15.JPG; echo trtd width=15%div font
size=2 color=#FFFFFF姓 名/font/div/tdtd width=85%font size=2
color=#FFFFFF$myrow[username]/font/td/tr; echo trtd width=15%div font
size=2 color=#FFFFFF电子信箱/font/div/tdtd width=85%font size=2
color=#FFFFFFa href=mailto:$myrow[email]$myrow[email]/font/a/td/tr;
echo trtd width=15%div font size=2 color=#FFFFFF公司主页/font/div/tdtd
width=85%font size=2 color=#FFFFFFa href=$myrow[homepage]
target=_blank$myrow[homepage]/font/a/td/tr; echo trtd width=15%div
font size=2 color=#FFFFFF留言主题/font/div/tdtd width=85%font size=2
color=#FFFFFF$myrow[topic]/font/td/tr; echo trtd width=15%div font
size=2 color=#FFFFFF留言内容/font/div/tdtd width=85%font size=2
color=#FFFFFF$myrow[content]/font/td/tr; echo trtd width=15%div font
size=2 color=#FFFFFF留言时间/font/div/tdtd width=85%font size=2
color=#FFFFFF$myrow[date]/font/td/tr; echo /tablehr size=1
color=#ccccffwidth=75%;} } echo table width=100%trtd width=87%;
#判断是否有或 echo form name=hiddenform method=post
action=guestbook.php; echo div input type=hidden name=rownum value=;
echo input type=hidden name=rowcount value=$rowcount; #显示 if
($rownum=5) echo input type=submit value=
onclick=document.hiddenform.rownum.value=.($rownum-5).; #显示 if
($rownum+5=$rowcount) { echo input type=submit value=
onclick=document.hiddenform.rownum.value=.($rownum+5)./div; } echo
/form; echo /td; echo /tr; echo /table; echo table width=100% trtddiv
font color=#ffffff size=2a
href=guestbook.htm返回继续发言/a/font/div/td/tr/table; ? /body /html
2.show.php3 ? $username = htmlspecialchars(ltrim(stripslashes
(trim($name))));//本函式可去掉字串中的反斜线空格字元 $email =
htmlspecialchars(ltrim(stripslashes (trim($email)))); $homepage =
htmlspecialchars(ltrim(stripslashes (trim($homepage)))); $topic =
htmlspecialchars(ltrim(stripslashes (trim($topic)))); $content =
htmlspecialchars(ltrim(stripslashes (trim($content)))); //
$content=base64_encode($content); //send email //if ($ok)
mail($email,$topic,$content); if
(($username==)or($topic==)or(strlen($username)20)or(strlen($topic)20))
{echo 请填写必要的项目或着非法用户名!a
href=javascript:history.go(-1);返回/a; } //wrong email ? elseif
(($email!=)and(!eregi(^[_.0-9a-z-]+@([0-9a-z][0-9a-z-]+.)+[a-z]{2,3}$,$email)))
{ echo 请您填写正确的 E-Mail 地址/pp a
href=javascript:history.go(-1);返回/a; } //wrong homepage ? elseif
(($homepage!=)and(!eregi(()+[0-9a-z-]+.([0-9a-z-]+.)+[a-z]{2,3}$,$homepage)))
{echo 主页地址输入错误!a href=javascript:history.go(-1);返回/a;} else{
//联接数据库 mysql_connect(localhost,root,);
mysql_select_db(lyanban); $sql=select password from tb where
username=’$username’; $result=mysql_query($sql);
$nums=mysql_num_rows($result); if($nums!=1){ echo对不起!请先a
href=register.html注册/a!; } else{ //得到日期 YYYY-MM-DD HH:MM:SS
2000-01-01 00:00:00′ $t = date(Y.-.m.-.d. .H.:.i.:.s);
//将新用户插入数据库 mysql_query(insert into message values
(‘$username’,’$email’,’$homepage’,’$topic’,’$content’,’$t’)); echo div
font size=2 color=#000000谢谢您留言!您的留言已成功加入,a
href=guestbook.php返回/a/font/div; } } ? 3.zhuc.php(注册程序) ?
mysql_connect(localhost,root,) or die(无法连接数据库,请重试);
mysql_select_db(lyanban) or die(无法选择数据库,请重试); $query=select
password from tb where username=’$username’;
$result=mysql_query($query); $numrows=mysql_num_rows($result);
if($numrows!=0) {echo ‘已有人注册此名,请重新选择名字!a
href=javascript:history.go(-1);返回/a’;} else {$query=insert into
tb(username,password) values(‘$username’,’$password’);
mysql_query($query); echo ‘注册成功’; echo ‘A HREF=guestbook.htm
请登录!/A’;} ? 以下是两个配套的HTML: 1。留言网页 html head meta
content=text/html; charset=gb2312 meta name=GENERATOR content=Microsoft
FrontPage 4.0 meta name=ProgId content=FrontPage.Editor.Document
title天地网络留言版欢迎您留言!/title /head body bgcolor=#FFFFFF div
align=center center br font size=2天地网络留言版测试版/fontbr br form
method=post action=show.php3 table width=66% tr td width=50% height=1
div align=center font size=2 您的尊姓大名:/font/div /td td width=50%
height=1 div align=center input type=text name=name size=20 /div /td /tr
tr td width=50% height=1 div align=centerfont size=2
您的电子邮件地址:/font/div /td td width=50% height=1 div align=center
input type=text name=email size=20 /div /td /tr tr td width=50% height=1
div align=centerfont size=2 您的公司主页地址:/font/div /td td width=50%
height=1 div align=center input type=text name=homepage size=20 value=
/div /td /tr tr td width=50% height=1 div align=center font
size=2留言主题:/font/div /td td width=50% height=1 valign=middle div
align=center input type=text name=topic size=20 /div /td /tr tr td
width=50% height=1 div align=center font size=2留言内容:/font/div /td
td width=50% height=1 div align=center /div /td /tr tr td width=100%
colspan=2 height=66 p align=center textarea rows=10 name=content
cols=50/textarea /p /td /tr tr td width=50% height=18 div
align=center/div /td td width=50% height=18 div align=center/div /td /tr
tr td width=50% height=18 align=center p align=center input type=submit
value=发表留言 name=B1 /p /td td width=50% height=18 align=center div
align=center input type=reset value=全部重写 name=B2 /div /td /tr /table
/form /center /div p /p p /p /body /html 2.注册程序 html head
titleregiste/title meta content=text/html; charset=gb2312 /head body
bgcolor=#FFFFFF div align=center p/p p/p p用户注册/p form method=post
action=zhuc.php p用户名: input type=text name=username /p p密码: input
type=password name=password /p p input type=submit name=Submit
value=确定 input type=reset name=Submit2 value=重来 /p /form p/p /div
/body /html 如需要ZIP文件可给我来信。tandinet@163.net

## index.php html head title论坛/title meta content=text/html;
charset=gb2312 /head frameset cols=125,* rows=* border=0
frameborder=0frame src=left.php name=left scrolling=AUTO frameborder=YES
bordercolor=#000000 frame src=right.htm name=main scrolling=AUTO
/frameset noframesbody bgcolor=#FFFFFF /body/noframes /html ##
left.php ?php $fp=fopen(file/counter.txt,r); $counter=fgets($fp,8);
fclose($fp); $counter=$counter+1; $fp=fopen(file/counter.txt,w);
fputs($fp,$counter); fclose($fp); require(config.inc.php); $sql=select
* from boardinfo; $sql_result=mysql_query($sql);
$sql_row=mysql_fetch_array($sql_result); ? html head
title版面列表/title meta content=text/html; charset=gb2312 link
href=css/new.css rel=stylesheet /head body background=image/bg.gif
bgcolor=#FFFFFF table width=100% border=0 cellspacing=2 cellpadding=0
tr td align=center/td /tr tr td align=centera href=apply.php
target=main注册用户/a/td /tr tr td align=centerfont
color=#666666———/font/td /tr ?php do { echotr; echotd
align=centera href=list.php?board=$sql_row[name]
target=main$sql_row[chinesename]/a/td; echo/tr;
}while($sql_row=mysql_fetch_array($sql_result)); ? tr td
align=centerfont color=#006666———/font/td /tr tr td height=11
script src=file/X86tree.js/script script language=javascript
img_t1=image/t1.gif; img_t2=image/t2.gif; tree=new
TreeView(0,0,640,300); tree.AddImage(0,image/dot.gif);
tree.AddImage(1,image/close.gif); tree.AddImage(2,image/open.gif);
m1=new Nodes(m1,tree.ImageList,论坛转向,0,2,); m1.Add(new
Node(站点首页,1,0,a href=” target=’_top’));m1.Add(new
Node(论坛首页,1,0,a href=’right.htm’ target=’main’)); tree.Add2(m1);
doc2=new Nodes(doc2,tree.ImageList,论坛功能,0,2,-); doc2.Add(new
Node(帖子查询,1,0,a href=’query.php’ target=’main’)); doc2.Add(new
Node(精华区域,1,0,a href=’good.php’ target=’main’)); doc2.Add(new
Node(察看留言,1,0,a href=’vmlogin.php’ target=’main’)); doc2.Add(new
Node(修改资料,1,0,a href=’modify_l.php’ target=’main’)); doc2.Add(new
Node(察看资料,1,0,a href=’userinfo.php’ target=’main’)); doc2.Add(new
Node(察看积分,1,0,a href=’viewscore.php’ target=’main’)); doc2.Add(new
Node(论坛管理,1,0,a href=’manage.htm’ target=’main’)); tree.Add2(doc2);
tree.Show(); doc2.Close(); m1.Close(); /script /td /tr tr td
align=center bfont color=#006666——–/fontbr ?php echo
$counter?/b/td /tr /table /body /html ## list.php ?php
require(func.php); if(empty($board)){ $board=computer; } $sql=select *
from boardinfo where name=’$board’; $sql_result=mysql_query($sql);
$sql_row=mysql_fetch_array($sql_result);
$chinesename=$sql_row[chinesename]; setcookie
(jl_forum[chinesename],$chinesename); $sql=select name from user
where slaveboard=’$board’; $sql_result=mysql_query($sql); ? html head
titleList/title meta content=text/html; charset=gb2312 link
rel=stylesheet type=text/css href=css/index.css script
language=javascript function
openwin(board,id){window.open(read.php?board=+board+&id=+id,,height=460,width=600,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no);
} function
post(board){window.open(post.php?board=+board,,height=500,width=600,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no);
} /script /head body bgcolor=#FFFFFF background=image/bg.gif ?php
include header.php;? br table width=100% border=1 cellspacing=0
cellpadding=0 bordercolorlight=#000000 bordercolordark=#FFFFFF trtd
height=22 width=23% bgcolor=#eeeeee版面:?php echo $chinesename; ?/td
td height=22 width=41% bgcolor=#eeeeee版主:?php while
($sql_row=mysql_fetch_array($sql_result)) { echo $sql_row[name].;
} # 选择出留言纪录; $sql=select * from $board where slaveid=0;
$temp=mysql_query($sql); $sum=mysql_num_rows($temp);
$totalpage=ceil($sum/$pagesize); if ($sum==0) { $totalpage=1; } # 分页
if($page1 or empty($page)){ $page=1; } elseif ($page$totalpage){
$page=$totalpage; } $offset=($page-1)*$pagesize; $sql=select * from
$board where slaveid=0 order by id desc limit $offset,$pagesize;
$sql_result=mysql_query($sql); ? /td td height=22 width=13%
bgcolor=#eeeeee贴子总数:?php echo $sum; ?/td td height=22 width=12%a
href=’javascript:post(?php echo $board;?)’img src=image/newtopic.jpg
width=93 height=21 border=0 alt=发新贴子/a/td td height=22 width=11%div
align=centera href=?php echo
$php_self?board=$board&page=$page;?刷新浏览/a/div /td /tr /table br
table width=100% border=1 cellspacing=0 cellpadding=1
bordercolorlight=#CCCCCC bordercolordark=#FFFFFF tr bgcolor=#995100
align=center td width=6%font color=#FFFFFF回应/font/td td width=67%
bgcolor=#995100font color=#FFFFFF主 题/font/td td width=20%font
color=#FFFFFF时 间/font/td td width=7%font color=#FFFFFF人气/font/td
/tr tr bgcolor=#FFCC99 td colspan=5 height=2/td /tr ?php while
($sql_row=mysql_fetch_array($sql_result)) { echotr; echotd width=6%
bgcolor=#FFF5DD align=center; if ($sql_row[renum]!=0) { echo font
color=#FF0000[+$sql_row[renum]]/font; } else { echo [0]; }
echo/td; echotd bgcolor=#E8FDEE width=56%font face=宋体a
href=’javascript:openwin($board,$sql_row[id])’
title=作者:$sql_row[writer]
大小:$sql_row[size]字节$sql_row[title]/a/font/td; echotd width=18%
bgcolor=#FFF5DD align=center$sql_row[writetime]/td; echotd width=6%
bgcolor=#E8FDEE align=center$sql_row[hits]/td; echo/tr; } ? tr
bgcolor=#FFCC99 td colspan=5 align=center height=2/td /tr /table div
align=right form method=post action=?php echo $php_self;? 共b?php echo
$totalpage;?/b页 第b?php echo $page;?/b页・?php if ($page!=1){
$back=$page-1; echoa href=$php_self?board=$board&page=1首页/a a
href=$php_self?board=$board&page=$back/a; } if ($page==1){ echo首页 ; }
if($page!=$totalpage){ $next=$page+1; echo a
href=$php_self?board=$board&page=$next/a a
href=$php_self?board=$board&page=$totalpage尾页/a; }
if($page==$totalpage){ echo 尾页; } ?・input type=submit name=goto
value=转到 input type=text name=page size=2 页/form /div ?php include
footer.php;? /body /html ## login.php ?php require func.php; if
($name==$admin_name and $password==$admin_password) { setcookie
(jl_admin[name],$name); setcookie (jl_admin[password],$name);
redirect2(admin.php); } else { show_error(1); } ? ## manage.php ?php
require func.php; if (check_admin_password()) { switch ($job){ case
setgood: set_good($jl_forum[board],$id); break; case setnogood:
set_no_good($jl_forum[board],$id); break; case delete:
del_doc($jl_forum[board],$id); break; } echo h2操作成功!/h2br; ?
htmlheadtitleo,k/title/headbody form method=POST input type=button
value= 关 闭 name=B1 onclick=window.close() /form /body /html ?php }
else { show_error(1); } ? ## manage_list.php ?php require(func.php);
if (check_admin_password()) { $board=$jl_forum[board]; $sql=select
* from boardinfo where name=’$board’; $sql_result=mysql_query($sql);
$sql_row=mysql_fetch_array($sql_result);
$chinesename=$sql_row[chinesename]; setcookie
(jl_forum[chinesename],$chinesename); $sql=select name from user
where slaveboard=’$board’; $sql_result=mysql_query($sql); ? html head
titleList/title meta content=text/html; charset=gb2312 link
rel=stylesheet type=text/css href=css/index.css script
language=javascript function
openwin(board,id){window.open(manage_read.php?board=+board+&id=+id,,height=460,width=600,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no);
} function
post(board){window.open(post.php?board=+board,,height=500,width=600,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no);
} /script /head body bgcolor=#FFFFFF background=image/bg.gif ?php
include header.php;? br table width=100% border=1 cellspacing=0
cellpadding=0 bordercolorlight=#D8D8E8 bordercolordark=#D8D8E8 trtd
height=20 width=27% bgcolor=#d8dde9版面:?php echo $chinesename;
?(管理)/td td height=20 width=31% bgcolor=#d8dde9版主:?php while
($sql_row=mysql_fetch_array($sql_result)) { echo $sql_row[name].;
} # 选择出留言纪录; $sql=select * from $board where slaveid=0;
$temp=mysql_query($sql); $sum=mysql_num_rows($temp);
$totalpage=ceil($sum/$pagesize); if ($sum==0) { $totalpage=1; } # 分页
if($page1 or empty($page)){ $page=1; } elseif ($page$totalpage){
$page=$totalpage; } $offset=($page-1)*$pagesize; $sql=select * from
$board where slaveid=0 order by id desc limit $offset,$pagesize;
$sql_result=mysql_query($sql); ? /td td height=20 width=15%
bgcolor=#d8dde9贴子总数:?php echo $sum; ?/td td height=20 width=12%a
href=’javascript:post(?php echo $board;?)’img src=image/newtopic.jpg
width=92 height=21 border=0 alt=发新贴子/a/td td height=20 align=center
width=15%a href=?php echo
$php_self?board=$board&page=$page;?刷新浏览/a/td /tr /table br table
width=100% border=1 cellspacing=0 cellpadding=1
bordercolorlight=#CCCCCC bordercolordark=#CCCCCC tr bgcolor=#995100
align=center td width=6%font color=#FFFFFF回应/font/td td width=67%
bgcolor=#995100font color=#FFFFFF主 题/font/td td width=20%font
color=#FFFFFF时 间/font/td td width=7%font color=#FFFFFF人气/font/td
/tr tr bgcolor=#FFCC99 td colspan=5 height=2/td /tr ?php while
($sql_row=mysql_fetch_array($sql_result)) { echotr; echotd width=6%
bgcolor=#FFF5DD align=center; if ($sql_row[renum]!=0) { echo font
color=#FF0000[+$sql_row[renum]]/font; } else { echo [0]; }
echo/td; echotd bgcolor=#E8FDEE width=56%font face=宋体a
href=’javascript:openwin($board,$sql_row[id])’
title=作者:$sql_row[writer]
大小:$sql_row[size]字节$sql_row[title]/a/font/td; echotd width=18%
bgcolor=#FFF5DD align=center$sql_row[writetime]/td; echotd width=6%
bgcolor=#E8FDEE align=center$sql_row[hits]/td; echo/tr; } ? tr
bgcolor=#FFCC99 td colspan=5 align=center height=2/td /tr /table div
align=right form method=post action=?php echo $php_self;? 共b?php echo
$totalpage;?/b页 第b?php echo $page;?/b页・ ?php if ($page!=1){
$back=$page-1; echoa href=$php_self?board=$board&page=1首页/a a
href=$php_self?board=$board&page=$back/a; } if ($page==1){ echo首页 ; }
if($page!=$totalpage){ $next=$page+1; echo a
href=$php_self?board=$board&page=$next/a a
href=$php_self?board=$board&page=$totalpage尾页/a; }
if($page==$totalpage){ echo 尾页; } ?・转到第input type=text name=page
size=2 页/form /div ?php include footer.php? /body /html ?php } else {
show_error(4); } ?

‘ 用GetListCount方法确定在conlink.txt中有多少条超链. Dim i For i=1 to
lcount li a href=”%20%%20=Link.GetNthURL(“conlink.txt”, i) %”

%=Link.GetNthDescription(“conlink.txt”, i) % /a % Next %

‘ 用GetNthURL、GetNthDescription方法逐一将存储在conlink.txt
文件的URL和文本信息读出并显示给客户端浏览器,循环执行. /ul /body /html

You can leave a response, or trackback from your own site.

Leave a Reply

网站地图xml地图