ex3_1_libi

<!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 border=\"1\">";
    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>