관리자 질문좀 드리겠습니다.
본문
안녕하세요 관리자 페이지를 만들고있습니다..
아직 php 초보자라서 여러가지를 해보는중인데
카테고리랑 pp_wr1 <명칭 들어간부분이 저장이안되는데
저장은 어떻게해야하나요 ㅠㅜ?
personalpayform.php
<?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>
<?php
if($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
$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
걍 이렇게 수정해도 안되는거죠?
<?php echo $pp['pp_wr1']; ?>
네..그런데 문제는 저장이안됩니다. pp_name <이거는 저장이되는데
pp_wr1 <저장이안됩니다
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']}' ";
}
<?php echo $pp['pp_wr1'] ? $pp['pp_wr1'] : ''; ?>
여기부분 이해가 잘안되는데요..
<?php echo $pp['pp_wr1']; ?>
여분필드 처럼 wr_1 <이런식으로 사용할려고합니다 ...명칭만 다를뿐입니다.
혹시 해당테이블에 pp_wr1 칼럼 만드신건가요?
네 맞습니다.
답변을 작성하시기 전에 로그인 해주세요.
