invisio v2.0

<?php

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

if ($connection) {

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

$sql_select = "SELECT
        pay.invoice_number
        ,pay.payment_amount
        ,mem.member_id
        ,mem.register_no
        ,mem.ref_member_id
        ,detail.member_name
        ,detail.member_name_en
        FROM tbl_member_payment pay
        LEFT JOIN tbl_member mem ON mem.member_id = pay.member_id
        LEFT JOIN tbl_member_detail detail on detail.member_id = mem.member_id
        WHERE pay.transfer_date IS NULL AND mem.ref_member_id = '$ref_member_id'";

$res_select = mysqli_query($connection, $sql_select)  or die($connection->error);
    } else {
        echo "Connection Error";
    }

mysqli_close($connection);
    ?>