|
|
\n";
}
}
function build_search_clause($keyword_str, $search_type) {
$retval = "1 = 0";
if($search_type == "abstitle") {
$keyword_arr = preg_split("/\s+/", $keyword_str);
if(count($keyword_arr) > 0) {
$retval = "";
foreach($keyword_arr as $kw) {
$retval = add_clause($retval, "UPPER(p.title || ' ' || p.abstract_text) LIKE UPPER('%$kw%')", " AND ");
}
}
}
else {
$keyword_arr = preg_split("/,/", $keyword_str);
if($search_type == "keywords") {
if(count($keyword_arr) > 0) {
$retval = "";
foreach($keyword_arr as $kw) {
$retval = add_clause($retval, "UPPER(pk.keywords) LIKE UPPER('%" . trim($kw) . "%')", " OR ");
}
}
}
else {
if(count($keyword_arr) > 0) {
$retval = "";
foreach($keyword_arr as $kw) {
$kw = trim($kw);
$name_parts = preg_split("/\s+/", $kw);
$last_name = "";
if(count($name_parts) > 1) {
$last_name = array_pop($name_parts);
$first_name = implode(" ", $name_parts);
}
else {
$first_name = array_pop($name_parts);
}
if(strlen($last_name) < 1) {
$last_name = $first_name;
$retval = add_clause($retval, "(UPPER(a.givenname) LIKE UPPER('%$first_name%') OR UPPER(a.familyname) LIKE UPPER('%$last_name%'))", " OR ");
explode_high_ascii($last_name);
}
else {
$retval = add_clause($retval, "(UPPER(a.givenname) LIKE UPPER('%$first_name%') AND UPPER(a.familyname) LIKE UPPER('%$last_name%'))", " OR ");
explode_high_ascii($last_name);
}
}
}
}
}
return "($retval)";
}
function process_results($resultarr) {
global $CONN;
$result_count = 0;
foreach($resultarr as $result) {
$ses_id = $result["ses_id"];
$paper_id = $result["paperid"];
$sesinfo["ses_id"] = $result["ses_id"];
$sesinfo["ses_room"] = $result["ses_room"];
$sesinfo["ses_type"] = $result["ses_type"];
$sesinfo["ses_title"] = $result["ses_title"];
$sesinfo["chair1"] = $result["chair1"];
$sesinfo["chair2"] = $result["chair2"];
$sesinfo["date"] = $result["date"];
$sesinfo["time"] = $result["time"];
$sesinfo["room"] = $result["room"];
$date = preg_replace('/\s+,/',',',$sesinfo["date"]);
$starttime = $sesinfo["time"];
list($hour,$min) = explode(":", $starttime);
$endhour = $hour+2;
$endtime = implode(":", array($endhour,$min));
$min_inc = 20;
$ses_no = $result["ses_no"];
$result_count++;
?>
| " valign="top">
|
" valign="top" width="15%">
Session: -
Date:
= 60) {
$hour_add = (int)(($min+$min_add) / 60);
$min_add = -$min + ($min+$min_add) % 60;
}
$ptime = sprintf("%02d:%02d", $hour + $hour_add, $min + $min_add);
echo "Time: $ptime
";
}
else
echo "Time: $starttime - $endtime
";
?>
Room:
Type:
Poster #: $result[ses_order]
\n";
?>
.PDF">View paper
| ">
";
e($a_row["affiliation"]);
print "
";
}
?>
Keywords:
0) ? $result["keywords"] : "";
e($paper_keywords);
?>
|
No matches for \"$search\".";
}
}
$f_keywords = isset($_GET["keywords"]) ? $_GET["keywords"] : "";
$f_abstitle = isset($_GET["abstitle"]) ? $_GET["abstitle"] : "";
$f_authors = isset($_GET["authors"]) ? $_GET["authors"] : "";
?>
INTERSPEECH 2006 PAPER SEARCH
|
";
$results = dbQueryGet($q, $CONN);
?>
|
|
|
|
