Home >Backend Development >PHP Tutorial >Mini drift bottle implemented in PHP_php skills
The example in this article describes the mini drift bottle implemented in PHP. Share it with everyone for your reference. The details are as follows:
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>
I hope this article will be helpful to everyone’s PHP programming design.