PHP实现的迷你漂流瓶

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：

发布信息


<?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)){
?>
 
已读标记 <?=$re['flag']?>

  
ID : 
  
<?=$re['author']?>
 
 

  
Text : 
  
<?=$re['text'] ?>
 
 

  
Date : 
  
<?=$re['date']?>
 
 

<?php
$q = "update `btn` set flag = 1 where id = {$re['id']}";
mysql_query($q);
}
}
?>

throwbtn.php：

截取信息
<?php
@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程序设计有所帮助。