我正在尝试为我的网站创建一个管理面板。我在仪表板上使用以下代码来计算用户数量(对于博客帖子等,也是类似的:
//get result
$data = mysql_query("SELECT count(user_id) AS total FROM account_users");
$info = mysql_fetch_assoc($data);
//output result
echo "Rows found :" . $info['total'];
当我输入以下代码并查看页面时,结果如下所示:
Rows found :
如你所见,这个数字是不可见的。
我尝试执行PHPMyAdmin的SQL部分中的代码,结果是1(数据库中有1行,所以这是正确的!)
这怎麽可能?(你能帮我吗?)
更新第一条评论:我添加了他告诉我的代码,但它并没有变得更好……
我现在得到一个错误:
Notice: Undefined index: auth in /home/vol9_6/epizy.com/epiz_21854614/admin.ictsupport.ga/htdocs/index.php on line 9
Warning: mysqli_query() expects at least 2 parameters, 1 given in /home/vol9_6/epizy.com/epiz_21854614/admin.ictsupport.ga/htdocs/index.php on line 19
Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, null given in /home/vol9_6/epizy.com/epiz_21854614/admin.ictsupport.ga/htdocs/index.php on line 20
Rows found :
Notice: Undefined index: username in /home/vol9_6/epizy.com/epiz_21854614/admin.ictsupport.ga/htdocs/nav.php on line 3
发布于 2018-06-25 01:55:50
mysql_query已弃用。
使用mysqli_query。尝试:
$con=mysqli_connect("localhost","my_user","my_password","my_db");
$sql="SELECT count(user_id) AS total FROM account_users";
$result=mysqli_query($con,$sql);
// Associative array
$row=mysqli_fetch_assoc($result);
echo "Rows found :" . $row['total'];
https://stackoverflow.com/questions/51012280
复制相似问题