Php+mysql implementation of database random rearrangement example

The main implementation code is as follows:

code is as follows: <?php


//database connection not written in 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 ' <meta http-equiv= ' refresh ' content= ' 0;url=rand.php?s= '. ($s +50). ' &E=50 "> Processing data, currently '. $s ... ' ... ';


}


Else


{


Echo ' completes all data processing <a href=rand.php> and then randomly sorts once </a> ';


}


?>