<?php
header('Content-type: text/plain; charset=ISO-8859-1');

require('kanta.php');

$url = $_REQUEST["url"];
$channel = $_REQUEST["channel"];

 print $url . "\n";
 print $hlo;
 print $channel . "\n";

$sql = $dbh->prepare('
INSERT INTO Read (UserId, link, channel) VALUES (:user, :link, :channel)
');
/*
CREATE TABLE Read (
UserID VARCHAR(16) NOT NULL,
link VARCHAR(1024) NOT NULL,
CONSTRAINT Read_PK PRIMARY KEY (UserId, link),
CONSTRAINT Read_FK FOREIGN KEY (link)
REFERENCES Item (link)
);
*/

if ( !$sql ) {
  print_r( $dbh->errorInfo() );
  print("tietokantavirhe");
}


$sql->bindParam(":user", $hlo); 
$sql->bindParam(":link", $url); 
$sql->bindParam(":channel", $channel); 

$ok = $sql->execute();

if ( !$ok ) {
  print_r( $sql->errorInfo() );
  print("SQL-suorituksessa tapahtui virhe.");
} 
else {
  echo "ok";
}

?>