<?php 

$servername = "rs08";
$database = "wl3a_Luke";
$username = "wl3a";
$password_db = "AWC_TLEVEL123!"; 

$conn = mysqli_connect($servername, $username,$password_db,$database);

if(!$conn){
    die("Connection failed: ". mysqli_connect_error());
}

$sql_check =  "SELECT jobTitle, COUNT(*) AS employeeCount, SUM(hourlyWage) AS totalWages, AVG(hourlyWage) 
AS averageWage, MIN(hourlyWage) AS minWage, MAX(hourlyWage) AS maxWage FROM Personal GROUP BY jobTitle"; 

$stmt = mysqli_prepare($conn, $sql_check); 

mysqli_stmt_bind_param($stmt, "ss", $sql_check);

$result = mysqli_stmt_get_result($stmt); 


if (mysqli_num_rows($result) > 0) {
    $row = mysqli_fetch_assoc($result); 
    echo $row;
}




?>