header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-cache, must-revalidate");
header("Pragma: no-cache");
extract($_POST); extract($_GET);extract($_SERVER);
?>
CVWW'06 Abstract
$sqlserver = "localhost";
$sqluser = "cprw2000";
$sqlpassword = "useradd";
$dbname="CPRW2000";
$sql = mysql_connect($sqlserver,$sqluser,$sqlpassword);
#$GLOBALS["id"] = 76;
if ($sql) {
if (mysql_select_db($dbname)) {
$result=mysql_query($select);
if(!mysql_affected_rows()){
print "Submission's database is empty\n";
}
else{
$select = "SELECT s.Title AS Title, s.Abstract AS Abstract, s.ID_submission AS Sid,a1.Name AS Author1, a2.Name AS Author2, a3.Name AS Author3, a1.First_name AS AuthorF1, a2.First_name AS AuthorF2, a3.First_name AS AuthorF3 FROM Submission AS s LEFT JOIN Author AS a1 ON s.ID_author_1 = a1.ID_author LEFT JOIN Author AS a2 ON s.ID_author_2 = a2.ID_author LEFT JOIN Author AS a3 ON s.ID_author_3 = a3.ID_author WHERE s.ID_submission = '$id'";
$result=mysql_query($select);
if(mysql_affected_rows()){
$row = mysql_fetch_array($result);
mysql_free_result($result);
$author="$row[AuthorF1] $row[Author1]";
if ($row[Author2]) { $author="$author, $row[AuthorF2] $row[Author2]";}
if ($row[Author3]) { $author="$author, $row[AuthorF3] $row[Author3]";}
print "$author: $row[Title]
\n";
$row[Abstract] = stripslashes($row[Abstract]);
print "Abstract:\n";
}
}
}
else {
echo "Databáze: ".$dbname." se nepodařila otevřít
";
echo mysql_errno().": ".mysql_error()."
";
}
mysql_close($sql);
} else {
print "Spojení s SQL serverem se nepodařilo otevřít\n";
echo mysql_errno().": ".mysql_error()."
";
}
?>