<?php
header("Content-type: text/xml");

try {
  $dbh = new PDO('sqlite:/var/www/virtual.hosts/appro.mit.jyu.fi/sovellukset/vt/vt8/foo/taso1/user');
}
catch ( PDOException $e ) {
  print ( $e->getMessage() );
}

$kayttaja = $dbh->prepare('SELECT DomainID, DomainName FROM Domain');


print '<?xml version="1.0" encoding="ISO-8859-1"?><select xmlns="http://www.w3.org/1999/xhtml" name="domain" id="domain">';

if ( !$kayttaja ) {
//  print_r( $dbh->errorInfo() );
  print("<option>Tietokantavirhe</option>");
}


$ok = $kayttaja->execute();

if ( !$ok ) {
//  print_r( $kuviot->errorInfo() );
  print("<option>Tietokantavirhe</option>");
}

while ($rivi = $kayttaja->fetch(PDO::FETCH_ASSOC)) {
  print '<option value="' . $rivi["DomainID"] . '">' . $rivi["DomainName"] . "</option>";
}
print "</select>";
?>
