PHP processes a large amount of data, and each data is processed, returns the method of the client to display the current status.
Similar to dedecms to generate static pages
idea:
1. The client sends a request
2. The server accepts the request and starts counting the amount of data to be processed
3. Arrange the required processing data according to certain rules and send it to the server processing end
4. The server processing side processes the first data and sends the processing result to the client after a certain amount of processing.
5. The client receives the result and automatically displays the processing result and sends it to the server.
6. The server receives the processing result and forwards it to the server processing end
7. The processing end continues to process the results...
8. Loop 4-7 steps until processing is completed
Experimental process:
1. Create databases and tables
create databases handle; create table user( id int unsigned not null auto_increment primary key, name varchar(8), sex tinyint(1) default '1', score int not null, state tinyint(1) );
2. Add data to the table (not an example)
3. Create client, server 1, server 2
:
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Client</title>
</head>
<body>
<button onclick="send('?state=0')">Start request</button>
<div style="position: fixed;width: 500px;height: 300px;top: 100px;background: gray">
<span style="color: white;font-size: 20px;"></span>
</div>
<script type="text/javascript" src="./jquery-1.10."></script>
<script type="text/javascript">
//Create a modal boxfunction display(value){
$('span').html(value);
}
//ajax
function send(dizhi){
$.ajax({
type: "get",
url: dizhi,
success: function(msg){
var arr=(msg);
(arr);
//alert();
var tishi="Has been processed"+ +"One, total"++"indivual";
display(tishi);
if(!=){
send("?now="++"&all="+);
}else{
alert("Finish!");
}
}
});
}
</script>
</body>
</html>
:
<?php
require('./');
$link=mysql_connect(HOST,USER,PASS) or die('Database link failed');
mysql_select_db(DBNAME);
/*
Query data
$sql="select * from user";
$result=mysql_query($sql);
$row=mysql_fetch_assoc($result);
var_dump($row);
*/
/*
Loop insertion
for($i=3;$i<=100;$i++){
$sql= "insert into user(name,score,state) values('z".$i."',".$i.",1)";
mysql_query($sql);
}
*/
/*Total number of data to be processed by query*/
//isset($_GET['state'])?$_GET['state']:0;
if(isset($_GET['state'])){
$sql="select count(*) from user";
$result=mysql_query($sql);
$all=mysql_result($result,0);
$now=0;
header("Location: ?all={$all}&now=0");
}else{
header("Location: ?all={$_GET['all']}&now={$_GET['now']}");
}
/*Return the currently processed data*/
:
<?php
require('./');
$link=mysql_connect(HOST,USER,PASS) or die('Database link failed');
mysql_select_db(DBNAME);
/*Return the currently processed data*/
//$id=$_GET['id'];//Get the id to be processed$now=$_GET['now'];//The number of already processed$all=$_GET['all'];//Total number of processing$sql="select score from user limit {$now},1";
$result=mysql_query($sql);
$value=mysql_result($result, 0);
$now++;
$arr=array(
'now'=>$now,
'all'=>$all,
'value'=>$value
);
//print_r($arr);
echo json_encode($arr);
:
<?php
define('HOST','127.0.0.1');
define('USER', 'root');
define('PASS','root');
define('DBNAME','handle');
The above is what the editor shared with you how to use PHP to process database data to return the data to the client and display the current status. I hope it will be helpful to everyone!