Untitled

<?php
    //Step 1
    $db = mysqli_connect('172.24.1.64', 'root', '', 'hospital') or die('Error connecting to MySQL server.');
    $dbhost = "localhost";
    $dbuser = "root";
    $dbpass = "";
    $dbname = "hospital";
    $db = mysqli_connect($dbhost, $dbuser, $dbpass) or die("dbconn");
    mysql_select_db($dbname, $db) or die("mysql");
?>

<html>
    <head>
    </head>
    <body>
        <h1>
            PHP connect to MySQL
        </h1>
        <?php
            //Step 2
            $query = "SELECT * FROM patients;";
            mysqli_query($db, $query) or die('Error querying database.');

            $result = mysqli_query($db, $query);
            $row = mysqli_fetch_array($result);

            while($row = mysqli_fetch_array($result)){
                $id = $row['id'];
                $patientname = $row['patient_name'];
                $checkindate = $row['check_in_date'];
                $roomnumber = $row['room_number'];
                $bednumber = $row['bed_number'];
                $notes = $notes['notes'];
                echo "$id $patientname $checkindate $roomnumber $bednumber $notes";
            }
        ?>
    </body>
</html>