안녕하세요 관리자 페이지를 만들고있습니다..
아직 php 초보자라서 여러가지를 해보는중인데
카테고리랑 pp_wr1 <명칭 들어간부분이 저장이안되는데
저장은 어떻게해야하나요 ㅠㅜ?
personalpayform.php
Copy
<?php$sub_menu = '400440';include_once('./_common.php'); auth_check($auth[$sub_menu], "w"); $g5['title'] = '요금제 관리'; if ($w == 'u') { $html_title = '요금제 수정'; $sql = " select * from {$g5['g5_shop_personalpay_table']} where pp_id = '$pp_id' "; $pp = sql_fetch($sql); if (!$pp['pp_id']) alert('등록된 자료가 없습니다.');}else{ $html_title = '요금제 입력'; $pp['pp_use'] = 1;} $category_select = '';$script = '';$sql = " select * from {$g5['g5_shop_category_table']} ";if ($is_admin != 'super') $sql .= " where ca_mb_id = '{$member['mb_id']}' ";$sql .= " order by ca_order, ca_id ";$result = sql_query($sql);for ($i=0; $row=sql_fetch_array($result); $i++){ $len = strlen($row['ca_id']) / 2 - 1; $nbsp = ""; for ($i=0; $i<$len; $i++) $nbsp .= " "; $category_select .= "<option value=\"{$row['ca_id']}\">$nbsp{$row['ca_name']}</option>\n"; $script .= "ca_use['{$row['ca_id']}'] = {$row['ca_use']};\n"; $script .= "ca_stock_qty['{$row['ca_id']}'] = {$row['ca_stock_qty']};\n"; //$script .= "ca_explan_html['$row[ca_id]'] = $row[ca_explan_html];\n"; $script .= "ca_sell_email['{$row['ca_id']}'] = '{$row['ca_sell_email']}';\n";} $wrp_tag_st = '';$wrp_tag_end = '';if($popup == 'yes') { // 팝업창일 때 include_once(G5_PATH.'/head.sub.php'); $pp['od_id'] = $od_id; $sql = " select od_id, od_name, od_misu from {$g5['g5_shop_order_table']} where od_id = '$od_id' "; $od = sql_fetch($sql); $pp['pp_name'] = $od['od_name']; if($od['od_misu'] > 0) $pp['pp_price'] = $od['od_misu']; $wrp_tag_st = '<div class="new_win">'.PHP_EOL.'<h1 id="new_win_title">'.$html_title.'</h1>'; $wrp_tag_end = '</div>';}else { // 현재페이지일 때 include_once (G5_ADMIN_PATH.'/admin.head.php');}$pg_anchor = '<ul class="anchor"><li><a href="#anc_spp_info">주문 정보</a></li> </ul>'; // pg 설정 필드 추가 ?> <form name="fpersonalpayform" action="./personalpayformupdate.php" method="post" onsubmit="return form_check(this);"><input type="hidden" name="w" value="<?php echo $w; ?>"><input type="hidden" name="pp_id" value="<?php echo $pp_id; ?>"><input type="hidden" name="sst" value="<?php echo $sst; ?>"><input type="hidden" name="sod" value="<?php echo $sod; ?>"><input type="hidden" name="sfl" value="<?php echo $sfl; ?>"><input type="hidden" name="stx" value="<?php echo $stx; ?>"><input type="hidden" name="page" value="<?php echo $page; ?>"><input type="hidden" name="popup" value="<?php echo $popup; ?>"><?php if($popup == 'yes') { ?><input type="hidden" name="pp_use" value="1"><?php } ?> <?php echo $wrp_tag_st; ?> <section id="anc_spp_info"> <h2 class="h2_frm">요금제 </h2> <div class="tbl_frm01 tbl_wrap"> <table> <caption>상품분류 입력</caption> <colgroup> <col class="grid_4"> <col> </colgroup> <tbody> <tr> <th scope="row"><label for="ca_id">기본분류</label></th> <td> <?php if ($w == "") echo help("기본분류를 선택하면, 판매/재고/HTML사용/판매자 E-mail 등을, 선택한 분류의 기본값으로 설정합니다."); ?> <select name="ca_id" id="ca_id" onchange="categorychange(this.form)"> <option value="">선택하세요</option> <?php echo conv_selected_option($category_select, $it['ca_id']); ?> </select> <script> var ca_use = new Array(); var ca_stock_qty = new Array(); //var ca_explan_html = new Array(); var ca_sell_email = new Array(); var ca_opt1_subject = new Array(); var ca_opt2_subject = new Array(); var ca_opt3_subject = new Array(); var ca_opt4_subject = new Array(); var ca_opt5_subject = new Array(); var ca_opt6_subject = new Array(); <?php echo "\n$script"; ?> </script> </td> </tr> <?php for ($i=2; $i<=3; $i++) { ?> <tr> <th scope="row"><label for="ca_id<?php echo $i; ?>"><?php echo $i; ?>차 분류</label></th> <td> <?php echo help($i.'차 분류는 기본 분류의 하위 분류 개념이 아니므로 기본 분류 선택시 해당 상품이 포함될 최하위 분류만 선택하시면 됩니다.'); ?> <select name="ca_id<?php echo $i; ?>" id="ca_id<?php echo $i; ?>"> <option value="">선택하세요</option> <?php echo conv_selected_option($category_select, $it['ca_id'.$i]); ?> </select> </td> </tr> <?php } ?> </tbody> </table> </div> <div class="tbl_frm01 tbl_wrap"> <table> <caption>주문 정보 목록</caption> <colgroup> <col class="grid_4"> <col> </colgroup> <tbody> <tr> <th scope="row"><label for="pp_name"> 요금제명 :</label></th> <td><input type="text" name="pp_name" value="<?php echo get_text($pp['pp_name']); ?>" id="pp_name" required class="required frm_input"></td> </tr> <tr> <th scope="row"><label for="pp_price">기본요금제 :</label></th> <td><input type="text" name="pp_price" value="<?php echo $pp['pp_price']; ?>" id="pp_price" required class="required frm_input" size="20"> </td> </tr> <tr> <th scope="row"><label for="pp_wr1">약정할인 :</label></th> <td><input type="text" name="pp_wr1" value="<?php echo $pp['pp_wr1'] ? $pp['pp_wr1'] : ''; ?>" id="pp_wr1" class="frm_input" size="20"></td> </tr> <tr> <th scope="row"><label for="pp_wr2">전화제공 :</label></th> <td><input type="text" name="pp_wr2" value="<?php echo $pp['pp_wr2'] ? $pp['pp_wr2'] : ''; ?>" id="pp_wr2" class="frm_input" size="20"></td> </tr> <tr> <th scope="row"><label for="pp_wr3">데이터제공 :</label></th> <td><input type="text" name="pp_wr3" value="<?php echo $pp['pp_wr3'] ? $pp['pp_wr3'] : ''; ?>" id="pp_wr3" class="frm_input" size="20"></td> </tr> <tr> <th scope="row"><label for="pp_wr4">문자제공 :</label></th> <td><input type="text" name="pp_wr4" value="<?php echo $pp['pp_wr4'] ? $pp['pp_wr4'] : ''; ?>" id="pp_wr4" class="frm_input" size="20"></td> </tr> <tr> <th scope="row"><label for="pp_content">내용</label></th> <td><textarea name="pp_content" id="pp_content" rows="8"><?php echo $pp['pp_content']; ?></textarea></td> </tr> </tbody> </table> </div> </section> <div class="btn_confirm01 btn_confirm"> <input type="submit" value="확인" class="btn_submit" accesskey="s"> <?php if($popup == 'yes') { ?> <button type="button" onclick="self.close();">닫기</button> <?php } else { ?> <a href="./personalpaylist.php?<?php echo $qstr; ?>">목록</a> <?php } ?> <?php if($w == 'u') { ?> <a href="./personalpayformupdate.php?w=d&pp_id=<?php echo $pp['pp_id']; ?>" onclick="return delete_confirm(this);">삭제</a> <?php } ?> </div> <?php if($popup != 'yes') { ?> <?php } ?> </form> <script>function form_check(f){ if(f.pp_price.value.replace(/[0-9]/g, "").length > 0) { alert("주문금액은 숫자만 입력해 주십시오"); return false; } return true;}</script> <?phpif($popup == 'yes') { echo '<script src="'.G5_ADMIN_URL.'/admin.js"></script>'.PHP_EOL; include_once(G5_PATH.'/tail.sub.php');} else { include_once (G5_ADMIN_PATH.'/admin.tail.php');}?>
personalpaycopyupdate.php
Copy
$sql_common = " pp_name = '{$_POST['pp_name']}', pp_price = '{$_POST['pp_price']}', pp_content = '{$_POST['pp_content']}', pp_receipt_price = '{$_POST['pp_receipt_price']}', pp_settle_case = '{$_POST['pp_settle_case']}', pp_receipt_time = '{$_POST['pp_receipt_time']}', pp_shop_memo = '{$_POST['pp_shop_memo']}', pp_wr1 = '{$_POST['pp_wr1']}', pp_wr2 = '{$_POST['pp_wr2']}', pp_wr3 = '{$_POST['pp_wr3']}', pp_wr4 = '{$_POST['pp_wr4']}', pp_use = '{$_POST['pp_use']}' ";}
|
답변 3개 / 댓글 4개
채택된 답변
+20 포인트
2016-11-30 (수) 17:48:14
걍 이렇게 수정해도 안되는거죠?
<?php echo $pp['pp_wr1']; ?>
답변에 대한 댓글 2개
fldkfem1
2016-11-30 (수) 17:50:37
fldkfem1
2016-11-30 (수) 17:51:42
personalpaycopyupdate.php 여기 부분에서요
pp_wr1 = '{$_POST['pp_wr1']}', 이거만추가하면 다른것도 다저장이안되네요 ㅠㅠ
$sql_common = " pp_name = '{$_POST['pp_name']}',
pp_price = '{$_POST['pp_price']}',
od_id = '$od_id',
pp_content = '{$_POST['pp_content']}',
pp_receipt_price = '{$_POST['pp_receipt_price']}',
pp_settle_case = '{$_POST['pp_settle_case']}',
pp_receipt_time = '{$_POST['pp_receipt_time']}',
pp_shop_memo = '{$_POST['pp_shop_memo']}',
pp_wr1 = '{$_POST['pp_wr1']}',
pp_use = '{$_POST['pp_use']}' ";
}
pp_wr1 = '{$_POST['pp_wr1']}', 이거만추가하면 다른것도 다저장이안되네요 ㅠㅠ
$sql_common = " pp_name = '{$_POST['pp_name']}',
pp_price = '{$_POST['pp_price']}',
od_id = '$od_id',
pp_content = '{$_POST['pp_content']}',
pp_receipt_price = '{$_POST['pp_receipt_price']}',
pp_settle_case = '{$_POST['pp_settle_case']}',
pp_receipt_time = '{$_POST['pp_receipt_time']}',
pp_shop_memo = '{$_POST['pp_shop_memo']}',
pp_wr1 = '{$_POST['pp_wr1']}',
pp_use = '{$_POST['pp_use']}' ";
}
2016-11-30 (수) 17:43:55
혹시 해당테이블에 pp_wr1 칼럼 만드신건가요?
답변에 대한 댓글 1개
2016-11-30 (수) 17:37:17
<?php echo $pp['pp_wr1'] ? $pp['pp_wr1'] : ''; ?>
여기부분 이해가 잘안되는데요..
<?php echo $pp['pp_wr1']; ?>
답변에 대한 댓글 1개
fldkfem1
2016-11-30 (수) 17:40:14
여분필드 처럼 wr_1 <이런식으로 사용할려고합니다 ...명칭만 다를뿐입니다.
답변을 작성하려면 로그인이 필요합니다.
pp_wr1 <저장이안됩니다