include("includes/db_connect.php");
include("includes/header.php");
// req 0: by year, 1: by title, 2: by type
// type 1: journal 2: proceeding 3: tr 4: thesis
$req = 0;
if(isset($_GET['req'])) {
$req = $_GET['req'];
}
?>
Hakim Weatherspoon
Publications
function printByTitle($q)
{
printPapers($q);
}
function printByYear($q)
{
while($row = mysql_fetch_array($q)) {
$year = $row['year'];
echo "
$year
\n";
$query = "SELECT * FROM Publications WHERE year=$year ORDER BY year DESC, month DESC";
$q2 = mysql_query($query) or die('Error, selection failed');
printPapers($q2);
echo "
\n";
}
}
function printByType($q)
{
while($row = mysql_fetch_array($q)) {
$type = $row['Type'];
printType($type);
$query = "SELECT * FROM Publications WHERE type=$type ORDER BY year DESC, month DESC";
$q2 = mysql_query($query) or die('Error, selection failed');
printPapers($q2);
echo "
\n";
}
}
function printByProject($q)
{
while($row = mysql_fetch_array($q)) {
$category=$row['Name'];
$subarea=$row['Subareas'];
echo "
$category
\n";
if ($subarea != '') {
$tok = strtok($subarea, ",");
while( $tok !== false) {
echo "
$tok
\n";
printPapersByProject(trim($tok));
$tok = strtok(",");
}
} else
printPapersByProject($category);
echo "
";
// $prj = $row['Project'];
// echo "
$prj
";
// $query = "SELECT * FROM Publications WHERE Project='$prj' ORDER BY Title";
// $q2 = mysql_query($query) or die('Error, selection failed');
// printPapers($q2);
// echo "
\n";
}
}
function printPapersByProject($category)
{
$query = "SELECT * FROM Projects, Publications WHERE Projects.Name = Publications.Project AND Projects.Category='$category' ORDER BY Publications.Year DESC";
$q = mysql_query($query) or die('Error, selection failed');
printPapers($q);
}
function printPapers($q)
{
echo "
";
while($row = mysql_fetch_array($q)) {
$title=$row['Title'];
$auths = $row['Authors'];
$book = $row['Booktitle'];
$type = $row['Type'];
$fname= $row['pdf'];
$year=$row['year'];
$pub = $row['published'];
$misc = $row['misc'];
$abst = $row['abstract'];
$id = $row['ID'];
echo "
-
";
if ($fname != "") echo "
";
echo "$title";
if ($fname != "") echo "
";
echo ", $auths, ";
if ($type < 3) {
echo $pub==0 ? "To Appear in ": "Appears in ";
echo $book;
echo $misc=="" ? "." : ", ".$misc.".";
} else if ($type==3){
echo "Technical Report, ";
echo $book;
echo $misc=="" ? "." : ", ".$misc.".";
} else {
echo "PhD Thesis";
}
if ($row['Best'] == 1) {
echo "
Best Paper Award";
}
echo "";
echo "
\n";
echo "
\n";
}
echo "
";
}
function printType($p)
{
if($p == 1)
echo "
Journal Papers
\n";
else if($p == 2)
echo "
Referred Papers
\n";
else if($p == 3)
echo "
Technical Report
\n";
else if($p == 4)
echo "
Thesis
\n";
}
function genQuery($r)
{
switch ($r) {
case 0:
return "SELECT DISTINCT year FROM Publications ORDER BY year DESC";
case 1:
return "SELECT * FROM Publications ORDER BY Title";
case 2:
return "SELECT DISTINCT Type FROM Publications ORDER BY Type, year DESC";
case 3:
// return "SELECT DISTINCT Project FROM Publications WHERE Project IS NOT NULL ORDER BY Year DESC, Project";
return "SELECT * FROM ResearchArea where Active=1 order by ord";
default:
exit();
}
}
?>
$query = genQuery(0);
$q = mysql_query($query) or die('Error, selection failed');
printByYear($q);
?>
$query = genQuery(1);
$q = mysql_query($query) or die('Error, selection failed');
printByTitle($q);
?>
$query = genQuery(2);
$q = mysql_query($query) or die('Error, selection failed');
printByType($q);
?>
$query = genQuery(3);
$q = mysql_query($query) or die('Error, selection failed');
printByProject($q);
?>
include("includes/footer.php");
?>