12
){
return false;
}
$date = is_null($stamp) ? getdate():getdate($stamp);
$year = $date['year'];
$month = $date['mon']-($fiscal-1);
return mktime(0,0,0,$month,1,$year);
}
$facialTime = fiscalyear();
$mysql = new MySQL;
$range = array(
"ddate>='".$mysql -> escape(date('Y',$facialTime)).'0401'."'",
"ddate<='".$mysql -> escape(date('Y',$facialTime)+1).'0331'."'"
);
$reqs = $_SERVER['REQUEST_METHOD'] == 'GET' ? $_GET:array();
if(array_key_exists('ago',$reqs) && strlen($reqs['ago']) > 0){
$bun = false;
$range = array(
"ddate>='".$mysql -> escape($reqs['ago']).'0401'."'",
"ddate<='".$mysql -> escape($reqs['ago']+1).'0331'."'"
);
}
$range = ' WHERE '.join(' AND ',$range);
$data = '';
$sql = "SELECT * FROM a_match".$range." ORDER BY ddate ASC";
$mysql -> query($sql);
if($mysql -> rows() > 0){
$data = '
| 日程 |
試合名 |
時間 |
チーム |
対戦相手 |
会場 |
';
$now = date("Y").sprintf("%02d",date("m")).sprintf("%02d",date("d"));
while($row = $mysql -> fetch()){
$e_date = $row['ddate'];
$m = $row['month']."月";
$d = $row['day']."日";
$day = $m.$d;
$name = $row['name'];
$h = $row['hour'];
$gr = $row['gr'];
$trg = $row['trg'];
$plc = $row['place'];
//f1f1f1
$bg = $e_date < $now ? ' style="background-color:#f1f1f1;"':'';
$data .= '
'.$day.'
'.$name.'
'.$h.'
'.$gr.'
'.$trg.'
'.$plc.'
';
}
$data .= '
';
}
?>
試合日程 --- 同志社ラグビー部 公式ホームページ
