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

###############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测试数据/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://HdhCmsTestmacromedia测试数据/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测试数据/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://HdhCmsTestmacromedia测试数据/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> 发表时间： <? echo $data[time];?> 阅读次数： <? 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>对不起！本文已经被管理员锁定！"; } 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">   您的电子邮件: <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>  ".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";?>

声明：本文来自网络，不代表【好得很程序员自学网】立场，转载请注明出处：http://haodehen.cn/did3515

更新时间：2022-09-12 阅读：50次