PHP+MYSQL简易新闻栏目实例
这里我的例子是利用MySQL数据库的方式制作的，代码如下：
一：发布新闻文件pub.php和pub_ok.php，代码如下：
文件pub.php:
<form name="form1" method="post" action="pub_ok.php" onsubmit="javascript:return Juge(this);" >
<table width="90%" border="0" cellspacing="1" cellpadding="1" align="center">
<tr> <td> 标题： </td></tr>
<tr> <td> <input type="text" name="title" size="80"> </td> </tr>
<tr> <td> 详细内容：</td></tr>
<tr> <td> <textarea name="detail" style="width=80%;height=160px;">>/textarea<
</td></tr>
<tr><td><input type="submit" name="pub" value="发布"></td></tr>
</table>
</form>
文件pub.php:
<?php include "common_news.php"; ?> <html> <head> <title>新闻发布</title> </head> <body bgcolor=#cccccc><?php if ($pub){ $title=htmlspecialchars($title); $detail=htmlspecialchars($detail); $detail= str_replace ( " ","<br>", $detail); $pub_time=date("Y")."-".date("m")."-".date("d")." ".date("H").":".date("i").":".date("s"); $query="insert into news (title,detail,pub_time) values "; $query.="('$title','$detail','$pub_time')"; $result=mysql_query($query,$db); echo "<div align='center'>"; if ($result){ echo "<p>发布成功！<a href='view.php?page=1'>查看</a>、<a href='pub.php'>发布</a></p>"; } else{ echo mysql_error(); echo "<p>发布失败！</p>"; } echo "</div>"; } ?> </body> </html> 说明：上面用了一个包含文件common_news.php,其中$page_size变量为一页最多显示的新闻数，其余的大家应该一看就明白。<?php $id=mysql_connect('localhost','root','cgreen'); $db=mysql_select_db('db_news',$id); $page_size=5; ?>
显示新闻条目文件：view.php
<?php include "common_news.php"; ?><html> <head> <title>新闻发布</title> <SCRIPT language=JavaScript> function view(Url) { popup=window.open(Url,"Displaywindow","left=30,top=30,width=600,height=400,toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes, resizable=no"); } </SCRIPT> </head><body bgcolor=#cccccc> <center> 新闻列表 </center> <?php if ($page){ $query="select count(*) as total from news"; $result=mysql_query($query,$db); $message_count=mysql_result($result,0,"total"); $page_count=ceil($message_count/$page_size); $offset=($page-1)*$page_size; $query="select * from news order by id desc limit $offset, $page_size"; $result=mysql_query($query,$db); if($result){ $rows=mysql_num_rows($result); $i=1; ?> <?php while($myrow=mysql_fetch_array($result)){ ?> <table width="422" border="0" cellspacing="1" cellpadding="1" align="center"> <tr> <td width="277"><li><a href="javascript:view('view_d.php?recid=<?php echo $myrow[id] ?>');"><?php echo "$myrow[title]</a>($myrow[pub_time])"; ?></td> </tr> </table> <?php $i++; if ($i<=$rows){ echo ""; } } ?> <?php $prev_page=$page-1; $next_page=$page+1; ?> <center> <?php if ($page<=1){ echo "第一页"; } else{ echo "<a href='$PATH_INFO?page=1'>第一页</a>"; } echo " "; if ($prev_page<1){ echo "上一页"; } else{ echo "<a href='$PATH_INFO?page=$prev_page'>上一页</a>"; } echo " "; if ($next_page>$page_count){ echo "下一页"; } else{ echo "<a href='$PATH_INFO?page=$next_page'>下一页</a>"; } echo " "; if ($page>=$page_count){ echo "最后一页"; } else{ echo "<a href='$PATH_INFO?page=$page_count'>最后一页</a>"; } } else{ echo "<p align='center'>现在还没有新闻!/p>"; } } ?> <p> </p> </body> </html>
浙公网安备 33010602011771号