PHP+mysql implementation of random database rearrangement example_PHP tutorial

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';
}
?>

http://www.bkjia.com/PHPjc/896775.htmlwww.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...