급급해서 php급 문의입니다,,ㅠㅠ > 십년전오늘

십년전오늘

10년전 추억의 책장을 넘기며

급급해서 php급 문의입니다,,ㅠㅠ 정보

급급해서 php급 문의입니다,,ㅠㅠ

본문

제가 파일을 뒤집은 관계로 수정후 파일이 없어졌네요, 디자이너라 php쪽은 아예모르는데 도통 뭐가 잘못된건지 모르겠어여,,

http://philwoori.co.kr/air/air_list.php?at1_code=1
페이지는 여기구요.

여기서 항공사 마크가 다 동일시 나오는데여.
각각 데이타를 입력하면, 해당쿼리에 있는 값을 던져줘야하는데 그게 안되고 있어요.

<?
include_once '../WM_Config/define.php';
include_once define_Path.'/WM_Lib/common.lib.php';
include_once define_Path.'/WM_Function/common.php';
include_once define_Path.'/WM_Function/fn_page.php';

switch ($at1_code) {
case "1": $Tit_img = "air_top.gif"; break;
case "2": $Tit_img = "air_3.jpg"; break;
case "3": $Tit_img = "ari_4.jpg"; break;
default: $Tit_img = "air_top.gif"; break;
}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr">
<title>필리핀 전문 여행___우리여행사</title>
<script language="javascript" src="/WM_JS/pop.js"></script>
<link href="<?=define_ROOTS;?>WM_Style/wm_style.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
@import url("../tu.css");
-->
</style>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function getRule(arg) {
pop_win('./air_rule.php?at_uiq='+arg,'air_rules','100','100','575','693');
}
function getTime(arg) {
pop_win4('./air_time.php?at_uiq='+arg,'air_time','100','100','500','500');
}

var old_menu = '';
function menuclick( submenu ) {
if( old_menu != submenu ) {
if( old_menu !='' ) {
old_menu.style.display = 'none';
}
submenu.style.display = 'block';
old_menu = submenu;

} else {
submenu.style.display = 'none';
old_menu = '';
}
}
var old_menus = '';
function menuclicks( submenus ) {
if( old_menus != submenus ) {
if( old_menus !='' ) {
old_menus.style.display = 'none';
}
submenus.style.display = 'block';
old_menus = submenus;

} else {
submenus.style.display = 'none';
old_menus = '';
}
}

//-->
</script>
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="1000" border="0" align="left" cellpadding="0" cellspacing="0">
  <tr>
    <td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td>
            <? include $_SERVER["DOCUMENT_ROOT"]. "/public/top.htm"; ?>
          </td>
        </tr>
      </table></td>
  </tr>
  <tr>
    <td width="237" rowspan="2" valign="top">
      <? include $_SERVER["DOCUMENT_ROOT"]. "/public/left_air.htm"; ?>
    </td>
    <td width="763"><table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td><img src="../images/<?=$Tit_img;?>"></td>
        </tr>
        <tr>
          <td align="center"> <div align="left">
              <table width="693" height="87" border="0" cellpadding="0" cellspacing="0" class="box8">
                <tr>
                  <td width="214" height="67"> <table width="97%" height="67" border="0" cellpadding="0" cellspacing="0" background="../images/dddd.jpg">
                      <tr>
                        <td>&nbsp;</td>
                      </tr>
                    </table></td>
                  <td width="469"><table width="100%" height="23" border="0" cellpadding="0" cellspacing="0">
                      <tr>
                        <td>
<font color="#336699">
<?
$AC_Q =db_query("select * from wm_air_category where cate_code = '".$at1_code."'",$db);
$AC_tot = db_num_rows($AC_Q);
$i = 1;
while ($AC_R = db_fetch_array($AC_Q)) {
?>
<strong><a href="./air_list.php?at1_code=<?=$at1_code;?>&at2_code=<?=$AC_R['cate_uiq'];?>"><?=$AC_R['cate_name'];?></a> </strong>
<? if ($i != $AC_tot) { ?> | <? } ?>
<?
$i++;
}
?>
</font>
</td>
                      </tr>
                    </table></td>
                </tr>
              </table>
            </div></td>
        </tr>
      </table></td>
  </tr>
  <tr>
    <td align="left" valign="top">
<table width="91%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td height="10" align="right" valign="bottom">
<!-- <table width="43%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td width="81%" align="right"><span class="small02">월별조건</span>
                  <select name="select" class="small01">
                    <option>4월</option>
                  </select> <span class="small02">정렬조건</span> <select name="select2" class="small01">
                    <option>최저가기준</option>
                  </select> </td>
                <td width="19%" align="right"><img src="../images/ari_p_17.gif" width="53" height="26"></td>
              </tr>
            </table> -->
</td>
        </tr>
        <tr>
          <td height="27" align="center"> <table width="100%" height="25" border="0" cellpadding="0" cellspacing="0" class="box02">
              <tr>
                <td height="15">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" class="small">
                    <tr align="center" class="ss">
                      <td width="141"class="small02"><strong>항공사</strong></td>
                      <td width="10"class="small02">|</td>
                      <td width="111"><span class="small02"><strong>특징</strong></span><font color="#666666">&nbsp;
                        </font></td>
                      <td width="8" class="small02">|</td>
                      <td width="99" class="small02"><strong>적용기간</strong></td>
                      <td width="5" class="small02">|</td>
                      <td width="109" class="small02"><strong>가 격</strong></td>
                      <td width="6" class="small02">|</td>
                      <td width="126" class="small02"><strong>규 정</strong></td>
                      <td width="7" class="small02">|</td>
                      <td width="101" class="small02"><strong>예약</strong></td>
                    </tr>
                  </table></td>
              </tr>
            </table></td>
        </tr>
        <tr align="center">
          <td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<?
if ($at1_code) {
$S_Where = " AND aircate1 = '".$at1_code."'";
}
if ($at2_code) {
$S_Where.= " AND aircate2 = '".$at2_code."'";
}
$qry = mysql_fetch_row(mysql_query("select count(*) from wm_air_ticket where at_view = 'y' $S_Where",$db));
$tot = $qry[0];
if (!$gsCount) $gsCount = 10;  //리스트의 화면 출력수
if (!$page) $page = 1;
$tot_page = ceil($tot/$gsCount);
$url = $PHP_SELF;
$f_page = $gsCount * ( $page-1 );
$last = $page * $gsCount;
$sql1 = "select * from wm_air_ticket where at_view = 'y' ".$S_Where." order by at_wdate Desc limit ".$f_page.",".$gsCount;
//echo $sql1;
$qry1 = mysql_query($sql1,$db);
$tot1 = mysql_affected_rows($db);
$gsPage = 10;  // 생성된 게시판 리스트의 페이지 표시수
$option = "";
$page_list = getPaging($url,$tot,$page,$gsPage,$gsCount,$option);
?>
<?
if ($tot < 1) {
?>
<tr>
<td colspan="11" align="center" height="50"><font color="#FF0000"><B>표시할 데이터가 없습니다.</B></font></td>
</tr>
<tr>
<td><hr size="1" style="color:#E3E3E3;"></td>
</tr>
<?
} else {
$line_num = $tot - $gsCount *($page-1);
while ($r = db_fetch_array($qry1)){
#--- 항공사 체크
$AR_r = db_fetch_array(db_query("select ac_name from wm_air_company where ac_uiq = '".$r['at_uiq']."'",$db));
#---티켓구분
switch ($r['at_ticket_type']) {
case "1": $ticket_type = "7일 단기티켓"; break;
case "2": $ticket_type = "15일 단기티켓"; break;
case "3": $ticket_type = "1개월 단기티켓"; break;
case "4": $ticket_type = "3개월 장기티켓"; break;
case "5": $ticket_type = "6개월 일반티켓"; break;
case "6": $ticket_type = "1년 일반티켓"; break;
}
#--- 경유지 구분
if ($r['at_course'] == "1") {
$course = "직항";
} else if ($r['at_course'] == "2") {
$course = "경유";
}
#--- 왕복/편도 구분
if ($r['at_go_type'] == "1") {
$go_type = "왕복";
} else if ($r['at_course'] == "2") {
$go_type = "편도";
}
#--- 전자티켓 구분
if ($r['at_digital_ticket'] == "y") {
$digital_ticket = "전자티켓";
} else if ($r['at_course'] == "2") {
$digital_ticket = "";
}
#--- 등록일자
$wday = explode(" ",$r['at_wdate']);
#--- 운항시간표 체크
$time_r = db_fetch_array(db_query("select count(*) as tot from wm_air_time where air_ticket_code = '".$r['at_uiq']."'",$db));
//$Btn_Time = "<img src=\"../admin/images/button/air_time_on.gif\" onclick=\"getTime('$r[at_uiq]');\" style=\"cursor:hand;\">";
$Btn_Time = "<img src=\"../admin/images/button/air_time_on.gif\" onClick=\"menuclick(sq".$line_num.");menuclicks(sq_line".$line_num.");\" style=\"cursor:hand;\">";
#--- 항공규정 체크
$rule_r = db_fetch_array(db_query("select count(*) as tot from wm_air_rule where air_ticket_code = '".$r['at_uiq']."'",$db));
$Btn_Rule = "<img src=\"/images/flight_farelist_box3_listbtn1.gif\" onclick=\"getRule('$r[at_uiq]');\" style=\"cursor:hand;\">";

$tm_qry = db_query("select * from wm_air_time where air_ticket_code = '".$r['at_uiq']."' order by atime_wdate Desc",$db);

?>
<tr>
<td height="5"></td>
</tr>
              <tr>
                <!-- <td height="54" background="../images/bbbb.gif"> -->
                <td>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="0" class="small">
                    <tr align="center" class="ss">
                      <td width="25" height="48"class="small02"><img src="../images/ari_p_25.gif" width="22" height="22"></td>
                      <td width="127"class="small02"> <div align="left"><?=$AR_r['ac_name'];?></div></td>
                      <td width="120"class="small02"><div align="center"><?=$ticket_type;?><br><?=$digital_ticket;?><br><?=$course;?><br><?=$go_type;?></div></td>
                      <td width="102"class="small02"><?=$r['at_gigan1'];?><br><?=$r['at_gigan2'];?><br><?=$r['at_gigan3'];?><br><?=$r['at_gigan4'];?></td>
                      <td width="115"class="small02"><?=fn_won_set2($r['at_price']);?></td>
                      <td width="129"class="small02"><?=$Btn_Rule;?><BR><?=$Btn_Time;?></td>
                      <td width="106"class="small02"><a href="air_appointment.php?at_uiq=<?=$r['at_uiq'];?>"><img src="../images/ari_p_22.jpg" width="78" height="40"></a></td>
                    </tr>
                  </table>
</td>
              </tr>
<tr>
<td><hr size="1" style="color:#E3E3E3;"></td>
</tr>

<tr id="sq<?=$line_num;?>" style="display:none;">
<td align="right" bgcolor="#F9F5F5">
<table cellpadding="10"  cellspacing="0" border="0" bgcolor="#F9F5F5">
<?
while ($tm_r = db_fetch_array($tm_qry)) {
#---출발요일체크
$Start_Week = '';
if ($tm_r['atime_st_w'] == "y") {
$TD_Start_Week = "<td style=\"padding-left:10px;\">";
$Start_Week = "<img src=\"/admin/images/ico/w_daily.gif\">";
} else {
$TD_Start_Week = "<td style=\"padding-left:10px;\">";
if ($tm_r['atime_st_w1'] == "y") $Start_Week = "<img src=\"/admin/images/ico/w1_on.gif\">";
else  $Start_Week.= "<img src=\"/admin/images/ico/w1_off.gif\">";
if ($tm_r['atime_st_w2'] == "y") $Start_Week.= "&nbsp;<img src=\"/admin/images/ico/w2_on.gif\">";
else  $Start_Week.= "&nbsp;<img src=\"/admin/images/ico/w2_off.gif\">";
if ($tm_r['atime_st_w3'] == "y") $Start_Week.= "&nbsp;<img src=\"/admin/images/ico/w3_on.gif\">";
else  $Start_Week.= "&nbsp;<img src=\"/admin/images/ico/w3_off.gif\">";
if ($tm_r['atime_st_w4'] == "y") $Start_Week.= "&nbsp;<img src=\"/admin/images/ico/w4_on.gif\">";
else  $Start_Week.= "&nbsp;<img src=\"/admin/images/ico/w4_off.gif\">";
if ($tm_r['atime_st_w5'] == "y") $Start_Week.= "&nbsp;<img src=\"/admin/images/ico/w5_on.gif\">";
else  $Start_Week.= "&nbsp;<img src=\"/admin/images/ico/w5_off.gif\">";
if ($tm_r['atime_st_w6'] == "y") $Start_Week.= "&nbsp;<img src=\"/admin/images/ico/w6_on.gif\">";
else  $Start_Week.= "&nbsp;<img src=\"/admin/images/ico/w6_off.gif\">";
if ($tm_r['atime_st_w7'] == "y") $Start_Week.= "&nbsp;<img src=\"/admin/images/ico/w7_on.gif\">";
else  $Start_Week.= "&nbsp;<img src=\"/admin/images/ico/w7_off.gif\">";
}
?>
<tr>
<td><?=$tm_r[atime_st_area];?>[<?=$tm_r[atime_st_time];?>] → <?=$tm_r[atime_arr_area];?>[<?=$tm_r[atime_arr_time];?>] [<?=$tm_r[atime_air_name];?>]</td>
<?=$TD_Start_Week;?><?=$Start_Week;?></td>
</tr>
<?
}
?>
</table>
</td>
</tr>
<tr id="sq_line<?=$line_num;?>" style="display:none;">
<td><hr size="1" style="color:#E3E3E3;"></td>
</tr>
<?
$line_num--;
}
}
?>

            </table>
<table width="100%" height="30" cellpadding="0" cellspacing="0" border="0">
<tr>
<td align="center"><?=$page_list[paging]?></td>
</tr>
</table>
</td>
        </tr>
        <tr>
          <td>&nbsp;</td>
        </tr>
      </table>
      <div align="left"></div>
      <div align="left"></div></td>
  </tr>
  <tr>
    <td colspan="2" valign="top"><table width="1000" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td>
            <? include $_SERVER["DOCUMENT_ROOT"]. "/public/copy.htm"; ?>
          </td>
        </tr>
      </table></td>
  </tr>
</table>

댓글 전체

전체 129,546
십년전오늘 내용 검색

회원로그인

진행중 포인트경매

  1. 참여0 회 시작24.03.28 11:15 종료24.04.04 11:15
(주)에스아이알소프트 / 대표:홍석명 / (06211) 서울특별시 강남구 역삼동 707-34 한신인터밸리24 서관 1404호 / E-Mail: admin@sir.kr
사업자등록번호: 217-81-36347 / 통신판매업신고번호:2014-서울강남-02098호 / 개인정보보호책임자:김민섭(minsup@sir.kr)
© SIRSOFT