<?php

  if(!isset($_POST['value'])) {
    print 'ERROR: No POST data.';
    return;
  }

  $data = $_POST['value'];

  try {
    $db = new PDO('sqlite:live.sqlite');
    $db->beginTransaction();
    $q = $db->prepare('UPDATE data SET txt=(SELECT txt FROM data WHERE idx=2) where idx=3');
    $q->execute();
    $q = $db->prepare('UPDATE data SET txt=(SELECT txt FROM data WHERE idx=1) where idx=2');
    $q->execute();
    $q = $db->prepare('UPDATE data SET txt=:txt WHERE idx=1');
    $q->execute(array(':txt' => addslashes($data)));
    $db->commit();
  } catch(PDOException $e) {
    die;
  }

?>