本文实例讲述了PHP实现的迷你漂流瓶。共享给大家供大家参考。详细如下:
mysql.php:
mysql_connect('127.0.0.1','root','wjy123') or die('exit(-1)');
mysql_select_db('floatbtn');
mysql_query('set names utf8');
pickbtn.php:
/p>
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
ppick u.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;
}
@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)){
?>
ID : =$re['author']?>Text : =$re['text'] ?>Date : =$re['date']?>已读标记 =$re['flag']?>
$q = "update `btn` set flag = 1 where id = {$re['id']}";
mysql_query($q);
}
}
?>
throwbtn.php:
/p>
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
微软雅黑.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;
}
@include('mysql.php');
if(isset($_REQUEST['send'])){
echo 'Publish Successed !
';
$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);
}
}
?>
ID | |
---|---|
Text | |
Date |
希望本文所述对大家的php程序设计有所帮助。