openConnection(); function generateHtml($id, $title, $img, $desc, $url) { $prj_icon=""; if ($id==NULL) { if (strlen($url)==0) $prj_icon = ""; else { $prj_icon = ""; $prj_icon .= "
"; } } else { $prj_icon = ""; $prj_icon .= "
"; } $desc = strlen($desc) > 700? substr($desc, 0, 700)."...":$desc; $html = <<

{$title}

{$prj_icon}
{$desc}
HTML; return $html; } ?>
PhD Digital Media "; $res = $db->query("SELECT * FROM `project` WHERE `date` >= '2007-08-01' ORDER BY `date` DESC;"); while($row = $db->fetchAssoc($res)){ $prjs_html .= generateHtml(empty($row["folder"])?NULL:$row["id"], $row["long_title"], $row["thumbnail"], $row["short_desc"], $row["website"]); } $prjs_html .= "
"; echo tidyHTML($prjs_html); $prjs_html = "

MS Human Computer Interaction

"; $res = $db->query("SELECT * FROM `project` WHERE `date` >= '2005-08-01' AND `date` < '2007-08-01' ORDER BY `date` DESC;"); while($row = $db->fetchAssoc($res)){ $prjs_html .= generateHtml(empty($row["folder"])?NULL:$row["id"], $row["long_title"], $row["thumbnail"], $row["short_desc"], $row["website"]); } $prjs_html .= "
"; echo tidyHTML($prjs_html); $prjs_html = "

Software Development

"; $res = $db->query("SELECT * FROM `project` WHERE `date` >= '2002-07-01' AND `date` < '2005-08-01' ORDER BY `date` DESC;"); while($row = $db->fetchAssoc($res)){ $prjs_html .= generateHtml(empty($row["folder"])?NULL:$row["id"], $row["long_title"], $row["thumbnail"], $row["short_desc"], $row["website"]); } $prjs_html .= "
"; echo tidyHTML($prjs_html); $prjs_html = "

MS Electrical Engineering

"; $res = $db->query("SELECT * FROM `project` WHERE `date` >= '2000-09-01' AND `date` < '2002-07-01' ORDER BY `date` DESC;"); while($row = $db->fetchAssoc($res)){ $prjs_html .= generateHtml(empty($row["folder"])?NULL:$row["id"], $row["long_title"], $row["thumbnail"], $row["short_desc"], $row["website"]); } $prjs_html .= "
"; echo tidyHTML($prjs_html); /* $prjs_html = "

Second Lieutenant

"; $res = $db->query("SELECT * FROM `project` WHERE `date` >= '1997-07-15' AND `date` < '1999-06-20' ORDER BY `date` DESC;"); while($row = $db->fetchAssoc($res)){ $prjs_html .= generateHtml(empty($row["folder"])?NULL:$row["id"], $row["long_title"], $row["thumbnail"], $row["short_desc"], $row["website"]); } $prjs_html .= "
"; echo tidyHTML($prjs_html); */ ?>