<html> <head> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> </head> <body> <script type="text/javascript" src="scripts.js"></script> <?php include './function.php'; $table = new table(); $atable = new atable(); $abfrage = new db(); $text = new text(); $methode = $_GET['tmet']; if ($methode == 1) { $border = 1; $tableheadarray = array($text->view("Objektnummer"), $text->view("Kategorie"), $text->view("Aktionen")); $table->start($border); $table->head($tableheadarray); $abfrage2 = $sql->prepare("\n\t\t\tSELECT objekt.OID,kategorie.KNAME,attribute.ANAME,objatt.TVALUE,objatt.NVALUE FROM objekt \n\t\t\tINNER JOIN kategorie ON objekt.KID=kategorie.KID\n\t\t\tINNER JOIN objatt ON objatt.OID=objekt.OID\n\t\t\tINNER JOIN attribute ON objatt.AID=attribute.AID\n\t\t\t\n\t\t\t"); $sqlobj = $abfrage->select_i("objekt.OID,KNAME", "objekt", "kategorie", "KID", "KID"); while ($erg = $sqlobj->fetch()) { $buttons1 = "<button onclick='anzeige(" . '"form.php?fmet=4&objid=' . $erg[0] . '"' . ")'>Objekt Bearbeiten</button>"; array_push($erg, $buttons1); $table->row($erg); } $table->end(); } if ($methode == 2) { $headarray = array("KategorieID", "Kategoriename", "Kategorie Kurztext", "Kategorie Langtext"); $atable->a(0, 1, $headarray, "kategorie", "KID,KNAME,KURZTEXT,LANGTEXT", ""); }
} if ($methode == 2) { #Zweite methode Attribute $atname = $_POST['atname']; $atkurz = $_POST['atkurz']; $atlang = $_POST['atlang']; $aistext = $_POST['aistext']; $att->neu($atname, $atkurz, $atlang, $aistext); $form->start("POST", "index.php"); $form->end($text->view_nq("zuindex")); } if ($methode == 3) { #Dritte methode Objekt einfügen $KID = $_POST['katid']; $objid = $obj->neu($KID); echo $text->view("NeuesObjektErstellt"); echo $objid; $form->start("POST", "./form.php?fmet=4"); $form->hidden("objid", "{$objid}"); $form->end("Objekt Attribute Bearbeiten"); } if ($methode == 4) { #vierte methode Objekt bearbeiten $objid = $_POST['objid']; $objkat = $obj->obj_kat($objid); $katatt = $kat->attribute_zu_kategorie($objkat); while ($erg = $katatt->fetch()) { $AID = $erg[1]; $istext = $att->is_text($AID); $formvalue = $_POST[$AID]; if ($formvalue != NULL) {
include './function.php'; #Initalisiere Klassen #Initalisiere Text $text = new text(); #Initalisiere Form $form = new form(); #Initalisiere SQL $abfrage = new db(); #Erfasse Methode $methode = $_GET['fmet']; #Anzeige Formulare if ($methode == 1) { #Formular für eine neue Kategorie #Texte aus XML holen $text_katname = $text->view("FormKatname"); $text_katkurz = $text->view("FormKatkurz"); $text_katlang = $text->view("FormKatlang"); $form->start("POST", "./formaction.php?fmet={$methode}"); $form->textf_2($text_katname, "katname"); $form->textf_2($text_katkurz, "katkurz"); $form->textf_2($text_katlang, "katlang"); $form->end("Senden"); } if ($methode == 2) { #Formular für neue Attribute #Texte aus XML holen $text_atname = $text->view("FormAtname"); $text_atkurz = $text->view("FormAtkurz"); $text_atlang = $text->view("FormAtlang"); $text_aistext = $text->view("FormAtIsText");