<?php
/**
* TestGuest Version1.0
* ================================================
* Copy 2010-2012
* Web:295508987@qq.com
* ================================================
* Author: sun
* Date: 2014-2-9
*
*
*/
//做了分页模式的最简单的模式。具有具有后台的删除功能，和文件的未读功能
$_conn=mysql_connect('localhost','root','woheni1314');
mysql_select_db('luntan',$_conn);
mysql_query("SET NAMES UTF8");
//数据获取功能
$_result= mysql_query("SELECT*FROM message ORDER BY time DESC LIMIT 10");
//删除功能
if(isset($_GET['action'])){
mysql_query("DELETE FROM message WHERE id='{$_GET['action']}' LIMIT 1");
echo "<script type='text/javascript'>alert('ok');location.href='message.php';</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" />
<script type="text/javascript" ></script>
<title>短信显示</title>
</head>
<body>
<div>
<table border="1 solid black" align="center">
<?php while(!!$_rows=mysql_fetch_array($_result)) {?>
<tr>
<td><?php echo $_rows['id']?></td>
<td><?php echo $_rows['uername']?></td>
<td><a href="content.php?id=<?php echo $_rows['id']?>"><?php echo $_rows['content']?></a></td>
<td><?php echo $_rows['time']?></td>
<td><?php
// if($_rows['state']==0){
// echo '未读';
// }else{
// echo '已读';
// }
echo $_rows['state'];
?></td>
<td><a href="message.php?action=<?php echo $_rows['id']?>">删除</a></td>
</tr>
<?php }?>
</table>
<p align="center"><input type="button" value="返回列表" onclick="javascript:history.back();"/></p>
</div>
</body>
</html>