## The entire "departments-simple.php"

- https://cscie12.dce.harvard.edu/cgi/ext-courses/departments-simple.php

    <!DOCTYPE html>
    <html>
     <head>
      <title>Departments</title>
      <link rel="stylesheet" href="styles/site.css" />
     </head>
     <body>
    <h1>Harvard Extension School</h1>
    <h2>Departments</h2>

    <?php
    // use Dotenv to load database info from .env file
    // DB_HOST, DB_USER, DB_PW, DB_NAME
    require_once('vendor/autoload.php');
    $dotenv = Dotenv\Dotenv::createImmutable(__DIR__);
    $dotenv->safeLoad();

    // Connecting, selecting database
    $mysqli = new mysqli($_ENV['DB_HOST'],$_ENV['DB_USER'],$_ENV['DB_PW'],$_ENV['DB_NAME']);
    if ($mysqli->connect_errno) {
        echo "Failed to connect to mysql: ".$mysqli->connect_errno." ".$mysqli->connect_error;
    }

    // Performing SQL query
    $query = <<<ENDQUERY
    SELECT
        DISTINCT department, department_code
    FROM
        ext_courses
    ORDER BY
        department
    ENDQUERY;

    $result = $mysqli->query($query);

    // iterating through results
    echo "<ul>\n";
    while ($row = $result->fetch_assoc()) {
      echo "<li>";
        echo $row['department'];
        echo "</li>\n";
     }
    echo "</ul>\n";

    // cleanup query result and close connection
    $query_result->free();
    $mysqli->close();
    ?>

    <footer>
      <p>This is a learning example to demonstrate PHP and mysql for the courses CSCI E-12 and CSCI S-12 taught by David Heitmeyer.  <br/>
    The real <a href="https://courses.dce.harvard.edu/">Harvard Extension School course search</a> is at: <a href="https://courses.dce.harvard.edu/">courses.dce.harvard.edu</a></p>
    </footer>
     </body>
    </html>