invisio v2.0

<?php

include('../../../config/main_function.php');
$secure = "cAh3DrJACzw4RbU";
$connection = connectDB($secure);

$member_id = mysqli_real_escape_string($connection, $_POST['member_id']);
$temp_id = explode(".", $member_id);
$member_id = bigsara_decode($temp_id[0], $temp_id[1]);

$sql = "SELECT m.*,d_m.*,pm.transfer_date FROM 
tbl_member m
JOIN tbl_member_detail d_m ON m.member_id = d_m.member_id
JOIN tbl_member_payment pm ON m.member_id = pm.member_id
WHERE m.member_id  = '$member_id'";
$res = mysqli_query($connection, $sql);
$row = mysqli_fetch_assoc($res);
$transfer_date = $row['transfer_date'];

$sql_postcode = "SELECT * FROM tbl_district WHERE district_id = '{$row['card_district_id']}'";
$res_postcode = mysqli_query($connection, $sql_postcode);
$row_postcode = mysqli_fetch_assoc($res_postcode);

$password = 'sd32f43q5we';
$originalMessage = "CXgvsdf542sdfg";
$encryptedMessage = encryptMessage($originalMessage, $password);

?>

<form id="frm_profile" method="POST" enctype="multipart/form-data">
    <input type="hidden" id="decryptedMessage" name="decryptedMessage" value="<?php echo $encryptedMessage; ?>">
    <div class="card bg-default mt-3 mb-3 shadow-sm">
        <div class="card-body">
            <div class="mt-3 border-1">
                <input type="hidden" class="form-control" id="member_id" name="member_id" value="<?php echo $member_id; ?>">
                <div class="row mb-2">
                    <div class="col-6 mb-2">
                        <b>ระดับ<span class="text-danger">*</span></b><br>
                        <select name="register_level" id="register_level" class="select2" onchange="GetMoreInfo()">
                            <option value="g9k1s" <?php echo ($row['register_level'] == 'g9k1s') ? "selected" : ""; ?>>ทั่วไป</option>
                            <option value="kki22" <?php echo ($row['register_level'] == 'kki22') ? "selected" : ""; ?>>วิสามัญ</option>
                            <option value="x9fkq" <?php echo ($row['register_level'] == 'x9fkq') ? "selected" : ""; ?>>สามัญ</option>
                        </select>
                    </div>
                    <div class="col-6 mb-2">
                        <b>ประเภท<span class="text-danger">*</span></b><br>
                        <select name="register_type" id="register_type" class="select2" onchange="GetMoreInfo()">
                            <?php
                            $sql_type = "SELECT * FROM tbl_member_type ORDER BY type_code ASC";
                            $res_type = mysqli_query($connection, $sql_type) or die($connection->error);
                            while ($row_type = mysqli_fetch_assoc($res_type)) {
                            ?>
                                <option value="<?php echo $row_type['type_code']; ?>" <?php echo ($row['register_type'] == $row_type['type_code']) ? "selected" : ""; ?>><?php echo $row_type['type_name']; ?></option>
                            <?php
                            }
                            ?>
                        </select>
                    </div>
                    <div class="col-lg-6 col-6">
                        <b>รูปถ่ายใบสมัคร ไม่เกิน 6 เดือน <small class="text-danger">(ขนาดรูปที่แนะนำ 1200x900 px)</small></b>
                        <div class="row">
                            <div class="col-md-10 col-9 show_upload_image mt-1" hidden>
                                <div class="row">
                                    <div class="col-md-5 ml-4"><span style="color: green;"><b>แนบรูปภาพแล้ว</b></span></div>
                                    <div class="col-md-1 col-1">
                                        <a href="javascript:void(0);" onclick="change_image();"><i class="fa fa-search"></i></a>
                                    </div>
                                    <div class=" col-md-1 col-1">
                                        <a href="javascript:void(0);" onclick="remove_image();"><i class="fa fa-close"></i></a>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-10 col-9 custom-file">
                                <div class="">
                                    <input id="profile_image" name="profile_image" type="file" class="custom-file-input w-100" accept="image/png, image/gif, image/jpeg" onchange="readURL01(this);">
                                    <label for="profile_image" class="custom-file-label"><i class="fa fa-search"></i> </label>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="row mb-2">
                    <div class="col-lg-2 col-12 mb-2">
                        <b>คำนำหน้านาม<span class="text-danger">*</span></b><br>
                        <select name="title_name" id="title_name" class="form-select select2">
                            <option value="" selected>-- กรุณาเลือก --</option>
                            <option value="1" <?php echo ($row['title_name'] == '1') ? "selected" : ""; ?>>นาย ( Mr. )</option>
                            <option value="2" <?php echo ($row['title_name'] == '2') ? "selected" : ""; ?>>นางสาว ( Miss )</option>
                            <option value="3" <?php echo ($row['title_name'] == '3') ? "selected" : ""; ?>>นาง ( Mrs. )</option>
                            <option value="4" <?php echo ($row['title_name'] == '4') ? "selected" : ""; ?>>อื่นๆ</option>
                        </select>
                    </div>
                    <div class="col-lg-5 col-12 mb-2">
                        <b>ชื่อ - นามสกุล<span class="text-danger">*</span></b>
                        <input type="text" class="form-control" id="member_name" name="member_name" value="<?php echo $row['member_name'] ?>">
                    </div>
                    <div class="col-lg-5 col-12 mb-2">
                        <b>Firstname - Surname</b>
                        <input type="text" class="form-control" id="member_name_en" name="member_name_en" value="<?php echo $row['member_name_en'] ?>">
                    </div>
                </div>
                <div class="row mb-2">
                    <div class="col-lg-3 col-12 mb-2">
                        <b>วันเดือนปี เกิด <small class="text-danger">( วัน/เดือน/ปี พ.ศ. )</small><span class="text-danger">*</span></b>
                        <input type="text" id="birth_date" name="birth_date" class="form-control" data-mask="99/99/9999" placeholder="" onchange="checkDate('birth_date');" value="<?php echo date("d/m/Y", strtotime($row['birth_date'])); ?>">
                    </div>
                    <div class="col-lg-4 col-12 mb-2">
                        <b>เลขบัตรประจำตัวประชาชน / หนังสือเดินทาง <span class="text-danger">*</span></b>
                        <input type="text" class="form-control" id="citizen_no" name="citizen_no" value="<?php echo $row['citizen_no'] ?>">
                    </div>
                    <div class="col-lg-3 col-12 mb-2">
                        <b>สัญชาติ<span class="text-danger">*</span></b>
                        <select name="country" id="country" class="form-select select2">
                            <option value="" selected>-- กรุณาเลือก --</option>
                            <?php
                            $sql_country = "SELECT * FROM tbl_country";
                            $res_country = mysqli_query($connection, $sql_country);
                            while ($row_country = mysqli_fetch_assoc($res_country)) {
                            ?>
                                <option value="<?php echo $row_country['ct_code']; ?>" <?php echo ($row['race'] == $row_country['ct_code']) ? "selected" : ""; ?>><?php echo $row_country['ct_nameTHA']; ?></option>
                            <?php
                            }
                            ?>
                        </select>
                    </div>
                </div>
                <div class="row mb-2">
                    <div class="col-lg-12 col-12 mb-2">
                        <b>ที่อยู่ตามบัตรประจำตัวประชาชน</b> <span class="text-danger">*</span>
                        <input type="text" class="form-control" id="card_address" name="card_address" onchange="change_address(this.value)" placeholder="เลขที่ หมู่ ซอย ถนน" value="<?php echo $row['card_address'] ?>">
                    </div>
                </div>
                <div class="row mb-2">
                    <div class="col-lg-3 col-12 mb-2">
                        <b> รหัสไปรษณีย์ <span class="text-danger">*</span></b>
                        <input type="text" class="form-control" id="postcode" name="postcode" onchange="selectPostCode()" maxlength="10" onkeypress="return chkNumber(event)" value="<?php echo $row_postcode['district_zipcode'] ?>">
                    </div>
                    <div class="col-lg-3 col-12 mb-2">
                        <b>ตำบล</b>
                        <br><span id="show_district1">กรุณากรอกรหัส ปณ.</span>
                    </div>
                    <div class="col-lg-3 col-12 mb-2">
                        <b>อำเภอ</b>
                        <br><span id="show_ampoe1">กรุณากรอกรหัส ปณ.</span>
                    </div>
                    <div class="col-lg-3 col-12 mb-2">
                        <b>จังหวัด</b>
                        <br><span id="show_province1">กรุณากรอกรหัส ปณ.</span>
                    </div>
                </div>
                <div class="row mb-2">
                    <div class="col-lg-4 col-12 mb-2">
                        <b>เบอร์โทรติดต่อ</b>
                        <input type="text" class="form-control" id="phone" name="phone" value="<?php echo $row['phone'] ?>">
                    </div>
                    <div class="col-lg-8 col-12 mb-2">
                        <b>อีเมล</b>
                        <input type="text" class="form-control" id="email" name="email" value="<?php echo $row['username'] ?>">
                    </div>
                    <div class="col-lg-4 col-12 mb-2">
                        <b>วุฒิการศึกษาสูงสุด</b>
                        <select class="form-control select2" id="education_level" name="education_level">
                            <option value="">กรุณาเลือก</option>
                            <option value="1" <?php echo ($row['education_level'] == '1') ? "selected" : ""; ?>>ปริญญาเอก</option>
                            <option value="2" <?php echo ($row['education_level'] == '2') ? "selected" : ""; ?>>ปริญญาโท</option>
                            <option value="3" <?php echo ($row['education_level'] == '3') ? "selected" : ""; ?>>ปริญญาตรี หรือ เทียบเท่า</option>
                            <option value="4" <?php echo ($row['education_level'] == '4') ? "selected" : ""; ?>>ต่ำกว่า ปริญญาตรี </option>
                        </select>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="card bg-default mt-3 mb-3 shadow-sm">
        <div class="card-body">
            <div class="mt-3 border-1">
                <span>ข้อมูลเพิ่มเติม</span>
                <hr>
                <div id="specifics"></div>
            </div>
        </div>
    </div>
</form>

<div class="text-center">
    <button type="button" class="btn btn-gold btn-sm text-white w-25  shadow-sm" onclick="ImportFile(),SubmitProfileForm()"><strong>บึนทึกข้อมูล</strong></button>
    <?php if ($transfer_date == '') { ?>
        <button type="button" class="btn btn-gold btn-sm text-white w-25  shadow-sm" onclick="SendProfile()"><strong>ลงทะเบียนและชำระเงิน</strong></button>
    <?php } ?>
</div>