데이터베이스를 사랑하는 사람들의 모임 데이터베이스 사랑넷

Database

DBMS

ㆍMySQL

PostgreSQL

Community

Admin

MySQL Q&A 27550 게시물 읽기

No. 27550

일주일(한달)중 토요일과 일요일은 출력하지 않게하려면
작성자	최재영	작성일	2008-04-30 10:10	조회수	3,354

일주일 간격으로 한달이 출력되는 소스인데요.

토요일과 일요일은 안나오게 하려고하는데 어떻게 하나요?

$cfg_path = "../";

include_once("$cfg_path/libs/_common.php");

$mb = get_member($USER_UID);

$table_name = "members";

//studio - 강사의 현 studio

$db_studio = explode("|",$mb[m_studio]);

$studio = $db_studio[1];

//오늘날짜

$year = date('Y');

$month = date('n');

$day = date('j');

//echo $year."-".$month."-".$day;

//현재 수정설정 - config_auth

$query = "SELECT * FROM config_auth";

$result = mysql_query($query);

$row = mysql_fetch_array($result);

<!--

function detailOpen(m_uid) {

newWin("detail_info.php?no="+m_uid,"MemberInfo","50","50","center","center","auto");

}

function lectureList(m_uid) {

newWin("lecture_list.php?m_uid="+m_uid,"MemberInfo","50","50","center","center","auto");

}

function memberModify(m_uid) {

newWin("member_edit.php?m_uid="+m_uid,"MemberInfo","50","50","center","center","auto");

}

function addMember() {

newWin("member_add.php","MemberAdd","50","50","center","center","auto");

}

function memberLeave(m_uid) {

if(confirm("정말 탈퇴처리하시겠습니까?")) {

location.href = "member_leave.php?<?=$link?>&m_uid="+m_uid;

}

function go_del(no) {

if(window.confirm('정말로 삭제합니까?')==true) {

location.href='./studio_del_act.php?no='+no;

}

//시수 수정

function go_sisu(studio,gyear,gmonth,day) {

if($USER_LEVEL==2) {

var a = window.open('chulcheck_sisu.php?studio='+studio+'&gyear='+gyear+'&gmonth='+gmonth+'&day='+day,'check','width=250,height=130');

a.focus();

} else if($USER_LEVEL==3) { //강사면 오늘날짜것만 수정가능 - 관리자가 풀어주기 전까진 ㅎㅎ

if(gyear == '<?=$year?>' && gmonth == '<?=$month?>' && day == '<?=$day?>') { //해당일에만 수정,입력가능

var a = window.open('chulcheck_sisu.php?studio='+studio+'&gyear='+gyear+'&gmonth='+gmonth+'&day='+day,'check','width=250,height=130');

a.focus();

} else if('<?=$row[gangsa_chul]?>'=='Y') {

var a = window.open('chulcheck_sisu.php?studio='+studio+'&gyear='+gyear+'&gmonth='+gmonth+'&day='+day,'check','width=250,height=130');

a.focus();

} else {

alert('해당일자만 입력,수정가능합니다');

}

<? } ?>

}

//출석시간 수정

function go_check(id,studio,gyear,gmonth,day) {

if($USER_LEVEL==2) {

var a = window.open('chulcheck_day.php?id='+id+'&studio='+studio+'&gyear='+gyear+'&gmonth='+gmonth+'&day='+day,'check','width=250,height=230');

a.focus();

<? } else if($USER_LEVEL==3) { ?>

if(gyear == '<?=$year?>' && gmonth == '<?=$month?>' && day == '<?=$day?>') { //해당일에만 수정,입력가능

var a = window.open('chulcheck_day.php?id='+id+'&studio='+studio+'&gyear='+gyear+'&gmonth='+gmonth+'&day='+day,'check','width=250,height=230');

a.focus();

} else if('<?=$row[gangsa_chul]?>'=='Y') {

var a = window.open('chulcheck_day.php?id='+id+'&studio='+studio+'&gyear='+gyear+'&gmonth='+gmonth+'&day='+day,'check','width=250,height=230');

a.focus();

} else {

alert('해당일자만 입력,수정가능합니다');

}

<? } ?>

}

//-->

</script>

function printDiv () {

if (document.all && window.print) {

window.onbeforeprint = beforeDivs;

window.onafterprint = afterDivs;

window.print();

}

function beforeDivs () {

if (document.all) {

objContents.style.display = 'none';

objSelection.innerHTML = document.all['d1'].innerHTML;

}

function afterDivs () {

if (document.all) {

objContents.style.display = 'block';

objSelection.innerHTML = "";

}

</SCRIPT>

function printWindow() {

factory.printing.header = ""

factory.printing.footer = ""

factory.printing.portrait = true

factory.printing.leftMargin = 10.0

factory.printing.topMargin = 5.0

factory.printing.rightMargin = 10.0

factory.printing.bottomMargin = 5.0

//factory.printing.Print(false, window)

}

</script>

classid="clsid:1663ed61-23eb-11d2-b92f-008048fdd814"

codebase="/ScriptX/smsx.cab#Version=6,1,429,14">

</object>

if($studio) {

$query = "SELECT * FROM studio WHERE no='$studio' ";

// echo $query;

$result = mysql_query($query);

if($result) {

$num = mysql_num_rows($result);

}

if($num>0) {

$row = mysql_fetch_array($result);

}

//넘어온 값이 없다면 디비값가져온다

if(!$gyear && !$gmonth) {

//$gyear = substr($row[syear],0,4);

//$gmonth = (int)substr($row[syear],5,2);

$gyear=date("Y");

$gmonth=date("n");

$gday=date("d"); //오늘

$sd = date("w", mktime(0,0,0,$gmonth,1,$gyear)); //요일 구하기 (num)

$ed = date("t", mktime(0,0,0,$gmonth,1,$gyear)); //마지막날 구하기

$jucnt=ceil(($sd+$ed)/7);

$day=-$sd+1;

} else {

//$gyear=date("Y");

//$gmonth=date("n");

$gday=date("d"); //오늘

$sd = date("w", mktime(0,0,0,$gmonth,1,$gyear)); //요일 구하기 (num)

$ed = date("t", mktime(0,0,0,$gmonth,1,$gyear)); //마지막날 구하기

$jucnt=ceil(($sd+$ed)/7);

$day=-$sd+1;

}

<tr>

<td height="30" style="padding-left:15px;" align="center">(<a href="<?=$PHP_SELF?>?pm=<?=$pm?>&studio=<?=$studio?>&gyear=<?=($gyear-1)?>&gmonth=<?=$gmonth?>&m=030200"><img src=/images/common/attend_title_dot1.gif></a><?=$gyear?>년<a href="<?=$PHP_SELF?>?pm=<?=$pm?>&studio=<?=$studio?>&gyear=<?=($gyear+1)?>&gmonth=<?=$gmonth?>&m=030200"><img src=/images/common/attend_title_dot2.gif></a>

<a href="<?=$PHP_SELF?>?pm=<?=$pm?>&studio=<?=$studio?>&gyear=<?=$gyear?>&gmonth=<?=($gmonth-1)?>&m=030200"><img src=/images/common/attend_title_dot1.gif></a><?=$gmonth?>월<a href="<?=$PHP_SELF?>?pm=<?=$pm?>&studio=<?=$studio?>&gyear=<?=$gyear?>&gmonth=<?=($gmonth+1)?>&m=030200"><img src=/images/common/attend_title_dot2.gif></a>)출석부

</td>

</tr>

<tr>

<tr>

<td width="20%"><img src=/images/common/attend_menu_01.gif> :

<?=$row[title]?>

</td>

<td width="20%"><img src=/images/common/attend_menu_02.gif> :

<?=$row[grade]?>

학년</td>

<td width="20%"><img src=/images/common/attend_menu_03.gif> :

<?=$row[hakjum]?>

점</td>

<td width="20%"><img src=/images/common/attend_menu_04.gif> :

//members

$query_g = "SELECT * FROM members WHERE m_uid='$row[gangsa]'";

$result_g = mysql_query($query_g);

$row_g = mysql_fetch_array($result_g);

echo $row_g[m_name];

(인)</td>

<td width="20%"><img src=/images/common/attend_menu_05.gif> :

//members

$query_g = "SELECT * FROM members WHERE m_uid='$row[professor]'";

$result_g = mysql_query($query_g);

$row_g = mysql_fetch_array($result_g);

echo $row_g[m_name];

(인)</td>

</tr>

</table></td>

</tr>

<tr>

학과</td>

월</td>

</tr>

일</td>

for ( $ju=0 ; $ju < $jucnt ; $ju++ ) {

for ( $i=0 ; $i < 7 ; $i++, $day++ ) {

if ( $day > 0 && $day <= $ed ) { echo "<td width=21 align=center>".$day."</td>"; }

//echo "(".date("w",mktime(0,0,0,3,$day,2008)).")";

}

</tr>

요일</td>

$day=-$sd+1;

for ( $ju=0 ; $ju < $jucnt ; $ju++ ) {

for ( $i=0 ; $i < 7 ; $i++, $day++ ) {

if ( $day > 0 && $day <= $ed ) {

$yoil = date("w",mktime(0,0,0,$gmonth,$day,$gyear));

if($yoil==0) {

$yoil_han = "일";

} else if($yoil==1) {

$yoil_han = "월";

} else if($yoil==2) {

$yoil_han = "화";

} else if($yoil==3) {

$yoil_han = "수";

} else if($yoil==4) {

$yoil_han = "목";

} else if($yoil==5) {

$yoil_han = "금";

} else if($yoil==6) {

$yoil_han = "토";

}

echo "<td width=21 align=center>".$yoil_han."</td>";

}

</tr>

시수</td>

$day=-$sd+1;

for ( $ju=0 ; $ju < $jucnt ; $ju++ ) {

for ( $i=0 ; $i < 7 ; $i++, $day++ ) {

if ( $day > 0 && $day <= $ed ) {

//시수 - 암꺼나 하나 가져온다

$query1 = "SELECT * FROM chulcheck WHERE studio='$studio' AND year='$gyear' AND month='$gmonth'

AND day='$day' LIMIT 1";

//echo $query1;

$result1 = mysql_query($query1);

$row1 = mysql_fetch_array($result1);

if($row1) {

echo "<td width=21 align=center><a href=javascript:go_sisu(".$studio.",".$gyear.",".$gmonth.",".$day.");>".$row1[sisu]."</a></td>";

} else {

echo "<td width=21 align=center><a href=\"javascript:alert('출석체크 1건입력후 입력가능합니다');\">0</a></td>";

}

</tr>

//members

$db_studio = "|".$studio."|";

$query = "SELECT * FROM members WHERE m_level=9 AND m_studio LIKE '%$db_studio%' AND secede='N' ORDER BY m_uid DESC";

$result = mysql_query($query);

while($mb = mysql_fetch_array($result)) {

//학과

$class = get_class2();

foreach($class as $item => $val)

$class_name = $class[$mb['m_class']];

<?=$class_name?>

</td>

$day=-$sd+1;

for ( $ju=0 ; $ju < $jucnt ; $ju++ ) {

for ( $i=0 ; $i < 7 ; $i++, $day++ ) {

if ( $day > 0 && $day <= $ed ) {

//chulcheck

$query1 = "SELECT * FROM chulcheck WHERE id='$mb[m_id]' AND studio='$studio' AND year='$gyear' AND month='$gmonth'

AND day='$day'";

$result1 = mysql_query($query1);

$row1 = mysql_fetch_array($result1);

echo $row1[chulcheck];

</td>

}

</tr>

<? } ?>

</table></td>

</tr><? } ?>

</table> <br>

</span>

</div>

</DIV>

[Top]

No.	제목	작성자	작성일	조회
27554	디비자동 백업관련 입니다.. [2]	정기수	2008-05-13	4215
27553	[질문]varchar 형의 Max 값 구하기 [3]	박계원	2008-05-13	5825
27551	LOAD DATA 사용시 한글이 깨지네요. ㅠㅠ [2]	강재호	2008-04-30	4039
27550	일주일(한달)중 토요일과 일요일은 출력하지 않게하려면	최재영	2008-04-30	3354
27549	mysql.sock 접속 문제.... ㅜㅜ	박화은	2008-04-29	3733
27548	날짜 자동 생성... [1]	천명환	2008-04-29	3493
27547	mysql에서 한글을 사용하고 싶습니다. [1]	helpme	2008-04-29	3378

작업시간: 0.017초, 이곳 서비스는
PostgreSQL v16.2로 자료를 관리합니다