테스트 사이트 - 개발 중인 베타 버전입니다

디비 질문좀 드리겠습니다. 채택완료

초보입니다1 7년 전 조회 1,795

안녕하세요 영카드 배너등록을 이용중인데요

글을 등록을 해도 저장이 되질 않습니다. 추가해야하는곳은 다했다고보는데 어떤것이 문제인지 잘모르겠습니다. 

답변좀 주시면 감사하겠습니다.

 

phpmyadmin  sql 에서 bn_1 bn_2 bn_3 다 추가했구요 

 

 

bannerform.php 부분

</p>

<p><tr>

        <th scope="row"><label for="bn_1">핸드폰명</label></th>

        <td>

            <input type="text" name="bn_1" size="80" value="<?php echo $bn['bn_1']; ?>" id="bn_1" class="frm_input">

        </td>

    </tr></p>

<p>

    <tr>

        <th scope="row"><label for="bn_2">예상요금</label></th>

        <td>

            <input type="text" name="bn_2" size="80" value="<?php echo $bn['bn_2']; ?>" id="bn_2" class="frm_input">

        </td>

    </tr>

    <tr>

        <th scope="row"><label for="bn_3">요금제</label></th>

        <td>

            <input type="text" name="bn_3" size="80" value="<?php echo $bn['bn_3']; ?>" id="bn_3" class="frm_input">

        </td>

    </tr></p>

<p>

 

 

bannerformupdate.php 부분

</p>

<p>$bn_url = clean_xss_tags($bn_url);</p>

<p>if ($w=="")

{

    if (!$bn_bimg_name) alert('배너 이미지를 업로드 하세요.');</p>

<p>    sql_query(" alter table {$g5['g5_shop_banner_table']} auto_increment=1 ");</p>

<p>    $sql = " insert into {$g5['g5_shop_banner_table']}

                set bn_alt        = '$bn_alt',

                    bn_url        = '$bn_url',

                    bn_device     = '$bn_device',

                    bn_position   = '$bn_position',

                    bn_border     = '$bn_border',

                    bn_new_win    = '$bn_new_win',

                    bn_begin_time = '$bn_begin_time',

                    bn_end_time   = '$bn_end_time',

                    bn_1          = '$bn_1',

                    bn_2          = '$bn_2',

                    bn_3          = '$bn_3',

                    bn_time       = '$now',

                    bn_hit        = '0',

                    bn_order      = '$bn_order' ";

    sql_query($sql);</p>

<p>    $bn_id = sql_insert_id();

}

else if ($w=="u")

{

    $sql = " update {$g5['g5_shop_banner_table']}

                set bn_alt        = '$bn_alt',

                    bn_url        = '$bn_url',

                    bn_device     = '$bn_device',

                    bn_position   = '$bn_position',

                    bn_border     = '$bn_border',

                    bn_new_win    = '$bn_new_win',

                    bn_begin_time = '$bn_begin_time',

                    bn_end_time   = '$bn_end_time',

                    bn_order      = '$bn_order',

                    bn_1          = '$bn_1',

                    bn_2          = '$bn_2',

                    bn_3          = '$bn_3',

                    where bn_id = '$bn_id' ";

    sql_query($sql);

}</p>

<p>

필드 종류 데이터정렬방식 보기 Null 기본값 추가 실행
  bn_1 varchar(255) utf8_general_ci   아니오 None   http://db.realkt.com/_gabia/dbadmin/sql.php?db=dbrealkt&table=g5_shop_banner&token=2ab5aaa97561fec9a0998b63af4fc4a9&goto=tbl_structure.php&back=tbl_structure.php&sql_query=SELECT+COUNT%28%2A%29+AS+%60%ED%96%89%28%EB%A0%88%EC%BD%94%EB%93%9C%29%60%2C+%60bn_1%60+FROM+%60g5_shop_banner%60+GROUP+BY+%60bn_1%60+ORDER+BY+%60bn_1%60&phpMyAdmin=3d866d0d27a160e3caf94a672025490d">Browse distinct valueshttp://db.realkt.com/_gabia/dbadmin/themes/original/img/b_browse.png" title="Browse distinct values" width="16" /> http://db.realkt.com/_gabia/dbadmin/tbl_alter.php?db=dbrealkt&table=g5_shop_banner&token=2ab5aaa97561fec9a0998b63af4fc4a9&goto=tbl_structure.php&back=tbl_structure.php&field=bn_1&phpMyAdmin=3d866d0d27a160e3caf94a672025490d">변경http://db.realkt.com/_gabia/dbadmin/themes/original/img/b_edit.png" title="변경" width="16" /> http://db.realkt.com/_gabia/dbadmin/sql.php?db=dbrealkt&table=g5_shop_banner&token=2ab5aaa97561fec9a0998b63af4fc4a9&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_shop_banner%60+DROP+%60bn_1%60&cpurge=1&purgekey=bn_1&zero_rows=%ED%95%84%EB%93%9C+bn_1+%EB%A5%BC+%EC%A0%9C%EA%B1%B0%ED%96%88%EC%8A%B5%EB%8B%88%EB%8B%A4&phpMyAdmin=3d866d0d27a160e3caf94a672025490d" onclick="return confirmLink(this, 'ALTER TABLE `g5_shop_banner` DROP `bn_1`')">삭제http://db.realkt.com/_gabia/dbadmin/themes/original/img/b_drop.png" title="삭제" width="16" /> http://db.realkt.com/_gabia/dbadmin/sql.php?db=dbrealkt&table=g5_shop_banner&token=2ab5aaa97561fec9a0998b63af4fc4a9&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_shop_banner%60+DROP+PRIMARY+KEY%2C+ADD+PRIMARY+KEY%28%60bn_1%60%29&zero_rows=+bn_1%EC%97%90+%EA%B8%B0%EB%B3%B8+%ED%82%A4%EA%B0%80+%EC%B6%94%EA%B0%80%EB%90%98%EC%97%88%EC%8A%B5%EB%8B%88%EB%8B%A4&phpMyAdmin=3d866d0d27a160e3caf94a672025490d" onclick="return confirmLink(this, 'ALTER TABLE `g5_shop_banner` DROP PRIMARY KEY, ADD PRIMARY KEY(`bn_1`)')">기본http://db.realkt.com/_gabia/dbadmin/themes/original/img/b_primary.png" title="기본" width="16" /> http://db.realkt.com/_gabia/dbadmin/sql.php?db=dbrealkt&table=g5_shop_banner&token=2ab5aaa97561fec9a0998b63af4fc4a9&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_shop_banner%60+ADD+UNIQUE%28%60bn_1%60%29&zero_rows=bn_1+%EC%97%90+%EC%9D%B8%EB%8D%B1%EC%8A%A4%EA%B0%80+%EA%B1%B8%EB%A0%B8%EC%8A%B5%EB%8B%88%EB%8B%A4&phpMyAdmin=3d866d0d27a160e3caf94a672025490d">고유값http://db.realkt.com/_gabia/dbadmin/themes/original/img/b_unique.png" title="고유값" width="16" /> http://db.realkt.com/_gabia/dbadmin/sql.php?db=dbrealkt&table=g5_shop_banner&token=2ab5aaa97561fec9a0998b63af4fc4a9&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_shop_banner%60+ADD+INDEX%28%60bn_1%60%29&zero_rows=bn_1+%EC%97%90+%EC%9D%B8%EB%8D%B1%EC%8A%A4%EA%B0%80+%EA%B1%B8%EB%A0%B8%EC%8A%B5%EB%8B%88%EB%8B%A4&phpMyAdmin=3d866d0d27a160e3caf94a672025490d">인덱스http://db.realkt.com/_gabia/dbadmin/themes/original/img/b_index.png" title="인덱스" width="16" /> http://db.realkt.com/_gabia/dbadmin/sql.php?db=dbrealkt&table=g5_shop_banner&token=2ab5aaa97561fec9a0998b63af4fc4a9&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_shop_banner%60+ADD+FULLTEXT%28%60bn_1%60%29&zero_rows=bn_1+%EC%97%90+%EC%9D%B8%EB%8D%B1%EC%8A%A4%EA%B0%80+%EA%B1%B8%EB%A0%B8%EC%8A%B5%EB%8B%88%EB%8B%A4&phpMyAdmin=3d866d0d27a160e3caf94a672025490d">Fulltexthttp://db.realkt.com/_gabia/dbadmin/themes/original/img/b_ftext.png" title="Fulltext" width="16" />
  bn_2 varchar(255) utf8_general_ci   아니오 None   http://db.realkt.com/_gabia/dbadmin/sql.php?db=dbrealkt&table=g5_shop_banner&token=2ab5aaa97561fec9a0998b63af4fc4a9&goto=tbl_structure.php&back=tbl_structure.php&sql_query=SELECT+COUNT%28%2A%29+AS+%60%ED%96%89%28%EB%A0%88%EC%BD%94%EB%93%9C%29%60%2C+%60bn_2%60+FROM+%60g5_shop_banner%60+GROUP+BY+%60bn_2%60+ORDER+BY+%60bn_2%60&phpMyAdmin=3d866d0d27a160e3caf94a672025490d">Browse distinct valueshttp://db.realkt.com/_gabia/dbadmin/themes/original/img/b_browse.png" title="Browse distinct values" width="16" /> http://db.realkt.com/_gabia/dbadmin/tbl_alter.php?db=dbrealkt&table=g5_shop_banner&token=2ab5aaa97561fec9a0998b63af4fc4a9&goto=tbl_structure.php&back=tbl_structure.php&field=bn_2&phpMyAdmin=3d866d0d27a160e3caf94a672025490d">변경http://db.realkt.com/_gabia/dbadmin/themes/original/img/b_edit.png" title="변경" width="16" /> http://db.realkt.com/_gabia/dbadmin/sql.php?db=dbrealkt&table=g5_shop_banner&token=2ab5aaa97561fec9a0998b63af4fc4a9&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_shop_banner%60+DROP+%60bn_2%60&cpurge=1&purgekey=bn_2&zero_rows=%ED%95%84%EB%93%9C+bn_2+%EB%A5%BC+%EC%A0%9C%EA%B1%B0%ED%96%88%EC%8A%B5%EB%8B%88%EB%8B%A4&phpMyAdmin=3d866d0d27a160e3caf94a672025490d" onclick="return confirmLink(this, 'ALTER TABLE `g5_shop_banner` DROP `bn_2`')">삭제http://db.realkt.com/_gabia/dbadmin/themes/original/img/b_drop.png" title="삭제" width="16" /> http://db.realkt.com/_gabia/dbadmin/sql.php?db=dbrealkt&table=g5_shop_banner&token=2ab5aaa97561fec9a0998b63af4fc4a9&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_shop_banner%60+DROP+PRIMARY+KEY%2C+ADD+PRIMARY+KEY%28%60bn_2%60%29&zero_rows=+bn_2%EC%97%90+%EA%B8%B0%EB%B3%B8+%ED%82%A4%EA%B0%80+%EC%B6%94%EA%B0%80%EB%90%98%EC%97%88%EC%8A%B5%EB%8B%88%EB%8B%A4&phpMyAdmin=3d866d0d27a160e3caf94a672025490d" onclick="return confirmLink(this, 'ALTER TABLE `g5_shop_banner` DROP PRIMARY KEY, ADD PRIMARY KEY(`bn_2`)')">기본http://db.realkt.com/_gabia/dbadmin/themes/original/img/b_primary.png" title="기본" width="16" /> http://db.realkt.com/_gabia/dbadmin/sql.php?db=dbrealkt&table=g5_shop_banner&token=2ab5aaa97561fec9a0998b63af4fc4a9&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_shop_banner%60+ADD+UNIQUE%28%60bn_2%60%29&zero_rows=bn_2+%EC%97%90+%EC%9D%B8%EB%8D%B1%EC%8A%A4%EA%B0%80+%EA%B1%B8%EB%A0%B8%EC%8A%B5%EB%8B%88%EB%8B%A4&phpMyAdmin=3d866d0d27a160e3caf94a672025490d">고유값http://db.realkt.com/_gabia/dbadmin/themes/original/img/b_unique.png" title="고유값" width="16" /> http://db.realkt.com/_gabia/dbadmin/sql.php?db=dbrealkt&table=g5_shop_banner&token=2ab5aaa97561fec9a0998b63af4fc4a9&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_shop_banner%60+ADD+INDEX%28%60bn_2%60%29&zero_rows=bn_2+%EC%97%90+%EC%9D%B8%EB%8D%B1%EC%8A%A4%EA%B0%80+%EA%B1%B8%EB%A0%B8%EC%8A%B5%EB%8B%88%EB%8B%A4&phpMyAdmin=3d866d0d27a160e3caf94a672025490d">인덱스http://db.realkt.com/_gabia/dbadmin/themes/original/img/b_index.png" title="인덱스" width="16" /> http://db.realkt.com/_gabia/dbadmin/sql.php?db=dbrealkt&table=g5_shop_banner&token=2ab5aaa97561fec9a0998b63af4fc4a9&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_shop_banner%60+ADD+FULLTEXT%28%60bn_2%60%29&zero_rows=bn_2+%EC%97%90+%EC%9D%B8%EB%8D%B1%EC%8A%A4%EA%B0%80+%EA%B1%B8%EB%A0%B8%EC%8A%B5%EB%8B%88%EB%8B%A4&phpMyAdmin=3d866d0d27a160e3caf94a672025490d">Fulltexthttp://db.realkt.com/_gabia/dbadmin/themes/original/img/b_ftext.png" title="Fulltext" width="16" />
  bn_3 varchar(255) utf8_general_ci   아니오 None   http://db.realkt.com/_gabia/dbadmin/sql.php?db=dbrealkt&table=g5_shop_banner&token=2ab5aaa97561fec9a0998b63af4fc4a9&goto=tbl_structure.php&back=tbl_structure.php&sql_query=SELECT+COUNT%28%2A%29+AS+%60%ED%96%89%28%EB%A0%88%EC%BD%94%EB%93%9C%29%60%2C+%60bn_3%60+FROM+%60g5_shop_banner%60+GROUP+BY+%60bn_3%60+ORDER+BY+%60bn_3%60&phpMyAdmin=3d866d0d27a160e3caf94a672025490d">Browse distinct valueshttp://db.realkt.com/_gabia/dbadmin/themes/original/img/b_browse.png" title="Browse distinct values" width="16" /> http://db.realkt.com/_gabia/dbadmin/tbl_alter.php?db=dbrealkt&table=g5_shop_banner&token=2ab5aaa97561fec9a0998b63af4fc4a9&goto=tbl_structure.php&back=tbl_structure.php&field=bn_3&phpMyAdmin=3d866d0d27a160e3caf94a672025490d">변경http://db.realkt.com/_gabia/dbadmin/themes/original/img/b_edit.png" title="변경" width="16" /> http://db.realkt.com/_gabia/dbadmin/sql.php?db=dbrealkt&table=g5_shop_banner&token=2ab5aaa97561fec9a0998b63af4fc4a9&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_shop_banner%60+DROP+%60bn_3%60&cpurge=1&purgekey=bn_3&zero_rows=%ED%95%84%EB%93%9C+bn_3+%EB%A5%BC+%EC%A0%9C%EA%B1%B0%ED%96%88%EC%8A%B5%EB%8B%88%EB%8B%A4&phpMyAdmin=3d866d0d27a160e3caf94a672025490d" onclick="return confirmLink(this, 'ALTER TABLE `g5_shop_banner` DROP `bn_3`')">삭제http://db.realkt.com/_gabia/dbadmin/themes/original/img/b_drop.png" title="삭제" width="16" /> http://db.realkt.com/_gabia/dbadmin/sql.php?db=dbrealkt&table=g5_shop_banner&token=2ab5aaa97561fec9a0998b63af4fc4a9&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_shop_banner%60+DROP+PRIMARY+KEY%2C+ADD+PRIMARY+KEY%28%60bn_3%60%29&zero_rows=+bn_3%EC%97%90+%EA%B8%B0%EB%B3%B8+%ED%82%A4%EA%B0%80+%EC%B6%94%EA%B0%80%EB%90%98%EC%97%88%EC%8A%B5%EB%8B%88%EB%8B%A4&phpMyAdmin=3d866d0d27a160e3caf94a672025490d" onclick="return confirmLink(this, 'ALTER TABLE `g5_shop_banner` DROP PRIMARY KEY, ADD PRIMARY KEY(`bn_3`)')">기본http://db.realkt.com/_gabia/dbadmin/themes/original/img/b_primary.png" title="기본" width="16" /> http://db.realkt.com/_gabia/dbadmin/sql.php?db=dbrealkt&table=g5_shop_banner&token=2ab5aaa97561fec9a0998b63af4fc4a9&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_shop_banner%60+ADD+UNIQUE%28%60bn_3%60%29&zero_rows=bn_3+%EC%97%90+%EC%9D%B8%EB%8D%B1%EC%8A%A4%EA%B0%80+%EA%B1%B8%EB%A0%B8%EC%8A%B5%EB%8B%88%EB%8B%A4&phpMyAdmin=3d866d0d27a160e3caf94a672025490d">고유값http://db.realkt.com/_gabia/dbadmin/themes/original/img/b_unique.png" title="고유값" width="16" /> http://db.realkt.com/_gabia/dbadmin/sql.php?db=dbrealkt&table=g5_shop_banner&token=2ab5aaa97561fec9a0998b63af4fc4a9&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_shop_banner%60+ADD+INDEX%28%60bn_3%60%29&zero_rows=bn_3+%EC%97%90+%EC%9D%B8%EB%8D%B1%EC%8A%A4%EA%B0%80+%EA%B1%B8%EB%A0%B8%EC%8A%B5%EB%8B%88%EB%8B%A4&phpMyAdmin=3d866d0d27a160e3caf94a672025490d">인덱스http://db.realkt.com/_gabia/dbadmin/themes/original/img/b_index.png" title="인덱스" width="16" /> http://db.realkt.com/_gabia/dbadmin/sql.php?db=dbrealkt&table=g5_shop_banner&token=2ab5aaa97561fec9a0998b63af4fc4a9&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_shop_banner%60+ADD+FULLTEXT%28%60bn_3%60%29&zero_rows=bn_3+%EC%97%90+%EC%9D%B8%EB%8D%B1%EC%8A%A4%EA%B0%80+%EA%B1%B8%EB%A0%B8%EC%8A%B5%EB%8B%88%EB%8B%A4&phpMyAdmin=3d866d0d27a160e3caf94a672025490d">Fulltexthttp://db.realkt.com/_gabia/dbadmin/themes/original/img/b_ftext.png" title="Fulltext" width="16" />
댓글을 작성하려면 로그인이 필요합니다.

답변 1개

채택된 답변
+20 포인트

코드 상으로는 정확히 어떤 문젠지 안 보이네요.

sql_query($sql);

이렇게 된 거 전부 막아 버리시고 페이지 이동하는 것도 다 막으시고

echo $sql;

이렇게 직접 찍어 보세요.

그리고 나온 쿼리문 그대로 복사해서 phpmyadmin 같은 데에서 직접 붙여넣어 보시면 정확하게 답이 나옵니다.

로그인 후 평가할 수 있습니다

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

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

로그인