"; $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"; } ?>