php做的新闻系统——仅供初学者参考

<?php error_reporting(0); ini_set('html_errors',false); ini_set('display_errors',false); ?> <?php session_start(); $dlzhanghao=$_SESSION['zhanghao']; $quanxian=$_SESSION['quanxian']; $biaoti="首页"; require('../inc/head.php'); require('../inc/dbconnect.php'); mysql_query("set names gb2312"); $xiaoye=4; $daye=8; $meiyeshu=$_GET["meiyeshu"]; if($meiyeshu=="") {$meiyeshu=$xiaoye;} $dangqianye=$_GET["dangqianye"]; $sql="SELECT * FROM xinwen ORDER BY `xinwen`.`shijian` DESC"; $result=mysql_query($sql); $total=mysql_num_rows($result); $yemax=ceil($total/$meiyeshu); if($dangqianye>=$yemax) $dangqianye=$yemax; if($dangqianye<=1) $dangqianye=1; $xianshid="当前第<font color='#FF0000'>".$dangqianye."</font>页"; $xianshig="共有<font color='#FF0000'>".$yemax."</font>页"; if($dangqianye!=1) { $msg.="<a href=".$_SERVER['PHP_SELF']."?dangqianye=1&meiyeshu=".$meiyeshu.">第一页</a>"; $msg.="<a href=".$_SERVER['PHP_SELF']."?dangqianye=".($dangqianye-1)."&meiyeshu=".$meiyeshu.">上一页</a>"; } if($dangqianye!=$yemax) { $msg.="<a href=".$_SERVER['PHP_SELF']."?dangqianye=".($dangqianye+1)."&meiyeshu=".$meiyeshu.">下一页</a>"; $msg.="<a href=".$_SERVER['PHP_SELF']."?dangqianye=".$yemax."&meiyeshu=".$meiyeshu.">最后一页</a>"; } $n=1; while($row=mysql_fetch_array($result)) { $xinwen[$n]=$row['xwid']; $n++; } ?> <br> <table align="center"> <tr align="center"> <td align="center" width="100">序号</td> <td align="center" width="300">标题</td> <td align="center" width="100">作者</td> <td align="center" width="100">时间</td> </tr> <?php $kye=($dangqianye-1)*$meiyeshu+1; $jye=$kye+$meiyeshu; for($n=$kye;$n<=$jye && $n<=$total;$n++) { $sql2="SELECT * FROM xinwen WHERE xwid='".$xinwen[$n]."'"; $result2=mysql_query($sql2); $xinwen2=mysql_fetch_array($result2); $xwzhuangtai=$xinwen2['zhuangtai']; $xwid=$xinwen2['xwid']; $xwbiaoti=$xinwen2['biaoti']; $xwzuozhe=$xinwen2['zuozhe']; $xwtime=$xinwen2['shijian']; $sqlxw="SELECT * FROM renyuan WHERE zhanghao='".$xwzuozhe."'"; $resultxw=mysql_query($sqlxw); $rowxw=mysql_fetch_array($resultxw); $zuozhename=$rowxw['xingming']; if($dlzhanghao=="") { if($xwzhuangtai=="y") { if($n%2==0) {echo "<tr align='center' bgcolor='#CC0000'>";} else{echo "<tr align='center'>";} echo " <td>".$n."</td> <td ><a href='xwlist.php?xwid=".$xwid."'>".$xwbiaoti."</a></td> <td>".$zuozhename."</td> <td>".$xwtime."</td></tr> "; } } else { if($n%2==0) {echo "<tr align='center' bgcolor='#CC0000'>";} else{echo "<tr align='center'>";} echo " <td>".$n."</td> <td><a href='xwlist.php?xwid=".$xwid."'>".$xwbiaoti."</a></td> <td>".$zuozhename."</td> <td>".$xwtime."</td>"; if($quanxian<=2) { echo "<td><a href='xwbianji.php?xwid=".$xwid."'>编辑</td>"; echo "<td><a href='xwsc.php?xwid=".$xwid."'>删除</td></tr>"; } else { if($dlzhanghao==$xwzuozhe) { echo "<td><a href='xwbianji.php?xwid=".$xwid."'>编辑</td>"; echo "<td><a href='xwsc.php?xwid=".$xwid."'>删除</td></tr>"; } } } } if($meiyeshu==$daye) { ?> <form method="get"> <tr> <td> <?php echo $xianshid; ?> </td> <td><?php echo $xianshig;?></td> <td> <?php echo $msg;?> </td> <td> <input name="meiyeshu" type="hidden" value="<?php echo $meiyeshu;?>" /> <input name="dangqianye" type="text" size="4"> <input type="submit" value="跳转到"> </td> </form> <?php } if($meiyeshu==$xiaoye) { echo "</tr><tr><td><a href=".$_SERVER['PHP_SELF']."?meiyeshu=".$daye.">更多</td></tr>"; } if($meiyeshu==$daye) { echo "<td align='right'><a href=".$_SERVER['PHP_SELF']."?meiyeshu=".$xiaoye."&dangqianye=1>收起</a></td>"; } ?> </tr> </table> <?php require('../inc/end.php'); ?>