使用 PHP 显示 MySQL 数据库中的注册用户数量 - Display amount of registered users in MySQL database using PHP

Display amount of registered users in MySQL database using PHP

我想显示在我的数据库中注册的当前用户数量(称为道尔顿(/用户存储在该数据库中名为simpleauth_players的表中。它存储他们的姓名，哈希，注册日期，登录日期和最后。

我想以某种方式使用PHP代码(将我登录到数据库(并显示数据库中当前的名称数量。因此，我可以在我的 HTML/PHP 页面中显示一条消息，例如"嘿，目前有 1,894 名注册玩家！我有点新手，如果有人可以共享代码和说明，那就太棒了。

我的代码：

$connection = mysql_connect('host', 'username', 'password');
mysql_select_db('database');
$query = "SELECT * FROM simpleauth_players"; 
$result = mysql_query($query);
$registered = "SELECT COUNT(*) FROM dalton.tables WHERE simpleauth_players = 'name' and     TABLE_TYPE='BASE TABLE';
echo "$registered"; 
mysql_close();

这是我

用来在simpleauth_players表中显示注册玩家数量(AKA 行(的代码。

<?php
$link = mysql_connect("localhost", "username", "password");
mysql_select_db("dalton", $link);
if ($_GET['task'] == 'total') {
    $get_db = 'simpleauth_players';
    $result = mysql_query("SELECT * FROM $get_db", $link);
        echo '{"task":"total","amount":"';
            echo mysql_num_rows($result);
        echo '"}';
}
?>

select count(*) as total_player from simpleauth_players

或

$sql = "select * from simpleauth_players";
$result = mysqli_query($con,$sql);
$count = mysqli_num_rows();
echo "Total ".$count." Players";

假设您的列名是language，请尝试这个

SELECT COUNT(*) FROM simpleauth_players WHERE language = "PHP"

或者如果你想按每种语言类型获得计数，你可以使用它

SELECT COUNT(DISTINCT user_id) AS Count,language FROM simpleauth_players GROUP BY language

根据您的原始帖子/问题 由于您尚未向我们提供用于连接的MySQL API，因此这是一个mysqli_版本，使用MySQL的聚合COUNT()函数，它将计算表中给定行数：

$connection = mysqli_connect('host', 'username', 'password', 'database');
$result = mysqli_query($connection, "SELECT  COUNT(*) as count
            FROM simpleauth_players"
);
while ($row = mysqli_fetch_array($result)) {
    $var = $row['count'];
    echo "There are currently " .$var. " users.";
}

编辑：如果使用mysql_

$connection = mysql_connect('host', 'username', 'password');
if (!$connection) {
    die('Not connected : ' . mysql_error());
}
$db_selected = mysql_select_db('database', $connection);
if (!$db_selected) {
    die ('Can''t use database : ' . mysql_error());
}
$result = mysql_query("SELECT  COUNT(*) as count
            FROM simpleauth_players", $connection);
while ($row = mysql_fetch_array($result)) {
    $var = $row['count'];
    echo "There are currently " .$var. " users.";
}