예제 #1
0
$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>