我有这段查询SQL DB的代码。我想将数组中的值存储为变量,然后 PHP 可以在页面上的其他地方回显出来。
知道我做错了什么吗?结果只是作为"数组"。
<?php
$con=mysqli_connect("localhost","root","root","mongolwar");
$result = mysqli_query($con,"SELECT * FROM userdata");
$total = ['player_total'];
mysqli_close($con);
?>
<?php
echo $total;
;?>
我找到了解决方案:
<?php
$con=mysqli_connect("localhost","root","root","mongolwar");
$result = mysqli_query($con,"SELECT * FROM userdata");
while($row = mysqli_fetch_array($result)) {
$total = $row[player_total];
}
mysqli_close($con);
?>
<?php
echo $total;
;?>
在这种情况下
,你说$total = ['player_total']
,你可能的意思是$total = $result['player_total']
;
运行此代码,它会让你接近你想要的,然后希望你可以接受它剩下的方式:
<?php
$con=mysqli_connect("localhost","root","root","mongolwar");
$result = mysqli_query($con,"SELECT * FROM userdata");
mysqli_close($con);
print_r($result);
?>
此外,您应该真正查看准备好的语句。