PHP: Using mysqli object to fetch data

PHP: Fetching MySQL Data into an HTML table

<style>
.dataTable{
width:500px;
border:1px solid #000000;
background:blue;
}

.dataTable td {

padding:0 8px;
color:#fff;
border:1px solid #000000;

}

.subH{

font-size:1.4em;
font-weight:bold;
}
</style>


<?php
$host='localhost';
$user='root';
$pass='Marion9197';
$dbname='bilbo';

$conn=new mysqli($host,$user,$pass,$dbname);

if($conn->connect_error){
die("Connection Failed: $conn->connect_error");
}

$sql="SELECT * FROM map";

$result=$conn->query($sql);


echo "<table cellpadding='0' cellspacing='0' class='dataTable'>";
echo "<tr class='subH'><td>Land</td><td>Residents</td><td>Creature</td><td>Food</td></tr>";
if($result->num_rows  >  0){


while($row=$result->fetch_assoc()){

echo "<tr>";
echo  "<td>$row[land]</td><td>$row[residents]</td><td>$row[creature]</td><td>$row[food]</td>";

echo "</tr>";
}

echo "</table>";

}
else{

echo "Zero Records";
}

$conn->close();

?>