PHP IC2_DataObject_BlackList::orderBy Exemples

Exemple #1

Fichier : ic2_viewtable.php Projet : unpush/p2-php

// {{{ 設定と消去
// 設定ファイル読み込み
$ini = ic2_loadconfig();
if (!isset($_REQUEST['table'])) {
    p2die('ImageCache2 - 不正なクエリ');
}
$mode = $_REQUEST['table'];
switch ($mode) {
    case 'errlog':
        $table = new IC2_DataObject_Errors();
        $table->orderBy('occured ASC');
        $title = 'エラーログ';
        break;
    case 'blacklist':
        $table = new IC2_DataObject_BlackList();
        $table->orderBy('uri ASC');
        $title = 'ブラックリスト';
        break;
    default:
        p2die('ImageCache2 - 不正なクエリ');
}
$db = $table->getDatabaseConnection();
if (isset($_POST['clean'])) {
    $sql = 'DELETE FROM ' . $db->quoteIdentifier($table->__table);
    $result = $db->query($sql);
    if (DB::isError($result)) {
        p2die($result->getMessage());
    }
} elseif (isset($_POST['delete']) && isset($_POST['target']) && is_array($_POST['target'])) {
    foreach ($_POST['target'] as $target) {
        $delete = clone $table;