get($sql); $count = $res['cnt']; define('BASE', dirname(dirname(__FILE__))); $pear = BASE."/common/PEAR"; ini_set('include_path', ini_get('include_path').":".$pear); //ページング $params = array( 'perPage' => $page, 'totalItems' => $count, 'urlVar' => 'start', 'currentPage' => $start, 'prevImg' => '<<前の'.$page.'件', 'nextImg' => '次の'.$page.'件>>', 'firstPageText' => '先頭', 'lastPageText' => '最後', ); $o_page = Pager::factory($params); $navi = $o_page->getLinks(); $pager = $navi['all']; $offset = ($o_page->getCurrentPageID()-1) * $page; //データ取得 $sql = "SELECT art.t_a_name as a_name,art.t_a_furi as a_furi,item.* FROM bw_t_item item ". "JOIN bw_t_artist art ON art.t_artist_id = item.t_artist_id " . "WHERE item.t_del_flg = 0 AND t_csv_flg = 0 AND t_i_buy_date >= '".$date."' " . "AND ((t_start_date <= '".$now."' AND t_end_date IS NULL) " . "OR ('".$now."' BETWEEN t_start_date AND t_end_date)) " . "ORDER BY t_i_buy_date DESC,t_i_product DESC,art.t_a_furi,t_i_furi " . "LIMIT ".$page." OFFSET ".$offset; $res = $dbObj->get_all($sql); $img_file_path = $DOC_ROOT . "image/item/"; $data = array(); if ($res) { //画像の存在チェック foreach ($res as $val) { if ($val['t_i_jacket_img'] == NULL) { $val['t_i_jacket_img'] = "noimg.gif"; } elseif (!file_exists($img_file_path.$val['t_i_jacket_img'])) { $val['t_i_jacket_img'] = "noimg.gif"; } array_push($data, $val); } unset($res); } ?> Bellwood Records オフィシャルサイト | New Releases
  1. HOME
  2. EVENT NEWS
  3. NEW RELEASES
  4. CATALOG
  5. ARTIST MANAGEMENT
  6. ABOUT BELLWOOD
  7. LINKS
TOP > New Releases

New Releases

New Releases

0) { ?>
ジャケット画像
 
税込価格
品番
発売日
形態
発売元
レーベル名
>>

NEW RELEASEは御座いません。