php - 查找用户小部件

Question

我对 php/mysql 一点经验都没有，这是我目前的经验。

我想在我的网页上创建一个显示 5 个随机用户的部分，所以我做了 5 个查询，每个查询输出 1 个用户，它工作正常，但我需要帮助添加一些东西，我想要我当前的用户名作为排除登录，我希望没有重复的用户名。到目前为止，我的代码如下，非常感谢您的帮助。

include "connect.php";
        $query = mysql_query("SELECT * FROM users ORDER BY rand() LIMIT 5");
        $row = mysql_fetch_assoc($query);
        $random = $row['username'];

        $query = mysql_query("SELECT * FROM users ORDER BY rand() LIMIT 5");
        $row = mysql_fetch_assoc($query);
        $random2 = $row['username'];

        $query = mysql_query("SELECT * FROM users ORDER BY rand() LIMIT 5");
        $row = mysql_fetch_assoc($query);
        $random3 = $row['username'];

        $query = mysql_query("SELECT * FROM users ORDER BY rand() LIMIT 5");
        $row = mysql_fetch_assoc($query);
        $random4 = $row['username'];

        $query = mysql_query("SELECT * FROM users ORDER BY rand() LIMIT 5");
        $row = mysql_fetch_assoc($query);
        $random5 = $row['username'];

        echo "
        <div class='well well-sm' style='padding-top:4px;padding-bottom:8px; margin-bottom:8px; overflow:hidden; background:white;'>
            <a href='./$random'>$random</a><br>
            <a href='./$random2'>$random2</a><br>
            <a href='./$random3'>$random3</a><br>
            <a href='./$random4'>$random4</a><br>
            <a href='./$random5'>$random5</a>
        </div>
    </div>

Answer 1

$query = mysqli_query('SELECT * FROM users WHERE username <> "' . mysqli_real_escape_string($connection, $username) . '" ORDER BY rand() LIMIT 5');

while($row = mysqli_fetch_array($query)) {
        $random[] = $row['username'];           
}

foreach ($random as $random_user) { //echo name of each random user
        echo $random_user . '<br />';
}