Untitled

<?php
    //1. Create a database connection
    $dbhost = "localhost";
    $dbuser = "root";
    $dbpass = "";
    $dbname = "test";
    $connection = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);

    //Showing error in case of failed connection
    if(mysqli_connect_errno()){
        die(
            "Database connection failed: ".mysqli_connect_error()." (".mysqli_connect_errno().")"
           );
    }
?>

<?php
    //2. Perform Database Query
    $query = "SELECT * FROM subjects";
    $result = mysqli_query($connection, $query);

    //Test if there is a query error
    if(!$result){
        die("Database Query Failed");
    }
?>

<html>
<head>
    <title>PHP MySQL Database</title>
</head>
<body>
    <?php
        //3. User returned Data (if any)
        while($row = mysqli_fetch_row($result)){
            //output data from each row
            var_dump();
            echo "<hr/>";
        }
    ?>

    <?php
        //4. Release the returned data
        mysqli_close($connection);
    ?>
</body>
</html>

<?php
    //5. Close database connection
    mysqli_close($connection);
?>