";
$rr = $_GET["rr"];
$cc = $_GET["cc"];
$ss = $_GET["ss"];
// Odstranenie SQL Injection
settype($rr, 'integer');
settype($cc, 'integer');
settype($ss, 'integer');
$actual = "./issues/" ."ISSUE_". $rr ."_". $cc .".txt";
$article = "./full/" ."KM_". $rr ."_". $cc ."_". $ss .".pdf"; // PDF-ak !!!
//echo $actual, "
";
echo "
| ";
echo "";
echo "VOLUME ", $rr;
echo " (", $rr+1962, "), ";
echo " Issue ", $cc;
// echo ", p. ", $ss;
// echo " - ", $db->f(strkon);
echo "";
echo "";
//, Date("F",$cc*2)" ",
echo " "; echo " |
";
$imgartic = "
";
$img_no = "
";
// if ( File_Exists ($actual) )
{
// definicia dB
// definicia dB
// MySQL_Connect("localhost","ummsoldo","kovmat157");
define("DATABASE_NAME","kovmat");
define("DATABASE_USER","ummsoldo");
define("DATABASE_PASSWORD","kovmat157");
define("DATABASE_HOST","");
require('./db_mysql.php');
$db = new DB_Sql();
$db->Database = DATABASE_NAME;
$db->User = DATABASE_USER;
$db->Password = DATABASE_PASSWORD;
$db->Host = DATABASE_HOST;
// koniec definicie
$db2 = new DB_Sql();
$db2->Database = DATABASE_NAME;
$db2->User = DATABASE_USER;
$db2->Password = DATABASE_PASSWORD;
$db2->Host = DATABASE_HOST;
// MySQL_Select_DB("kovmat");
?>
// podmienka $where = "where rocnik=".$rr." and cislo=".$cc." and strana=".$ss; $db->query("select * from clanky ".$where); //for($i=0;$i<$db->nf();$i++) { $db->next_record(); // echo "
| ";
echo "", $db->f('nazov'), " "; echo "", $db->f('autor'), " "; echo "vol. ", $db->f('rocnik'); echo " (", $rr+1962, "), "; echo "no. ", $db->f('cislo'), ", "; if ( $db->f('strkon') > 0 ) { // zatial neurcena echo "pp. ", $db->f('strana'); echo " - ", $db->f('strkon'); } $ss = $db->f('strana'); echo " "; echo " Abstract Key words "; List($aut1, $tmp) = Explode(",", $db->f('autor')); $article = $rr ."_". $cc ."_". $aut1 .".pdf"; // PDF-ak !!! $farticle = "./full/". $article; if ( ! File_Exists ($farticle) ) // +$ss { $article = $rr ."_". $cc ."_". $aut1 ."_". $ss .".pdf"; // PDF-ak !!! $farticle = "./full/". $article; } if ( File_Exists ($farticle) ) // velkost pdf-clanku { $size = FileSize ( $farticle )/1024; $isize = (int) $size; } if ($isize > 0) { // echo ""; echo ""; echo $imgartic, " Full text "; echo "(", $isize, " KB)"; // $isize = 0; // musim vynulovat } else { echo $img_no, " Full text "; echo "not available";} echo " "; } ?> // echo "Nasiel som ".$db->nf()." zaznam. "; // else {echo " neexistuje ...";} ?> |