invisio v2.0

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

$certification_lot_id = mysqli_real_escape_string($connection, $_POST['certification_lot_id']);
$create_note = mysqli_real_escape_string($connection, $_POST['create_note']);
$cer_date = explode('/', $_POST['certification_date']);
$certification_date = date('Y-m-d', strtotime($cer_date['0'] . "-" . $cer_date['1'] . "-" . $cer_date['2']));

$eff_date = explode('/', $_POST['effective_date']);
$effective_date = date('Y-m-d', strtotime($eff_date['0'] . "-" . $eff_date['1'] . "-" . $eff_date['2']));

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

if ($connection) {

$sql_cer = "UPDATE tbl_certification_lot 
    SET create_admin_id = '$admin_id',
    create_note = '$create_note',
    certification_date = '$certification_date',
    effective_date = '$effective_date'
    WHERE certification_lot_id  = '$certification_lot_id'
    ";
    $res_cer = mysqli_query($connection, $sql_cer);
    $num_update = mysqli_num_rows($res_cer);

if ($res_cer) {
        $arr['result'] = 1;
    } else {
        $arr['result'] = 0;
    }
} else {
    $arr['result'] = 9;
}

echo json_encode($arr);