function f_show_list()
{
global $gl_array;
// 関数の中で関数の外の変数／配列を使用する場合に宣言
extract($gl_array);
// 配列データ名を変数名へ置換
#=================================================
# DB一覧取得処理
#=================================================
$sql = "SELECT * FROM t_fish_recipe";
// テーブル一覧取得
$sql .= " WHERE now() > posted_day";
// 現在日付以前取得
$sql .= " AND posted_flg = '1'";
$sql .= " ORDER BY posted_day DESC";
// 最新日付で昇順にソート
$res = f_db_query($sql);
// SQL実行
$num = f_db_num_rows($res);
// テーブル件数取得
#=================================================
# TABLE一覧配列格納処理
#=================================================
if ($num > 0) {
// DB取得テーブルが1件以上なら以下の処理を行う
$array_data = array();
while ($row = f_db_fetch($res)) {
// DB取得データをShift-Jisへ変換し、配列へ
$array_data[] = array("id" => $row['id'], "title" => $row['title'], "image_path" => $row['image_path'], "posted_day" => $row['posted_day']);
}
#=================================================
# Paging処理
#=================================================
$perPage = 20;
// 一覧表示件数設定
$params = array("perPage" => $perPage, "itemData" => $array_data, "extraVars" => array());
$o_page = Pager::factory($params);
foreach ($o_page->getPageData() as $item) {
$data_list_for_page[] = $item;
}
$navi = $o_page->getLinks();
echo $navi['all'];
// 先頭 Paging 表示
} else {
// DB取得テーブルが0件なら以下のメッセージ表示
f_show_mes("予期せぬエラーが発生しました。管理者へ問合せて下さい。");
}
#=================================================
# 画面表示処理
#=================================================
for ($i = 0; $i < count($data_list_for_page); $i++) {
$pday = date("n/j", strtotime($data_list_for_page[$i]['posted_day'])) . "UP!";
// 掲載月日設定
$image_dir = IMG_FILE . $data_list_for_page[$i]['image_path'];
// 画像保存先フルパス
$id_name = "detail" . $i;
if ($i % 2 == 0) {
// 偶数奇数を判定し、背景色入替
$style = "style ='background-color:#cce8ff'";
} else {
$style = "";
}
?>
<!-- HTML出力 -->
<li class="fvmlist" <?php
echo $style;
?>
>
<!-- 詳細画面遷移[選択ID]POST -->
<a href="javascript:onclick=document.getElementById('<?php
echo $id_name;
?>
').submit();">
<img src="<?php
echo $image_dir;
?>
" width="80" align="left" style="margin:5px;">
<div class="bass_img">
<span class="bass_tx4"><?php
echo $data_list_for_page[$i]["title"];
?>
</span>
<span class="new"><?php
echo $pday;
?>
</span>
</div>
<div clear="all" style="clear:both;"></div>
</a>
<form method="POST" action="./detail.php" id="<?php
echo $id_name;
?>
">
<input type="hidden" name="id" value="<?php
echo $data_list_for_page[$i]['id'];
?>
"/>
</form>
</li>
<?php
}
if ($num > 0) {
// DB取得テーブルが1件以上なら以下の処理を行う
echo $navi['all'];
// 末尾 Paging 表示
}
}
function f_do_serach()
{
global $gl_array, $now, $past, $array_data;
// 関数の中で関数の外の変数／配列を使用する場合に宣言
extract($gl_array);
// 配列データ名を変数名へ置換
#=================================================
# 検索処理(Key入力)
#=================================================
if ($keyword != "") {
$serch .= " AND ( jan like '%" . mysql_real_escape_string($keyword) . "%'";
// JANコード検索
$serch .= " OR main_title like '%" . mysql_real_escape_string($keyword) . "%'";
// タイトル検索
$serch .= " OR sub_title like '%" . mysql_real_escape_string($keyword) . "%'";
// サブタイトル検索
$serch .= " OR infomation like '%" . mysql_real_escape_string($keyword) . "%'";
// 説明検索
$serch .= " OR price like '%" . mysql_real_escape_string($keyword) . "%'";
// 価格検索
$serch .= " OR recording like '%" . mysql_real_escape_string($keyword) . "%')";
// 収録時間検索
} else {
$serch = "";
// Key入力無し
}
#=================================================
# 検索処理(チェックボックス入力)
#=================================================
if ($chk != "") {
// チェックボックス入力
$checkbox = " AND ( category IN (";
// カテゴリ内検索
foreach ($chk as $chk_num => $chk_list) {
$checkbox .= " '" . mysql_real_escape_string($chk_list) . "',";
// チェックボックス検索
}
$checkbox .= " ''))";
} else {
$checkbox = "";
// チェックボックス入力無し
}
#=================================================
# 最新(NEW)フラグ処理
#=================================================
if ($new_flg != "") {
$sale_new = "AND (sale_date BETWEEN '" . mysql_real_escape_string($past) . "'";
$sale_new .= " AND sale_date)";
// 発売日から1ヶ月後
} else {
$sale_new = "";
}
#=================================================
# DB一覧取得処理
#=================================================
$sql = "SELECT * FROM dt_catalogue";
// テーブル全件取得
$sql .= " WHERE del_flg = '" . FLG_0 . "'";
// 非削除
$sql .= " AND gen_flg = '" . FLG_0 . "'";
// DVDのみ取得
$sql .= " " . $sale_new . "";
// 最新(NEW)検索
$sql .= " " . $serch . "";
// Key入力検索
$sql .= " " . $checkbox . "";
// チェックボックス検索
$sql .= " ORDER BY sale_date DESC";
// 発売日降順
echo $sql . "<br />";
$rs = f_db_query($sql);
// SQL実行
$num = f_db_num_rows($rs);
// テーブル件数取得
#=================================================
# DB取得エラーチェック
#=================================================
if ($num > 0) {
// DB取得テーブルが「NULL」の場合、以下の処理実行
$array_data = array();
while ($row = f_db_fetch($rs)) {
// DB取得データをShift-Jisへ変換し、配列へ
#=================================================
# DBデータを配列へ格納
#=================================================
$array_data[] = array("catalogue_id" => $row['catalogue_id'], "jan" => $row['jan'], "category" => $row['category'], "main_title" => $row['main_title'], "sub_title" => $row['sub_title'], "infomation" => $row['infomation'], "price" => $row['price'], "recording" => $row['recording'], "image" => $row['image'], "movie" => $row['movie'], "gen_flg" => $row['gen_flg'], "sol_flg" => $row['sol_flg'], "act_flg" => $row['act_flg'], "del_flg" => $row['del_flg'], "sale_date" => $row['sale_date'], "add_date" => $row['add_date'], "upd_date" => $row['upd_date']);
}
}
#=================================================
# 検索画面
#=================================================
?>
<form method = "POST" action="<?php
echo $_SERVER['SCRIPT_NAME'];
?>
" >
<div class="serch_box">
<div>
<span class="small title">人名・タイトル</span>
<input class="dvd_category" type="text" name="keyword" size="40" maxlength="40" border="0" value="<?php
echo $keyword;
?>
">
<input class="small dvd_category" type="checkbox" name="new_flg" value="<?php
echo FLG_1;
?>
">
<span class="small dvd_category">最新（NEW） </span>
</div>
<div class="category_box">
<span class="small title">ジャンル</span>
<input class="chkbox" type="checkbox" name="chk[]" value="<?php
echo BASS;
?>
" />
<span class="small dvd_category"><?php
echo KA_BASS;
?>
</span>
<input class="chkbox" type="checkbox" name="chk[]" value="<?php
echo SALT;
?>
" />
<span class="small dvd_category"><?php
echo KA_SALT;
?>
</span>
<input class="chkbox" type="checkbox" name="chk[]" value="<?php
echo TROUT;
?>
" />
<span class="small dvd_category"><?php
echo KA_TROUT;
?>
</span>
<input class="chkbox" type="checkbox" name="chk[]" value="<?php
echo FLY;
?>
" />
<span class="small dvd_category"><?php
echo KA_FLY;
?>
</span>
<input class="chkbox" type="checkbox" name="chk[]" value="<?php
echo ITN;
?>
" />
<span class="small dvd_category"><?php
echo KA_ITN;
?>
</span>
<input class="chkbox" type="checkbox" name="chk[]" value="<?php
echo AYU;
?>
" />
<span class="small dvd_category"><?php
echo KA_AYU;
?>
</span>
<input class="chkbox" type="checkbox" name="chk[]" value="<?php
echo KEI;
?>
" />
<span class="small dvd_category"><?php
echo KA_KEI;
?>
</span>
<input class="chkbox" type="checkbox" name="chk[]" value="<?php
echo OKI;
?>
" />
<span class="small dvd_category"><?php
echo KA_OKI;
?>
</span>
<input class="chkbox" type="checkbox" name="chk[]" value="<?php
echo HERA;
?>
" />
<span class="small dvd_category"><?php
echo KA_HERA;
?>
</span>
<input class="chkbox" type="checkbox" name="chk[]" value="<?php
echo ETC;
?>
" />
<span class="small dvd_category"><?php
echo KA_ETC;
?>
</span>
</div>
<input class="serch_button" type="hidden" name="mode" value="do_search" >
<input class="serch_button" type="hidden" name="sale_date" value="<?php
echo $sale_date;
?>
" >
<input class="serch_button" type="submit" name="submit" value="検索" border="0" />
<input class="serch_button" type="button" onClick="normalformList('')" value="リセット"border="0" />
</div>
</form>
<?php
}
