<?php

include ("brett.inc");
include ("htmllib.inc");

if (!isset($action))
  {
  $action=ACTION_DEFAULT;
  }

$link = mysql_connect ("localhost", "uebung", "secret");
if ($link && mysql_select_db("brett_db"))
{  
print html_begin("Formular","marginwidth=\"0\" marginheigh=\"0\" leftmargin=\"0\" topmargin=\"0\" bgcolor=\"silver\"");
print table("border=0 cellspacing=0 cellpadding=0 width=\"100%\"");
switch ($action)
  {
  case ACTION_DEFAULT:
	print form(ACTION_SAVE, "brett.php3", "");
	print tr("");
		print td("height=\"20\" bgcolor=\"black\" colspan=\"3\" align=\"center\"","");
		$link=sprintf("brett.php3?action=%d",ACTION_DEFAULT);
		print a($link);
		print font("color=\"white\""); 
		print "Anlegen"; print etag("a");
		print "&nbsp;&nbsp;&nbsp;";
		$link=sprintf("brett.php3?action=%d",ACTION_SEARCH);
		print a($link);
		print font("color=\"white\""); 
		print "Suchen"; print etag("a");
		print etag("td");
	print etag("tr");

	print tr("");
		print td("height=\"50\" width=\"120\"","");
		print img("grafik/logo.gif", "height=\"74\" width=\"100\"");
		print etag("td");
		print td("width=\"250\"","");
		print ("&nbsp;");
		print etag("td");
		print td("","");
		print ("&nbsp;");
		print etag("td");
	print etag("tr");

	print tr("");
		print td("","");
		print ("&nbsp;");
		print etag("td");
		print td("", "") . stdfont(). "Name" . etag("font") . etag("td");
		print td("", input("text", "user", "", "size=40") ) . etag("td");
	print etag("tr");
	print tr("");
		print td("","");
		print ("&nbsp;");
		print etag("td");
		print td("", "") . stdfont(). "Betreff" . etag("font") . etag("td");
		print td("", input("text", "subject", "", "size=40") ) . etag("td");
	print etag("tr");
	print tr("");
		print td("valign=\"top\"","");
		print ("&nbsp;");
		print etag("td");
		print td("valign=\"top\"", "") . stdfont(). "Beschreibung" . etag("font") . etag("td");
		print td("", textarea("descript", "Inhalt", "cols=30 rows=10") ) . etag("td");
	print etag("tr");
	print tr("");
		print td("","");
		print ("&nbsp;");
		print etag("td");
		print td("", "") . stdfont(). "Wertung" . etag("font") . etag("td");
		print td("",""); 
		print stdfont();
		print ("1");
		print input ("radio", "rated", "1", "");		
		print stdfont();
		print ("2");
		print input ("radio", "rated", "2", "checked");		
		print stdfont();
		print ("3");
		print input ("radio", "rated", "3", "");		
		print etag("td");
	print etag("tr");


	print tr("");
		print td("","");
		print ("&nbsp;");
		print etag("td");
		print td("","");
		print ("&nbsp;");
		print etag("td");
		print td("", input("submit", "button", "Absenden", "")). etag("td");
	print etag("tr");
	print etag("form");
	
	break;

  case ACTION_SEARCH:
		print form(ACTION_DISPLAY, "brett.php3", "");
		print tr("");
			print td("height=\"20\" bgcolor=\"black\" colspan=\"3\" align=\"center\"","");
			$link=sprintf("brett.php3?action=%d",ACTION_DEFAULT);
			print a($link);
			print font("color=\"white\""); 
			print "Anlegen"; print etag("a");
			print "&nbsp;&nbsp;&nbsp;";
			$link=sprintf("brett.php3?action=%d",ACTION_SEARCH);
			print a($link);
			print font("color=\"white\""); 
			print "Suchen"; print etag("a");
			print etag("td");
		print etag("tr");
	
		print tr("");
			print td("height=\"50\" width=\"120\"","");
			print img("grafik/logo.gif", "height=\"74\" width=\"100\"");
			print etag("td");
			print td("width=\"250\"","");
			print ("&nbsp;");
			print etag("td");
			print td("","");
			print ("&nbsp;");
			print etag("td");
		print etag("tr");
	
		print tr("");
			print td("","");
			print ("&nbsp;");
			print etag("td");
			print td("", "") . stdfont(). "Name" . etag("font") . etag("td");
			print td("", input("text", "user", "", "size=40") ) . etag("td");
		print etag("tr");
		print tr("");
			print td("","");
			print ("&nbsp;");
			print etag("td");
			print td("", "") . stdfont(). "Betreff" . etag("font") . etag("td");
			print td("", input("text", "subject", "", "size=40") ) . etag("td");
		print etag("tr");
		print tr("");
			print td("","");
			print ("&nbsp;");
			print etag("td");
			print td("","");
			print ("&nbsp;");
			print etag("td");
			print td("", input("submit", "button", "Absenden", "")). etag("td");
		print etag("tr");
		print etag("form");
       break;

  case ACTION_SAVE:
	   $record[0] = $user;
	   $record[1] = $subject;
	   $record[2] = $descript;
	   $record[3] = $rated;
		 
	   $query = sprintf ("INSERT INTO inhalt (name, subject, descript, rated) VALUES (\"%s\",\"%s\",\"%s\",%d)", $record[0], $record[1], $record[2], $record[3]);

	   if (!mysql_query ($query))
		   die ("FEHLER! Eingabe in Inhalt Erfolglos!!");
 	   else
	       print "Danke f&uuml;r die Teilnahme";
	   break;

  case ACTION_DISPLAY:
	   print tr("");
	   print td("height=\"20\" bgcolor=\"black\" colspan=\"3\" align=\"center\"","");


	   $link=sprintf("brett.php3?action=%d",ACTION_DEFAULT);
	   print a($link);
	   print font("color=\"white\""); 
	   print "Anlegen"; print etag("a");
	   print "&nbsp;&nbsp;&nbsp;";
	   $link=sprintf("brett.php3?action=%d",ACTION_SEARCH);
	   print a($link);
	   print font("color=\"white\""); 
	   print "Suchen"; print etag("a");
	   print etag("td");
	   print etag("tr"); 
	   print tr("");
	   print td("colspan=\"3\" align=\"center\"","");
	   print h("1","","Ergebnis:");
	   print etag("td");
	   print etag("tr");
	   print tr("");
	   print td("colspan=\"3\"","");

	   if ((strlen($user) == 0) && (strlen($subject) == 0))
		   {
		   print "Bitte machen Sie eine Angabe";
		   break;
		   }
	   
	   $search = "";
	   if (strlen($user) != 0)
	     {
	     $search = sprintf("name=\"%s\"", $user);
         }
	   if (strlen($subject) != 0)
		 {
		 if (strlen($user) == 0)
		   {
		   $search = sprintf("subject=\"%s\"", $subject);
		   }
		 else
		   {
		   $search = sprintf("%s AND subject=\"%s\"", $search, $subject);
		   } 
		 }
	   
       #print $search . "<br>";
	   $query = sprintf("SELECT * FROM inhalt WHERE %s", $search);
	   $result = mysql_query ($query);
	   while($row = mysql_fetch_array($result))
  	   {
		   print a(sprintf("brett.php3?action=%d&id=%s", ACTION_VIEW, $row[id]));		
		   print $row[subject] . "<br>" . etag("a");
		   print $row[rated] . "<br>";
		   print "<hr>";
	   }
	   mysql_free_result ($result);
	   print etag("td");
	   print etag("tr");


	   break;

  case ACTION_VIEW:
	   print tr("");
			print td("height=\"20\" bgcolor=\"black\" colspan=\"3\" align=\"center\"","");
			$link=sprintf("brett.php3?action=%d",ACTION_DEFAULT);
			print a($link);
			print font("color=\"white\""); 
			print "Anlegen"; print etag("a");
			print "&nbsp;&nbsp;&nbsp;";
			$link=sprintf("brett.php3?action=%d",ACTION_SEARCH);
			print a($link);
			print font("color=\"white\""); 
			print "Suchen"; print etag("a");
			print etag("td");
	   print etag("tr"); 
	   print tr("");
	   print td("colspan=\"3\" align=\"center\"","");
	   print h("1","","Ihre Auswahl:");
	   print etag("td");
	   print etag("tr");
	   print tr("");
	   print td("colspan=\"3\"","");

	   $query = sprintf("SELECT * FROM inhalt where id=%d", $id);
	   $result = mysql_query ($query);
	   $row = mysql_fetch_array($result);
	   print "Name: " . $row[1] . "<br>";
	   print "Betreff: " . $row[2] . "<br>";
	   print "Beschreibung: <br>" . $row[3] . "<br>";
	   print "Wertung: " . $row[4] . "<br>";
	   mysql_free_result ($result);
	   print etag("td");
	   print etag("tr"); 
	   break;
	 
  }  
#Fusszeile
	print tr("");
		print td("colspan=\"3\" bgcolor=\"black\"","");
		print ("&nbsp;");
		print etag("td");
	print etag("tr");
	print etag("table");

print html_end();
}
else
{
print "failed to open Database";
}
?>