PHP rexlist::setQuery 예제들

예제 #1

파일: index.inc.php 프로젝트: BackupTheBerlios/redaxo-addons

        }
    }
}
//------------------------------> Löschen
if ($func == "delete") {
    $query = "delete from rex_opf_lang where replacename= BINARY'" . $oname . "' ";
    $delsql = new sql();
    // $delsql->debugsql=0;
    $delsql->setQuery($query);
    $func = "";
    echo rex_opf_msg("Replace value deleted");
}
//------------------------------> Liste
//if($func == ""){
$sql = "select * from rex_opf_lang where rex_opf_lang.clang=" . $clang . " order by replacename";
$mit = new rexlist();
$mit->setQuery($sql);
$mit->setList(30);
$mit->setGlobalLink("index.php?page=" . $mypage . "&clang=" . $clang . "&next=");
$mit->setValue("id", "rex_opf_lang.id");
$mit->setLink("index.php?page=" . $mypage . "&clang=" . $clang . "&func=edit&oid=", "id");
$mit->setValue("Value", "rex_opf_lang.name");
$mit->setLink("index.php?page=" . $mypage . "&clang=" . $clang . "&func=edit&oid=", "id");
$mit->setValue("ReplaceValue", "rex_opf_lang.replacename");
$mit->addColumn("delete", "index.php?page=" . $mypage . "&clang=" . $clang . "&func=delete&oname=", "replacename", " onclick=\"return confirm('Delete ?');\"");
echo $mit->showall($next);
//}
include $REX[INCLUDE_PATH] . "/layout/bottom.php";
?>

예제 #2

파일: settings.inc.php 프로젝트: BackupTheBerlios/redaxo

    $form->setValue("subline", "Tabelleninformationen", "left", 0);
    $form->setValue("singleselect", "Name", "", 1, "SHOW TABLES", "Tables_in_redaxo2_7", "Tables_in_redaxo2_7");
    $form->setValue("text", "Bezeichnung", "tbl_label", 1);
    $form->setValue("text", "Primärschlüssel", "tbl_pk", 1);
    echo $form->showForm();
    echo "<br><br><a href=index.php?page=" . $page . "&subpage=" . $subpage . "><b>&laquo; Zurück zur Übersicht</b></a><br>";
}
//------------------------------> Shortcut löschen
if ($func == 'delete') {
    $query = 'DELETE FROM ' . TBL_GLOSSAR . ' WHERE short_id=' . $sid;
    $delsql = new sql();
    //    $delsql->debugsql=1;
    $delsql->setQuery($query);
    $func = '';
}
//------------------------------> Shortcutliste
if ($func == '') {
    $sql = 'SELECT * FROM ' . TBL_EXCEL_EXPORT_TBL . ' ORDER BY tbl_name';
    //        var_dump( $sql);
    $list = new rexlist();
    $list->setQuery($sql);
    // Spalten setzen
    $list->setValue("Bezeichnung", "tbl_label");
    $list->setLink("index.php?page=" . $page . "&subpage=" . $subpage . "&func=edit&tid=", "tbl_label");
    //    $list->setValue($I18N_GLOSSAR->msg('language'), "langname");
    //    $list->setValue($I18N_GLOSSAR->msg('description'), "description");
    //    $list->setValue($I18N_GLOSSAR->msg('casesensitivity'), "casesensitivity");
    $list->addColumn($I18N->msg('delete'), "index.php?page=" . $page . "&func=delete&sid=", "short_id", " onclick=\"return confirm('" . $I18N_GLOSSAR->msg("confirm_delete") . "');\"");
    echo $list->showall($next);
    echo "<br><br><a href=index.php?page=" . $page . "&subpage=" . $subpage . "&func=add><b>Tabelle hinzufügen</b></a><br>";
}