invisio v2.0

<?php

use function PHPSTORM_META\type;

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

if ($connection) {

$admin_id = mysqli_real_escape_string($connection, $_POST['admin_id']);

$sql_select = "SELECT * FROM tbl_admin WHERE admin_id = '$admin_id' ";
    $res_select = mysqli_query($connection, $sql_select) or die($connection->error);
    $row = mysqli_fetch_assoc($res_select);

$munu_access = explode(",", $row['menu_access']);
} else {
    echo "Connection Error";
}

$menu_access_num = [
    1,
    2,
    3,
    4,
    5,
    6,
    7,
    8,
    9,
    10,
    11,
    12
];

$menu_access_title = [
    "สมาชิก",
    "สมาชิกที่มีสถานะ",
    "รอบรับรอง",
    "นำเข้าข้อมูล",
    "ใบวางบิล",
    "ใบเสร็จ",
    "ตั้งค่าบัญชีธนาคาร",
    "ตั้งค่าบทความ",
    "ตั้งค่าสไลด์",
    "ตั้งค่าโค้ดส่วนลด",
    "ตั้งค่าตำแหน่งในใบสมัคร",
    "กำหนดสิทธิผู้ใช้งาน"
];

?>
<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 method="POST" id="frm_add_officer">

<div class="form-group mb-2">
            <label for="admin_name_label" id="admin_name_label">ชื่อ - นามสกุล</label>
            <input type="text" name="admin_name" id="admin_name" class="form-control">
        </div>

<div class="form-group mb-2">
            <label for="username_label" id="username_label">Username</label>
            <input type="text" name="username" id="username" class="form-control">
        </div>

<div class="form-group mb-2" id="member_list">
            <label for="password_label" id="Password_label">Password</label>
            <input type="text" name="password" id="password" class="form-control">
        </div>

<div class="form-group mb-2" id="member_list">
            <label for="re_password_label" id="re_password_label">Re-Password</label>
            <input type="text" name="re_password" id="re_password" class="form-control">
        </div>

<label for="">กำหนดเมนู</label>
        <div class="row px-3">
            <input type="hidden" value="<?php echo $admin_id; ?>" id="admin_id" name="admin_id">
            <?php for ($i = 0; $i < count($menu_access_num); $i++) { ?>
                <div class="col-6">
                    <input class="form-check-input" type="checkbox" value="<?php echo $menu_access_num[$i] ?>" id="permission<?php echo $i; ?>" name="menu_access[]" <?php echo in_array($menu_access_num[$i], $menu_access) ? "checked" : "" ?>>
                    <label class="form-check-label menuaccess" for="permission<?php echo $i; ?>">
                        <?php echo $menu_access_title[$i] ?>
                    </label>
                </div>
            <?php } ?>
        </div>

</div>

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