Magnetic diagnostic bibliography

<HTML>
<HEAD>
	<TITLE>Magnetic Diagnostic Bibliography</TITLE>
</HEAD>
<BODY>
<FORM METHOD="post">
<H1>
	Magnetic Diagnostic Bibliography
</H1>
<SCRIPT LANGUAGE="php">
if ($_POST['Username']) {
	echo "<INPUT TYPE=hidden NAME=Username VALUE=".$_POST['Username'].">";
	echo "<INPUT TYPE=hidden NAME=Password VALUE=".$_POST['Password'].">";
	mysql_connect("crppibm2.epfl.ch",$_POST['Username'],$_POST['Password']);
	mysql_select_db("magrefs");
	$s = "SELECT Author,Title,Journal,Year,Volume,Page,Device,Topic,PdfURL FROM magrefs WHERE 1";
	if ($_POST['AuthorSel']) { $s .= " AND Author  LIKE \"%" . $_POST['AuthorSel']  ."%\""; }
	if ($_POST['TitleSel'])  { $s .= " AND Title   LIKE \"%" . $_POST['TitleSel']   ."%\""; }
	if ($_POST['JournalSel']){ $s .= " AND Journal LIKE \"%" . $_POST['JournalSel'] ."%\""; }
	if ($_POST['YearSel'])   { $s .= " AND Year    =       " . $_POST['YearSel']          ; }
	if ($_POST['DeviceSel']) { $s .= " AND Device  LIKE \"%" . $_POST['DeviceSel']  ."%\""; }
	if ($_POST['TopicSel'])  { $s .= " AND Topic   LIKE \"%" . $_POST['TopicSel']   ."%\""; }
	if ($_POST['Order'])     { $s .= " ORDER BY ".$_POST['Order']; }
	$q=mysql_query($s);
} else {
	echo "<P>Username: <INPUT TYPE=text NAME=Username> Password: <INPUT TYPE=password NAME=Password><INPUT TYPE=submit VALUE=Login></P>";
	exit;
}
</SCRIPT>
<P>	
	Report errors and comments to <A HREF=mailto:jean-marc.moret@epfl.ch>Jean-Marc Moret</A>.
	Display order: <SELECT NAME=Order>
		<OPTION VALUE="Year DESC,Author" SELECTED>  Most recent
		<OPTION VALUE="Author,Year">                Author
		<OPTION VALUE="Topic,Year DESC">            Topic
		<OPTION VALUE="Device,Year DESC">           Device
	</SELECT>
</P>
<TABLE WIDTH=100% BORDER=1>
	<THEAD>
		<TR>
			<TH>Author</TH>
			<TH>Title</TH>
			<TH>Journal</TH>
			<TH>Year</TH>
			<TH>Volume</TH>
			<TH>Page</TH>
			<TH>Device</TH>
			<TH>Topic</TH>
			<TH>pdf</TH>
		</TR>
	</THEAD>
	<TBODY>
		<TR>
			<TD><INPUT TYPE="TEXT" NAME="AuthorSel"></TD>
			<TD><INPUT TYPE="TEXT" NAME="TitleSel"></TD>
			<TD><INPUT TYPE="TEXT" NAME="JournalSel"></TD>
			<TD><INPUT TYPE="TEXT" NAME="YearSel" SIZE="5"></TD>
			<TD><BR></TD>
			<TD><BR></TD>
			<TD><INPUT TYPE="TEXT" NAME="DeviceSel" SIZE="10"></TD>
			<TD><INPUT TYPE="TEXT" NAME="TopicSel"></TD>
			<TD><INPUT TYPE="SUBMIT" VALUE="Search"></TD>
		</TR>
		<SCRIPT LANGUAGE="php">
			if ($q) {
				$k=0;
				while ($r=mysql_fetch_array($q)) {
					if ($k) {
						echo "<TR BGCOLOR=ffff88>";
					} else {
						echo "<TR BGCOLOR=ffffff>";
					}
					$k = 1 - $k;
					echo "<TD>".$r["Author"] ."<BR></TD>";
					echo "<TD>".$r["Title"]  ."<BR></TD>";
					echo "<TD>".$r["Journal"]."<BR></TD>";
					echo "<TD>".$r["Year"]   ."<BR></TD>";
					echo "<TD>".$r["Volume"] ."<BR></TD>";
					echo "<TD>".$r["Page"]   ."<BR></TD>";
					echo "<TD>".$r["Device"] ."<BR></TD>";
					echo "<TD>".$r["Topic"]  ."<BR></TD>";
					if ($r["PdfURL"]) {
						echo "<TD><A HREF=\"".$r["PdfURL"]."\">pdf<BR></A></TD>";
					} else {
						echo "<TD><BR></TD>";
					}
				}
			} else {
				echo "<P><FONT COLOR=FF0000>Error in querry: ".$s."</FONT></P>";
			}
		</SCRIPT>
	</TBODY>
</TABLE>
</FORM>
</BODY>
</HTML>