无法在 php 中打印 Mysqli 查询结果 - Could not be able to print Mysqli query result in php

Could not be able to print Mysqli query result in php

本文关键字：Mysqli 查询结果打印 php | 更新日期: 2023-09-27

我想打印Mysqli查询的结果，但是当我尝试执行以下操作时，它不会返回任何值或错误。代码不会通过 while 循环。我的代码会有什么问题，请帮助我！

<?php
    $mysqli = new mysqli("localhost", "root", "", "domains");
    if ($mysqli->connect_errno) {
        printf("Connect failed: %s'n", $mysqli->connect_error);
        exit();
    }
    $part = explode(".", $str);
    $part1 = $part[0];
    $part2 = $part[1];
    $sql = "SELECT
            DomainCategory.Name
        FROM
            DomainName_Client,
            DomainNameType,
            DomainCategory,
            OrderDomain_Client
        WHERE
            DomainName_Client.Name = '$part1'
        AND DomainNameType.Name = '$part2'
        AND DomainName_Client.TypeID = DomainNameType.ID
        AND DomainCategory.ID = DomainName_Client.DomainCategoryID
        AND OrderDomain_Client.DomainNameID = DomainName_Client.ID";
    $result = $mysqli->query($sql);
    if (!$result = $mysqli->query($sql)) {
        die('There was an error running the query ' . $mysqli->error . ']');
    }
    while ($row = $result->fetch_assoc()) {
        echo 'Total results: ' . $result->num_rows;
    }
?>

首先，使用以下代码检查 sql 查询中返回的结果数，然后使用 while 或 for 循环打印它。

echo $result->num_rows;