University of California, Irvine (UCI)
School of Information and Computer Sciences (ICS)
Center for Machine Learning and Intelligent Systems (CML)
AI in Science Institute (AI-Science)
Institute for Genomics and Bioinformatics (IGB)
connect_error) {
//die("Connection failed: " . $conn->connect_error);
//}
//$query = "SELECT DISTINCT year FROM publications ORDER BY year DESC";
// old below
//$year_result = mysql_query($query,$db);
$check = new mysqli_connect("dover-2.ics.uci.edu:3306", "baldi_reader", "letmein", "baldi_cv_testing");
if ($check -> connect_error) {
die("Connection failed: " . $check->connect_error);
echo "Connect Error \n";
}
$query = "SELECT DISTINCT year FROM publications ORDER BY year DESC";
$year_result = mysqli_query($check,$query);
//print '
';
// need to change
//while($year = mysql_fetch_row($year_result))
//{
//printf('%s ', $year[0],$year[0],$year[0]);
//}
foreach($year_result as $year) {
$string = implode(", ", $year);
echo "$string
\n";
};
print '';
//$check = mysqli_connect("dover-2.ics.uci.edu:3306", "baldi_reader", "letmein", "baldi_cv_testing");
$query = "SELECT id,title,authors,journal,pdf_filename,volume,edition,series,editors,publisher,location,pages,month,year,category FROM publications ORDER BY year DESC, category DESC";
$result = mysqli_connect($check,$query);
$alternate = 1;
while ($myrow = mysqli_fetch_row($result))
{
if($currentYear != $myrow[13])
{
printf('
');
$alternate+=1;
}
// Check if there is an html URL to link to
//if (!empty($myrow[15])){
//Print Publication info
// printf('%s%s%s %s', $myrow[15],$myrow[1],$myrow[2],$myrow[3],$formated_data); //html_link,title,authors,journal,pdf
//}else{
//Print Publication info
printf('%s%s%s %s', $myrow[1],$myrow[2],$myrow[3],$formated_data); //title,authors,journal,pdf
//}
//Print out a link for a bib file, which is actually built on the fly
printf("", $myrow[0]); //id
//Print out the link of the pdf file, if it exists
if(!empty($myrow[4]))
printf("", $myrow[0]); //id
//Close up this section
print "
";
} //END while
?>
Deep Learning
';
while($year = mysql_fetch_row($year_result2))
{
printf('%s ', $year[0],$year[0],$year[0]);
}
print '';
$query = "SELECT
id,title,authors,journal,pdf_filename,volume,edition,series,editors,publisher,location,pages,month,year,category FROM publications WHERE
general_category='deep' OR general_category='neuro' ORDER BY year DESC, category DESC";
$result=mysql_query($query,$db);
$alternate = 1;
while ($myrow = mysql_fetch_row($result))
{
if($currentYear != $myrow[13])
{
printf('
');
$alternate+=1;
}
// Check if there is an html URL to link to
//if (!empty($myrow[15])){
//Print Publication info
// printf('%s%s
// %s %s', $myrow[15],$myrow[1],$myrow[2],$myrow[3],$formated_data);
// //html_link,title,authors,journal,pdf
//}else{
//Print Publication info
printf('%s%s%s %s',
$myrow[1],$myrow[2],$myrow[3],$formated_data); //title,authors,journal,pdf
//}
//Print out a link for a bib file, which is actually built on the fly
printf("", $myrow[0]); //id
//Print out the link of the pdf file, if it exists
if(!empty($myrow[4]))
printf("", $myrow[0]); //id
//Close up this section
print "
";
} //END while
?>
Nueroscence
';
while($year = mysql_fetch_row($year_result2))
{
printf('%s ', $year[0],$year[0],$year[0]);
}
print '';
$query = "SELECT
id,title,authors,journal,pdf_filename,volume,edition,series,editors,publisher,location,pages,month,year,category FROM publications WHERE
general_category='neuro' ORDER BY year DESC, category DESC";
$result=mysql_query($query,$db);
$alternate = 1;
while ($myrow = mysql_fetch_row($result))
{
if($currentYear != $myrow[13])
{
printf('
');
$alternate+=1;
}
// Check if there is an html URL to link to
//if (!empty($myrow[15])){
//Print Publication info
// printf('%s%s
// %s %s', $myrow[15],$myrow[1],$myrow[2],$myrow[3],$formated_data);
// //html_link,title,authors,journal,pdf
//}else{
//Print Publication info
printf('%s%s%s %s',
$myrow[1],$myrow[2],$myrow[3],$formated_data); //title,authors,journal,pdf
//}
//Print out a link for a bib file, which is actually built on the fly
printf("", $myrow[0]); //id
//Print out the link of the pdf file, if it exists
if(!empty($myrow[4]))
printf("", $myrow[0]); //id
//Close up this section
print "
