Php+mysql implementation of database random rearrangement instance _php technique

In this paper, the method of random rearrangement of php+mysql database is realized, and all the data in the table can be randomly read out once and then randomly saved to another table, thus the function of recording random is achieved.

The main implementation code is as follows:

Copy Code code as follows:

<?php
The database connection will not be written in this area.
$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 ' <meta http-equiv= "Refresh" content= "0;url=rand.php?s=". ($s +50). ' &AMP;E=50 "> Processing data, currently '. $s ... ' ... ';
}
Else
{
Echo ' completes all data processing <a href=rand.php> and then randomly sorts once </a> ';
}
?>

I hope this article will help you with your PHP program design.