標籤：
<?php/*** TestGuest Version1.0* ================================================* Copy 2010-2012* Web:[email protected]* ================================================* 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>
php 簡單串連資料庫的操作
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
