set_charset("utf8"); // イベント情報取得 $now = date("Y-m-d H:i:s",strtotime("now")); $stmt = $con->prepare("SELECT start_at,event_id_1,event_id_2,event_id_3,event_id_4,event_id_5,update_user,update_at,delete_flg,public_flg FROM hp_events_top WHERE start_at < ? AND public_flg = 1 and delete_flg != 1 order by start_at DESC limit 1"); $stmt->bind_param('s',$now); $stmt->execute(); $stmt->bind_result($start_at,$event_id_1,$event_id_2,$event_id_3,$event_id_4,$event_id_5,$update_user,$update_at,$delete_flg,$public_flg); $stmt->fetch(); $stmt->close(); $info = $con->prepare("SELECT start_at,close_at,show_on,body,url,new_window_flg,toppage_flg,show_ids,update_user,update_at,delete_flg,public_flg FROM hp_informations WHERE toppage_flg = 1 and start_at < ? AND close_at > ? and public_flg = 1 and delete_flg != 1 order by show_on DESC,id DESC"); $info->bind_param('ss',$now,$now); $info->execute(); $info->bind_result($start_at,$close_at,$show_on,$body,$url,$new_window_flg,$toppage_flg,$show_ids,$update_user,$update_at,$delete_flg,$public_flg); $info_array = array(); while($info->fetch()) { $show_ids = explode(',',$show_ids); $merge_array = array(); // 掲載区分テーブルから掲載位置取得 foreach ($show_ids as $show_id) { $merge_array = array_merge($merge_array,$show_top_list[$show_id]); } // 重複する掲載区分を除外 $newlist = array_unique($merge_array); $add_array = array('start_at' => $start_at,'close_at' => $close_at,'show_on' => $show_on,'body' => $body,'url' => $url,'new_window_flg' => $new_window_flg,'toppage_flg' => $toppage_flg,'show_ids' => $show_ids,'update_user' => $update_user,'update_at' => $update_at,'delete_flg' => $delete_flg,'public_flg' => $public_flg,'newlist' => $newlist); array_push($info_array,$add_array); } $info->close(); // トップのイベント情報の詳細を取得 $event_datas = array(); $list = $con->prepare("SELECT id,start_at,close_at,show_on,event_type,status_type,open_at,title_1,title_2,url,sikaku_type,sikaku_name,toppage_flg,newly_flg,update_user,update_at,delete_flg,public_flg FROM hp_events WHERE id=? OR id=? OR id=? OR id=? OR id=?"); $list->bind_param('iiiii',$event_id_1,$event_id_2,$event_id_3,$event_id_4,$event_id_5); $list->execute(); $list->bind_result($event_id,$start_at,$close_at,$show_on,$event_type,$status_type,$open_at,$title_1,$title_2,$url,$sikaku_type,$sikaku_name,$toppage_flg,$newly_flg,$update_user,$update_at,$delete_flg,$public_flg); while($list->fetch()) { // イベントが該当する場合はその場所のハッシュにデータを設定 if ($event_id_1 == $event_id) { $event_datas['1'] = array( 'event_id' => $event_id,'start_at' => $start_at,'close_at' => $close_at,'show_on' => $show_on,'event_type' => $event_type,'status_type' => $status_type, 'open_at' => $open_at ,'title_1' => $title_1,'title_2' => $title_2,'url' => $url,'sikaku_type' => $sikaku_type,'sikaku_name' => $sikaku_name,'toppage_flg' => $toppage_flg,'newly_flg' => $newly_flg, 'update_user' => $update_user,'update_at' => $update_at,'delete_flg' => $delete_flg,'public_flg' => $public_flg); } if ($event_id_2 == $event_id) { $event_datas['2'] = array( 'event_id' => $event_id,'start_at' => $start_at,'close_at' => $close_at,'show_on' => $show_on,'event_type' => $event_type,'status_type' => $status_type, 'open_at' => $open_at, 'title_1' => $title_1,'title_2' => $title_2,'url' => $url,'sikaku_type' => $sikaku_type,'sikaku_name' => $sikaku_name,'toppage_flg' => $toppage_flg,'newly_flg' => $newly_flg, 'update_user' => $update_user,'update_at' => $update_at,'delete_flg' => $delete_flg,'public_flg' => $public_flg); } if ($event_id_3 == $event_id) { $event_datas['3'] = array( 'event_id' => $event_id,'start_at' => $start_at,'close_at' => $close_at,'show_on' => $show_on,'event_type' => $event_type,'status_type' => $status_type, 'open_at' => $open_at,'title_1' => $title_1,'title_2' => $title_2,'url' => $url,'sikaku_type' => $sikaku_type,'sikaku_name' => $sikaku_name,'toppage_flg' => $toppage_flg,'newly_flg' => $newly_flg, 'update_user' => $update_user,'update_at' => $update_at,'delete_flg' => $delete_flg,'public_flg' => $public_flg); } if ($event_id_4 == $event_id) { $event_datas['4'] = array( 'event_id' => $event_id,'start_at' => $start_at,'close_at' => $close_at,'show_on' => $show_on,'event_type' => $event_type,'status_type' => $status_type, 'open_at' => $open_at,'title_1' => $title_1,'title_2' => $title_2,'url' => $url,'sikaku_type' => $sikaku_type,'sikaku_name' => $sikaku_name,'toppage_flg' => $toppage_flg,'newly_flg' => $newly_flg, 'update_user' => $update_user,'update_at' => $update_at,'delete_flg' => $delete_flg,'public_flg' => $public_flg); } if ($event_id_5 == $event_id) { $event_datas['5'] = array( 'event_id' => $event_id,'start_at' => $start_at,'close_at' => $close_at,'show_on' => $show_on,'event_type' => $event_type,'status_type' => $status_type, 'open_at' => $open_at,'title_1' => $title_1,'title_2' => $title_2,'url' => $url,'sikaku_type' => $sikaku_type,'sikaku_name' => $sikaku_name,'toppage_flg' => $toppage_flg,'newly_flg' => $newly_flg, 'update_user' => $update_user,'update_at' => $update_at,'delete_flg' => $delete_flg,'public_flg' => $public_flg); } } $list->close(); ?> 日商簿記や税理士、建設業経理士の資格書籍、WEB講座ならネットスクール

簿記検定や税理士試験、建設業経理士などの資格書籍・問題集・WEB講座ならネットスクール

<
【重要】サーバメンテナンスに伴うWebキャンパスのサービス一時中止について(2016/10/16 23:00~2016/10/17 6:00)
新着情報
= 15) { break; } ?>