当前位置: 首页 > 图文教程 > 网络编程 > PHP > PHP+MYSQL的文章管理系统(二)

PHP
php 多线程上下文中安全写文件实现代码
PHP类的使用 实例代码讲解
用php实现让页面只能被百度gogole蜘蛛访问的方法
php 学习笔记
PHP编程过程中需要了解的this,self,parent的区别
php 操作excel文件的方法小结
使用PHP获取网络文件的实现代码
PHP 巧用数组降低程序的时间复杂度
php下将XML转换为数组
php 文件上传代码(限制jpg文件)
php 无极分类(递归)实现代码
PHP 采集获取指定网址的内容
PHP 将图片按创建时间进行分类存储的实现代码
PHP 存储文本换行实现方法
PHP 批量更新网页内容实现代码
用PHP查询搜索引擎排名位置的代码
用php实现的获取网页中的图片并保存到本地的代码
php实现首页链接查询 友情链接检查的代码
处理php自动反斜杠的函数代码
php实现的遍历文件夹下所有文件,编辑删除

No. « 216 217 218 219 »

技术文章搜索

关键字

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

出处:互联网   整理: 软晨网（RuanChen.com）   发布: 2009-09-13   浏览: 44 ::
收藏到网摘: n/a

###############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>
<!--
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> </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";?>