PHP实现的迷你漂流瓶
程序员文章站
2023-12-03 17:37:58
本文实例讲述了php实现的迷你漂流瓶。分享给大家供大家参考。具体如下：
mysql.php：
本文实例讲述了php实现的迷你漂流瓶。分享给大家供大家参考。具体如下：
mysql.php：
<?php
mysql_connect('127.0.0.1','root','wjy123') or die('exit(-1)');
mysql_select_db('floatbtn');
mysql_query('set names utf8');
pickbtn.php：
<!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='throwbtn.php'>发布信息</a>
<form id="form1" name="form1" method="post" action="pickbtn.php">
<table width="80%" border="0">
<?php
@include('mysql.php');
if(isset($_request['new'])){
$q = 'select * from `btn`';
$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['author']?></td>
</tr>
<tr>
<td class="box" >text : </td>
<td class="box"><?=$re['text'] ?></td>
</tr>
<tr>
<td class="box">date : </td>
<td class="box"><?=$re['date']?></td>
</tr>
<p class="box">已读标记 <?=$re['flag']?></p>
</table>
<?php
$q = "update `btn` set flag = 1 where id = {$re['id']}";
mysql_query($q);
}
}
?>
<input class="btn" name="new" type="submit" value="截取"/>
</form>
</body>
</html>
throwbtn.php：
<!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>
<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;
}
.box1 {
font-family: "微软雅黑";
font-size: 12px;
color: #369;
width: 800px;
border: 1px solid #666;
}
</style>
</head>
<body>
<a href='pickbtn.php'>截取信息</a>
<?php
@include('mysql.php');
if(isset($_request['send'])){
echo 'publish successed !<br>';
$author = $_request['author'];
$text = $_request['text'];
$date = date('y-m-d h:m:s');
if(!(null == trim($author)) && !(null == trim($text))) {
$q = "insert into `btn`(`id`,`author`,`text`,`date`,`flag`) values('','$author','$text','$date','0')";
mysql_query($q);
}
}
?>
<form id="form1" name="form1" method="post" action="throwbtn.php">
<table width="80%" border="0">
<tr>
<th class="box" width="110">id</th>
<td class="box" width="442"><input class="box1" type="text" name="author" /></td>
</tr>
<tr>
<th class="box" >text</th>
<td class="box"><input class="box1" name="text" type="text" /></td>
</tr>
<tr>
<th class="box">date</th>
<td class="box">
<input class="box1" type="text" name="date" disabled="disabled" value="<?=date('y-m-d')?>" /></td>
</tr>
</table>
<div align="center"><input class="btn" name="send" type="submit" value="send message"/></div>
</form>
</body>
</html>
希望本文所述对大家的php程序设计有所帮助。
上一篇： C#使用NPOI上传excel