conn.php文件:
<!--该页面用于连接数据库的公用文件.....-->
<?php
//连接数据库
$conn=mysql_connect("localhost","root","") or die("数据库连接失败");
mysql_select_db("cql",$conn) or die("数据库选择失败,请检测是否存在该数据....");
mysql_query('set names utf8');
?>
index.php文件:
<?php
session_start();
include"conn.php";
//<!--网站主页面index.php.....-->
//检测是否登录
if($_SESSION['user_name']==""||$_SESSION['user_id']=="")
{
echo "<script>alert('您未登录,请登录!');location.href='login.php';</script>";
}
//点击退出
if($_GET[out])
{
unset($_SESSION[user_name]);
unset($_SESSION[user_id]);
echo "<script>window.close();</script>";
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<script language="javascript">
var ajax=false;
try {
ajax = new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
try {
ajax = new ActiveXObject("Microsoft.XMLHTTP");
} catch (E) {
ajax = false;
}
}
if (!ajax && typeof XMLHttpRequest!='undefined') {
ajax = new XMLHttpRequest();
}
function getnews(newsID)
{
if (typeof(newsID) == 'undefined')
{
return false;
}
var url = "show.php?id="+ newsID;
var show = document.getElementById("show_news");
//alert(show);
ajax.open("GET", url, true);
ajax.onreadystatechange = function() {
if (ajax.readyState == 4 && ajax.status == 200) {
show.innerHTML = ajax.responseText;
//alert(ajax.responseText);
}
}
ajax.send(null);
}
</script>
</head>
<body>
欢迎您!<a href="show_user.php?id=<?php echo $_SESSION[user_id]?>">查看我的信息</a>
<?php
$query=mysql_query("select * from `zf`");
$num=mysql_num_rows($query);
if($num==0)
{
echo "<center><font size=\"+2\">对不起,没有相关内容......</font></center>";
}else{
?>
<TABLE cellSpacing=1 cellPadding=3 width="99%" bgColor=#6298e1 border=0>
<TBODY>
<TR>
<TD noWrap background=Admin_Poli.files/th_bg.gif height=25><FONT
color=#ffffff><STRONG><font size="+0">当前页面</font></STRONG></FONT>
</TD></TR>
<TR>
<TD noWrap align=middle bgColor=#ebf2f9 height=30>
<TABLE cellSpacing=0 width="99%" border=0>
<TBODY>
<TR>
</TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=1 cellPadding=0 width="99%" border=0>
<TBODY>
<TR>
<TD height=30></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=1 cellPadding=3 width="99%" bgColor=#6298e1 border=0>
<FORM name=formDel action=?Result=Photo method=post>
<TBODY>
<TR>
<TD width="5%"
height=25 align=middle noWrap background=Admin_Poli.files/th_bg.gif><FONT color=#ffffff><STRONG>序号</STRONG></FONT></TD>
<TD width="5%"
height=25 align=middle noWrap background=Admin_Poli.files/th_bg.gif><FONT color=#ffffff><STRONG>ID号</STRONG></FONT></TD>
<TD width="10%" align=middle noWrap background=Admin_Poli.files/th_bg.gif><FONT
color=#ffffff><STRONG>标题</STRONG></FONT></TD>
<TD width="19%" align=middle noWrap background=Admin_Poli.files/th_bg.gif><FONT
color=#ffffff><STRONG>内容</STRONG></FONT></TD>
<TD width="5%" align=middle noWrap
background=Admin_Poli.files/th_bg.gif><strong><font color="#ffffff">上传者</font></strong></TD>
<TD width="7%" align=middle noWrap
background=Admin_Poli.files/th_bg.gif><STRONG><FONT
color=#ffffff>发布时间</FONT></STRONG></TD>
<TD width="5%" align=middle noWrap
background=Admin_Poli.files/th_bg.gif><STRONG><FONT
color=#ffffff>来源</FONT></STRONG></TD>
<TD width="4%" align=middle noWrap
background=Admin_Poli.files/th_bg.gif><STRONG><FONT
color=#ffffff>点击量</FONT></STRONG></TD>
<TD width="5%" align=middle noWrap
background=Admin_Poli.files/th_bg.gif><STRONG><FONT
color=#ffffff>评论量</FONT></STRONG></TD>
<TD width="4%" align=middle noWrap
background=Admin_Poli.files/th_bg.gif><STRONG><FONT
color=#ffffff>分类</FONT></STRONG></TD>
</TR>
<?php
$each_page=8;
if($_GET[page]==null){
$page=1;
}else{
$page=$_GET[page];
}
$all_page=ceil($num/$each_page);
$pagestar=($page-1)*$each_page;
$sq=mysql_query("SELECT * FROM `zf` ORDER BY `zf_uptime` DESC LIMIT $pagestar , $each_page");
while($arr=mysql_fetch_array($sq))
{
?>
<TR onMouseOver="this.style.backgroundColor = '#FFFFFF'" style="CURSOR: hand"
οnmοuseοut="this.style.backgroundColor = ''" bgColor=#ebf2f9>
<TD noWrap align=middle height=24>161</TD>
<TD noWrap align=middle height=24><?php echo $arr[zf_id]?></TD>
<TD noWrap><A href="#" οnclick="getnews(<?php echo $arr[zf_id]?>)">
<?php echo $arr[zf_title]?></A></TD>
<TD noWrap align=middle><?php //echo cut_str($arr[zf_content],20,0)."..." ?></TD>
<TD noWrap align=middle><?php echo $arr[zf_upname]?></TD>
<TD noWrap align=middle><?php echo $arr[zf_uptime]?></TD>
<TD noWrap align=middle><?php echo $arr[zf_resource]?></TD>
<TD noWrap align=middle><?php echo $arr[zf_djtimes]?></TD>
<TD noWrap align=middle><?php echo $arr[zf_pltimes]?></TD>
<TD noWrap align=middle><?php echo $arr[zf_type]?></TD>
</TR>
<?php }?>
<TR>
<TD noWrap bgColor=#d7e4f7 colSpan=13>
<TABLE cellSpacing=0 cellPadding=0 width="100%" align=center border=0>
<TBODY>
<TR>
<TD>共计:<FONT color=#ff6600><?php echo $num?></FONT>条记录 页次:<FONT
color=#ff6600><?php echo $page?></FONT></STRONG>/<?php echo $all_page?> 每页:<FONT
color=#ff6600>8</FONT>条
<?php
echo "当前页:".$page;
if($page<=1);
else
echo "<a href=\"?page=".($page-1)."\" >上一页</a>";
if($page>=$all_page);
else
echo "<a href=\"?page=".($page+1)."\" >下一页</a>";
/*echo "<input type=\"button\" value=\"首页\" οnclick=\"location.href='?page=1&type=".$_GET['type']."'\" /> ";
*/ /*echo "<input type=\"button\" value=\"尾页\" οnclick=\"location.href='?page=".($all_page)."&type=".$_GET['type']."'\" /> ";*/
?>
</TD>
</TR></TBODY></TABLE></TD></TR></FORM></TBODY></TABLE>
<?php
}
?>
<div id="show_news"></div>
</body>
</html>
show.php文件:
<?php
include"conn.php";
echo "SELECT * FROM `zf` where `zf_id`=$_GET[id]";
$sq=mysql_query("SELECT * FROM `zf` where `zf_id`=$_GET[id]");
while($arr=mysql_fetch_array($sq))
{
echo "<br><font color=\"#00CCFF\">标题:".$arr[zf_id]."</font><br>";
echo "作者:".$arr[zf_upname]."<br>";
echo "内容:".$arr[zf_content]."<br>";
}
?>