※既に開催済みのイベント(オンデマンド配信中)はこちら
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 start_at < ? AND close_at > ? AND status_type = ? AND public_flg = 1 AND delete_flg != '1' ORDER BY open_at DESC");
$status_type = 1;
$before->bind_param('ssi',$now,$now,$status_type);
$before->execute();
$before->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($before->fetch()) {
?>
close();
?>
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 start_at < ? AND close_at > ? AND status_type = ? AND public_flg = 1 AND delete_flg != '1' ORDER BY open_at DESC");
$status_type = 2;
$ondemand->bind_param('ssi',$now,$now,$status_type);
$ondemand->execute();
$ondemand->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($ondemand->fetch()) {
?>
close();
?>
