data

data can be made ready to reveal to everyone.

PHP is used to interact with the MySQL database.

if ($numrows>0) {
  //fetch associative array
  while($row = $result->fetch_assoc()) {
    //format and echo
  } 
} else {
        echo "no results";
       }          

//free result set
$result->free();

//close the connection
$db->close();