<?php
    $db = new PDO("mysql:dbname=password_lookup;host=localhost;charset=utf8", "root", "");
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    if (!isset($_GET["username"])) {
        header("HTTP/1.1 400 bad request");
        die("You need to specify the username");
    }
    $username = $_GET["username"];
    $resultSet = $db->query("SELECT * from passwords WHERE username = '$username'");

    $jsonData = [];
    foreach ($resultSet as $row) {
        $passwordRow = [
            "username" => $row["username"],
            "password" => $row["password"],
            "website" => $row["website"],
        ];
        $jsonData[]= $passwordRow;
        //array_push($jsonData, $passwordRow);
    }
    
    print(json_encode($jsonData));