模仿OSO的論壇(四)
更新時(shí)間:2006年10月09日 00:00:00 作者:
reply.php(用來(lái)回復(fù)主題)
<HTML><HEAD><TITLE>疑難問(wèn)題</TITLE>
<LINK href="mypic/style.css" rel=STYLESHEET type=text/css></HEAD>
<?php
if (!$cook_user)
{echo "<script language='javascript'>";
echo "parent.location.href='index.php'";
echo "</script>";}
else {include ("connect.inc.php");
$query = "select * from my_user where user='".$cook_user."' and password='".$cook_password."'";
$res = mysql_query($query);
if (!$res)
{echo "<script language='javascript'>";
echo "parent.location.href='index.php'";
echo "</script>";}
include "connect.inc.php";
if ($content) {$content= str_replace ( "'","mysinglequotes",$content);
$content=htmlspecialchars($content);
$content=nl2br($content);
$query = "INSERT INTO guestbook (name,type,content,icon,time_open,time_close,answer_count,answer_name,main_id) VALUES ('".$cook_user."',0,'".$content."',".$icon.",now(),now(),1,'".$cook_user."',".$theme_id.")";
$res = mysql_query($query);
if ($res)
{$query = "update guestbook set time_close=now(),answer_count=answer_count+1,answer_name='".$cook_user."' where id=".$theme_id;
$res = mysql_query($query);
if ($res)
{echo "<script language='javascript'>";
echo "parent.location.href='post_end.php'";
echo "</script>";}}}}
?>
<SCRIPT language=JavaScript>
<!--
var submitcount=0;
function check_com(){
if(document.form.theme.value.length ==0){
submitcount--;
alert("主題不能為空!nYou must supply a subject.");
return false;
}
if(document.form.content.value.length == 0){
submitcount--;
alert("加貼內(nèi)容不能為空!nYou must supply a message.");
return false;
}
return true;
}
//-->
</SCRIPT>
<BODY bgColor=#cccc99 bottomMargin=0 leftMargin=0 topMargin=0 marginwidth="0" marginheight="0">
<form method="post" action="reply.php" name="form" onSubmit="return check_com()">
<SCRIPT language=JavaScript
src="mypic/x.js"></SCRIPT>
<TR>
<TD vAlign=top>
<TABLE align=center border=0 cellPadding=4 cellSpacing=0 width=100%>
<TBODY>
<TR>
<TD class=mid width=20%>回復(fù)主題<BR><BR></TD>
<TD class=mid><A class=title
href="read.php?theme_id=<?php echo $theme_id ?>">
<?php
$query = "select theme from guestbook where id=".$theme_id;
$res = mysql_query($query);
$row = mysql_fetch_row($res);
echo $row[0];
?>
</A><BR><BR></TD></TR>
<TR>
<TD class=mid vAlign=top>表情圖標(biāo)</TD>
<TD><INPUT CHECKED name=icon type=radio value=1> <IMG
align=ABSCENTER height=18
src="mypic/icon1.gif"
width=18><INPUT name=icon type=radio value=2> <IMG
align=ABSCENTER height=18
src="mypic/icon2.gif"
width=18><INPUT name=icon type=radio value=3> <IMG
align=ABSCENTER height=18
src="mypic/icon3.gif"
width=18><INPUT name=icon type=radio value=4> <IMG
align=ABSCENTER height=18
src="mypic/icon4.gif"
width=18><INPUT name=icon type=radio value=5> <IMG
align=ABSCENTER height=18
src="mypic/icon5.gif"
width=18><INPUT name=icon type=radio value=6> <IMG
align=ABSCENTER height=18
src="mypic/icon6.gif"
width=18><INPUT name=icon type=radio value=7> <IMG
align=ABSCENTER height=18
src="mypic/icon7.gif"
width=18><BR><INPUT name=icon type=radio value=8> <IMG
align=ABSCENTER height=18
src="mypic/icon8.gif"
width=18><INPUT name=icon type=radio value=9> <IMG
align=ABSCENTER height=18
src="mypic/icon9.gif"
width=18><INPUT name=icon type=radio value=10> <IMG
align=ABSCENTER height=18
src="mypic/icon10.gif"
width=18><INPUT name=icon type=radio value=11> <IMG
align=ABSCENTER height=18
src="mypic/icon11.gif"
width=18><INPUT name=icon type=radio value=12> <IMG
align=ABSCENTER height=18
src="mypic/icon12.gif"
width=18><INPUT name=icon type=radio value=13> <IMG
align=ABSCENTER height=18
src="mypic/icon13.gif"
width=18><INPUT name=icon type=radio value=14> <IMG
align=ABSCENTER height=18
src="mypic/icon14.gif"
width=18></TD></TR>
<TR>
<TD class=mid vAlign=top><input type="hidden" name="theme_id" size="12" class="stedit" value="<?php echo $theme_id ?>">
加貼內(nèi)容</TD>
<TD><TEXTAREA cols=50 name=content rows=6></TEXTAREA> </TD></TR>
<TR>
<TD> </TD>
<TD><INPUT name=submit onclick="return checkSubmit()" type=submit value=" 發(fā) 表 ">
<INPUT name=reset type=reset value=" 清 除 "> </TD></TR>
</FORM>
<TR>
<TD colSpan=2><BR><BR><FONT color=#797979>
<LI>本主題最后 5 個(gè)帖子 (按發(fā)帖時(shí)間倒序排列)</FONT></LI></TD></TR></TBODY></TABLE>
<TABLE align=center bgColor=#000000 border=0 cellPadding=4 cellSpacing=1
width=100%>
<TBODY>
<TR bgColor=#666666>
<TD width="10%"><FONT color=#ffffff>作 者</FONT></TD>
<TD width="90%"><FONT color=#ffffff>內(nèi) 容</FONT></TD></TR>
<?php
$query = "select * from guestbook where main_id=".$theme_id." or id=".$theme_id." order by time_open DESC limit 5 ";
$res = mysql_query($query);
function TdBackColor() {
static $ColorStr;
if ($ColorStr=="#ededed") {
$ColorStr="#dedede";
} else {
$ColorStr="#ededed";
}
return($ColorStr);
}
for ($i=1;$i<=5;$i++)
{$row = @mysql_fetch_array($res);
if (!$row) break;
$ColorStr=TdBackColor();
echo "<TR bgColor=".$ColorStr.">";
echo "<TD vAlign=top>".$row['name']."</td>";
$content= str_replace ( "mysinglequotes","'",$row['content']);
echo "<td>".$content."</td></tr>";
}
?>
</TBODY></TABLE>
</TBODY></TABLE>
</FORM>
</html>
【本文版權(quán)歸作者與奧索網(wǎng)共同擁有,如需轉(zhuǎn)載,請(qǐng)注明作者及出處】
<HTML><HEAD><TITLE>疑難問(wèn)題</TITLE>
<LINK href="mypic/style.css" rel=STYLESHEET type=text/css></HEAD>
<?php
if (!$cook_user)
{echo "<script language='javascript'>";
echo "parent.location.href='index.php'";
echo "</script>";}
else {include ("connect.inc.php");
$query = "select * from my_user where user='".$cook_user."' and password='".$cook_password."'";
$res = mysql_query($query);
if (!$res)
{echo "<script language='javascript'>";
echo "parent.location.href='index.php'";
echo "</script>";}
include "connect.inc.php";
if ($content) {$content= str_replace ( "'","mysinglequotes",$content);
$content=htmlspecialchars($content);
$content=nl2br($content);
$query = "INSERT INTO guestbook (name,type,content,icon,time_open,time_close,answer_count,answer_name,main_id) VALUES ('".$cook_user."',0,'".$content."',".$icon.",now(),now(),1,'".$cook_user."',".$theme_id.")";
$res = mysql_query($query);
if ($res)
{$query = "update guestbook set time_close=now(),answer_count=answer_count+1,answer_name='".$cook_user."' where id=".$theme_id;
$res = mysql_query($query);
if ($res)
{echo "<script language='javascript'>";
echo "parent.location.href='post_end.php'";
echo "</script>";}}}}
?>
<SCRIPT language=JavaScript>
<!--
var submitcount=0;
function check_com(){
if(document.form.theme.value.length ==0){
submitcount--;
alert("主題不能為空!nYou must supply a subject.");
return false;
}
if(document.form.content.value.length == 0){
submitcount--;
alert("加貼內(nèi)容不能為空!nYou must supply a message.");
return false;
}
return true;
}
//-->
</SCRIPT>
<BODY bgColor=#cccc99 bottomMargin=0 leftMargin=0 topMargin=0 marginwidth="0" marginheight="0">
<form method="post" action="reply.php" name="form" onSubmit="return check_com()">
<SCRIPT language=JavaScript
src="mypic/x.js"></SCRIPT>
<TR>
<TD vAlign=top>
<TABLE align=center border=0 cellPadding=4 cellSpacing=0 width=100%>
<TBODY>
<TR>
<TD class=mid width=20%>回復(fù)主題<BR><BR></TD>
<TD class=mid><A class=title
href="read.php?theme_id=<?php echo $theme_id ?>">
<?php
$query = "select theme from guestbook where id=".$theme_id;
$res = mysql_query($query);
$row = mysql_fetch_row($res);
echo $row[0];
?>
</A><BR><BR></TD></TR>
<TR>
<TD class=mid vAlign=top>表情圖標(biāo)</TD>
<TD><INPUT CHECKED name=icon type=radio value=1> <IMG
align=ABSCENTER height=18
src="mypic/icon1.gif"
width=18><INPUT name=icon type=radio value=2> <IMG
align=ABSCENTER height=18
src="mypic/icon2.gif"
width=18><INPUT name=icon type=radio value=3> <IMG
align=ABSCENTER height=18
src="mypic/icon3.gif"
width=18><INPUT name=icon type=radio value=4> <IMG
align=ABSCENTER height=18
src="mypic/icon4.gif"
width=18><INPUT name=icon type=radio value=5> <IMG
align=ABSCENTER height=18
src="mypic/icon5.gif"
width=18><INPUT name=icon type=radio value=6> <IMG
align=ABSCENTER height=18
src="mypic/icon6.gif"
width=18><INPUT name=icon type=radio value=7> <IMG
align=ABSCENTER height=18
src="mypic/icon7.gif"
width=18><BR><INPUT name=icon type=radio value=8> <IMG
align=ABSCENTER height=18
src="mypic/icon8.gif"
width=18><INPUT name=icon type=radio value=9> <IMG
align=ABSCENTER height=18
src="mypic/icon9.gif"
width=18><INPUT name=icon type=radio value=10> <IMG
align=ABSCENTER height=18
src="mypic/icon10.gif"
width=18><INPUT name=icon type=radio value=11> <IMG
align=ABSCENTER height=18
src="mypic/icon11.gif"
width=18><INPUT name=icon type=radio value=12> <IMG
align=ABSCENTER height=18
src="mypic/icon12.gif"
width=18><INPUT name=icon type=radio value=13> <IMG
align=ABSCENTER height=18
src="mypic/icon13.gif"
width=18><INPUT name=icon type=radio value=14> <IMG
align=ABSCENTER height=18
src="mypic/icon14.gif"
width=18></TD></TR>
<TR>
<TD class=mid vAlign=top><input type="hidden" name="theme_id" size="12" class="stedit" value="<?php echo $theme_id ?>">
加貼內(nèi)容</TD>
<TD><TEXTAREA cols=50 name=content rows=6></TEXTAREA> </TD></TR>
<TR>
<TD> </TD>
<TD><INPUT name=submit onclick="return checkSubmit()" type=submit value=" 發(fā) 表 ">
<INPUT name=reset type=reset value=" 清 除 "> </TD></TR>
</FORM>
<TR>
<TD colSpan=2><BR><BR><FONT color=#797979>
<LI>本主題最后 5 個(gè)帖子 (按發(fā)帖時(shí)間倒序排列)</FONT></LI></TD></TR></TBODY></TABLE>
<TABLE align=center bgColor=#000000 border=0 cellPadding=4 cellSpacing=1
width=100%>
<TBODY>
<TR bgColor=#666666>
<TD width="10%"><FONT color=#ffffff>作 者</FONT></TD>
<TD width="90%"><FONT color=#ffffff>內(nèi) 容</FONT></TD></TR>
<?php
$query = "select * from guestbook where main_id=".$theme_id." or id=".$theme_id." order by time_open DESC limit 5 ";
$res = mysql_query($query);
function TdBackColor() {
static $ColorStr;
if ($ColorStr=="#ededed") {
$ColorStr="#dedede";
} else {
$ColorStr="#ededed";
}
return($ColorStr);
}
for ($i=1;$i<=5;$i++)
{$row = @mysql_fetch_array($res);
if (!$row) break;
$ColorStr=TdBackColor();
echo "<TR bgColor=".$ColorStr.">";
echo "<TD vAlign=top>".$row['name']."</td>";
$content= str_replace ( "mysinglequotes","'",$row['content']);
echo "<td>".$content."</td></tr>";
}
?>
</TBODY></TABLE>
</TBODY></TABLE>
</FORM>
</html>
【本文版權(quán)歸作者與奧索網(wǎng)共同擁有,如需轉(zhuǎn)載,請(qǐng)注明作者及出處】
相關(guān)文章
整合了前面的PHP數(shù)據(jù)庫(kù)連接類~~做成一個(gè)分頁(yè)類!
整合了前面的PHP數(shù)據(jù)庫(kù)連接類~~做成一個(gè)分頁(yè)類!...2006-11-11壞狼php學(xué)習(xí) 計(jì)數(shù)器實(shí)例代碼
首先進(jìn)入phpmyadmin建立1個(gè)數(shù)據(jù)庫(kù)命名為db,然后建立幾個(gè)表.name是用戶badwolf的訪問(wèn)記數(shù),IP是存來(lái)訪IP,new是存數(shù).2008-06-06