电脑技术学习

PHP+MYSQL的文章管理系统(二) 

dn001 47 0
###############index.php######################
<?session_start();
require"./inc/func.php"
mscon();
require "./inc/header.inc"
?>
<script language="javascript">
function opwin(filename)
{window.open("read_article.php?id="+filename,"","height=500,width=585,resizable=no,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no");
}

</script>
</head>
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0">
<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#003399" height="23">
;;<tr>
;;;;<td width="80">
;;;;;;<div id="Layer2" style="position:absolute; left:7px; top:17px; width:43px; height:44px; z-index:2"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="80" height="60">
;;<param name=movie value="images/logo.swf">
;;<param name=quality value=high>
;;<param name="wmode" value="transparent">
;;<embed src="images/logo.swf" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="80" height="60" wmode="transparent">
;;</embed>
</object></div>
;;;;;;<div id="Layer1" style="position:absolute; left:-5px; top:61px; width:49px; height:37px; z-index:1"><img src="images/11.gif" width="58" height="55"></div>
;;;;</td>
;;;;<td width="539"> <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="468" height="60">
;;<param name=movie value="images/ti1.swf">
;;<param name=quality value=high>
;;<param name="wmode" value="transparent">
;;<embed src="images/ti1.swf" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="468" height="60" wmode="transparent">
;;</embed>

;;;;;;</object> </td>
;;</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
;;<tr>
;;;;<td background="images/211.gif" height="2">&nbsp;</td>
;;</tr>
</table>
<table><FORM name=form1 action=search.php;;method=post target=_blank>
;;<table width="80%" border="0" cellspacing="0" cellpadding="0" bgcolor="#009933" align="center">
;;;;<tr>
;;;;<td align="center">
;;;;<input type="text" name="key">
;;<select name="type">
;;<option value=>全部类别</option>
<? $typ=file("list.txt");
$num=count($typ);
for($i=2;$i<=$num;$i++)
{
;;echo"<option value=$typ[$i]>$typ[$i]</option>";}
;;;;;;?>
;;</select>
;;<select name="whe">
;;<option value=>全部内容</option>
;;<option value=1>文章内容</option>
;;<option value=2>文章标题</option>
;;<option value=3>加入时间</option>
;;</select>
;;<input type="hidden" name="submit" value="1">
;;<input type="submit" name="submit" value="提交查询">
;;</td>
;;</tr>
</table>
</FORM></table>
<?
$type=trim($type);
;;if($comm)
;;;;{
;;;;;$sec="and comm=1"
;;;;;$fir="where comm=1"
;;;;}
;;if(!empty($type))
;;;;$query="select count(*) from $table where type='$type' $sec"
;;else
;;;;$query="select count(*) from $table $fir"
;;$res=mysql_db_query("$database",$query);
;;if(@mysql_num_rows($res)>0)
;;;;$tot=mysql_fetch_array($res);
;;$total=$tot[0];
;;$total_page=ceil($total/$pagenum);
;;echo "<table width="80%" border="0" cellspacing="0" cellpadding="0" align=center>"
;;echo "<tr><td>共:".$total."篇".$total_page."页</td></tr>"
;;if(empty($page))
;;;;$page=0;
;;if(empty($offset))
;;;;$offset=0;
;;$offset=$pagenum*$page;
;;if(!empty($type))
;;;;;$query="select * from $table where type='$type' $sec order by id desc limit $offset,$pagenum"
;;else
;;;;$query="select * from $table $fir order by id desc limit $offset,$pagenum"
;;$res=mysql_db_query("$database",$query);
;;if(@mysql_num_rows($res)>0)
;;;;;while($topic=mysql_fetch_array($res))
;;;;;;;{
;if(strlen($topic[title])>40)
;;{
;;;;$topic[title]=substr($topic[title],0,40) ;
;;;;$topic[title]=$topic[title]."....."
;;}
;if(trim($topic[time])==date(Y年m月d日))
;;;$topic[time]="<font color=#FF9900>$topic[time]</font>"
;;;echo" <tr><td>[$topic[type]]<a href=# onClick="opwin($topic[id])";>$topic[title]</a><font size=1>($topic[time])</font>"
if($topic[comm]==1)
;;echo "<img src="./images/comm.gif" alt="精品文章">"
if($topic[locked]==1)
;;echo "<img src="./images/locked.gif" alt="文章已锁定">"
echo "</td>
;;<td>阅读：$topic[hits] 次;评论：$topic[p_num]次</td>
;;</tr>"
;;;;;}
else
;;;echo " 对不起,本栏 目暂没有任何文章!!!"
echo "</table>"
;;?>

<br>
<table width="80%" border="0" cellspacing="0" cellpadding="0" align="center">
;;<tr>
;;;;<td>
;;<?
;;;;;$pre=$page-1;
;;;;;$next=$page+1;
if($page>0)
;;;echo "<a href="$php_self?page=$pre&type=$type">上一页</a><br><br>"
else
;;echo "上一页<br><br>";;;?></td>
;;;;<td><?if($page<$total_page-1)
;;;echo ";;;<a href="$php_self?page=$next&type=$type">下一页</a><br><br>"
else echo ";;;下一页<br><br>";?></td>
;;;;<td>
<form> 跳转到:
<select name="page" onchange="top.location='<? echo $php_self;?>?page='+document.forms[1].elements[0].value+'&type=<?echo $type;?>';" class="border">
;;<?
;;for($i=0;$i<$total_page;$i++)
;;;;{
;;;;;$p=$i+1;
;;;;;echo "<option value=$i"
;;;;;if($page==$i) echo " selected" ;
;;;;;echo ">第".$p."页</option>n"
;;;;;}
?>
</select> </form>
</td>
<td>
<form >选择栏目:
<select name="type";;onchange="top.location='<? echo $php_self;?>?type='+document.forms[2].elements[0].value<?if($comm) echo"+'&comm=1'";?>;" >
;;<? $typ=file("list.txt");
$num=count($typ);
for($i=0;$i<$num;$i++)
{
;;echo"<option value=$typ[$i] "if(trim($typ[$i])==$type) {;;echo ";;selected"} echo ">$typ[$i]</option>";}
;;;;;;?>
</select>
;;;;</form>
</td><td><form method="post" action=<? echo $PHP_SELF;?>?type=<?echo $type;?> target="_balnk"><input type="submit" name="comm" value="精品文章" class=border></form></td>
</tr>
</table>
<?require "./inc/footer.inc";?>
#####################read_article.php#########################
<?
require"./inc/func.php"
if(!$id)
{
;;echo"<script>window.close();</script>"
;;;exit();
}
mscon();
$query="select * from $table where id='$id'"
$res=mysql_db_query("$database",$query);
if(!$res)
;;{
;;;;echo "this article has been deleted or no this article!!"
;;;;exit();
;;}
$data=mysql_fetch_array($res);
add_hits($data[id]);
$pre=$data[id]-1;
$next=$data[id]+1;
?>
<HTML>
<HEAD>
<TITLE>
<?;;;echo "$data[title]--[$data[type]]";?>
</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<style type=text/css>
<!--
body,table,td,input,textarea {;;font-family: "宋体"font-size: 9pt}
select {;;font-family: "宋体"font-size: 9pt}
code {font-family: "Courier" ; font-size: 10pt}
a {;;color: #005500}
a:hover {;;color: #CC0000}
.border {border: 1px #000000 solid; background-color:transparent; list-style-position: inside; list-style-type: square}
-->
</style>
<script language="javascript">
function name()
{
;;var theResult = true;
;;var elem4 = null;

;;if (document.forms[0].elements[0].value == "" || document.forms[0].elements[0].value == "undefined" || document.forms[0].elements[0].value == "null")
;;{
;;;;elem4 = prompt("请输入您的姓名：","");
;;;;theResult = false;
;;;;document.forms[0].elements[0].value = elem4;
;;}
;;return theResult;
}
function mail()
{
;;var theResult = true;
;;var elem1 = null
;;if ((document.forms[0].elements[1].value.indexOf('@') == -1 || document.forms[0].elements[1].value == "" || document.forms[0].elements[1].value.indexOf('.') == -1))
;;{
;;;;elem1 = prompt("请输入您的正确的电子邮件地址。谢谢！！","");
;;;;theResult = false;
;;;;document.forms[0].elements[1].value = elem1;
;;}
;;return theResult;
}
function go()
{
var theResult=true;
theResult = name()&&mail();
return theResult;
}
</script>
</HEAD>
<BODY text=#000000 bgColor=#ffffff>
<TABLE borderColor=#339933 cellSpacing=0 borderColorDark=#ffffff
cellPadding=0 align=center borderColorLight=#000000 border=1 width=545>
;;<TBODY>
;;<TR vAlign=center bgColor=#009900>
;;;;<TD background=images/third-back3.gif>
;;;;;;<TABLE cellSpacing=0 cellPadding=0 width=100% border=0>
<TBODY>
<TR>
;;<TD width=17>&nbsp;</TD>
;;<TD width=590>
;;;;<TABLE width="36%" align=center border=0>
;;;;;;<TBODY>
;;;;;;<TR>
<TD bgcolor="#009900">
;;<DIV align=center><FONT face="Verdana, Arial, Helvetica, sans-serif" color=#ffffff><b>
;;;;<? echo $data[title];?>
;;;;</b></FONT></DIV>
</TD></TR></TBODY></TABLE></TD>
;;<TD width=19>
;;;;<DIV align=center><A href="javascript:window.close()"><IMG height=17
;;;;src="images/third-close.gif" width=17 align=absMiddle
;;;;border=0 name=content_r03_c28></A></DIV>
;;</TD></TR></TBODY></TABLE></TD></TR>
;;<TR vAlign=center align=left bgColor=#cccccc>
;;;;<TD>
;;;;;;<TABLE cellSpacing=0 cellPadding=0 border=0 align="center" width="100%">
<TBODY>
<TR>
;;<TD>
;;;;<DIV align=left><A class=whitetxt
;;;;href="read_article.php?id=<? echo;;$pre;?>"><img src="images/prethread.gif" width="48" height="12" border="0"></A></DIV>
;;</TD>
;;<TD>
;;;;<DIV align=left><a class=whitetxt
;;;;href="read_article.php?id=<? echo $next;?>"><img src="images/nextthread.gif" width="48" height="12" border="0"></a></DIV>
;;</TD>
;;<TD><IMG
;;;;height=16 src="images/mail.gif" width=16></TD>
;;<TD class=myfont><A class=redtxt
;;;;href="commend.php?id=<? echo "$data[id]&title=$data[title]";?>">推荐给朋友</A></TD>
;;<TD> 发表时间：
;;;;<? echo $data[time];?>
;;;;阅读次数：
;;;;<? echo $data[hits];?>
;;</TD>
;;<TD>&nbsp; </TD>
</TR>
</TBODY>
;;;;;;</TABLE>
;;;;</TD></TR>
;;;;<TR vAlign=top>
;;;;<TD class=tenpt>
<?
if($data[locked]<>0)
{
;;echo "<img src=images/lock.gif>对不起！本文已经被管理员锁定！"
}
else
;;if($data[html]==1)
;;;;;highlight_string($data[cont]);
;;else
;;;;;echo nl2br($data[cont]);
?>
;;;;;;</TD>
;;</TR>
;;</TBODY></TABLE>
<table bordercolor=#339933 cellspacing=0 bordercolordark=#ffffff
cellpadding=0 align=center bordercolorlight=#000000 border=1 width=545>
;;<tbody>
<TR bgColor=#cccccc>
;;;;<th>
;;;;;;<DIV align=center>发表评论</DIV>
;;;;</th>
;;</TR>
;;<tr>
;;;;<td>
<form name="form1" method="post" action="ping.php" onsubmit="return go()">
您的姓名:
<input type="text" name="name" class="border">
;;;;;;;&nbsp;&nbsp;您的电子邮件:
<input type="text" name="mail" size=20 class="border">
仅站长可见:<input type="checkbox" name="pub" value="<? echo $data[title];?>">
<input type="hidden" name="p_id" value="<? echo $id;?>">
<br>
发表评论:
<textarea name="cont" rows="8" cols="85"></textarea>
<br>
<br>
<center>
;;<input type="submit" name="Submit" value="提交" class="border">
;;<input type="reset" name="Submit2" value="重写" class="border">
</center></form>
</td>
;;</tr>
;;<TR bgColor=#cccccc>
;;;;<th>
;;;;;;<DIV align=center>相关评论</DIV>
;;;;</th>
;;</TR>
;;<tr>
;;<td>
<?;;$query="select * from $ping_tab where p_id='$id' order by time desc"
;;$res=mysql_db_query("$database",$query);
;;if(mysql_num_rows($res)>0)
;;;{$i=1;
;;;while($ping=mysql_fetch_array($res))
;;;;echo "评论人:$ping[name];;;电子邮件:$ping[mail]<br>&nbsp;&nbsp;".nl2br($ping[p_cont])."<br>时间:$ping[time];;来自:$ping[ip]<hr size=1>n" ;
;;;}
;;;else
;;;echo "暂时没有本文章的相关评论!"
;;?>
;;</td>
;;</tr>
;;<tr bgcolor=#cccccc>
;;;;<td>
;;;;;;<div align=center><a
;;href="javascript:window.close()">关闭窗口</a></div>
;;;;</td>
;;</tr>
;;</tbody>
</table>
<?require "./inc/footer.inc";?>;

标签：

上一篇 消息持续发送的完整例子

下一篇 PHP+MYSQL的文章管理系统(一)  

相关文章