index.php (98f6610) - kvs-php.git · David Blume's GitList

index.php

<?php
require('config.php');
header("Content-Type: text/plain");
try {
    $db = new PDO('sqlite:store.db');
    $db->exec('create table if not exists keys(k varchar(80) primary key, 
               v varchar(140), created integer, updated integer, origin varchar(16));');
} catch(PDOException $e) {
    echo 'Exception : '.$e->getMessage();
    exit(0);
}

if (isset($_GET['k'])) {
    // This is a request to get one specific value.
    $keys = array_map(array($db, 'quote'), explode(',', $_GET['k']));
    $result = $db->query('select v from keys where k in ('.implode(',', $keys).') 
                          order by updated desc limit 1;', PDO::FETCH_ASSOC);
    foreach($result as $row) {
        echo $row['v'];
    }
    exit(0);
} elseif (isset($_POST['auth'])) {
    if ($_POST['auth'] != $authorization) {
        echo "Not authorized.\n";
        exit(0);
    }

// We have an authorized request to add or update a key/value pair.
    $stmt = $db->prepare('select k from keys where k=?');
    foreach ($_POST as $key => $value) {
        if ($key == 'auth') {
            continue;
        }
        $stmt->bindParam(1, $key, PDO::PARAM_STR);
        $stmt->execute();
        $row = $stmt->fetch(PDO::FETCH_ASSOC);
        if(!$row) {
            $db->exec('insert into keys (k, v, created, updated, origin) values ('.
                       $db->quote($key).', '.$db->quote($value).', '.
                       $_SERVER['REQUEST_TIME'].', '.$_SERVER['REQUEST_TIME'].', '.
                       $db->quote($_SERVER['REMOTE_ADDR']).');');
        } else {
            $db->exec('update keys set v = '.$db->quote($value).', updated = '.$_SERVER['REQUEST_TIME'].
                      ', origin = '.$db->quote($_SERVER['REMOTE_ADDR']).' where k = '.$db->quote($key).';');
        }
        if ($db->errorCode() != '00000') {
            echo "Error:", $db->errorInfo()[2], "\n";
        } else {
            echo 'OK';
        }
    }
    exit(0);
}
$headers = array("key        ","value       ","created     ","updated     ","origin      ");
echo implode("\t", $headers)."\n";
$headers = array("-----------","------------","------------","------------","------------");
echo implode("\t", $headers)."\n";
$result = $db->query('select * from keys', PDO::FETCH_ASSOC);
foreach($result as $row) {
    // print_r( $row );
    $row['k'] = str_pad($row['k'], 12);
    $row['v'] = str_pad($row['v'], 12);
    $row['created'] = date('Y-m-d', $row['created']);
    echo implode("\t", $row)."\n";
}
?>

kvs-php.git

Replace tabs with spaces for more consistent preview.