<?php include './header.html'; ?>

<h1>Abstracts of Poster/Demos and Invited Talks</h1>

<?php
include './admin/mystri_config.php';

if (!isset($query)) { $query = ''; }

if ($query == '') {

	$my_query = 'SELECT title, abstract_id, authors, type FROM ' . $db_tables[0]; 

} else {

	echo '<p>Search results for: <em>' . $query . '</em></p>';
	$my_query = 'SELECT title, abstract_id, authors, type, MATCH (title,abstract) AGAINST ("' . $query . '") AS score FROM ' . $db_tables[0] . ' WHERE MATCH (title,abstract) AGAINST ("' . $query . '") ORDER BY score DESC';

}

$mysql_conn = mysql_pconnect($db_host, $db_user, $db_password);
mysql_select_db($db_database);

$res = mysql_query($my_query, $mysql_conn);

if (mysql_num_rows($res) < 1) {

?>

<p><strong>Search Results</strong></p>

<p>No matching results found.</p>


<?php

} else {

	$talk_array = array();
	$demo_array = array();
	$workshop_array = array();
	$row = array();
	
	while ($row = mysql_fetch_array($res)) {
	
		if ($row['type'] == 'Poster/Demo') {
			$demo_array[] = '<a href="abstract_detail.php?id=' . $row['abstract_id'] . '">' . $row['title'] . '</a><br>' . $row['authors'];
		}
	
		if ($row['type'] == 'Invited Talk') {
			$talk_array[] = '<a href="abstract_detail.php?id=' . $row['abstract_id'] . '">' . $row['title'] . '</a><br>' . $row['authors'];
		}
	
		if ($row['type'] == 'Workshop') {
			$workshop_array[] = '<a href="abstract_detail.php?id=' . $row['abstract_id'] . '">' . $row['title'] . '</a><br>' . $row['authors'];
		}
	
	}
	
	if (count($talk_array) > 0) {
	
	echo '
	<p><strong>Invited Talks</strong></p>
	
	<ul>
	<li>' , implode("</li>\n<li>", $talk_array) , '</li>
	</ul>';
	
	}
	
	if (count($demo_array) > 0) {
	
	echo '
	<p><strong>Posters / Demos</strong></p>
	
	<ul>
	<li>' , implode("</li>\n<li>", $demo_array) , '</li>
	</ul>';
	
	}
	
	if (count($workshop_array) > 0) {
	
	echo '
	<p><strong>Workshops</strong></p>
	
	<ul>
	<li>' , implode("</li>\n<li>", $workshop_array) , '</li>
	</ul>';
	
	}

}?>


<p><strong>Search Abstracts</strong></p>

<form action="abstracts_list.php" method="get">

<p><input type="text" name="query" value=""> <input type="submit" value="Search"></p>

</form>


<?php include './footer.html'; ?>