Help getting my code to work

Website Building
#1

Hi, I’m currently building a website to display a database from 000webhost, I can connect fine but it doesn’t return any of the values I wish it to. Could someone look at my below code to see what I’m doing wrong? I’m not great with PHP yet so it has me stumped. Thanks

<?php
    //Step 1
	$servername = "localhost";
	$username = "id760726_john";
	$password = "";
	$database = "id760726_devproject2017";

echo "Connected successfully";
	
    
	
	$result = mysqli_query($db, "SELECT * FROM patients");
	
	echo "<table border = 5>";
		echo "<tr>";
			echo "<th>ID</th>
			<th>Patient name</th>
			<th>Check in date</th>
			<th>Room number</th>
			<th>Bed number</th>
			<th>Notes</th>";
		echo "</tr>";
	
	
	while($row = mysqli_fetch_array($result)){
		echo "<tr>";
			echo "<td>" . $row['id'] . "</td>";
			echo "<td>" . $row['patient_name'] . "</td>";
			echo "<td>" . $row['check_in_date'] . "</td>";
			echo "<td>" . $row['room_number'] . "<td>";
			echo "<td>" . $row['bed_number'] . "</td>";
			echo "<td>" . $row['notes'] . "</td>";
		echo "</tr>";
	}
	echo "</table>";
    mysqli_close($db);
		
		
        
?>
#2

what is the error that you have got ?

#3

There is no mysqli_connect so your script never connects to database

#4

Nothing from my database appears on the website

#5

Hi, where should I put this line? I’m new to PHP and not very good, thank you for the response

#6

try this tutorial