invisio v2.0

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

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

if ($connection) {
    ///ถอด xapi
    $password = 'sd32f43q5we';
    $xapi = 'CXgvsdf542sdfg';
    $encryptedMessage = mysqli_real_escape_string($connection, $_POST['encryptedMessage']);

if (decryptMessage($encryptedMessage, $password) == $xapi) {

$sql = "SELECT * FROM tbl_job WHERE active_status = '1' ORDER BY create_datetime DESC LIMIT 0,4";
        $res = mysqli_query($connection, $sql) or die($connection->error);

$list = array();
        while ($row = mysqli_fetch_assoc($res)) {
            $temp_array = [
                "create_user_id" => $row['create_user_id'],
                "announcement_date" => $row['announcement_date'],
                "company_name" => $row['company_name'],
                "job_title" => $row['job_title'],
                "salary" => $row['salary'],
                "location" => $row['location'],
                "job_description" => $row['job_description'],
                "benefits" => $row['benefits'],
                "active_status" => $row['active_status']
            ];
            array_push($list, $temp_array);
        }
    } else {
        $arr['result'] = 0;
        $arr['message'] = "xapi is valid";
    }
} else {
    $arr['result'] = 9;
    $arr['message'] = "Connection Error";
}

?>
<p class="card-text">NEW JOBS.</p>
<div>
    <div class="row">
        <?php foreach ($list as $row) { ?>
            <div class="col-2 comp-div">
                <div class="card">
                    <img src="assets/image/Logo.png" class="card-img-top" alt="...">
                    <div class="card-body">
                        <p class="card-text text-truncate"><?php echo $row['job_title']; ?></p>
                    </div>
                </div>
            </div>
        <?php } ?>
    </div>
</div>