<?php
/**
 * Password lookup Webservice: takes in a username, website and password,
 * and stores that password for the user for later retrieval
 */

$db = new PDO("mysql:dbname=password_lookup;host=localhost;charset=utf8", "root", "");
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

header("Content-Type: application/json");
if (!isset($_POST["username"]) ||
    !isset($_POST["website"]) ||
    !isset($_POST["password"]))  {
    header("HTTP/1.1 Bad request");
    die("Yo, you need to provide us all your passwordz.  (And username, and a website)");
}

$username = $_POST["username"];
$website = $_POST["website"];
$password = $_POST["password"];

header("Content-Type: application/json");
try {
    $rowsAffected = $db->exec("
    INSERT INTO passwords
        (username, website, password)
    VALUES
        ('$username', '$website', '$password')    
    ");
    print(json_encode(['result' => 'success']));

} catch (PDOException $pdoex) {
    print(json_encode(['exception' => $pdoex]));
}