query_edit PHP 코드 예제들

예제 #1

0

파일 보기

파일: os.php 프로젝트: aim-web-projects/ann-cosme

 }
 //ソート
 arsort($main[$k], SORT_NUMERIC);
 $tmp = "";
 $i = 0;
 foreach ($main[$k] as $k2 => $v2) {
     if ($k2 == "total") {
         continue;
     }
     //link
     if ($k == $tmp) {
         $link = "&nbsp;";
     } else {
         //icon
         $icon = isset($icon_path[strtolower($k)]) ? set_img($icondir . $icon_path[strtolower($k)], $k) . "&nbsp;" : set_img($icondir . "none.gif", $k) . "&nbsp;";
         $link = $icon . sel_link(query_edit("sel", $k), $k);
     }
     $tmp = $k;
     echo '<tr id="bg_id' . $k . $i . '" onmouseover="chBG(\'bg_id' . $k . $i . '\', 1);" onmouseout="chBG(\'bg_id' . $k . $i . '\', 0);">';
     echo '<td>&nbsp;' . $link . '&nbsp;</td>';
     echo '<td>&nbsp;' . $k2 . '&nbsp;</td>';
     echo '<td align="right">&nbsp;' . $v2 . '&nbsp;</td>';
     echo '<td>&nbsp;' . mk_graph($v2, $main["total"], $max_val) . '&nbsp;</td>';
     echo '</tr>' . "\n";
     $i++;
 }
 //合計
 echo '<tr>';
 echo '<td class="bg_total">&nbsp;</td>';
 echo '<td class="bg_total" align="right">&nbsp;<b>合計：</b>&nbsp;</td>';
 echo '<td class="bg_total" align="right">&nbsp;<b>' . $main[$k]["total"] . '</b>&nbsp;</td>';

예제 #2

0

파일 보기

파일: navi.php 프로젝트: aim-web-projects/ann-cosme

/* メニュー表示                            */
/*=========================================*/
if ($menu_act) {
    foreach ($menu_act as $v) {
        if (trim($v) == "") {
            continue;
        }
        unset($menu);
        if (eregi("^\\[.+.]\$", $v)) {
            //トップ項目
            $menu["top"] = eregi_replace("^\\[(.+)]\$", "\\1", $v);
            $navi .= '<li class="list_title">' . $menu["top"] . '</li>';
        } else {
            //アクション
            list($menu["act"], $menu["name"]) = explode("||", $v);
            $navi .= '<li><a href="w3a.php' . query_edit("act", $menu["act"]) . '" target="_top">' . $menu["name"] . '</a></li>' . "\n";
        }
    }
    //管理メニュー追加
    if ($adm) {
        $navi .= '<li class="list_title">管理</li>';
        $navi .= '<li><a href="info.php">ログ情報一覧</a></li>' . "\n" . '<li><a href="setting.php">設定変更</a></li>' . "\n";
    }
}
/*=========================================*/
/* 管理メニュー表示                        */
/*=========================================*/
if ($userauth_flg == "2") {
    $navi .= <<<EOM
<li class="list_title">ログアウト</li>
<li><a href="w3a.php?logout" target="_top">ログアウトする</a></li>

예제 #3

0

파일 보기

파일: time.php 프로젝트: aim-web-projects/ann-cosme

    echo '<div id="time_w">';
    echo '<table border="0" cellpadding="0" cellspacing="0">';
    echo '<tr align="center" valign="bottom">' . $tmp["main"] . '</tr>';
    echo '<tr>' . $tmp["time"] . '</tr>';
    echo '</table>';
    echo '</div>';
} else {
    echo '<table>';
    echo '<tr>';
    echo '<th nowrap>時間</th>';
    echo '<th nowrap>ユニーク</th>';
    echo '<th nowrap>件数</th>';
    echo '<th nowrap>グラフ</th>';
    echo '</tr>';
    for ($i = 0; $i < 24; $i++) {
        //ユニーク値
        $uniq = intval($uniqs[$i]);
        if (!$uniq) {
            $uniq = 0;
        }
        //link
        $link = sel_link(query_edit("sel", $i), $i);
        echo '<tr id="bg_id' . $i . '" onmouseover="chBG(\'bg_id' . $i . '\', 1);" onmouseout="chBG(\'bg_id' . $i . '\', 0);">';
        echo '<td align="right">&nbsp;' . $link . '&nbsp;</td>';
        echo '<td align="right">&nbsp;<font color="#0000FF">' . $uniq . '</font>&nbsp;</td>';
        echo '<td align="right">&nbsp;<font color="#FF0000">' . $main[$i] . '</font>&nbsp;</td>';
        echo '<td align="left">&nbsp;' . mk_graph2($main[$i], $main, $uniq, $uniqs, $max_val) . '&nbsp;</td>';
        echo '</tr>';
    }
    echo '</table>';
}

예제 #4

0

파일 보기

파일: track.php 프로젝트: aim-web-projects/ann-cosme

        } else {
            $view = $v["ch"] ? $v["ch"] : $k;
        }
        echo '<option value="' . $k . '">' . $view . ' （' . $v["c"] . '）</option>';
    }
    echo '</select>';
    echo '&nbsp;<input value="　　送信　　" type="submit">';
    echo '</form><br>';
}
/*=========================================*/
/* メイン処理                              */
/*=========================================*/
if ($main) {
    //タイトル
    if ($send_sel) {
        echo "\n" . '<form action="w3a.php' . query_edit("act", "id_name") . '" method="POST">' . '追跡ユーザー［&nbsp;<b>' . $send_sel_ch . '</b>&nbsp;］' . ':&nbsp;<input type=text name="name" size=10 value="">&nbsp;' . '<input type=submit value="ID変換">' . '<input type="hidden" name="id" value="' . $send_sel . '">' . '<input type="hidden" name="mode" value="new">' . '</form>' . '<hr size="1">';
    }
    //日付初期化
    $track_day = "";
    //タイムアウト秒化
    $time_out = $time_out * 60;
    //基準時間初期化
    $def_time = 0;
    //処理開始
    foreach ($main as $track) {
        //UNIXタイムスタンプに変換
        $unix_time = $now_y . '-' . $now_m . '-' . $track["day"] . ' ' . $track["hour"] . ":" . $track["minute"] . ":" . $track["sec"];
        $unix_time = strtotime($unix_time);
        if (!$def_time) {
            $def_time = $unix_time;
        }

예제 #5

0

파일 보기

파일: calendar.php 프로젝트: aim-web-projects/ann-cosme

$now_day = query_edit("ym", "DELETE");
$now_day = query_edit("d", date("d"), $now_day);
for ($i = 0; $i < $wday; $i++) {
    // Blank
    $cal .= "<td class=\"cal_blank\">&nbsp;</td>\n";
}
$day = 1;
while (checkdate($m_num, $day, $year)) {
    //データ存在チェック
    $flg = false;
    $q = "";
    foreach ($dataflgs as $k => $v) {
        if ($k == $day) {
            //リンク作成
            $q = query_edit("ym", sprintf("%4d%02d", $year, $m_num));
            $q = query_edit("d", sprintf("%02d", $day), $q);
            $link = "w3a.php" . $q;
            $flg = true;
            break;
        }
    }
    $value = $flg ? "<a href={$link} target=\"_top\" class=\"cal_a\">" . $day . "</a>" : $day;
    if ($_GET["d"] == "all") {
        //  All
        $cal .= "<td class=\"cal_sel\">{$value}</td>\n";
    } elseif ($day == $today[mday] && $m_num == $today[mon] && $year == $today[year]) {
        //  Today
        $cal .= "<td class=\"cal_sel\">{$value}</td>\n";
    } elseif ($wday == 0) {
        //  Sunday
        $cal .= "<td class=\"cal_sun\">{$value}</td>\n";

예제 #6

0

파일 보기

파일: keyword.php 프로젝트: aim-web-projects/ann-cosme

/*=========================================*/
/* メイン処理                              */
/*=========================================*/
if (count($main)) {
    //ソート
    arsort($main, SORT_NUMERIC);
    echo '<table>';
    echo '<tr>';
    echo '<th nowrap>キーワード</th>';
    echo '<th nowrap>件数</th>';
    echo '<th nowrap>グラフ</th>';
    echo '</tr>';
    $i = 0;
    foreach ($main as $k => $v) {
        //link
        $link = sel_link(query_edit("sel", $k), $k);
        echo '<tr id="bg_id' . $i . '" onmouseover="chBG(\'bg_id' . $i . '\', 1);" onmouseout="chBG(\'bg_id' . $i . '\', 0);">';
        echo '<td>&nbsp;' . $link . '&nbsp;</td>';
        echo '<td align="right">&nbsp;<font color="#FF0000">' . $v . '</font>&nbsp;</td>';
        echo '<td>&nbsp;' . mk_graph($v, array_sum($main), max($main)) . '&nbsp;</td>';
        echo '</tr>';
        $i++;
    }
    //合計
    echo '<tr>';
    echo '<td class="bg_total" align="right">&nbsp;<b>合計：</b>&nbsp;</td>';
    echo '<td class="bg_total" align="right">&nbsp;<b>' . @array_sum($main) . '</b>&nbsp;</td>';
    echo '<td class="bg_total">&nbsp;</td>';
    echo '</tr>' . "\n";
    echo '</table>';
} else {

예제 #7

0

파일 보기

파일: isp.php 프로젝트: aim-web-projects/ann-cosme

arsort($main, SORT_NUMERIC);
echo '<table>';
echo '<tr>';
echo '<th nowrap>ISP</th>';
echo '<th nowrap>件数</th>';
echo '<th nowrap>グラフ</th>';
echo '</tr>';
$i = 0;
foreach ($main as $k => $v) {
    $tmp["name"] = ereg_replace('(.+)(\\|\\|)(.+)', "\\1", $k);
    if (ereg('(.+)(\\|\\|)(.+)', $k, $regs)) {
        $tmp["com"] = "<br>&nbsp;(" . $regs[3] . ")";
    } else {
        $tmp["com"] = "";
    }
    //link
    $link = sel_link(query_edit("sel", $tmp["name"]), $tmp["name"]) . $tmp["com"];
    echo '<tr id="bg_id' . $i . '" onmouseover="chBG(\'bg_id' . $i . '\', 1);" onmouseout="chBG(\'bg_id' . $i . '\', 0);">';
    echo '<td>&nbsp;' . $link . '&nbsp;</td>';
    echo '<td align="right">&nbsp;<font color="#FF0000">' . $v . '</font>&nbsp;</td>';
    echo '<td>&nbsp;' . mk_graph($v, array_sum($main), max($main)) . '&nbsp;</td>';
    echo '</tr>';
    $i++;
}
//合計
echo '<tr>';
echo '<td class="bg_total" align="right">&nbsp;<b>合計：</b>&nbsp;</td>';
echo '<td class="bg_total" align="right">&nbsp;<b>' . @array_sum($main) . '</b>&nbsp;</td>';
echo '<td class="bg_total">&nbsp;</td>';
echo '</tr>' . "\n";
echo '</table>';

예제 #8

0

파일 보기

파일: id_name.php 프로젝트: aim-web-projects/ann-cosme

if ($_POST["edit_id"]) {
    echo '<hr size=1><form action="w3a.php?' . $_SERVER[QUERY_STRING] . '" method="POST">';
    echo '[編集]&nbsp;ID:&nbsp;<b>' . $_POST["edit_id"] . '</b>&nbsp;&nbsp;';
    echo 'Name:&nbsp;<input type=text name="name" size=20 value="' . $ch_id[$_POST["edit_id"]] . '">&nbsp;&nbsp;';
    echo '<input type=submit value="編集を実行">';
    echo '<input type="hidden" name="id" value="' . $_POST["edit_id"] . '">';
    echo '<input type="hidden" name="mode" value="edit">';
    echo '</form>';
}
if ($ch_id) {
    echo '<br>';
    echo '<table>';
    echo '<tr>';
    echo '<th nowrap>ID</th>';
    echo '<th nowrap>変換名</th>';
    echo '<th nowrap>編集</th>';
    echo '<th nowrap>削除</th>';
    echo '</tr>';
    foreach ($ch_id as $k => $v) {
        $link = query_edit("act", "track");
        $link = query_edit("sel", $k, $link);
        $link = set_img(TRACKMARK) . "&nbsp;" . '<a href="' . FILENAME . $link . '" target="_top">' . $k . '</a>';
        echo '<tr id="bg_id' . $k . '" onmouseover="chBG(\'bg_id' . $k . '\', 1);" onmouseout="chBG(\'bg_id' . $k . '\', 0);">';
        echo '<td nowrap>' . $link . '</td>';
        echo '<td nowrap>' . $v . '</td>';
        echo '<td nowrap><form action="' . $_SERVER['PHP_SELF'] . '?' . $_SERVER[QUERY_STRING] . '" method="POST"><input type=submit value="編集"><input type="hidden" name="edit_id" value="' . $k . '"></form></td>';
        echo '<td nowrap><form action="' . $_SERVER['PHP_SELF'] . '?' . $_SERVER[QUERY_STRING] . '" method="POST"><input type=submit value="削除"><input type="hidden" name="id" value="' . $k . '"><input type="hidden" name="name" value="' . $v . '"><input type="hidden" name="mode" value="del"></form></td>';
        echo '</tr>';
    }
    echo '</table>';
}

예제 #9

0

파일 보기

파일: w3a.php 프로젝트: aim-web-projects/ann-cosme

<th>&nbsp;{$point} ユニークアクセス数&nbsp;</th>
</tr>
<tr align="right">
<td><b>{$count_d}</b></td>
<td><b>{$count_d_u}</b></td>
</tr>
</table><br>
EOM;
}
#-------------------------------------------------
#  パス指定
#-------------------------------------------------
if ($_GET["p_sel"]) {
    $p_sel_img = set_img(SELPATHMARK, "ページ指定");
    $p_sel_now = $_GET["p_sel"];
    $p_sel_cansel = '&nbsp;［<a href="' . FILENAME . query_edit("p_sel", "DELETE") . '">指定解除</a>］';
    $w3a["OPTION"] .= <<<EOM
<br>{$p_sel_img}
ページ指定：
<b>
{$p_sel_now}
</b>
{$p_sel_cansel}
<hr size="1">
EOM;
}
#-------------------------------------------------
#  メイン処理
#-------------------------------------------------
//スキン読み込み
$html = read_skin($skin_file, $w3a, 1);

예제 #10

0

파일 보기

파일: search.php 프로젝트: aim-web-projects/ann-cosme

 if (trim($v["dt"])) {
     echo '<tr><td width="100">Date:</td><td>&nbsp;' . $now_y . "/" . $now_m . "/" . $main_view[$k]["day"] . '(' . $main_view[$k]["week"] . ')&nbsp;' . $main_view[$k]["hour"] . ':' . $main_view[$k]["minute"] . ':' . $main_view[$k]["sec"] . '</td></tr>';
 }
 if (trim($v["path"])) {
     echo '<tr><td width="100">Path:</td><td>';
     if ($v["title"] != "") {
         echo "[&nbsp;" . $v["title"] . "&nbsp;]<br>";
     }
     echo '&nbsp;' . $main_view[$k]["path"] . '</td></tr>';
 }
 if (trim($v["remoteip"])) {
     //link
     if ($v["id"]) {
         $id = $v["ch_id"] ? $v["ch_id"] : $v["id"];
         $link = query_edit("act", "track");
         $link = query_edit("sel", $v["id"], $link);
         $link = '<a href="' . FILENAME . $link . '">' . set_img(TRACKMARK) . "&nbsp;" . $id . '</a><br>';
     } else {
         $link = "";
     }
     echo '<tr><td width="100">Host:</td><td>&nbsp;' . $link . $main_view[$k]["remoteip"] . '</td></tr>';
 }
 if (trim($v["ref"])) {
     $sel_ref = urldecode($main_view[$k]["ref"]);
     //EUC-JPにエンコード（一応、必要ないかも）
     if (function_exists("mb_convert_encoding")) {
         $sel_ref = @mb_convert_encoding($sel_ref, "EUC-JP", "auto");
     } else {
         $sel_ref = jcode_convert_encoding($sel_ref, 'euc-jp');
     }
     $sel_ref = '<a href="redirect.php?redirect=' . $v["ref"] . '" target="_blank">' . set_img(JUMPMARK) . "&nbsp;" . $sel_ref . '</a>&nbsp;';

예제 #11

0

파일 보기

파일: page.php 프로젝트: aim-web-projects/ann-cosme

/*=========================================*/
/* メイン処理                              */
/*=========================================*/
echo '<table>';
echo '<tr>';
echo '<th nowrap>ページ</th>';
echo '<th nowrap>ユニーク</th>';
echo '<th nowrap>件数</th>';
echo '<th nowrap>グラフ</th>';
echo '</tr>';
foreach ($main as $k => $v) {
    if ($p_sel_icon) {
        $sel_path = '<a href="' . FILENAME . query_edit("p_sel", $k) . '">' . set_img(SELPATHMARK, "ページ指定") . '</a>&nbsp;';
    }
    //ユニーク値
    $uniq = intval($uniqs[$k]);
    //Pathタイトル変換
    $path_title = "";
    if (is_array($ch_path) && isset($ch_path[$k])) {
        $path_title = "［&nbsp;" . $ch_path[$k] . "&nbsp;］<br>&nbsp;";
    }
    //link
    $link = $sel_path . $path_title . sel_link(query_edit("sel", $k), $k);
    echo '<tr id="bg_id' . $k . '" onmouseover="chBG(\'bg_id' . $k . '\', 1);" onmouseout="chBG(\'bg_id' . $k . '\', 0);">';
    echo '<td>&nbsp;' . $link . '&nbsp;</td>';
    echo '<td align="right">&nbsp;<font color="#0000FF">' . $uniq . '</font>&nbsp;</td>';
    echo '<td align="right">&nbsp;<font color="#FF0000">' . $v . '</font>&nbsp;</td>';
    echo '<td>&nbsp;' . mk_graph2($v, $main, $uniq, $uniqs, $max_val) . '&nbsp;</td>';
    echo '</tr>';
}
echo '</table>';

예제 #12

0

파일 보기

파일: ref.php 프로젝트: aim-web-projects/ann-cosme

        if ($flg_jump) {
            $jump = '<a href="redirect.php?redirect=' . $k . '" target="_blank">' . set_img(JUMPMARK) . '</a>&nbsp;';
        } else {
            $jump = "";
        }
        //ユニーク値
        $uniq = intval($uniqs[$k]);
        //URLタイトル変換(グループ化なし)
        $url_title = "";
        if (!$title_group && is_array($ch_url)) {
            foreach ($ch_url as $url => $title) {
                if (strstr($k, $url)) {
                    $url_title = $title . "<br>&nbsp;";
                    break;
                }
            }
        }
        //link
        $link = $url_title . sel_link(query_edit("sel", $k), str_cut($k));
        echo '<tr id="bg_id' . $k . '" onmouseover="chBG(\'bg_id' . $k . '\', 1);" onmouseout="chBG(\'bg_id' . $k . '\', 0);">';
        echo '<td>&nbsp;' . $jump . $link . '&nbsp;</td>';
        echo '<td align="right">&nbsp;<font color="#0000FF">' . $uniq . '</font>&nbsp;</td>';
        echo '<td align="right">&nbsp;<font color="#FF0000">' . $v . '</font>&nbsp;</td>';
        echo '<td>&nbsp;' . mk_graph2($v, $main, $uniq, $uniqs, $max_val) . '&nbsp;</td>';
        echo '</tr>';
        flush();
    }
    echo '</table>';
} else {
    echo '<hr size="1"><div id="error">解析結果：0件</div>';
}

예제 #13

0

파일 보기

파일: p_sel.php 프로젝트: aim-web-projects/ann-cosme

            continue;
        }
        if ($query_cut) {
            $p = parse_url($v["path"]);
            $v["path"] = $p["path"];
            unset($p);
        }
        //アクセス数
        $main[$v["path"]] = $v["title"];
    }
    unset($data);
}
//ソート
ksort($main, SORT_STRING);
/*=========================================*/
/* メイン処理                              */
/*=========================================*/
echo '<table>';
echo '<tr>';
echo '<th nowrap>ページパス</th>';
echo '<th nowrap>タイトル</th>';
echo '</tr>';
foreach ($main as $k => $v) {
    $query = query_edit("act", "DELETE");
    $link = set_img(SELPATHMARK, "ページ指定") . '&nbsp;<a href="' . FILENAME . query_edit("p_sel", $k, $query) . '">' . str_cut($k) . '</a>';
    echo '<tr id="bg_id' . $k . '" onmouseover="chBG(\'bg_id' . $k . '\', 1);" onmouseout="chBG(\'bg_id' . $k . '\', 0);">';
    echo '<td>&nbsp;' . $link . '&nbsp;</td>';
    echo '<td>&nbsp;' . $v . '&nbsp;</td>';
    echo '</tr>';
}
echo '</table>';

예제 #14

0

파일 보기

파일: week.php 프로젝트: aim-web-projects/ann-cosme

unset($tmp);
foreach ($uniqs as $k => $v) {
    $tmp[$k] = count($uniqs[$k]);
    if ($max_val < $main[$k]) {
        $max_val = $main[$k];
    }
}
$uniqs = $tmp;
/*=========================================*/
/* メイン処理                              */
/*=========================================*/
echo '<table>';
echo '<tr>';
echo '<th nowrap>曜日</th>';
echo '<th nowrap>ユニーク</th>';
echo '<th nowrap>件数</th>';
echo '<th nowrap>グラフ</th>';
echo '</tr>';
foreach ($main as $k => $v) {
    //ユニーク値
    $uniq = intval($uniqs[$k]);
    //link
    $link = sel_link(query_edit("sel", $k), $youbi[$k]);
    echo '<tr id="bg_id' . $k . '" onmouseover="chBG(\'bg_id' . $k . '\', 1);" onmouseout="chBG(\'bg_id' . $k . '\', 0);">';
    echo '<td align="center">&nbsp;' . $link . '&nbsp;</td>';
    echo '<td align="right">&nbsp;<font color="#0000FF">' . $uniq . '</font>&nbsp;</td>';
    echo '<td align="right">&nbsp;<font color="#FF0000">' . $v . '</font>&nbsp;</td>';
    echo '<td align="left">&nbsp;' . mk_graph2($v, $main, $uniq, $uniqs, $max_val) . '&nbsp;</td>';
    echo '</tr>';
}
echo '</table>';

PHP query_edit 예제들