";
$dbhost ="localhost";
$dbuser = "root";
$dbpass = "479.root";
$dbname = "typing";
$CONN=mysql_connect($dbhost, $dbuser, $dbpass);
if (!$CONN) {
die("ERROR . could not connet to mysql");
}
if (mysql_select_db($dbname, $CONN)) {
//echo "connect $dbname ok";
for ($i=1;$i<=6;$i++){
if ($i==6) {
$wherestr = "level>=6";
}
else{
$wherestr = "level=$i";
}
echo "
";
$sql="SELECT * from words where $wherestr";
//echo $sql. " ";
// echo $sql;
$rs=mysql_query($sql);
$rs_num=mysql_num_rows($rs);
//echo "level $i has $rs_num words but select 30 words as follow ";
for ($j=0;$j<$rs_num;$j++){
$row[$j]=mysql_fetch_array($rs);
}
//random grouping mathod
$mink=0;
for ($k=0;$k<30;$k++) {
if ((($k+1)*$rs_num / 30) >= ($rs_num - 1))
{
$maxk=$rs_num-1;
}
else
{
$maxk=(integer)(($k+1)*$rs_num/30);
}
$kk=rand($mink,$maxk);
$newword[$k]=$row[$kk][0];
//echo $newword[$k] . " ";
$mink=$maxk+1;
}
for ($k=0;$k<20;$k=$k+2) {
$temp=$newword[$k];
$newword[$k]=$newword[$k+9];
$newword[$k+9]=$temp;
}
for ($k=0;$k<30;$k++) {
echo $newword[$k] . " ";
}
echo " | \n";
}
mysql_close($CONN);
}
else
{
echo "connect $dbname error";
}
?>