예약한 수업시간이 출력이 안되고 예약자가 입력한 시간이 출력됩니다
본문
언어수업예약을 받는 게시판인데요
관리자가 "5시~6시 수업" 이라고 올리면 예약자가 해당 시간에 예약을 하면 예약시간에 "5시~6시 수업" 이출력되어야 하는데 예약자가 입력한 시간이 출력됩니다 ;;
<?php
$sub_menu = '700200';
include_once('./_common.php');
auth_check($auth[$sub_menu], "w");
$html_title = "내용";
$g5['title'] = $html_title.' 관리';
unset($arr_week);
$arr_week = array();
if ($w == "u")
{
$html_title .= " 수정";
$readonly = " readonly";
$sql = " select * from {$g5['wz_schedule_table']} where sc_id = '$sc_id' ";
$sc = sql_fetch($sql);
if (!$sc['sc_id'])
alert('등록된 자료가 없습니다.');
$arr_week = explode(',', $sc['sc_week']);
}
else
{
$html_title .= ' 입력';
}
include_once (G5_ADMIN_PATH.'/admin.head.php');
?>
<form name="frmcontentform" action="./wz_schedule_form_update.php" onsubmit="return getAction(this);" method="post">
<input type="hidden" name="w" value="<?php echo $w; ?>">
<input type="hidden" name="sc_id" value="<?php echo $sc_id;?>">
<div class="tbl_frm01 tbl_wrap">
<table>
<caption><?php echo $g5['title']; ?> 목록</caption>
<colgroup>
<col class="grid_4">
<col>
</colgroup>
<tbody>
<tr>
<th scope="row"><label for="bo_table">언어</label></th>
<td>
<select name="bo_table" id="bo_table" required>
<option value="">선택</a>
<?php
$sql = " select bo_table, bo_subject from {$g5['board_table']} where gr_id = 'language' order by bo_order asc ";
$result = sql_query($sql);
for($i=0; $row=sql_fetch_array($result); $i++) {
echo "<option value=\"{$row['bo_table']}\"";
if ($sc['bo_table'] == $row['bo_table'])
echo ' selected="selected"';
echo ">{$row['bo_subject']}</option>\n";
}
?>
</select>
</td>
</tr>
<tr>
<th scope="row"><label for="sc_campus">캠퍼스</label></th>
<td>
<select name="sc_campus" id="sc_campus" required>
<option value="">선택</a>
<option value="수영캠퍼스" <?php echo ($sc['sc_campus'] == '수영캠퍼스' ? 'selected="selected"' : '');?>>수영캠퍼스</a>
<option value="금정캠퍼스" <?php echo ($sc['sc_campus'] == '금정캠퍼스' ? 'selected="selected"' : '');?>>금정캠퍼스</a>
</select>
</td>
</tr>
<tr>
<th scope="row"><label for="sc_subject">강좌명</label></th>
<td><input type="text" name="sc_subject" value="<?php echo htmlspecialchars2($sc['sc_subject']); ?>" id="sc_subject" required class="frm_input required" size="90"></td>
</tr>
<tr>
<th scope="row"><label for="sc_week_1">수강요일</label></th>
<td>
<input type="checkbox" name="sc_week[]" id="sc_week_1" value="월" <?php if (in_array('월', $arr_week)) echo 'checked';?> /><label for="sc_week_1"> 월</label>
<input type="checkbox" name="sc_week[]" id="sc_week_2" value="화" <?php if (in_array('화', $arr_week)) echo 'checked';?> /><label for="sc_week_2"> 화</label>
<input type="checkbox" name="sc_week[]" id="sc_week_3" value="수" <?php if (in_array('수', $arr_week)) echo 'checked';?> /><label for="sc_week_3"> 수</label>
<input type="checkbox" name="sc_week[]" id="sc_week_4" value="목" <?php if (in_array('목', $arr_week)) echo 'checked';?> /><label for="sc_week_4"> 목</label>
<input type="checkbox" name="sc_week[]" id="sc_week_5" value="금" <?php if (in_array('금', $arr_week)) echo 'checked';?> /><label for="sc_week_5"> 금</label>
<input type="checkbox" name="sc_week[]" id="sc_week_6" value="토" <?php if (in_array('토', $arr_week)) echo 'checked';?> /><label for="sc_week_6"> 토</label>
<input type="checkbox" name="sc_week[]" id="sc_week_7" value="일" <?php if (in_array('일', $arr_week)) echo 'checked';?> /><label for="sc_week_7"> 일</label>
</td>
</tr>
<tr>
<th scope="row"><label for="sc_time">강의시간</label></th>
<td><input type="text" name="sc_time" value="<?php echo htmlspecialchars2($sc['sc_time']); ?>" id="sc_time" class="frm_input" size="50"></td>
</tr>
<tr>
<th scope="row"><label for="sc_teacher">담당선생님</label></th>
<td><input type="text" name="sc_teacher" value="<?php echo htmlspecialchars2($sc['sc_teacher']); ?>" id="sc_teacher" class="frm_input" size="30"></td>
</tr>
<tr>
<th scope="row"><label for="sc_status">상태</label></th>
<td>
<input type="radio" name="sc_status" id="sc_status_1" value="마감" <?php echo ($sc['sc_status'] == '마감' ? 'checked' : '');?> required /><label for="sc_status_1"> 마감</label>
<input type="radio" name="sc_status" id="sc_status_2" value="마감임박" <?php echo ($sc['sc_status'] == '마감임박' ? 'checked' : '');?> required /><label for="sc_status_2"> 마감임박</label>
<input type="radio" name="sc_status" id="sc_status_3" value="접수가능" <?php echo ($sc['sc_status'] == '접수가능' ? 'checked' : '');?> required /><label for="sc_status_3"> 접수가능</label>
</td>
</tr>
<tr>
<th scope="row"><label for="sc_bigo">비고</label></th>
<td><input type="text" name="sc_bigo" value="<?php echo htmlspecialchars2($sc['sc_bigo']); ?>" id="sc_bigo" class="frm_input" size="60"></td>
</tr>
</tbody>
</table>
</div>
<div class="btn_confirm01 btn_confirm">
<input type="submit" value="확인" class="btn_submit" accesskey="s">
<a href="./wz_schedule_list.php?<?php echo $qstr;?>">목록</a>
</div>
</form>
<script>
function getAction(f)
{
return true;
}
</script>
<?php
include_once (G5_ADMIN_PATH.'/admin.tail.php');
?>
위가 강의입력페이지구요
<?php
$sub_menu = '700100';
include_once('./_common.php');
auth_check($auth[$sub_menu], "w");
$html_title = "내용";
$g5['title'] = $html_title.' 관리';
unset($arr_week);
$arr_week = array();
if ($w == "u")
{
$html_title .= " 수정";
$readonly = " readonly";
$sql = " select * from {$g5['wz_order_table']} where od_id = '$od_id' ";
$od = sql_fetch($sql);
if (!$od['od_id'])
alert('등록된 자료가 없습니다.');
$sc_id = $od['sc_id'];
$sc['bo_subject'] = $od['od_language'];
$sc['sc_campus'] = $od['od_campus'];
$sc['sc_subject'] = $od['od_subject'];
$sc['sc_time'] = $od['od_time'];
}
else
{
$html_title .= ' 입력';
// 신청이 가능한 강좌인지 확인
$sql = " select * from {$g5['wz_schedule_table']} where sc_id = '$sc_id' ";
$sc = sql_fetch($sql);
if (!$sc['sc_id']) {
alert('존재하지 않는 강좌입니다.');
}
$bo = sql_fetch("select bo_subject, bo_1, bo_2 from {$g5['board_table']} where bo_table = '{$sc['bo_table']}'");
$sc['bo_subject'] = $bo['bo_subject'];
if ($sc['sc_campus'] == '수영캠퍼스') {
$od['od_section'] = $bo['bo_1'];
}
else {
$od['od_section'] = $bo['bo_2'];
}
}
include_once (G5_ADMIN_PATH.'/admin.head.php');
?>
<form name="frmcontentform" action="./wz_order_form_update.php" onsubmit="return getAction(this);" method="post">
<input type="hidden" name="w" value="<?php echo $w; ?>">
<input type="hidden" name="bo_table" id="bo_table" value="<?php echo $sc['bo_table'];?>" />
<input type="hidden" name="od_id" value="<?php echo $od_id;?>">
<input type="hidden" name="sc_id" value="<?php echo $sc_id;?>">
<div class="tbl_frm01 tbl_wrap">
<table>
<caption><?php echo $g5['title']; ?> 목록</caption>
<colgroup>
<col class="grid_4">
<col>
</colgroup>
<tbody>
<tr>
<th>언어</th>
<td><?php echo $sc['bo_subject'];?></td>
</tr>
<tr>
<th>캠퍼스</th>
<td><?php echo $sc['sc_campus'];?></td>
</tr>
<tr>
<th>강좌명</th>
<td><?php echo $sc['sc_subject'];?></td>
</tr>
<tr>
<th>강좌시간</th>
<td><?php echo $sc['sc_time'];?></td>
</tr>
<tr>
<th>개강월</th>
<td>
<input type="text" name="od_section" id="od_section" value="<?php echo $od['od_section'];?>" class="frm_input required" style="width:100px;" maxlength="20" required />
</td>
</tr>
<tr>
<th>신청자명</th>
<td>
<input type="text" name="od_name" id="od_name" value="<?php echo $od['od_name'];?>" class="frm_input required" style="width:100px;" maxlength="20" required />
</td>
</tr>
<tr>
<th>신청자아이디</th>
<td>
<input type="text" name="mb_id" id="mb_id" value="<?php echo $od['mb_id'];?>" class="frm_input" style="width:100px;" maxlength="20" />
</td>
</tr>
<tr>
<th>연락처</th>
<td>
<input type="text" name="od_tel" id="od_tel" value="<?php echo $od['od_tel'];?>" class="frm_input required" style="width:200px;" maxlength="30" required />
</td>
</tr>
<tr>
<th>이메일</th>
<td>
<input type="text" name="od_email" id="od_email" value="<?php echo $od['od_email'];?>" class="frm_input" style="width:300px;" maxlength="100" />
</td>
</tr>
</tbody>
</table>
</div>
<div class="btn_confirm01 btn_confirm">
<input type="submit" value="확인" class="btn_submit" accesskey="s">
<a href="./wz_order_list.php?<?php echo $qstr;?>">목록</a>
</div>
</form>
<script>
function getAction(f)
{
return true;
}
</script>
<?php
include_once (G5_ADMIN_PATH.'/admin.tail.php');
?>
위가 예약자출력페이지입니다...