<?php
// Create connection:

$conn = new mysqli ("server", "user", "password", "database");
mysqli_set_charset ($conn, "utf8");

// Check connection:

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

// SQL query:

$sql = "SELECT * FROM top_5000_songs LIMIT 0, 10";
  $result = $conn -> query($sql);
if ($result -> num_rows > 0) {

// Output each row
	
  while ($row = $result -> fetch_assoc()) {
    echo "<div>" . $row["song_title"] . " - " . $row["artist"] . "</div>";
}
} 
else {
  echo "No records found";
}
$conn -> close();
?>