php - Hangman php从数据库中生成新的随机单词

Question

我正在开发一个刽子手游戏，但我想从数据库中选择一个随机单词。

数据库连接:

     $db_host               = "127.0.0.1"; 
     $db_user               = "root";
     $db_pass               = "";
     $db_table          = "galgje";

    $db = mysql_connect($db_host,$db_user,$db_pass);
    mysql_select_db($db_table,$db);
    $query = "SELECT word FROM dba_tblwords " ;
    $select = @mysql_query($query);

while($row = mysql_fetch_array(($select)))

{
$list = ($row['word']);
}

选择一个新词:

 if ($wrong >= $max)
 {
SELECT word FROM dba_tblwords ORDER BY RAND() LIMIT 0,1  
} 

这不起作用。谁能帮助我？

Answer 1

您应该使用此查询

SELECT word FROM dba_tblwords ORDER BY RAND() LIMIT 1

并传递到数据库。请记住 order by rand() 的性能很低。为了更好地理解，请参阅this answer