정품인증 방법있을까요? 채택완료

</p>

<p>CREATE TABLE `g5_barcode_products` (

  `bp_id` int(11) NOT NULL AUTO_INCREMENT,

  `bp_barcode` varchar(50) NOT NULL COMMENT '바코드 번호',

  `bp_product_name` varchar(200) NOT NULL COMMENT '제품명',

  `bp_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '등록일시',

  PRIMARY KEY (`bp_id`),

  UNIQUE KEY `bp_barcode` (`bp_barcode`),

  KEY `bp_datetime` (`bp_datetime`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='바코드 제품 관리';</p>

<p>

</p>

<p><?php

include_once '../common.php';</p>

<p>$g5['title'] = '제품 진품 확인';

include_once G5_PATH.'/head.php';</p>

<p>$barcode = '';

$result_msg = '';

$product_name = '';</p>

<p>// 폼 처리

if (isset($_POST['barcode']) && $_POST['barcode']) {

    $barcode = clean_xss_tags($_POST['barcode']);

    

    // 바코드 조회

    $sql = "SELECT bp_product_name FROM g5_barcode_products WHERE bp_barcode = '".sql_real_escape_string($barcode)."'";

    $row = sql_fetch($sql);

    

    if ($row) {

        $result_msg = 'success';

        $product_name = $row['bp_product_name'];

    } else {

        $result_msg = 'fail';

    }

}

?></p>

<p><div id="barcode_check_wrap">

    <h2>제품 진품 확인</h2>

    

    <form method="post" action="">

        <p>

            <label for="barcode">바코드 번호</label>


            <input type="text" name="barcode" id="barcode" value="<?php echo htmlspecialchars($barcode); ?>" placeholder="바코드 번호를 입력하세요" required>

        </p>

        <p>

            <input type="submit" value="확인하기">

        </p>

    </form>

    

    <?php if ($result_msg == 'success') { ?>

    <div class="result_box success">

        <h3>✓ 정품 확인</h3>

        <p><strong>제품명:</strong> <?php echo htmlspecialchars($product_name); ?></p>

        <p>이 제품은 저희 홈페이지에서 판매한 정품입니다.</p>

    </div>

    <?php } elseif ($result_msg == 'fail') { ?>

    <div class="result_box fail">

        <h3>✗ 확인 불가</h3>

        <p>입력하신 바코드로 등록된 제품을 찾을 수 없습니다.</p>

    </div>

    <?php } ?>

</div></p>

<p><style>

#barcode_check_wrap {

    max-width: 500px;

    margin: 50px auto;

    padding: 20px;

    border: 1px solid #ddd;

}

#barcode_check_wrap h2 {

    text-align: center;

    margin-bottom: 30px;

}

#barcode_check_wrap input[type="text"] {

    width: 100%;

    padding: 10px;

    border: 1px solid #ccc;

    margin-top: 5px;

}

#barcode_check_wrap input[type="submit"] {

    background: #007cba;

    color: white;

    padding: 10px 20px;

    border: none;

    cursor: pointer;

}

.result_box {

    margin-top: 20px;

    padding: 15px;

    border-radius: 5px;

    text-align: center;

}

.result_box.success {

    background: #d4edda;

    border: 1px solid #c3e6cb;

    color: #155724;

}

.result_box.fail {

    background: #f8d7da;

    border: 1px solid #f5c6cb;

    color: #721c24;

}

</style></p>

<p><?php include_once G5_PATH.'/tail.php'; ?></p>

<p>

</p>

<p><?php

$sub_menu = "200900";

include_once('./_common.php');</p>

<p>auth_check($auth[$sub_menu], 'w');</p>

<p>$g5['title'] = '바코드 등록';

include_once('./admin.head.php');</p>

<p>// 등록 처리

if (isset($_POST['act']) && $_POST['act'] == 'add') {

    $barcode = clean_xss_tags($_POST['barcode']);

    $product_name = clean_xss_tags($_POST['product_name']);

    

    if (!$barcode) {

        alert('바코드를 입력해주세요.');

    }

    if (!$product_name) {

        alert('제품명을 입력해주세요.');

    }

    

    // 중복 확인

    $check_sql = "SELECT COUNT(*) as cnt FROM g5_barcode_products WHERE bp_barcode = '".sql_real_escape_string($barcode)."'";

    $check_result = sql_fetch($check_sql);

    

    if ($check_result['cnt'] > 0) {

        alert('이미 등록된 바코드입니다.');

    }

    

    // 등록

    $sql = "INSERT INTO g5_barcode_products 

            SET bp_barcode = '".sql_real_escape_string($barcode)."',

                bp_product_name = '".sql_real_escape_string($product_name)."',

                bp_datetime = NOW()";

    

    sql_query($sql);

    

    alert('바코드가 등록되었습니다.');

}

?></p>

<p><div class="local_desc01 local_desc">

    <p>제품에 부착할 바코드 정보를 등록합니다.</p>

</div></p>

<p><form name="fregister" method="post" action="">

<input type="hidden" name="act" value="add"></p>

<p><div class="tbl_frm01 tbl_wrap">

    <table>

    <colgroup>

        <col class="grid_4">

        <col>

    </colgroup>

    <tbody>

    <tr>

        <th scope="row"><label for="barcode">바코드 번호<strong class="sound_only">필수</strong></label></th>

        <td><input type="text" name="barcode" id="barcode" required class="frm_input required" maxlength="50"></td>

    </tr>

    <tr>

        <th scope="row"><label for="product_name">제품명<strong class="sound_only">필수</strong></label></th>

        <td><input type="text" name="product_name" id="product_name" required class="frm_input required" maxlength="200"></td>

    </tr>

    </tbody>

    </table>

</div></p>

<p><div class="btn_confirm01 btn_confirm">

    <input type="submit" value="등록" class="btn_submit" accesskey="s">

    <a href="<?php echo G5_URL; ?>/barcode_check.php" target="_blank" class="btn btn_02">조회페이지 보기</a>

</div></p>

<p></form></p>

<p><script>

document.getElementById('barcode').focus();

</script></p>

<p><?php

include_once('./admin.tail.php');

?></p>

<p>