Employee Information

<?php

    $dbhost = 'localhost';
    $dbuser = 'root';
    $dbpass = 'root';
    $dbname = 'employee';

    $conn = mysqli_connect( $dbhost, $dbuser, $dbpass, $dbname );

    if( !$conn ) {
        die('<h2>Error Estanblishing Database Connection: </h2>' . mysqli_connect_error() );
    }

    // Query
    $sql = "SELECT * FROM employee_information;";

    $query = mysqli_query($conn, $sql);

    $resultsCheck = mysqli_num_rows($query);

    if($resultsCheck > 0) {

        echo '<table border="1" style="border-collapse: collapse;">';

        while ( $row = mysqli_fetch_assoc($query) ) {
            echo '<tr>';
            echo '<td>ID: ' .$row['employee_id'] . '</td>';
            echo '<td>Name: ' .$row['employee_name'] . '</td>';
            echo '<td>Address: ' .$row['address'] . '</td>';
            echo '<td>Phone: ' .$row['phone_no'] . '</td>';
            echo '</tr>';
        }
        echo '</table>';

    } else {
        // if no information found
    }