Untitled

<!DOCTYPE html>
<html>
<body>
	<?php
		$servername = "localhost";
		$username = "root";
		$password = "root";
		$dbname = "my_database";

//create connection
		$conn = mysqli_connect($servername, $username, $password, $dbname);
//check connection
		$if(!$conn){
			die("Connection failed: ");
		}
/* sql to create table
		$sql = "CREATE TABLE Users(user_id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, firstname VARCHAR(20) NOT NULL,
		lastname VARCHAR(20) NOT NULL, email VARCHAR(50), reg_date TIMESTAMP)"; */

		$sql = "SELECT user_id, lastname, firstname FROM Users";
		$result = mysqli_query($conn, $sql);
//fetch a next row (as long as there are some) into $row
		while($row = mysqli_fetch_assoc($result)){
			printf("ID=%s %s (%s)<br>", $row["user_id"], $row["lastname"],$row["firstname"]);
		}
		echo "Fetched data successfully\n";
//free result set
		mysqli_free_result($result);
//close connection
		mysqli_close($conn);
	?>
</body>
</html>