invisio v2.0

<?php

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

if ($connection) {

$member_id_check = $_POST['member_id_check'];

$count_member = count($member_id_check);

$receipt_id  = getRandomID2(10, 'tbl_receipt_head', 'receipt_id');
    $receipt_no = getRunNO($size = 4, "REC" . $text = date('y') + 43. . date('m'), 'tbl_receipt_head', 'receipt_no');
    $ref_member_id = mysqli_real_escape_string($connection, $_POST['ref_member_id']);

$list_order = 1;
    foreach ($member_id_check as $member_id) {

$receipt_detail_id  = getRandomID(10, 'tbl_receipt_detail', 'receipt_detail_id');

// get payment 
        $sql = "SELECT 
        pack.unit_price
        ,coup.discount_amount
        ,coup.discount_type
        ,mem.register_level
        ,detail.title_name
        ,detail.member_name
        ,detail.member_name_en
        FROM tbl_member mem
        LEFT JOIN tbl_member_detail detail ON detail.member_id = mem.member_id
        LEFT JOIN tbl_package_price pack ON pack.member_type = mem.register_level
        LEFT JOIN tbl_member_payment pay ON pay.member_id = mem.member_id
        LEFT JOIN tbl_discount_coupon coup ON coup.coupon_id = pay.coupon_id
        WHERE mem.member_id = '$member_id'";
        $res = mysqli_query($connection, $sql);
        $row = mysqli_fetch_assoc($res);

if ($row['register_level'] == 'g9k1s') {
            $member_level = 'ทั่วไป';
        } elseif ($row['register_level'] == 'kki22') {
            $member_level = 'วิสามัญ';
        } elseif ($row['register_level'] == 'x9fkq') {
            $member_level = 'สามัญ.';
        }

$temp_title = explode(" ", getTitle_name($row['title_name']));
        $title_th = $temp_title[0];
        $title_en = $temp_title[2];

echo $product_name = "ค่าสมัครสมาชิก " . ($row['member_name'] != '' ? $title_th.$row['member_name'] : $title_en.$row['member_name_en']) . " ระดับ" . $member_level;
        echo "<pre>";
        echo $product_name;
        echo "</pre>";
        // $sql_detail = "INSERT INTO tbl_receipt_detail SET  
        // receipt_detail_id = '$receipt_detail_id',
        // receipt_id = '$receipt_id',
        // product_name = '$product_name',
        // unit = '$unit',
        // quantity = '$quantity',
        // cost_per_unit = '$cost_per_unit',
        // discount_per_unit = '$discount_per_unit',
        // discount_type = '$discount_type',
        // total_amount = '$total_amount',
        // list_order = '$list_order'
        // ";
        // $res_detail = mysqli_query($connection, $sql_detail)  or die($connection->error);

$list_order++;
    }
    if ($list_order - 1 == $count_member) {
        $arr['result'] = 1;
    } else {
        $arr['result'] = 0;
    }

///echo json_encode($arr);
}