채택완료

관리자 질문좀 드리겠습니다.

2016-11-30 (수) 16:45:05 4,338

안녕하세요 관리자 페이지를 만들고있습니다..

아직 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 .= "&nbsp;&nbsp;&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&amp;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 포인트

걍 이렇게 수정해도 안되는거죠?

<?php echo $pp['pp_wr1']; ?>  

답변에 대한 댓글 2개

네..그런데 문제는 저장이안됩니다. 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']}' ";
}

혹시 해당테이블에 pp_wr1 칼럼 만드신건가요? 

답변에 대한 댓글 1개

네 맞습니다.

<?php echo $pp['pp_wr1'] ? $pp['pp_wr1'] : ''; ?> 

여기부분 이해가 잘안되는데요..

<?php echo $pp['pp_wr1']; ?>

답변에 대한 댓글 1개

여분필드 처럼 wr_1 <이런식으로 사용할려고합니다 ...명칭만 다를뿐입니다.

답변을 작성하려면 로그인이 필요합니다.