getMessage() );
}
$dbh->beginTransaction();
$kayttaja = $dbh->prepare('INSERT INTO User
(UserName, Domain_DomainID)
VALUES (:user, :domain)');
if ( !$kayttaja ) {
// print_r( $dbh->errorInfo() );
print("
");
}
$user = $_REQUEST['sposti'];
$domain = $_REQUEST['domain'];
$friends = $_REQUEST['kaveri'];
$kayttaja->bindParam(":user", $user);
$kayttaja->bindParam(":domain", $domain);
$ok = $kayttaja->execute();
$d = $dbh->prepare('SELECT DomainName From Domain WHERE DomainID = :domain');
$d->bindParam(":domain", $domain);
$ok2 = $d->execute();
while($row = $d->fetch(PDO::FETCH_ASSOC)) {
$domain = $row['DomainName'];
}
$lastid = $dbh->lastInsertId();
$virhe = false;
$d = $dbh->prepare('INSERT INTO Friend (UserId, FriendId) VALUES (:user, :friend)');
foreach($friends as $key => $arvo) {
$d->bindParam(":user", $lastid);
$d->bindParam(":friend", $arvo);
if ( !$d->execute() ) $virhe = true;
}
if ( !$ok || !$ok2 || $virhe) {
// print_r( $kayttaja->errorInfo() );
print("Tunnuksen " . $user . "@" . $domain . " lisääminen epäonnistui!");
$dbh->rollBack();
}
else {
print("
Tunnus " . $user . "@" . $domain . " on lisätty!
");
if ( $friends.length ) {
$apu = "";
foreach($friends as $key => $arvo) {
if ( $apu.length > 0 ) $apu = $apu . "," . $arvo;
else $apu = $arvo;
}
$d = $dbh->prepare("SELECT UserName, DomainName FROM User, Domain WHERE UserID IN ( $apu ) AND User.Domain_DomainId = Domain.DomainID");
if ( !$d->execute() ) {
print "
Kaverien lisääminen epäonnistui
";
$dbh->rollBack();
}
else {
print "
Kaverit
";
while($row = $d->fetch(PDO::FETCH_ASSOC)) {
print "- " . $row['UserName'] . "@" . $row['DomainName'] . "
";
}
print "
";
$dbh->commit();
}
}
}
?>