示例#1
0
<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) {
示例#3
0
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");