Home > Backend Development > PHP Tutorial > PHP implementation of random rearrangement of mysql database example_PHP tutorial

PHP implementation of random rearrangement of mysql database example_PHP tutorial

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-07-13 10:17:02
Original
691 people have browsed it

PHP implementation of mysql database random rearrangement example

Program code

The code is as follows
 代码如下  

//数据库连接就不写在这里面了
$s = isset( $_GET['s'] )?$_GET['s']:0;
$e = isset( $_GET['e'])?$_GET['e']:50;
$count =85000;

if( $s < $count )
{
$sql = "select * from 表前缀_info where isget =0 order by id desc limit $s,$e ";
$query = mysql_query( $sql );
while( $rs = mysql_fetch_array( $query ) )
{
$id = $rs['id'];
$sss = $rs['sss'];
$typeid = $rs['typeid'];
$isget = $rs['isget'];
$sql = "insert into 表前缀_info_bak (id,表前缀,typeid,isget) values('$id','$sss','$typeid','$isget')";
mysql_query( $sql ) ;
echo $sql;
//exit;
$sqlu = "update 表前缀_info set isget=1 where id =".$rs['id'];
mysql_query( $sqlu );
}
echo '正在处理数据,当前为'.$s.'条......';
}
else
{
 echo '完成所有数据处理 再随机排序一次';
}
?>

//The database connection is not written here
$s = isset( $_GET['s'] )?$_GET['s']:0;
$e = isset( $_GET['e'])?$_GET['e']:50;
$count =85000;

if( $s < $count )
{
$sql = "select * from table prefix_info where isget =0 order by id desc limit $s,$e ";
$query = mysql_query( $sql );
while( $rs = mysql_fetch_array( $query ) )
{
$id = $rs['id'];
$sss = $rs['sss'];
$typeid = $rs['typeid'];
$isget = $rs['isget'];
$sql = "insert into table prefix_info_bak (id, table prefix, typeid, isget) values ​​('$id','$sss','$typeid','$isget')";
mysql_query( $sql ) ;
echo $sql;
//exit;
$sqlu = "update table prefix_info set isget=1 where id =".$rs['id'];
mysql_query( $sqlu );
}
echo 'Data is being processed, currently '.$ s.'Article. . . . . . ';
}
else
{
echo 'Complete all data processing Randomly sort again';
}
?>

http://www.bkjia.com/PHPjc/895098.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/895098.htmlTechArticle
PHP implementation of mysql database random rearrangement example program code is as follows? //Database connection will not be written here $s = isset( $_GET['s'] )?$_GET['s']:0; $e = isset( $_GET['e'])?$_GET...
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Issues
php data acquisition?
From 1970-01-01 08:00:00
0
0
0
PHP extension intl
From 1970-01-01 08:00:00
0
0
0
How to learn php well
From 1970-01-01 08:00:00
0
0
0
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template