$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 == 3) { $headarray = array("AttributID", "Attributname", "Attribut Kurztext", "Attribut Langtext", "Atribut ist Text"); $atable->a(0, 1, $headarray, "attribute", "AID,ANAME,KURZTEXT,LANGTEXT,ISTEXT", ""); } ?> <div id='anzeige2'></div> </body> </html>