php - 将 mysql 结果加载到 php 变量中

Question

你好，我有这个代码:

<?php   $servername = "xxx";
    $username = "xxx";
    $password = "xxx";
    $dbname = "xxx";

    // Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);
    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    } 




    $sql = "SELECT varible FROM test";
    $result = $conn->query($sql);
    echo $result;

    ?>

我想要的只是从 mysql 表加载一个数字并将其加载到 php 变量中并将该变量作为数字使用。感谢您的回复。

Answer 1

试试这个:

$sql = "SELECT varible FROM test";
$result = $conn->query($sql);
$res = mysqli_fetch_assoc($result);
echo $res['varible'];

如果你有一个列表，那么你可以使用:

while($res = mysqli_fetch_assoc($result)) {
     echo $res['varible'];
}