|
Book Chapters:
@ $db = mysql_pconnect("sql.media.mit.edu", "mf", "used2bic");
if (!$db) {
echo "Error: Could not connect to database. Please try again later.";
exit;
}
$wherest = "";
$orderbyst = " ORDER BY date DESC";
$orderst = " ASC";
if ($desc) {
$orderst = " DESC";
}
if ($doctype) {
$wherest = " WHERE doctype='" . addslashes($doctype) . "'";
}
if ($order) {
$orderbyst = " ORDER BY " . addslashes($order) . $orderst;
}
mysql_select_db("mf");
$query = "SELECT id, title, author, DATE_FORMAT(date, '%M'), DATE_FORMAT(date, '%Y'), researchgroup FROM pubs WHERE author like '%Davenport%' and doctype like 'book'" . $orderbyst ;
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
for ($i=1; $i < $num_results+1; $i++) {
$row = mysql_fetch_row($result);
$id = htmlspecialchars( stripslashes($row[0]) );
$title = htmlspecialchars( stripslashes($row[1]) );
$author = htmlspecialchars( stripslashes($row[2]) );
$month = htmlspecialchars( stripslashes($row[3]) );
$year = htmlspecialchars( stripslashes($row[4]) );
$researchgroup = htmlspecialchars( stripslashes($row[5]) );
$date = $year;
if ($month) {
$date = $month . " " . $year;
}
echo " ";
echo "" . $title . " || $researchgroup";
echo " ";
echo " $author ";
echo " ";
echo " | ";
echo " $date";
echo " ";
}
?> |
Conference Proceedings:
@ $db = mysql_pconnect("sql.media.mit.edu", "mf", "used2bic");
if (!$db){
echo "Error: Could not connect to database. Please try again later.";
exit;
}
$wherest = "";
$orderbyst = " ORDER BY date DESC";
$orderst = " ASC";
if ($desc) {
$orderst = " DESC";
}
if ($doctype) {
$wherest = " WHERE doctype='" . addslashes($doctype) . "'";
}
if ($order) {
$orderbyst = " ORDER BY " . addslashes($order) . $orderst;
}
mysql_select_db("mf");
$query = "SELECT id, title, author, DATE_FORMAT(date, '%M'), DATE_FORMAT(date, '%Y'), researchgroup FROM pubs WHERE author LIKE '%Davenport%' and doctype like 'conference'" . $orderbyst;
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
for ($i=1; $i < $num_results+1; $i++) {
$row = mysql_fetch_row($result);
$id = htmlspecialchars( stripslashes($row[0]) );
$title = htmlspecialchars( stripslashes($row[1]) );
$author = htmlspecialchars( stripslashes($row[2]) );
$month = htmlspecialchars( stripslashes($row[3]) );
$year = htmlspecialchars( stripslashes($row[4]) );
$researchgroup = htmlspecialchars( stripslashes($row[5]) );
$date = $year;
if ($month) {
$date = $month . " " . $year;
}
echo " ";
echo "" . $title . " || $researchgroup";
echo " ";
echo " $author ";
echo " ";
echo " | ";
echo " $date";
echo " ";
}
?> |
Journal Articles:
@ $db = mysql_pconnect("sql.media.mit.edu", "mf", "used2bic");
if (!$db){
echo "Error: Could not connect to database. Please try again later.";
exit;
}
$wherest = "";
$orderbyst = " ORDER BY date DESC";
$orderst = " ASC";
if ($desc) {
$orderst = " DESC";
}
if ($doctype) {
$wherest = " WHERE doctype='" . addslashes($doctype) . "'";
}
if ($order) {
$orderbyst = " ORDER BY " . addslashes($order) . $orderst;
}
mysql_select_db("mf");
$query = "SELECT id, title, author, DATE_FORMAT(date, '%M'), DATE_FORMAT(date, '%Y'), researchgroup FROM pubs WHERE author like '%Davenport%' and doctype like 'journal'" . $orderbyst;
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
for ($i=1; $i < $num_results+1; $i++) {
$row = mysql_fetch_row($result);
$id = htmlspecialchars( stripslashes($row[0]) );
$title = htmlspecialchars( stripslashes($row[1]) );
$author = htmlspecialchars( stripslashes($row[2]) );
$month = htmlspecialchars( stripslashes($row[3]) );
$year = htmlspecialchars( stripslashes($row[4]) );
$researchgroup = htmlspecialchars( stripslashes($row[5]) );
$date = $year;
if ($month) {
$date = $month . " " . $year;
}
echo " ";
echo "" . $title . " || $researchgroup";
echo " ";
echo " $author ";
echo " ";
echo " | ";
echo " $date";
echo " ";
}
?> |
Technical Reports:
@ $db = mysql_pconnect("sql.media.mit.edu", "mf", "used2bic");
if (!$db)
{
echo "Error: Could not connect to database. Please try again later.";
exit;
}
$wherest = "";
$orderbyst = " ORDER BY date DESC";
$orderst = " ASC";
if ($desc) {
$orderst = " DESC";
}
if ($doctype) {
$wherest = " WHERE doctype='" . addslashes($doctype) . "'";
}
if ($order) {
$orderbyst = " ORDER BY " . addslashes($order) . $orderst;
}
mysql_select_db("mf");
$query = "SELECT id, title, author, DATE_FORMAT(date, '%M'), DATE_FORMAT(date, '%Y'), researchgroup FROM pubs WHERE author LIKE '%Davenport%' and doctype like 'techreport'". $orderbyst;
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
for ($i=1; $i < $num_results+1; $i++) {
$row = mysql_fetch_row($result);
$id = htmlspecialchars( stripslashes($row[0]) );
$title = htmlspecialchars( stripslashes($row[1]) );
$author = htmlspecialchars( stripslashes($row[2]) );
$month = htmlspecialchars( stripslashes($row[3]) );
$year = htmlspecialchars( stripslashes($row[4]) );
$researchgroup = htmlspecialchars( stripslashes($row[5]) );
$date = $year;
if ($month) {
$date = $month . " " . $year;
}
echo " ";
echo "" . $title . " || $researchgroup";
echo " ";
echo " $author ";
echo " ";
echo " | ";
echo " $date";
echo " ";
}
?> |
|
For more publications check the complete index
|
|
|
|
| |