"") {$ki = $ki .', ' ; };
return $ki;
}
//tex karaktereket unicode-ra cserel
//function te_ca( $be ) {
//$ki=$be;
//$a=chr(195).chr(169);
//$trans = array("{\'a}" => "á","{\'e}" => "é","{\H o}" => "ő","{\'o}" => "ó",
// "$a" => "xxxx");
//$kii= strtr($ki, $trans);
//return $kii;
//}
function te_ca( $be ) {
$ki=$be;
return $ki;
}
//$listaban kivalasztott queryt megjeleniti
function out_list($result) {
echo "
";
$i=0;
if (mysql_num_rows($result) > 0)
{
// iterate over record set
// print each field
while($row = mysql_fetch_assoc($result))
{
//print_r ($row);
$author=te_ca($row['author']);
$title=te_ca($row['title']);
$url=$row['url'];
$type=$row['type'];
$author_str=au_au($author);
//$author_str=au_au($author);
if ($url <> "") {$title_str = ' '. $title . ', '; };
if ($url == "") {$title_str = ' '. $title . ', '; };
if ($i==0) {echo '- '; $i=1; } else
{echo '
- '; $i=0; };
if ($type == "article") {
echo $author_str .' ' ;
echo $title_str .' ' ;
$rest= sepa($row['journal']) .' '. sepa($row['volume'] .'(' . $row['year'] .') ') .
sepa($row['pages'] ) . sepa($row['note'] ) ;
$j=strrpos($rest,",");
$rest=substr($rest,0, $j ) . ".";
echo $rest;
};
if ($type == "incollection") {
echo $author_str .' ' ;
echo $title_str .' ' ;
$rest= te_ca(sepa($row['booktitle'])) .' '. sepa($row['pages']) . ' ' .
sepa($row['series']) .' ' . sepa($row['volume']) .' ' . sepa($row['publisher']) .' ' .
sepa($row['year']) .' ' . sepa($row['note']);
$j=strrpos($rest,",");
$rest=te_ca(substr($rest,0, $j )) . ".";
echo $rest;
};
if ($type == "misc") {
echo $author_str .' ' ;
echo $title_str .' ' ;
$rest= sepa($row['year']) .' '. te_ca(sepa($row['note']));
$j=strrpos($rest,",");
$rest=substr($rest,0, $j ) . ".";
echo $rest;
};
echo '
' ;
echo '
';
}
echo '
';
}
else
{
// print error message
echo 'No rows found!';
}
}
$connection = mysql_connect('mysql', 'soukupprivate', 'SoukupSecret') or die ('Unable to connect!');
// select database for use
mysql_select_db('soukupprivate') or die ('Unable to select database!');
// create and execute query
mysql_set_charset('utf8');
$query = 'SELECT * FROM full_publications WHERE status <> \'Note\' ORDER BY year ';
$result = mysql_query($query) or die ('Error in query: $query. ' . mysql_error());
out_list($result);
echo '
Notes
';
$query = 'SELECT * FROM full_publications WHERE status = \'Note\' ORDER BY year ';
$result = mysql_query($query) or die ('Error in query: $query. ' . mysql_error());
out_list($result);
echo '
';
// once processing is complete
// free result set
mysql_free_result($result);
// close connection to MySQL server
mysql_close($connection);
?>