invisio v2.0

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

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

$register_type = mysqli_real_escape_string($connection, $_POST['member_type']);
$register_level = mysqli_real_escape_string($connection, $_POST['member_level']);

switch ($register_level) {
    case 'g9k1s':
        $register_level = '1';
        break;
    case 'kki22':
        $register_level = '3';
        break;
    case 'x9fkq':
        $register_level = '2';
        break;
    default:
        break;
}

$sql_member = "SELECT a.register_type,
        b.list_order,
        b.doc_name
        FROM tbl_member a
        LEFT JOIN tbl_register_document b ON b.member_type = a.register_type 
        WHERE member_id = '$member_id' AND b.register_type ='1'  ORDER BY list_order ASC";
$register_doc = mysqli_query($connection, $sql_member)  or die($connection->error);

switch ($register_type) {
    case '1':
        $table = 'tbl_member_detail_employer';
        break;
    case '2':
        $table = 'tbl_member_detail_company';
        break;
    case '3':
        $table = 'tbl_member_detail_agency';
        break;
    case '4':
        $table = 'tbl_member_detail_worker';
        break;
    default:
        break;
}

$sql_doc = "SELECT * FROM $table WHERE member_id = '$member_id'";
$res_doc = mysqli_query($connection, $sql_doc);
$row_doc = mysqli_fetch_assoc($res_doc);
?>
<div class="ibox">
    <div class="ibox-content pt-3">
        <div class="row">
            <div class="col-12 text-center mb-5">
                <label for=""><b>เอกสารการสมัคร</b></label><br>

<a href="https://efa-member.com/main/print/application_form?id=<?php echo $mem_id ?>" class="btn btn-info btn-block" target="_blank" id="btn_print"><i class="fa fa-print"></i> ใบสมัคร</a>

<?php
                        $i = 1;
                        while ($row_member = mysqli_fetch_assoc($register_doc)) {
                            if (!empty($row_doc['document_file' . $i . ''])) {
                        ?>

<a href="https://efa-member.com/main/upload/join/file/<?php echo $row_doc['document_file' . $i . ''] ?>" class="btn btn-info btn-block" target="_blank" id="btn_print"><i class="fa fa-print"></i> <?php echo $row_member['doc_name']; ?></a>

<?php
                            }
                            $i++;
                        } ?>
                    </div>
                    <div class="col-6">

<a href="https://efa-member.com/main/print/print_all_doc?id=<?php echo $mem_id ?>" class="btn btn-success btn-block" target="_blank" id="btn_print"><i class="fa fa-print"></i> เอกสารทั้งหมด</a>

</div>
                </div>
            </div>
        </div>
    </div>
</div>