文章詳情頁

PHP+MYSQL的文章管理系統(tǒng)(二)

瀏覽：2日期：2024-01-07 17:57:29

###############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"> </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>  </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> </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> 發(fā)表時間： ;;;;<? echo $data[time];?> ;;;;閱讀次數(shù)： ;;;;<? echo $data[hits];?> ;;</TD> ;;<TD>  </TD> </TR> </TBODY> ;;;;;;</TABLE> ;;;;</TD></TR> ;;;;<TR vAlign=top> ;;;;<TD class=tenpt> <? if($data[locked]<>0) { ;;echo "<img src=images/lock.gif>對不起！本文已經(jīng)被管理員鎖定！"} 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>發(fā)表評論</DIV> ;;;;</th> ;;</TR> ;;<tr> ;;;;<td> <form name="form1" method="post" action="ping.php" onsubmit="return go()"> 您的姓名: <input type="text" name="name" class="border"> ;;;;;;;  您的電子郵件: <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> 發(fā)表評論: <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>  ".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

上一條：PHP+MYSQL的文章管理系統(tǒng)(一) 下一條：一段php加密解密的代碼

排行榜

					
					JavaScript實現(xiàn)通訊錄功能
Docker容器如何更新打包并上傳到阿里云
JetBrains IntelliJ IDEA 配置優(yōu)化技巧
Django Model層F，Q對象和聚合函數(shù)原理解析
ASP.NET MVC使用Session會話保持表單狀態(tài)
詳解瀏覽器的緩存機制
Django結合使用Scrapy爬取數(shù)據(jù)入庫的方法示例
asp中response.write("中文")或者js中文亂碼問題
.NET 中配置從xml轉向json方法示例詳解
告別AJAX實現(xiàn)無刷新提交表單
Python實現(xiàn)PS濾鏡中的USM銳化效果
				