hw3_roni

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>DBMS - HW3 - 314639402 - 312237639</title>
    <style>
        .center{
            display: block;
            margin-left: auto;
            margin-right: auto;
            width: 30%;
        }

        .textCenter{
            text-align: center;
        }
    </style>
</head>
<body style="background-color: lightseagreen;text-align: center">
<h1 style="text-align: center;font-family: 'Tahoma'">Welcome to the food survey</h1>
<p style="text-align: center;">This is Yael Kiselman and Roni Zaitsev's site. More generic description to come.</p>
<img src="img/eating.jpg" alt="We know how to alt tag in HTML!" class="center">
<br>
<a href="upload.php">Click here for form upload page</a> | <a href="fill.php" >Click here for form fill page</a>
<?php
$server = "tcp:techniondbcourse01.database.windows.net,1433";
$user = "roniza";
$pass = "Qwerty12!";
$database = "roniza";
$c = array("Database" => $database, "UID" => $user, "PWD" => $pass);
sqlsrv_configure('WarningsReturnAsErrors', 0);
$conn = sqlsrv_connect($server, $c);
if($conn === false)
{
    echo "error";
    die(print_r(sqlsrv_errors(), true));
}
//  echo "<center>";
echo "<table class='center'>";
echo "<tr><th>Sports</th><th>Average GPA</th><th>Average Weight</th></tr>";
$sql = "SELECT sport , AVG (F.GPA) as Average GPA, AVG (F.weight) as Average Weight FROM Food WHERE F.coffee = 2 and F.comfort_food = 'chocolate' GROUP BY sport";
$result=sqlsrv_query($conn,$sql);
while($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC))
{
    echo "<tr><td>".$row['sport']."</td><td>".$row['Average GPA']."</td><td>".$row['Average Weight']."</td></tr>";

}
echo "</table>"
//    echo "</center>";
?>

</body>
</html>