Q($sql); $cat_sort = $DB->Fetch_key(); preg_match_all('/".*?";/',$cat_sort["option_value"],$csm); foreach($csm[0] as $csmK => $csmV) { $csm[0][$csmK] = preg_replace('/"([0-9,]{1,200})";/','$1',$csmV); } preg_match_all('/i:[0-9]{1,3};/',$cat_sort["option_value"],$csm2); $subcat_loop = 0; foreach($csm2[0] as $csm2K => $csm2V) { $subcat[preg_replace('/i:([0-9]{1,3});/','$1',$csm2V)] = explode(",",$csm[0][$subcat_loop++]); } $submenu = explode(",",$csm[0][0]); foreach($submenu as $submenuV) { $submenu2[$submenuV] = @array_flip($subcat[$submenuV]); } unset($submenu2[1]);// 未分類を外す // 全てのカテゴリ名を得る $sql = "SELECT `wp_baby_2_terms`.`term_id` AS `id`,`name`,`count` FROM `wp_baby_2_terms` LEFT JOIN `wp_baby_2_term_taxonomy` ON `wp_baby_2_terms`.`term_id` = `wp_baby_2_term_taxonomy`.`term_id` WHERE `wp_baby_2_term_taxonomy`.`count` != 0"; $DB->Q($sql); while($DBR = $DB->Fetch_key()) { $taxo_name[$DBR["id"]] = $DBR["name"]; } // パンクズの後ろとサブナビのCSS ===================================================================== $BC = '　　'.$page["name"]; $sub_nav_css = ''; if(isset($_GET["cat"]) && strlen($_GET["cat"]) <= 3 && preg_match("/^[0-9]+$/",$_GET["cat"])) { $get_cat = $_GET["cat"]; if(isset($_GET["parent"]) && strlen($_GET["parent"]) <= 3 && preg_match("/^[0-9]+$/",$_GET["parent"])) { $get_parent = $_GET["parent"]; $BC = '　　'.$page["name"].'　　'.$taxo_name[$get_parent].'　　'.$taxo_name[$get_cat]; $sub_nav_css = '#sub_'.$get_parent.'{display:block;}'; } else { $BC = '　　'.$page["name"].'　　'.$taxo_name[$get_cat]; $sub_nav_css = '#sub_'.$get_cat.'{display:block;}'; } $css_snav_selected = "#snv_$get_cat{background:#ffffcc;}"; } else { $css_snav_selected = ''; } // 商品一覧を取得 ===================================================================== // 商品数を検出（CALC_FOUND_ROWS は使わない） if(isset($_GET["cat"]) && strlen($_GET["cat"]) <= 3 && preg_match("/^[0-9]+$/",$_GET["cat"])) { $get_cat = $_GET["cat"]; $sql = "SELECT `ID` FROM `wp_baby_2_term_relationships` LEFT JOIN `wp_baby_2_posts` ON `wp_baby_2_term_relationships`.`object_id` = `wp_baby_2_posts`.`ID` WHERE `wp_baby_2_term_relationships`.`term_taxonomy_id` = $get_cat AND `wp_baby_2_posts`.`post_status` = 'publish' AND `wp_baby_2_posts`.`post_type` = 'post'"; // ページングのURL用 $url_cat = "&cat=".$get_cat; } else { $sql = "SELECT `ID` FROM `wp_baby_2_posts` WHERE `post_status` = 'publish' AND `post_type` = 'post'"; // ページングのURL用 $url_cat = ""; } $DB->Q($sql); while($DBR = $DB->Fetch_key()) { $item_count[] = NULL; } $item_count = count($item_count); $item_per_page = 40; $max_page = ceil($item_count / $item_per_page); if(isset($_GET["parent"]) && strlen($_GET["parent"]) <= 3 && preg_match("/^[0-9]+$/",$_GET["parent"])) { $get_parent = $_GET["parent"]; $url_parent = "&parent=".$get_parent; } else { $url_parent = ""; } // ページング検出 ===================================================================== if(isset($_GET["p"]) && strlen($_GET["p"]) <= 3 && preg_match("/^[0-9]+$/",$_GET["p"])) { // 最大ページ数以内 if((int)$_GET["p"] <= $max_page) { $page_num = (int)$_GET["p"]; $limit = $page_num * $item_per_page; $offset = $limit - $item_per_page; $SQL_LIMIT = $offset.','.$item_per_page; // ページャー for($pg = 1; $pg <= $max_page; ++$pg) { if($pg == $page_num) { $pager[$pg] = true; } else { $pager[$pg] = false; } } } // 最大ページ数以上 else { header("Location: products.php"); } } else { $SQL_LIMIT = '0,'.$item_per_page; // ページャー for($pg = 1; $pg <= $max_page; ++$pg) { if($pg == 1) { $pager[$pg] = true; } else { $pager[$pg] = false; } } } // 商品データ参照 ===================================================================== if(isset($_GET["cat"]) && strlen($_GET["cat"]) <= 3 && preg_match("/^[0-9]+$/",$_GET["cat"])) { $get_cat = $_GET["cat"]; $sql = "SELECT `ID` FROM `wp_baby_2_term_relationships` LEFT JOIN `wp_baby_2_posts` ON `wp_baby_2_term_relationships`.`object_id` = `wp_baby_2_posts`.`ID` WHERE `wp_baby_2_term_relationships`.`term_taxonomy_id` = $get_cat AND `wp_baby_2_posts`.`post_status` = 'publish' AND `wp_baby_2_posts`.`post_type` = 'post' ORDER BY `menu_order` ASC LIMIT $SQL_LIMIT"; } else { $sql = "SELECT `ID` FROM `wp_baby_2_posts` WHERE `post_status` = 'publish' AND `post_type` = 'post' ORDER BY `menu_order` ASC LIMIT $SQL_LIMIT"; } $DB->Q($sql); while($DBR = $DB->Fetch_key()) { $items[$DBR["ID"]] = array(); $pid[] = $DBR["ID"]; } $pid_in = implode(",",$pid); // アイキャッチ画像の参照 $sql = "SELECT `post_id`,`guid` FROM `wp_baby_2_postmeta` LEFT JOIN `wp_baby_2_posts` ON `wp_baby_2_postmeta`.`meta_value` = `wp_baby_2_posts`.`ID` WHERE `meta_key` = '_thumbnail_id' AND `post_mime_type` LIKE 'image/%' AND `post_id` IN ($pid_in)"; $DB->Q($sql); while($DBR = $DB->Fetch_key()) { $DBR["guid"] = preg_replace("/\.jpg/","-300x300.jpg",$DBR["guid"]); $DBR["guid"] = preg_replace("/\.gif/","-300x300.gif",$DBR["guid"]); $DBR["guid"] = preg_replace("/\.png/","-300x300.png",$DBR["guid"]); $items[$DBR["post_id"]]["eye_catch"] = $DBR["guid"]; } // カスタムフィールドのデータ参照（テキスト） $sql = "SELECT `post_id`,`meta_value`,`meta_key` FROM `wp_baby_2_postmeta` WHERE `post_id` IN ($pid_in) AND `meta_key` IN ('商品名A','商品名B','本体価格')"; $DB->Q($sql); while($DBR = $DB->Fetch_key()) { if($DBR["meta_key"] == '商品名A') { $items[$DBR["post_id"]]["name_A"] = $DBR["meta_value"]; } elseif($DBR["meta_key"] == '商品名B') { $items[$DBR["post_id"]]["name_B"] = $DBR["meta_value"]; } elseif($DBR["meta_key"] == '本体価格') { $items[$DBR["post_id"]]["price"] = $DBR["meta_value"]; } } ?> <?=$html_header["site_name"];?>｜<?=$page["name"];?>

$pagerV) { if($pagerV) { ?>
$itemV) { if(!isset($itemV["eye_catch"])) { $itemV["eye_catch"] = "img/products/no_image.jpg"; } ?>
" width="168" height="168">
本体価格 ¥ + 税
$pagerV) { if($pagerV) { ?>