include "backend/Mis.php";
include "Up.php";
/*$db_connection = mysql_connect ($DBHost, $DBUser, $DBPass) OR die (mysql_error());
$db_select = mysql_select_db ($DBName) or die (mysql_error());
$db_table = $TBL_PR . "events";*/
function getmicrotime(){
list($usec, $sec) = explode(" ",microtime());
return ((float)$usec + (float)$sec);
}
$time_start = getmicrotime();
IF(!isset($_GET['year'])){
$_GET['year'] = date("Y");
}
IF(!isset($_GET['month'])){
$_GET['month'] = date("n")+1;
}
$month = addslashes($_GET['month'] - 1);
$year = addslashes($_GET['year']);
if (strlen($month)<2 )//月份補0
{$month="0".$month;}
//$query = "SELECT event_id,event_title,event_day,event_time FROM sd_class WHERE event_month='$month' AND event_year='$year' ORDER BY event_time";
$query = "SELECT ClassID as event_id,ClassNumber as event_title,ClassDate as event_day,ClassTime as event_time,Item FROM sd_class WHERE ClassDate Like '".$year."/".$month."%' ORDER BY event_day";
$query_result = mysql_query ($query);
while ($info = mysql_fetch_array($query_result))
{
$day = substr($info['event_day'],8,2);
//echo $info['event_day']."=".$day." ";
$event_id = $info['event_id'];
$events[$day][] = $info['event_id'];
$event_info[$event_id]['0'] = $info['event_title'];
switch ($info['Item']) {
case "E":
$Item_str="【企業專班】";
break;
case "A":
$Item_str="【成人專班】";
break;
case "C":
$Item_str="【兒童專班】";
break;
case "O":
$Item_str="【顧問師班】";
break;
case "M":
$Item_str="【看電影】";
break;
case "N":
$Item_str="【NLP是這樣..】";
break;
}
$event_info[$event_id]['1'] = $Item_str;
$event_info[$event_id]['2'] = $info['event_id'];
}
$todays_date = date("j");
$todays_month = date("n");
$days_in_month = date ("t", mktime(0,0,0,$_GET['month'],0,$_GET['year']));
$first_day_of_month = date ("w", mktime(0,0,0,$_GET['month']-1,1,$_GET['year']));
$first_day_of_month = $first_day_of_month + 1;
$count_boxes = 0;
$days_so_far = 0;
IF($_GET['month'] == 13){
$next_month = 2;
$next_year = $_GET['year'] + 1;
} ELSE {
$next_month = $_GET['month'] + 1;
$next_year = $_GET['year'];
}
IF($_GET['month'] == 2){
$prev_month = 13;
$prev_year = $_GET['year'] - 1;
} ELSE {
$prev_month = $_GET['month'] - 1;
$prev_year = $_GET['year'];
}
?>
include "Class_title.php";
?>
※歡迎各界人士25人以上(40人內)邀請開班.量身授課
for ($i = 1; $i <= 12; $i++) {
$link = $i+1;
IF($_GET['month'] == $link){
$selected = "selected";
} ELSE {
$selected = "";
}
echo "" . date ("F", mktime(0,0,0,$i,1,$_GET['year'])) . " \n";
}
?>
for ($i = 2010; $i <= 2012; $i++) {
IF($i == $_GET['year']){
$selected = "selected";
} ELSE {
$selected = "";
}
echo "$i \n";
}
?>
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
for ($i = 1; $i <= $first_day_of_month-1; $i++) {
$days_so_far = $days_so_far + 1;
$count_boxes = $count_boxes + 1;
echo " \n";
}
for ($i = 1; $i <= $days_in_month; $i++) {
$days_so_far = $days_so_far + 1;
$count_boxes = $count_boxes + 1;
IF($_GET['month'] == $todays_month+1){
IF($i == $todays_date){
$class = "highlighteddayboxes";
} ELSE {
$class = "dayboxes";
}
} ELSE {
IF($i == 1){
$class = "highlighteddayboxes";
} ELSE {
$class = "dayboxes";
}
}
echo "\n";
$link_month = $_GET['month'] - 1;
echo "\n";
IF(isset($events[$i])){
echo "\n";
}
echo " \n";
IF(($count_boxes == 7) AND ($days_so_far != (($first_day_of_month-1) + $days_in_month))){
$count_boxes = 0;
echo " \n";
}
}
$extra_boxes = 7 - $count_boxes;
for ($i = 1; $i <= $extra_boxes; $i++) {
echo " \n";
}
$time_end = getmicrotime();
$time = round($time_end - $time_start, 3);
?>
新班預告
編號
課程名稱
開課日期
開課時間
報名
$sql ="select * from sd_class where Status='1' and IsNew='Y' order by ClassDate desc";
$result = mysql_query($sql);
if ($result)
{
$sort_num=1;
while ($RS= mysql_fetch_array($result,MYSQL_ASSOC))
{
$wresult = mysql_query("select CName,Member_Mobile from sd_operator where Account='".$RS["Who"]."'");
$wRS= mysql_fetch_array($wresult,MYSQL_ASSOC);
$CName=$wRS["CName"];
$Member_Mobile=$wRS["Member_Mobile"];
mysql_free_result($wresult);
?>
【】
()
if (Trim($RS['MapPic'])<>"")
{
echo "查看地圖 ";
}
?>
線上報名
if (Trim($RS['Pic'])<>"")
{
echo "下載報名表 ";
}
?>
if (Trim($RS['ConUrl'])<>"")
{
echo "課程說明表 ";
}
?>
$sort_num=$sort_num+1;
}
mysql_free_result($result);
}
?>
※歡迎各界人士25人以上(40人內)邀請開班.量身授課
include "Down.php";
?>