Home >Backend Development >PHP Tutorial >PHP reads and writes operations on the database and random number operations
This article mainly introduces PHP's read and write operations for databases and random number operations. Interested friends can refer to it. I hope it will be helpful to everyone.
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>
<html>
<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>
<html>
<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>
<p align="center"><input class="btn" name="send" type="submit" value="Send Message"/></p>
</form>
</body>
</html>Summary: The above is the entire content of this article, I hope it will be helpful to everyone's study.
Related recommendations:
php Judgment of the current encoding and corresponding encoding conversion implementation skills
php How to use the MagickWand module to operate pictures and add watermarks
The above is the detailed content of PHP reads and writes operations on the database and random number operations. For more information, please follow other related articles on the PHP Chinese website!