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

PHP+mysql implementation of random database rearrangement example_PHP tutorial

WBOY
Release: 2016-07-13 10:16:42
Original
661 people have browsed it

php+mysql implementation of database random rearrangement example

The main implementation code is as follows:

The code is as follows:
//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 is'.$ s.'Article. . . . . . ';
}
else
{
echo 'Complete all data processing Randomly sort again';
}
?>

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/896775.htmlTechArticlephp+mysql implements the example of random rearrangement of the database. The main implementation code is as follows: The code is as follows: ?php //Database connection is It is not written here. $s = isset( $_GET['s'] )?$_GET['s']:0; $e = isse...
source:php.cn
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template