您的位置:365bet体育备用网址器 > 应用 > 基于mysql的论坛(7)

基于mysql的论坛(7)

2020-01-17 18:35

# sendmsg.php ?php require func.php; if ($b1) { if (is_user_exits($fromname) and check_user_password($fromname,$password)) { sendmsg(); echo 成功!brform method=POSTinput type=button value= 关闭窗口 name=B1 onclick=window.close()/form; } else { $founderr=1; echo 用户名/密码错误!; } } else { ? html head title发送留言/title meta content=text/html; charset=gb2312 link rel=stylesheet type=text/css href=css/index.css /head body bgcolor=#eeeeee form method=post action=?php echo $php_self;? table width=98% border=1 cellspacing=0 cellpadding=0 bordercolorlight=#000000 bordercolordark=#FFFFFF tr align=centertd colspan=2给 a href=userinfo.php?name=?php echo $name;? target=_blank?php echo $name;?/a发送留言/td /tr trtd align=right width=27%您的用户名:/td td width=73%input type=text name=fromname size=17 maxlength=16 value=?php echo $jl_forum[name];? * /td /tr trtd align=right width=27%您的密码:/td td width=73%input type=password name=password size=17 maxlength=16 * /td /tr trtd align=right width=27% valign=top内容:/td td width=73%textarea name=cont wrap=VIRTUAL cols=40 rows=3/textarea input type=hidden name=toname value=?php echo $name;? br input type=submit name=b1 value=发送 input type=button name=Submit value=取消 onclick=window.close() /td /tr /table /form /body /html ?php } ? ############### # setup.php # 此为初始化程序,只在上传后第一次执行,之后必须delete,以免出错 ################# ?php require func.php; echo h1初始化数据库/h1brbr; echo 建立数据库连接...ok!br; echo 建立表 boardinfo...; $sql=CREATE TABLE boardinfo (name varchar(50) NOT NULL, chinesename varchar(50) NOT NULL); mysql_query($sql) or die(错误); echo ok!br; echo 建立表 user...; $sql=CREATE TABLE user (id int(11) NOT NULL auto_increment, name varchar(50) NOT NULL, sex varchar(6), realname varchar(20), password varchar(16) NOT NULL, address varchar(40), oicq varchar(10), homepagevarchar(50), score int(11), phone varchar(20), email varchar(50), regtime varchar(20), qm text,slaveboard varchar(50), PRIMARY KEY (id)); mysql_query($sql) or die(错误); echo ok!br; echo 建立表 message... ; $sql=create table message (id int(11) NOT NULL auto_increment,name varchar(50), fromname varchar(50), writetime varchar(20), cont longtext, PRIMARY KEY(id)); mysql_query($sql) or die(错误); echo ok!br; echo 初始化版面 “个人电脑”...; create_board_table('computer','个人电脑'); echo ok!brbr; echo h2设置完毕!/h2; echo brbr冷情疯子; ? ## userinfo.php html head title用户信息/title meta content=text/html; charset=gb2312 link rel=stylesheet type=text/css href=css/index.css /head body bgcolor=#FFFFFF background=image/bg.gif ?php include header.php; if (!isset($name)) { ? form method=post action=?php echo $php_self;? table width=90% border=1 cellspacing=0 cellpadding=1 align=center bordercolorlight=#CCCCCC bordercolordark=#FFFFFF tr align=centertd请输入欲察看的用户名/td /tr tr align=centertd input type=text name=name size=18 maxlength=16 /td /tr tr align=centertd input type=submit name=b1 value=察看资料 /td /tr /table /form ?php } else { require func.php; if (is_user_exits($name)) { $sql=select * from user where name='$name'; $sql_result=mysql_query($sql); $row=mysql_fetch_array($sql_result); ? br table width=90% border=1 cellspacing=0 cellpadding=1 align=center bordercolorlight=#CCCCCC bordercolordark=#FFFFFF tr tdb详细资料/b/td /tr tr td用户名:?php echo $row[name];?/td /tr tr td真实姓名:?php echo $row[realname];?/td /tr tr td性别:?php echo $row[sex];?/td /tr tr td地址:?php echo $row[address];?/td /tr tr td电话:?php echo $row[phone];?/td /tr tr tdOICQ:?php echo $row[oicq];?/td /tr tr tdEmail:a href=mailto:?php echo $row[email];??php echo $row[email];?/a/td /tr tr td主页:a href=?php echo $row[homepage];? target=_blank?php echo $row[homepage];?/a/td /tr tr td注册时间:?php echo $row[regtime];?/td /tr tr td目前积分:?php echo $row[score];?/td /tr /table br ?php } else { echo 请输入正确合法存在的用户名称; } } include footer.php;? /body /html # viewmsg.php ?php require func.php; if (is_user_exits($jl_forum[name]) and check_user_password($jl_forum[name],$jl_forum[password])) { if (isset($job)) { if (is_this_user($id)) { delmsg($id); } } $name=$jl_forum[name]; $sql=select * from message where name='$name'; $sql_result=mysql_query($sql); $sum=mysql_num_rows($sql_result); ? html head title察看留言/title meta content=text/html; charset=gb2312 link rel=stylesheet type=text/css href=css/index.css script language=javascript function sendmsg(name){window.open(sendmsg.php?name=+name,,height=200,width=500,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no); } /script /head body bgcolor=#FFFFFF background=image/bg.gif p您目前共有 b?php echo $sum;?/b 条留言/p table width=98% border=1 cellspacing=0 cellpadding=0 bordercolorlight=#CCCCCC bordercolordark=#FFFFFF ?php while ($sql_row=mysql_fetch_array($sql_result)) { ? tr bgcolor=#eeeeeetda href=javascript:sendmsg('?php echo $sql_row[fromname];?')?php echo $sql_row[fromname];?/a于 ?php echo $sql_row[writetime];? a href=?php echo $php_self?job=del&id=$sql_row[id];?删除/a/td /tr tr td?php echo $sql_row[cont];?/td /tr tr td/td /tr ?php } ? /table p /p /body /html ?php } else { show_error(4); } ?

# post.php ?php require(config.inc.php); $sql=select * from boardinfo where name='$board'; $sql_result=mysql_query($sql); $sql_row=mysql_fetch_array($sql_result); ? html head title发新贴子/title link rel=stylesheet type=text/css href=css/index.css /head body bgcolor=#666666 ?php include ad.php;?br hr noshade width=80% size=1 table width=80% border=1 cellspacing=0 cellpadding=0 align=center bordercolorlight=#686898 bordercolordark=#FFFFFF tr align=center valign=top bgcolor=#666699tdfont size=3 color=#336699bfont color=#CCFFFF发 贴 子/font/b/fontbr /td /tr tr bgcolor=#ffffeftd/td /tr tr bgcolor=#e8eee0tdbr 您的贴子将被发表在b?php echo $sql_row[chinesename];?/b版块 /td /tr /table br form method=post action=read.php table width=98% border=1 cellspacing=0 cellpadding=0 align=center bordercolorlight=#336699 bordercolordark=#FFFFFF bgcolor=#666699 trtd width=89 bgcolor=#acc0fa align=right用户名:/td td width=224input type=text name=name style=font-size: 9pt; background-color: #FFFFFF; color: #3366FF; border: 1 solid #000000 value=?php echo $jl_forum[name];? size=17 maxlength=16 font color=#FF0000* /font /td td width=63 bgcolor=#acc0fa align=right密码:/td td width=160input type=password name=password size=10 maxlength=16 style=font-size: 9pt; background-color: #FFFFFF; color: #FF0000; border: 1 solid #000000 font color=#FF0000*/font font color=#FF0000 /font /td /tr trtd colspan=4font color=#FFFFFF主题:/fontinput type=text name=title size=50 maxlength=50 style=font-size: 9pt; background-color: #FFFFFF; color: ##3366FF; border: 1 solid #000000 font color=#FF0000* /font/td /tr trtd colspan=4 font color=#FFFFFF内容:/fontbr textarea name=cont cols=70 rows=12 wrap=VIRTUAL/textarea br input type=button name=Submit2 value=取消 onclick=window.close() input type=submit name=add value=提交 input type=checkbox name=qm value=qm checked font color=#FFFFFF使用签名/fontinput type=hidden name=board value=?php echo $board;? /td /tr /table /form ?php include footer.php;?br /body /html # query.php ?php require(func.php); $sql=select * from boardinfo; $sql_result=mysql_query($sql); ? html head titlemain/title meta content=text/html; charset=gb2312 link rel=stylesheet type=text/css href=css/page.css /head body bgcolor=#FFFFFF background=image/bg.gif table width=90% border=1 cellspacing=0 cellpadding=0 align=center bordercolorlight=#FFCC99 bordercolordark=#FFCC99 tr bgcolor=#CCFF99td div align=centerb论坛贴子查询/b/div /td /tr tr align=centertd form method=post action=query_list.php 在select name=board option selected请选择版面/option ?php while($sql_row=mysql_fetch_array($sql_result)){ ?option value=?php echo $sql_row[name];??php echo $sql_row[chinesename];?/option ?php } ? /select 中查询br input type=text name=query_str size=40 maxlength=40 br input type=submit name=title value=按主题查询 input type=submit name=cont value=按内容查询 input type=submit name=writer value=按作者查询 /form /td /tr tr bgcolor=#CCFF99td div align=centerb论坛信息/b/div /td /tr tr td ?php include info.php;? /td /tr /table /body /html # query_list.php ?php require(func.php); if (!empty($query_str)) { if(!is_board_exits($board)){ $board=computer; } if ($title){ $submit=title; } elseif ($cont) { $submit=cont; } elseif ($writer) { $submit=writer; } else { $submit=title; } $sql=select * from $board where ($submit like '%$query_str%'); $temp=mysql_query($sql); $sum=mysql_num_rows($temp); if ($sum!=0) { $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(good_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 tr td height=20 width=22% bgcolor=#E8E8E8版面:?php echo $chinesename; ?/td td height=20 width=29% bgcolor=#E8E8E8版主:?php while ($sql_row=mysql_fetch_array($sql_result)) { echo $sql_row[name].; } # 选择出留言纪录; $totalpage=ceil($sum/$pagesize); # 分页 if($page1 or empty($page)){ $page=1; } elseif ($page$totalpage){ $page=$totalpage; } elseif ($totalpage==0) { $page=0; } $offset=($page-1)*$pagesize; $sql=select * from $board where ($submit like '%$query_str%') order by id desc limit $offset,$pagesize; $sql_result=mysql_query($sql); ? /td td height=20 width=17% bgcolor=#E8E8E8查询到?php echo $sum; ?条纪录/td td height=20 colspan=2 width=32%a href='javascript:post(?php echo $board;?)'img src=image/newtopic.jpg width=92 height=21 border=0 alt=发新贴子/a/td /tr /table br table width=100% border=1 cellspacing=0 cellpadding=1 bordercolorlight=#CCCCCC bordercolordark=#eeeeee 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=#E8E8E8 align=center; echo [*]; 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;? input type=hidden name=?php echo $submit;? value=y input type=hidden name=query_str value=?php echo $query_str;? 共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&$submit=y&query_str=$query_str首页/a a href=$php_self?board=$board&page=$back&$submit=y&query_str=$query_str/a; } if ($page==1){ echo首页 ; } if($page!=$totalpage){ $next=$page+1; echo a href=$php_self?board=$board&page=$next&$submit=y&query_str=$query_str/a a href=$php_self?board=$board&page=$totalpage&$submit=y&query_str=$query_str尾页/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 ?php } else { show_error(10); } } else { show_error(9); } # read.php ?php require (func.php); if ($re){ $sql=select slaveid from $board where id=$id; $sql_result=mysql_query($sql); $sql_row=mysql_fetch_array($sql_result); if($sql_row[slaveid]!=0){ show_error(1); $founderr=1; } if (!check_user_password($name,$password)){ show_error(4); $founderr=1; } if (empty($title)){ show_error(2); $founderr=1; } if ($qm){ $qm=expl_qm($name); } if(!$founderr){ re_doc($board,$id); setcookie (jl_forum[name],$name); $sql=select * from $board where id=$id; $sql_result=mysql_query($sql); $sql_row=mysql_fetch_array($sql_result); $title=$sql_row[title]; $writer=$sql_row[writer]; $cont=$sql_row[cont]; $writetime=$sql_row[writetime]; $hits=$sql_row[$hits]; $fromip=$sql_row[fromip]; $sql=select * from $board where slaveid=$id; $sql_result=mysql_query($sql); # $sql_row=mysql_fetch_array($sql_result); } } elseif ($add){ if (!is_board_exits($board)){ show_error(7); $founderr=1; } if (empty($title)){ show_error(2); $founderr=1; } if (!check_user_password($name,$password)){ show_error(4); $founderr=1; } if ($qm){ $qm=expl_qm($name); } if (!$founderr){ add_doc($board); $add=1; setcookie (jl_forum[name],$name); } } else { if (!is_board_exits){ show_error(7); } add_one_hit($board,$id); $sql=select * from $board where id=$id; $sql_result=mysql_query($sql); $sql_row=mysql_fetch_array($sql_result); $title=$sql_row[title]; $writer=$sql_row[writer]; $cont=$sql_row[cont]; $writetime=$sql_row[writetime]; $hits=$sql_row[$hits]; $fromip=$sql_row[fromip]; $sql=select * from $board where slaveid=$id; $sql_result=mysql_query($sql); #$sql_row=mysql_fetch_array($sql_result); } ? html head title?php echo $title;?/title meta content=text/html; charset=gb2312 link rel=stylesheet type=text/css href=css/index.css script language=javascript function sendmsg(name){window.open(sendmsg.php?name=+name,,height=200,width=500,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no); } /script /head body bgcolor=#666699 ?php include ad.php;?br hr noshade width=98% size=1 table width=98% border=1 cellspacing=0 cellpadding=2 align=center bordercolorlight=#CCCCCC bordercolordark=#FFFFFF tr bgcolor=#666666 tdfont color=#FFcc00b标题:?php echo $title;?/b/font/td /tr tr td bgcolor=#eeeeee作者:?php echo $writer;?(?php echo $writetime;?) a href=javascript:sendmsg('?php echo $writer;?')img src=image/icon1.gif width=18 height=17 alt=给作者留言 border=0/a a href=userinfo.php?name=?php echo $writer;?img src=image/profile.gif width=16 height=15 alt=察看用户资料 border=0/a/td /tr tr bgcolor=#ffffeftd?php echo $cont;?/td /tr tr bgcolor=#e8eee0 td※ 来源:?php echo $jl_forum[chinesename];? [◆FROM:?php echo $fromip;?]/td /tr /table br ?php if ($add!=1){ while($sql_row=mysql_fetch_array($sql_result)) { ? table width=98% border=1 cellspacing=0 cellpadding=2 align=center bordercolorlight=#CCCCCC bordercolordark=#FFFFFF tr bgcolor=#015C71 tdfont color=#ffffff标题:?php echo $sql_row[title];?/font/td /tr tr bgcolor=#eeeeee td作者:?php echo $sql_row[writer];?(?php echo $sql_row[writetime];?) a href=javascript:sendmsg('?php echo $sql_row[writer];?')img src=image/icon1.gif width=18 height=17 alt=给作者留言 border=0/a a href=userinfo.php?name=?php echo $sql_row[writer];?img src=image/profile.gif width=17 height=15 alt=察看用户资料 border=0/a/td /tr tr bgcolor=#ffffeftd?php echo $sql_row[cont];?/td /tr tr bgcolor=#e8eee0 td※ 来源:?php echo $jl_forum[chinesename];? [◆FROM:?php echo $sql_row[fromip];?]/td /tr /table ?php } ? form method=post action=read.php table width=98% border=0 cellspacing=0 cellpadding=0 align=center tr td table width=40 border=1 cellspacing=0 cellpadding=0 height=20 bordercolorlight=#000099 bordercolordark=#FFFFFF tr valign=middle align=center bgcolor=#acc0fa td height=17回复/td /tr /table /td /tr /table table width=98% border=1 cellspacing=0 cellpadding=0 align=center bordercolorlight=#686898 bordercolordark=#CCCCCC tr td width=8% align=right bgcolor=#acc0fa用户名/td td width=33% input type=text name=name size=17 maxlength=16 value=?php echo $jl_forum[name];? font color=#FFFFFF* /font/td td width=7% bgcolor=#acc0fa align=center密码/td td width=52% input type=password name=password size=17 maxlength=16 font color=#FFFFFF* /font/td /tr tr td width=8% align=right bgcolor=#acc0fa标题:/td td colspan=3 input type=text name=title size=40 maxlength=50 font color=#FFFFFF * /font/td /tr tr td width=8% align=right bgcolor=#acc0fa内容:/td td colspan=3 textarea name=cont cols=60 rows=3 wrap=VIRTUAL/textarea /td /tr tr td width=8% align=right bgcolor=#acc0fa/td td colspan=3 input type=button name=clear value=关闭窗口 onclick=window.close() input type=submit name=re value=提交 input type=checkbox name=qm value=qm checked font color=#FFFFFF使用签名 input type=hidden name=board value=?php echo $board;? input type=hidden name=id value=?php echo $id;? /font/td /tr /table ?php } ? br /form ?php includefooter.php;?br /body /html

本文由365bet体育备用网址器发布于应用,转载请注明出处:基于mysql的论坛(7)

关键词: