本文介绍了统计数据库中的注册用户的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着跟版网的小编来一起学习吧！
问题描述
我想回应在我的网站上注册的人数只有我拥有的代码不起作用，它告诉我它不可能转换为字符串.此外，当我将其设置为在 HTML 中调用的函数时，我收到 $connection 未定义的错误
I would like to echo the number of people registered on my website only the code that I have does not work, it gives me back that it can't be converted to string. Also when I make it a function to call in my HTML I get error that $connection is undefined
require_once("connect.php");
$sql = "SELECT * FROM persons";
if ($result=mysqli_query($connection, $sql)){
$rowcount = mysqli_num_rows($result);
mysqli_free_result($result);
return $result;}
如何在我可以在打印注册人数的页面上调用的函数中获取此信息?
How do I get this in a function that I can call on my page that prints the number of people registered?
推荐答案
首先你应该使用 count 因为速度问题:
First of all you should use count because of speed issues:
$sql = "SELECT COUNT(id) FROM persons";
要编写一个返回数字的函数，您可以执行类似的操作
To write a function that returns the number, you can do something like
function registredMemberCount ($connection)
{
$sql = "SELECT COUNT(id) FROM persons";
$result = mysqli_query($connection,$sql);
$rows = mysqli_fetch_row($result);
return $rows[0];
}
并用
registredMemberCount($connection);
这篇关于统计数据库中的注册用户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！
本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益，请联系我们，我们会在确认后第一时间进行删除！