欢迎光临
我们一直在努力

PHP+MYSQL的文章管理系统(二)-PHP教程,PHP应用

建站超值云服务器,限时71元/月

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

赞(0)
版权申明:本站文章部分自网络,如有侵权,请联系:west999com@outlook.com 特别注意:本站所有转载文章言论不代表本站观点! 本站所提供的图片等素材,版权归原作者所有,如需使用,请与原作者联系。未经允许不得转载:IDC资讯中心 » PHP+MYSQL的文章管理系统(二)-PHP教程,PHP应用
分享到: 更多 (0)

相关推荐

  • 暂无文章