<?php
ini_set('display_errors', '1');

$user = 'cs108';
$pass = '108';

$db = new PDO('mysql:host=localhost;dbname=cs108', $user, $pass);
$db->query("SET NAMES utf8");


$option = $_POST['option'];
if ($option == 'add') {
    $descr  = $_POST['descr'];
    $user   = $_POST['user'];
    $pass   = $_POST['pass'];
    $note   = $_POST['note'];
    $addkey = $_POST['addkey'];

    $sql_text = "INSERT INTO passwords (descr, user, pass, note, addkey) VALUES (?, ?, ?, ?, ?)";
    $st = $db->prepare($sql_text);
    $st->execute(array($descr, $user, $pass, $note, $addkey));
} else if ($option == 'del') {
    $descr  = $_POST['descr'];
    $user   = $_POST['user'];
    $pass   = $_POST['pass'];
    $note   = $_POST['note'];
    $addkey = $_POST['addkey'];

    $sql_text = "DELETE FROM passwords WHERE (descr = ?) AND (user = ?) AND (pass = ?) AND (note = ?) AND (addkey = ?)";
    $st = $db->prepare($sql_text);
    $st->execute(array($descr, $user, $pass, $note, $addkey));
} else if ($option == 'POSTPass') {
    $addkey = $_POST['addkey'];

    $sql_text = "SELECT descr, user, pass, note FROM passwords WHERE addkey=?";
    $st = $db->prepare($sql_text);
    $st->execute(array($addkey));
    while ($row = $st->fetch()) {
        echo $row["descr"].";".$row["user"].";".$row["pass"].";".$row["note"]."\n";
    }
}
?>