PHP如何从表中获取所有数据并将其相应地放入div中

Question

我的数据库中有很多表，每个表都有特定的按钮，所以当我单击其中一个按钮时，它应该在 div 中显示表的行和列，但它不能正确显示例如

注意:每张表都有不同的数字列和不同的数字行

This is what it looks like
This is what i want, for each of the table

$query = "SELECT * FROM ghousn.$table";
        $result = mysqli_query($connection, $query);
           echo" <table >";
        while($row = mysqli_fetch_assoc($result)){  
            foreach($row as $key => $val){   
               echo "<tr>";
            echo"<th>$key</th> 
          </tr>
          <tr>
            <td>$val</td>


      </tr>";
        }
    }
        echo "</table>";


    }

Answer 1

$query = "SELECT * FROM FROM ghousn.$table";
$result = mysqli_query($connection,$query);
echo" <table border='1' >";

 while($row = mysqli_fetch_assoc($result)){  
 echo "<tr>";
     foreach($row as $key => $val){   
       echo"<th>$key</th> ";        
     }
  echo "</tr>";
      echo"<tr>";
     foreach($row as $key => $val){   
       echo "<td>$val</td>";        
     }
     echo "</tr>";
 }

echo "</table>";