Backend DevelopmentPHP TutorialPHP reads and writes operations on the database and random number operationsPHP 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!
How can you check if a PHP session has already started?Apr 30, 2025 am 12:20 AMIn PHP, you can use session_status() or session_id() to check whether the session has started. 1) Use the session_status() function. If PHP_SESSION_ACTIVE is returned, the session has been started. 2) Use the session_id() function, if a non-empty string is returned, the session has been started. Both methods can effectively check the session state, and choosing which method to use depends on the PHP version and personal preferences.
Describe a scenario where using sessions is essential in a web application.Apr 30, 2025 am 12:16 AMSessionsarevitalinwebapplications,especiallyfore-commerceplatforms.Theymaintainuserdataacrossrequests,crucialforshoppingcarts,authentication,andpersonalization.InFlask,sessionscanbeimplementedusingsimplecodetomanageuserloginsanddatapersistence.
How can you manage concurrent session access in PHP?Apr 30, 2025 am 12:11 AMManaging concurrent session access in PHP can be done by the following methods: 1. Use the database to store session data, 2. Use Redis or Memcached, 3. Implement a session locking strategy. These methods help ensure data consistency and improve concurrency performance.
What are the limitations of using PHP sessions?Apr 30, 2025 am 12:04 AMPHPsessionshaveseverallimitations:1)Storageconstraintscanleadtoperformanceissues;2)Securityvulnerabilitieslikesessionfixationattacksexist;3)Scalabilityischallengingduetoserver-specificstorage;4)Sessionexpirationmanagementcanbeproblematic;5)Datapersis
Explain how load balancing affects session management and how to address it.Apr 29, 2025 am 12:42 AMLoad balancing affects session management, but can be resolved with session replication, session stickiness, and centralized session storage. 1. Session Replication Copy session data between servers. 2. Session stickiness directs user requests to the same server. 3. Centralized session storage uses independent servers such as Redis to store session data to ensure data sharing.
Explain the concept of session locking.Apr 29, 2025 am 12:39 AMSessionlockingisatechniqueusedtoensureauser'ssessionremainsexclusivetooneuseratatime.Itiscrucialforpreventingdatacorruptionandsecuritybreachesinmulti-userapplications.Sessionlockingisimplementedusingserver-sidelockingmechanisms,suchasReentrantLockinJ
Are there any alternatives to PHP sessions?Apr 29, 2025 am 12:36 AMAlternatives to PHP sessions include Cookies, Token-based Authentication, Database-based Sessions, and Redis/Memcached. 1.Cookies manage sessions by storing data on the client, which is simple but low in security. 2.Token-based Authentication uses tokens to verify users, which is highly secure but requires additional logic. 3.Database-basedSessions stores data in the database, which has good scalability but may affect performance. 4. Redis/Memcached uses distributed cache to improve performance and scalability, but requires additional matching
Define the term 'session hijacking' in the context of PHP.Apr 29, 2025 am 12:33 AMSessionhijacking refers to an attacker impersonating a user by obtaining the user's sessionID. Prevention methods include: 1) encrypting communication using HTTPS; 2) verifying the source of the sessionID; 3) using a secure sessionID generation algorithm; 4) regularly updating the sessionID.
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.
MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.
SublimeText3 English version
Recommended: Win version, supports code prompts!
PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool
EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function
