PHP reads and writes operations on the database and random number operations-PHP Tutorial-php.cn

PHP reads and writes operations on the database and random number operations

墨辰丷

Release： 2023-03-30 18:20:01

Original

1602 people have browsed it

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(&#39;127.0.0.1&#39;,&#39;root&#39;,&#39;wjy123&#39;) or die(&#39;exit(-1)&#39;);
mysql_select_db(&#39;floatbtn&#39;);
mysql_query(&#39;set names utf8&#39;);

Copy after login

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=&#39;throwbtn.php&#39;>发布信息</a>
<form id="form1" name="form1" method="post" action="pickbtn.php">
<table width="80%" border="0">
<?php
@include(&#39;mysql.php&#39;);
if(isset($_REQUEST[&#39;new&#39;])){
$q = &#39;SELECT * FROM `btn`&#39;;
$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[&#39;author&#39;]?></td>
 </tr>
 <tr>
  <td class="box" >Text : </td>
  <td class="box"><?=$re[&#39;text&#39;] ?></td>
 </tr>
 <tr>
  <td class="box">Date : </td>
  <td class="box"><?=$re[&#39;date&#39;]?></td>
 </tr>
 <p class="box">已读标记 <?=$re[&#39;flag&#39;]?></p>
</table>
<?php
$q = "update `btn` set flag = 1 where id = {$re[&#39;id&#39;]}";
mysql_query($q);
}
}
?>
<input class="btn" name="new" type="submit" value="截取"/>
</form>
</body>
</html>

Copy after login

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=&#39;pickbtn.php&#39;>截取信息</a>
<?php
@include(&#39;mysql.php&#39;);
if(isset($_REQUEST[&#39;send&#39;])){
  echo &#39;Publish Successed !<br>&#39;;
  $author = $_REQUEST[&#39;author&#39;];
  $text = $_REQUEST[&#39;text&#39;];
  $date = date(&#39;Y-m-d h:m:s&#39;);
  if(!(null == trim($author)) && !(null == trim($text))) {
  $q = "insert into `btn`(`id`,`author`,`text`,`date`,`flag`) values(&#39;&#39;,&#39;$author&#39;,&#39;$text&#39;,&#39;$date&#39;,&#39;0&#39;)";
  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(&#39;Y-m-d&#39;)?>" /></td>
 </tr>
</table>
<p align="center"><input class="btn" name="send" type="submit" value="Send Message"/></p>
</form>
</body>
</html>

Copy after login

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

php uses the history function

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!