Sample connection to local PHP/MySQL using XAMPP

database_connection.php

<h1>Connect to a database</h1>
<?php
	// http://stevesohcot.com/tech-lessons-learned/2016/06/19/xampp-php-setup-on-a-mac/
	// Sample connection to local PHP/MySQL using XAMPP

	$host = "localhost";
	$user = "root";
	$password = "";

	$db1 = mysqli_connect($host, $user, $password, "MyDatabase") or die ("Could not connect");
	
	$query = "SELECT * FROM Users";
	$get_entries = mysqli_query($db1, $query);

	if ( mysqli_num_rows($get_entries) != 0) {

		while ($display_entries = mysqli_fetch_array($get_entries)) {

			print "<br>" . $display_entries['username'];

		}

	}		

	mysqli_close($db1);

?>