@extract($HTTP_GET_VARS);
@extract($HTTP_POST_VARS);
@extract($HTTP_SERVER_VARS);
@extract($HTTP_ENV_VARS);
$host_name="localhost"; //수정하지 마세요
$user_name="kritz"; //mysql DB 유저네임
$user_passwd="WH7TNDUS"; //myslq DB 패스워드
$db_name="kritz"; //사용할 DB 이름
$table="leaquacube"; //생성한 table code
$page_scale="15"; // 1화면당 페이지수
$page_count = 25; // 1 페이지 당 목록수
$admin_level = 1;
$connect = mysql_connect("$host_name","$user_name","$user_passwd");
mysql_select_db($db_name,$connect);
if(!$date) {
$que = "select * from $table where mid( date, 1, 10 ) = curdate() ORDER BY date ASC";
}
else {
$que = "select * from $table where mid( date, 1, 10 ) = '$date' ORDER BY date ASC";
}
$result = mysql_query($que,$connect);
$row = mysql_affected_rows();
$total = $row;
?>
// schYear, schMonth 를 받아오고 없음 오늘날짜로.
if ($date) {
$tmp = explode('-',$date);
$schYear = $tmp[0];
$schMonth = $tmp[1];
$sch_Day = $tmp[2];
}
if(empty($schYear)) $schYear = date("Y");
if(empty($schMonth)) $schMonth = date("m");
if(empty($sch_Day)) $sch_Day = date("d");
// 해당년월의 처음 요일을 구한다.
$firstTime = strtotime($schYear . "-" . $schMonth . "-01");
$firstWeek = date("w", $firstTime);
// 해당년월의 마지막 날을 구한다
for ($ld = 28; checkdate($schMonth,$ld,$schYear); $ld ++);
$lastDay = $ld - 1;
// 해당년월의 마지막 요일을 구한다.
$lastTime = strtotime($schYear . "-" . $schMonth . "-" . $lastDay);
$lastWeek = date("w", $lastTime);
// 배열에 날짜 데이터를 먼저 우겨넣는다.
$arrSCH = array(array(),array(),array(),array(),array(),array(),array());
for($i = 0; $i < $firstWeek; $i ++) { // 해당월의 처음 요일이 되기 전 공백 추가.
$arrSCH[$i][] = "";
}
$maxRow = 0;
for($schDay = 1; $schDay <= $lastDay; $schDay ++) {
$checkday = mktime(0, 0, 0, $schMonth, $schDay, $schYear);
$week = date("w", $checkday);
$arrSCH[$week][] = $schDay;
if(count($arrSCH[$week]) > $maxRow) $maxRow = count($arrSCH[$week]);
}
?>
LeAqua - Aquarium State Logger v1.3 with 30Cube
$next_year = $schYear;
$next_month = $schMonth + 1;
if($next_month > 12) { $next_month = 1 ; $next_year = $next_year + 1;}
$prev_year = $schYear;
$prev_month = $schMonth - 1;
if($prev_month < 1) { $prev_month = 12 ; $prev_year = $prev_year - 1;}
if($next_month < 10) { $next_month = "0".$next_month; }
if($prev_month < 10) { $prev_month = "0".$prev_month; }
echo "
◁ $schYear 년 $schMonth 월 ▷ ";
echo "
";
echo "";
for($row = 0; $row < $maxRow; $row ++) {
for($col = 0; $col < 7; $col ++) {
if($arrSCH[$col][$row]) {
$day = str_pad($arrSCH[$col][$row], 2, "0", STR_PAD_LEFT );
}
else {
$day =$arrSCH[$col][$row];
}
if($col == 6) $clss = "class=sat";
elseif ($col == 0) $clss = "class=sun";
else $clss = "class=main";
if(!$day) $aday = " ";
else if(date(d) < $day) {
//$aday= $day;
$aday= "$day";
}
else {
$aday= "$day";
}
echo "| $aday | ";
}
}
echo "
";
echo "";
for($row = 0; $row < $maxRow; $row ++) {
for($col = 0; $col < 7; $col ++) {
$day = $arrSCH[$col][$row];
if(!$day) $day = " ";
if($sch_Day == $day) echo "| ▲";
else echo " | ";
echo " | ";
}
}
echo "
";
echo "
";
?>