Outputting data from the database to the site page. How to do?

Question

PHP

I have a MySql database. I removed all the data in the code)) Here is a code that displays arrays of data from a database of this type
Array ( [ID] => 1 [Diametr] => 14 [Width] => 555 [Height] => 666 [Marka] => kama )
Array ( [ID] => 2 [Diametr] => 22 [Width] => 3 [Height] => 44 [Marka] => cordiant ) Tell me
how we can display this data, for example

1. Diameter: (HERE YOU NEED TO GET THE DIAMETER VALUE FROM THE DB
   
2. Height: (...)
   
3. Width: (...)
   
4. Brand: (...)
   

I am a complete newbie to PHP and Databases. Thanks in advance!

<?php
  $mysqli = @new mysqli('localhost', 'name', 'pass', 'bd');
  $result_set = $mysqli->query('SELECT * FROM autoobuv_spb');
  while ($row = $result_set->fetch_assoc()) {
    print_r($row);
    echo "<br />";
  }
  $result_set->close();
  $mysqli->close();
?>

Answer 1

$mysqli = @new mysqli('localhost', 'name', 'pass', 'bd');
  $result_set = $mysqli->query('SELECT * FROM autoobuv_spb');
  while ($row = $result_set->fetch_assoc()) {
    foreach($row as $v=>$k) {
        echo $k.': '.$v.'<br>';
    }   
  }
  $result_set->close();
  $mysqli->close();