How to retrieve data from database using Ajax and OOP php

Question

I am going to develop web page with ajax and php. but there is problem in my get_data_in_table function. it will show data in a table structure. but it shows error when i run this code. others are working properly. it shows error in while loop. but i am unable to find any issue.

    class get_data()

    {
     public function get_data_in_table($query){
            $output='';
            $result=  $this->Getdata($query);
            $output.='
                    <table class="table table-bordered table-striped">
                    <tr>
                    <th>Countty</th>
                    <th>Airline Name</th>
                    <th>Arrival Time</th>
                    <th>Status</th>
                    <th>Comment</th>


    </tr>';
            while($row= mysqli_fetch_array($result)){
                $output .='

                        <tr>
    <td>'.$row->country.'</td>
    <td>'.$row->air_line.'</td>
        <td>'.$row->arrival_time.'</td>
          <td>'.$row->status.'</td>
              <td>'.$row->comment.'</td>


    </tr>';


            }
            $output.='</table>';
            return $output;
                    }
?>

Answer 1

I guess I found it:

  class get_data()

    {
     public function get_data_in_table($query){
            $output='';
            $result=  $this->Getdata($query);
            $output.='
                    <table class="table table-bordered table-striped">
                    <tr>
                    <th>Countty</th>
                    <th>Airline Name</th>
                    <th>Arrival Time</th>
                    <th>Status</th>
                    <th>Comment</th>


    </tr>';
            while($row= mysqli_fetch_array($result)){
                $output .='

                        <tr>
    <td>'.$row->country.'</td>
    <td>'.$row->air_line.'</td>
        <td>'.$row->arrival_time.'</td>
          <td>'.$row->status.'</td>
              <td>'.$row->comment.'</td>


    </tr>';


            }
            $output.='</table>';
            return $output;
                    }
} // This was missing
    ?>