php - mysqli fetch_object 在结果集数组的第一个元素中返回非对象

Question

我有一个特定的 mysqli 查询，它在结果集数组的第 0 个位置返回一个空元素。当我尝试遍历结果集以显示到屏幕时，这个空的非对象元素似乎会导致问题

$projAreas[] = array();
$projectID = $_GET['projectID'];

$sql = "SELECT *
       FROM  `areas` ,  `project_area_junc` 
       WHERE  `areas`.`areaID` =  `project_area_junc`.`areaID` 
        AND  `project_area_junc`.`projectID` = $projectID";

$results = $conn->query($sql);
while($row = $results->fetch_object()) {
    $projAreas[] = $row;
    }

结果在位置 0 处给出不需要的数组元素)即当我 print_r($projAreas)我明白了:

Array
(
    [0] => Array
        (
        )

    [1] => stdClass Object
        (
            [areaID] => 56
            [propertyID] => 14
            [areaName] => Living Room
            [areaInfo] =>  lots of windows - colonial style
            [proj_area_juncID] => 10
            [projectID] => 4
        )

    [2] => stdClass Object
        (
            [areaID] => 57
            [propertyID] => 14
            [areaName] => Kitchen
            [areaInfo] =>   
            [proj_area_juncID] => 11
            [projectID] => 4
        )

Answer 1

试试这个....

 $projAreas = array();
    while($row = $results->fetch_object()) {
        array_push($projAreas ,$row);
        }

     print_r($projAreas);