invisio v2.0

<?php
include('../../../config/main_function.php');
$secure = "cAh3DrJACzw4RbU";
$connection = connectDB($secure);
$certification_lot_id = mysqli_real_escape_string($connection, $_POST['certification_lot_id']);
$sql = "SELECT * FROM tbl_certification_lot WHERE certification_lot_id = '$certification_lot_id'";
$res = mysqli_query($connection, $sql);
$row = mysqli_fetch_assoc($res);
?>

<div class="modal-header">
    <h4 class="modal-title">แก้ไขรอบรับรอง</h4>
    <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
</div>
<div class="modal-body">
    <form id="form_add" method="post" enctype="multipart/form-data">
        <input type="hidden" name="member_id" id="member_id" value="<?php echo $member_id; ?>">
        <input type="hidden" name="certification_lot_id" id="certification_lot_id" value="<?php echo $certification_lot_id; ?>">
        <div class="row">
            <div class="col-lg-12 mb-2">
                <div class="form-group">
                    <div class="form-group" id="data_1">
                        <label class="font-normal">วันที่รับรอง</label>
                        <div class="input-group date">
                            <span class="input-group-addon"><i class="fa fa-calendar"></i></span>
                            <input type="input" class="form-control datepicker" value="<?php echo date("d/m/Y",strtotime($row['certification_date'])); ?>" name="certification_date" id="certification_date" autocomplete="off">
                        </div>
                    </div>
                </div>
            </div>
            <div class="col-lg-12 mb-2">
                <div class="form-group">
                    <div class="form-group" id="data_1">
                        <label class="font-normal">วันที่มีผล</label>
                        <div class="input-group date">
                            <span class="input-group-addon"><i class="fa fa-calendar"></i></span>
                            <input type="input" class="form-control datepicker" value="<?php echo date("d/m/Y",strtotime($row['effective_date'])); ?>" name="effective_date" id="effective_date" autocomplete="off">
                        </div>
                    </div>
                </div>
            </div>
            <div class="col-lg-12 mb-2">
                <div class="form-group">
                    <label class="font-normal">หมายเหตุ</label>
                    <div class="input-group date">
                        <textarea name="create_note" id="create_note" cols="30" rows="5" class="form-control"><?php echo $row['create_note']; ?></textarea>
                    </div>

</div>
            </div>

</div>
    </form>
</div>
<div class="modal-footer">
    <button type="button" class="btn btn-primary" onclick="UpdateCertification();"><i class="fa fa-check"></i>&nbsp;บันทึก</button>
    <button type="button" class="btn btn-white" data-dismiss="modal">ปิด</button>
</div>