<?php

// MySQLi object-oriented
$mysqli = new mysqli("localhost", "username", "password", "database_name");

// Check connection
if ($mysqli->connect_error) {
  die("Connection failed: " . $mysqli->connect_error);
}

// Select data
$sql = "SELECT column1, column2, column3 FROM table_name";
$result = $mysqli->query($sql);

if ($result->num_rows > 0) {
  // Output data of each row
  while($row = $result->fetch_assoc()) {
    echo "Column1: " . $row["column1"]. " - Column2: " . $row["column2"]. " - Column3: " . $row["column3"]. "<br>";
  }
} else {
  echo "0 results";
}

// Close connection
$mysqli->close();

?>