<?php

/*
Template Name: MyTemplate
*/

get_header();

    $ServerName = "localhost";
    $Username = "root";
    $Password = "";
    $DatabaseName = "employeedatabase";

    $conn = @mysqli_connect($ServerName,$Username,$Password,$DatabaseName) or die("Connection Failed.....Try again");

    $SelectData = "select * from employeeregistration";
    $Result = $conn->query($SelectData);

    echo $Result->num_rows;

    if($Result->num_rows>0)
    {
        echo "<table style='width:100%;border:1px solid grey'>";
        while($row = $Result->fetch_assoc())
        {
            echo "<tr>";
            echo "<td style='border:1px solid grey'>" . $row['EmployeeID'] . "</td>";
            echo "<td style='border:1px solid grey'>" . $row['EmployeeName'] . "</td>";
            echo "<td style='border:1px solid grey'>" . $row['EmployeeDept'] . "</td>";
            echo "<td style='border:1px solid grey'>" . $row['EmployeeSalary'] . "</td>";
            echo "</tr>";
        }
        echo "</table>";
    }
$conn->close();

get_footer();

?>