迷你PHP漂流瓶原型-PHP源码-PHP中文網

迷你PHP漂流瓶原型

PHP中文网

發布： 2016-05-25 17:11:17

原創

2193 人瀏覽過

1.php代码

<?phpmysql_connect(&#39;127.0.0.1&#39;,&#39;root&#39;,&#39;wjy123&#39;) or die(&#39;exit(-1)&#39;);
mysql_select_db(&#39;floatbtn&#39;);
mysql_query(&#39;set names utf8&#39;);

登入後複製

2.代码

<!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>ppick u</title>
<style type="text/css">
.btn {
	font-family: "微软雅黑";
	font-size: 12px;
	color: #FFF;
	background-color: #369;
	border: 1px solid #666;
}
.box {
	font-family: "微软雅黑";
	color: #369;
	font-size: 12px;
	border: 1px solid #369;
}
</style>
</head>

<body>
<a href=&#39;throwbtn.php&#39;>发布信息</a>
<form id="form1" name="form1" method="post" action="pickbtn.php">
<table width="80%" border="0">
<?php@include(&#39;mysql.php&#39;);
if(isset($_REQUEST[&#39;new&#39;])){
$q = &#39;SELECT * FROM `btn`&#39;;
$rs = mysql_query($q);
$max = mysql_num_rows($rs);
$rd = rand(1,$max);
$q = "select * from `btn` where id = {$rd}";
$rs = mysql_query($q);
while($re = mysql_fetch_array($rs)){
?>
  <tr>
    <td class="box" width="12%">ID : </td>
    <td class="box" width="88%"><?=$re[&#39;author&#39;]?></td>
  </tr>
  <tr>
    <td class="box" >Text : </td>
    <td class="box"><?=$re[&#39;text&#39;] ?></td>
  </tr>
  <tr>
    <td class="box">Date : </td>
    <td class="box"><?=$re[&#39;date&#39;]?></td>
  </tr>
  <p class="box">已读标记 <?=$re[&#39;flag&#39;]?></p>
</table>
<?php$q = "update `btn` set flag = 1 where id = {$re[&#39;id&#39;]}";
mysql_query($q);
}
}
?>
<input class="btn" name="new" type="submit" value="截取"/>
</form>
</body>
</html>

登入後複製