本文实例讲述了PHP实现的迷你漂流瓶。分享给大家供大家参考。具体如下:
mysql.php:
1
2
3
4
|
<?php
mysql_connect( '127.0.0.1' , 'root' , 'wjy123' ) or die ( 'exit(-1)' );
mysql_select_db( 'floatbtn' );
mysql_query( 'set names utf8' );
|
pickbtn.php:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
|
<!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:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
<!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程序设计有所帮助。