一个分页的论坛

——————————-论坛————————– 数据表
create table guest(id int not null auto_increment,primary key(id),title
varchar(50),email varchar(30),homepage varchar(30),name varchar(30),text
text,relay int,r_time date) create table relay(id int not null
auto_increment,primarykey(id),title int,email varchar(30),name
varchar(30),text text)
————————-index.php————————–
STYLETD{FONT-FAMILY:宋体;FONT-SIZE:13pt}BODY{FONT-FAMILY:宋体;FONT-SIZE:13pt}SELECT{FONT-FAMILY:宋体;FONT-SIZE:13pt}A{COLOR:blue;FONT-FAMILY:宋体;FONT-SIZE:13pt;TEXT-DECORATION:none}/STYLE
div p font size=14b网站完全手册/font/p/div ?php $db
=mysql_connect(localhost, ****,****);
mysql_select_db(****,$db); @$result = mysql_query(SELECT * FROM
guest order by id desc,$db); $i=0; while($myrow =
mysql_fetch_row($result)) { $guestbook[$i][0] = $myrow[0];
$guestbook[$i][1] = $myrow[1]; $guestbook[$i][2] =
$myrow[2]; $guestbook[$i][3] = $myrow[4];
$guestbook[$i][4]=$myrow[6]; $guestbook[$i][5]=$myrow[7];
$i++; }//读入数组 mysql_close($db) ; echo
—————————–共[; if ($q!=) { $page = $q; } else {
$page = 0; } $i=count($guestbook); $msgnum=20;// 每页20笔 $start = $page
* $msgnum; $end = $start + $msgnum; if ($end $i) $end=$i;
$totalpage=$i/$msgnum; for ($i=0; $i$totalpage; $i++) { if ($i!=$page) {
echo a href=index.php?q=$i $i/a; } else { echo $i; } } echo
]页—————————–br;printf(p align=righta
href=111.php添加主题/a/p); echo br; echo table width=700 hight=560
border=1 ; echo tr;echo td width=200 bgcolor=aaaaaa border=1
style=border: 1px solid rgb(3,2,1)主题/td; echo td width=200
bgcolor=aaaaaa border=1 style=border: 1px solid rgb(3,2,1)电子邮件/td;
echo td width=80 bgcolor=aaaaaa border=1 style=border: 1px solid
rgb(3,2,1)呢称/td; echo td width=60 bgcolor=aaaaaa border=1
style=border: 1px solid rgb(3,2,1)回复/td; echo td width=200
bgcolor=aaaaaa border=1 style=border: 1px solid
rgb(3,2,1)最后回复时间/td; echo /tr; for ($i=$start; $i$end; $i++) {
$id=$guestbook[$i][0]; echo tr ;echo td width=200 bgcolor=bbbbbb
border=0 style=border: 1px solid rgb(3,2,1); echo a
href=444.php?id=$id;echo $guestbook[$i][1]; echo /a; echo /td; echo
td width=200 bgcolor=bbbbbb border=0 style=border: 1px solid rgb(3,2,1);
echo a href=mailto:.$guestbook[$i][2].;echo
$guestbook[$i][2];echo /a;echo /td; echo td width=80 bgcolor=bbbbbb
border=0 style=border: 1px solid rgb(3,2,1); echo $guestbook[$i][3];
echo /td; echo td width=60 bgcolor=bbbbbb border=0 style=border: 1px
solid rgb(3,2,1); echo $guestbook[$i][4]; echo /td; echo td
width=200 bgcolor=bbbbbb border=0 style=border: 1px solid rgb(3,2,1);
echo $guestbook[$i][5]; echo /td; echo /tr; } echo /table; echo br;
printf(a href=111.php添加主题/a); ?
——————————444.php——————————–
STYLETD{FONT-FAMILY:宋体;FONT-SIZE:13pt}BODY{FONT-FAMILY:宋体;FONT-SIZE:13pt}SELECT{FONT-FAMILY:宋体;FONT-SIZE:13pt}A{COLOR:blue;FONT-FAMILY:宋体;FONT-SIZE:13pt;TEXT-DECORATION:none}/STYLE
?php $db =mysql_connect(localhost, ****,****);
mysql_select_db(****,$db); @$result = mysql_query(SELECT * FROM
guest where id=’$id’,$db); echo table width=700 border=1 ; $myrow =
mysql_fetch_row($result); echo tr higth=20;echo td width=700
bgcolor=888888 border=1 style=border: 1px solid rgb(3,2,1)主题:; echo
$myrow[1]; echo /td; echo /tr; $msg=base64_decode($myrow[5]); $msg
= ereg_replace( ,,$msg);//空格处理 $msg=nl2br($msg);// 换行处理 if
($myrow[3]!=){$myrow[3]=a href=$myrow[3]$myrow[3]/a;} else
{$myrow[3]=我还没在网上安家;} echo tr higth=60; echo td width=700
bgcolor=bbbbbb border=1 style=border: 1px solid rgb(3,2,1); echo
$msg;echo /td;echo /tr; echo tr higth=20;echo td width=700
bgcolor=bbbbee border=1 style=border: 1px solid rgb(3,2,1)主页:; echo
$myrow[3]; echo /td/tr; echo tr higth=20;echo td width=700
bgcolor=888888 border=1 style=border: 1px solid rgb(3,2,1);echo
回复列表; echo /td; echo /tr; $num=$myrow[6]; @$result1 =
mysql_query(SELECT * FROM relay where title=’$id’ order by id
desc,$db); $i=0; while($myrow1 = mysql_fetch_row($result1)) {
$guestbook[$i][0] = $myrow1[1]; $guestbook[$i][1] =
$myrow1[2]; $guestbook[$i][2] = $myrow1[3];
$guestbook[$i][3]=$myrow1[4]; $i++; } mysql_close($db); if ($q!=)
{ $page = $q; } else { $page = 0; } $i=count($guestbook); $msgnum=5;//
每页5笔 $start = $page * $msgnum; $end = $start + $msgnum; if ($end $i)
$end=$i; $totalpage=$i/$msgnum; for ($i=$start; $i$end; $i++) {
$t=$guestbook[$i][0]; echo tr ;echo td width=700 bgcolor=aaaaaa
border=0 style=border: 1px solid rgb(3,2,1); echo Re:; echo
$myrow[1];echo /td;echo /tr; echo tr ; echo td width=700
bgcolor=bbbbbb border=0 style=border: 1px solid rgb(3,2,1); echo
$guestbook[$i][2]; echo /td;echo /tr; echo tr ; echo td width=700
bgcolor=bbbbee border=0 style=border: 1px solid rgb(3,2,1)电子邮件:;
echo a href=mailto:.$guestbook[$i][1].;echo
$guestbook[$i][1];echo /a;echo /td;echo /tr;
$msg=base64_decode($guestbook[$i][3]); $msg = ereg_replace(
,,$msg); $msg=nl2br($msg); echo tr ;echo td width=700 bgcolor=bbbbbb
border=0 style=border: 1px solid rgb(3,2,1); echo $msg; echo /td;echo
/tr; } echo /table; echo br; echo br;echo
——————————-共[; for ($i=0; $i$totalpage; $i++) { if
($i!=$page) { echo a href=444.php?q=$i&id=$id $i/a; } else { echo$i; }
}echo ]页———————————;echo br; echo a
href=333.php?t=$id&num=$num回复/a;echo br; echo a
href=index.php浏览主题/a; ?
——————————–333.php—————————–
html head ?php if (!$t){ if ($text==&$email==&$name==){echo *必填;echo
a
href=333.php?t=$title&name=$name&email=$email&text=$text&num=$num返回/a;
} else {if
(eregi(^[_.0-9a-z-]+@([0-9a-z][0-9a-z-]+.)+[a-z]{2,3}$,$email)){
$text = base64_encode($text);//检验邮件地址是否合法 $db
=mysql_connect(localhost, ****,****); $time=date(y-m-d);
mysql_select_db(****,$db); $sql=insert into relay
values(”,’$title’,’$email’,’$name’,’$text’); $result =
mysql_query($sql); $num=$num+1; $sql=update guest set
relay=’$num’,r_time=’$time’ where id=’$title’;
$result=mysql_query($sql); mysql_close(); echo META HTTP-EQUIV=REFRESH
CONTENT=’1; URL=444.php?id=$title’; } else {echo 邮件地址无效;echo a
href=333.php?t=$title&name=$name&text=$text&num=$num返回/a;} }} else
{?FORM ACTION=333.php METHOD=post table border=0 cellpadding=2 width=395
tr td width=20%input type=hidden name=title value=? echo $t; ?/td/tr tr
td nowrapfont color=004080呢称:*/font/td td width=10%input type=text
name=name size=10 value=? echo $name; ?/td /tr tr td nowrapfont
color=004080邮件:*/font/td td width=20%input type=text name=email
size=20 value=? echo $email; ?/td /tr tr td width=20%input type=hidden
name=num value=? echo $num; ?/td /tr tr td nowrapvalign=topfont
color=004080内容:*/font/td td width=80% colspan=3textarea rows=5
name=text cols=50 size=255? echo $text; ?/textarea/td /tr tr td
width=100% colspan=4 input type=submit value=送出 input type=reset
value=擦掉 /td /tr /table /FORM?} ? /head body /html
———————————– HTML HEAD ?php if
($title!=&$email!=&$name!=){ if
(eregi(^[_.0-9a-z-]+@([0-9a-z][0-9a-z-]+.)+[a-z]{2,3}$,$email)){
$text = base64_encode($text);//检验邮件地址是否合法 $db
=mysql_connect(localhost, ****,****); $time=date(y-m-d);
mysql_select_db(****,$db); $sql=insert into guest
values(”,’$title’,’$email’,’$homepage’,’$name’,’$text’,”,’$time’);
$result = mysql_query($sql);mysql_close(); echo META
HTTP-EQUIV=REFRESH CONTENT=’1; URL=index.php’; } else { echo
邮件地址无效; echo a
href=111.php?title=$title&&homepage=$homepage&name=$name&text=$text返回/a;}}
else {echo *必填; echo a
href=111.php?title=$title&email=$email&homepage=$homepage&name=$name&text=$text返回/a;}
//mysql_close($db) //printf(留言成功a href=222.php按此返回/a); ? /HEAD
BODY /BODY /HTML
——————————–111.php————————— html
head /head body FORM ACTION= METHOD=post table border=0 cellpadding=2
width=395 tr td nowrapfont color=004080标题:*/font/td td width=20%input
type=text name=title size=30 value=? echo $title; ?/td/trtr td
nowrapfont color=004080邮件:*/font/td td width=20%input type=text
name=email size=30 value=? echo $email; ?/td /tr tr td nowrapfont
color=004080主页:/font/td td width=25%input type=text name=homepage
size=30 value=? echo $homepage; ?/td /tr tr td nowrapfont
color=004080呢称:*/font/td td width=10%input type=text name=name
size=10 value=? echo $name; ?/td /tr tr td nowrapvalign=topfont
color=004080内容:/font/td td width=80% colspan=3textarea rows=5
name=text cols=50 size=255 ? echo $text; ?/textarea/td /tr tr td
width=100% colspan=4 input type=submit value=送出 input type=reset
value=擦掉 /td /tr /table /FORM /body /html

投票管理程序 表结构 CREATE TABLE poll(Poll_Id INT (11) not null
AUTO_INCREMENT,Poll_Name char(50) ,Poll_Del INT (10) DEFAULT ‘0’ ,
PRIMARY KEY (Poll_Id))CREATE TABLE pollsele(Pollsele_Id INT (11) not
null AUTO_INCREMENT,Pollsele_Name char(50) ,Poll_Del INT (10) DEFAULT
‘0’ , Pollsele_poll_Id INT (10) ,pollsele_num int (10), PRIMARY KEY
(Pollsele_Id))————————————————————————————————-
poll.php//主程序 ?$db =mysql_connect(localhost, root,391450);
mysql_select_db(class,$db); $sql=select poll_id,Poll_Name from poll
where poll_del=’1′; @$result = mysql_query($sql);
$myrow=mysql_fetch_row($result); echo table bgcolor=aabbcc width=250
hight=450 border=0 style=’border:1px solid rgb(0,0,0)’; echo td
bgcolor=99aabb style=’border:1px solid rgb(255,255,255)’; echo
$myrow[1]; $sql=select Pollsele_Name,pollsele_poll_id from pollsele
where pollsele_del=’0′ and pollsele_poll_id=’$myrow[0]’; @$result =
mysql_query($sql); echo FORM ACTION=’pollsee.php?poll_id=$myrow[0]’
METHOD=’post’ target=_blank; echo p ;
while($myrow=mysql_fetch_row($result)) { echo input type=’radio’
name=toupiao value=’$myrow[0]’$myrow[0]; echo ;} echo br;echo br;
echo input type=submit name=submit value=’投票’ ; echo /p; echo
/form;echo /td; echo /table; mysql_close(); echo br; echo p

align=right; echo a href=poll_input管理/a; echo /p;?

poll_input.php//添加主题 ?$db =mysql_connect(localhost, root,391450);
mysql_select_db(class,$db); $sql=select poll_id,poll_name,poll_del
from poll; echo table width=300 hight=560 bgcolor=aabbcc
style=’border:1px solid rgb(0,0,0)’; $result=mysql_query($sql);
while($my=mysql_fetch_row($result)) { echo tr;echo td width=50
bgcolor=99aabb style=’border: 1px solid rgb(255,255,255)’;echo
$my[0];echo /td; echo td width=200 bgcolor=99aabb style=’border: 1px
solid rgb(255,255,255)’a href=pollsele.php?id=$my[0]$my[1]/a/td;
echo td width=50 bgcolor=99aabb style=’border: 1px solid
rgb(255,255,255)’;echo $my[2];echo /td; echo /tr; }echo /table; ? html
head ? if($submit2!=添加) { echo p ; echo FORM ACTION=’poll_input.php’
METHOD=’post’; echo font color=004080主题:/font; echo input type=text
name=title size=30 value=”; echo input type=submit name=submit2
value=’添加’; echo /p; echo/form;} else {$db =mysql_connect(localhost,
root,391450); mysql_select_db(class,$db); $sql=select poll_name from
poll where poll_name=’$title’; mysql_query($sql); $sql=insert into
poll values(”,’$title’,”); mysql_query($sql); mysql_close(); echo
META HTTP-EQUIV=REFRESH CONTENT=’1; URL=poll_input.php’;}
if($submit1!=有效&&$submit3!=删除) {echo p ; echo FORM
ACTION=’poll_input.php’ METHOD=’post’; echo font
color=004080设置主题:/font; echo select name=’sele’ size=1; $db
=mysql_connect(localhost, root,391450); mysql_select_db(class,$db);
$sql=select Poll_Id from poll; $result = mysql_query($sql);
mysql_close(); while($myrow=mysql_fetch_row($result)) { echo option
value=’$myrow[0]’$myrow[0];} echo /select; echo input type=submit
name=submit1 value=’有效’; echo input type=submit name=submit3
value=’删除’; echo /p; echo /FORM; } else { if($submit1==有效) { $db
=mysql_connect(localhost, root,391450); mysql_select_db(class,$db);
$sql=update poll set Poll_Del=’0′; $result = mysql_query($sql);
$sql=update poll set Poll_Del=’1′ where poll_id=’$sele’; $result =
mysql_query($sql); mysql_close(); echo META HTTP-EQUIV=REFRESH
CONTENT=’1; URL=poll_input.php’;} else {$db =mysql_connect(localhost,
root,391450); mysql_select_db(class,$db); $sql=delete from poll where
poll_id=’$sele’; $result = mysql_query($sql); $sql=delete from
pollsele where pollsele_poll_id=’$sele’; mysql_query($sql);
mysql_close(); echo META HTTP-EQUIV=REFRESH CONTENT=’1;

URL=poll_input.php’;} } ?

pollsele.php//添加选项 ?$db =mysql_connect(localhost, root,391450);
mysql_select_db(class,$db); $sql=select
pollsele_id,pollsele_name,pollsele_del,pollsele_num from pollsele
where pollsele_poll_id=’$id’; echo table width=300 hight=560
bgcolor=aabbcc style=’border:1px solid rgb(0,0,0)’ ;
@$result=mysql_query($sql); while($my=mysql_fetch_row($result)) {
echo tr;echo td width=50 bgcolor=99aabbstyle=’border: 1px solid
rgb(255,255,255)’;echo $my[0];echo /td; echo td width=200
bgcolor=99aabbstyle=’border: 1px solid rgb(255,255,255)’$my[1]/td;
echo td width=50 bgcolor=99aabbstyle=’border: 1px solid
rgb(255,255,255)’;echo $my[2];echo /td; echo td width=50
bgcolor=99aabbstyle=’border: 1px solid rgb(255,255,255)’;echo
$my[3];echo /td; echo /tr; }echo /table; ? html head ?
if($submit2!=添加) {echo p ; echo FORM ACTION=’pollsele.php?id=$id’
METHOD=’post’; echo font color=004080选项:/font/td; echo input type=text
name=title size=30 value=”; echo input type=submit name=submit2
value=’添加’; echo /p; echo/form;} else {$db =mysql_connect(localhost,
root,391450); mysql_select_db(class,$db); $sql=insert into pollsele
values(”,’$title’,”,’$id’,”); mysql_query($sql); mysql_close();
echo META HTTP-EQUIV=REFRESH CONTENT=’1; URL=pollsele.php?id=$id’;}
if($submit1!=有效&&$submit3!=无效) {echo p ; echo FORM
ACTION=’pollsele.php?id=$id’ METHOD=’post’; echo font
color=004080设置选项:/font; echo select name=’sele’ size=1; $db
=mysql_connect(localhost, root,391450); mysql_select_db(class,$db);
$sql=select Pollsele_Id from pollsele where pollsele_poll_id=’$id’;
$result = mysql_query($sql); mysql_close();
while($myrow=mysql_fetch_row($result)) { echo option
value=’$myrow[0]’$myrow[0];} echo /select; echo input type=submit
name=submit1 value=’有效’; echo input type=submit name=submit3
value=’无效’; echo /p; echo /FORM; } else { $db
=mysql_connect(localhost, root,391450); mysql_select_db(class,$db);
if ($submit1==有效) { $sql=update pollsele set Pollsele_Del=’0′ where
pollsele_id=’$sele’; $result = mysql_query($sql);} else { $sql=update
pollsele set Pollsele_Del=’1′ where pollsele_id=’$sele’; $result =
mysql_query($sql);} mysql_close(); echo META HTTP-EQUIV=REFRESH

CONTENT=’1; URL=pollsele.php?id=$id’;} ?

pollsee.php//投票结果 ?if ($toupiao!=){ $db =mysql_connect(localhost,
root,391450); mysql_select_db(class,$db); $sql=select
Pollsele_Name,pollsele_num from pollsele where
pollsele_name=’$toupiao’; @$result = mysql_query($sql);
$myrow=mysql_fetch_row($result); $poll_num=$myrow[1];
$poll_num=$poll_num+1; $sql=update pollsele set
Pollsele_num=’$poll_num’ where pollsele_name=’$toupiao’;
mysql_query($sql); $sql=select Poll_Name from poll where
poll_id=’$poll_id’; @$result = mysql_query($sql);
$title=mysql_fetch_row($result); echo p ; echo $title[0]; echo /p;
echo br; $sql=select Pollsele_Name,pollsele_num from pollsele where
pollsele_del=’0′ and pollsele_poll_id=’$poll_id’; @$result =
mysql_query($sql); echo table bgcolor=aabbcc style=’border:1px solid
rgb(0,0,0)’; while($myrow=mysql_fetch_row($result)) {echo tr; echo td
width=150 bgcolor=99aabb style=’border:1px solid rgb(255,255,255)’; echo
$myrow[0];echo /tdtd width=50 bgcolor=99aabb style=’border:1px solid
rgb(255,255,255)’;echo $myrow[1]; echo /td/tr;} echo /table;} else
{echo font color=red你不能投空票!!!/font;} ?

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

Leave a Reply

网站地图xml地图