将 SQL 结果存储为 var


Storing SQL results as var

我有这段查询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);
?>

此外,您应该真正查看准备好的语句。