如何删除错误“试图获取非对象的属性”？

Question

I am new in PHP. I face an error message when i run my code Trying to get property of non-object I try all possible solutions provided on stackoverflow but i failed. Please have a look on my code and suggest me my error please.

Please dont mark as duplicate

<?php
   $servername = "localhost";
    $username = "root";
    $password = "";
    $dbname = "pacra-daily";
    $conn = new mysqli($servername, $username, $password, $dbname);
    //$id2 = $_GET['id'];

    $sql="SELECT pacra_teams.title as 'teamTitle', og_users.display_name, og_users.id
    FROM og_users
    LEFT JOIN pacra_teams
    ON pacra_teams.id = og_users.team_id
    Where og_users.id = 106";
    $result = $conn->query($sql);
    $row = $result->fetch_object();
    // setting variable values during session

    echo $row->display_name; // Change to correct column name in table og_users
    echo $row->teamTitle; 
    ?>

I got error on

echo $row->display_name; // Change to correct column name in table og_users
        echo $row->teamTitle; 

Answer 1

If query return you empty result set still you are trying to access the row. Access the db columns in a while loop shown as below.

while ($row = $result->fetch_object()) {
      echo $row->teamTitle;
}