function insert_work($data){
    global $conn; //Database_connection
    $stmt = mysqli_stmt_init($conn);

    $sql = "INSERT INTO `work_offers` (`submitted_by_id`, `type`,`description`,`work_date`, `title`, `address`, `region`) VALUES (?, ?, ?, ?, ?, ?, ?)";

    $user_id = $data['u_id'];
    $work_type = $data['work_type'];
    $description = $data['description'];
    $work_date = DateTime::createFromFormat('d/m-Y', $data['work_date'])->format('Y-m-d');
    $title = $data['title'];
    $address = $data['address'];
    $region = $data['region'];

    mysqli_stmt_prepare($stmt,$sql);
    mysqli_stmt_bind_param($stmt, "issssss", $user_id, $work_type, $description, $work_date, $title, $address, $region);
    //if(mysqli_stmt_execute($stmt)){
    mysqli_stmt_execute($stmt);

        $lat = $data['lat'];//mysqli_real_escape_string($conn, $data['lat']);
        $lng = $data['lng'];//mysqli_real_escape_string($conn, $data['lng']);
        $last_inserted_id = $stmt->insert_id;
        //$stmt->close();
        $pos_sql = "INSERT INTO `lat_lng` (`work_id`, `lat`, `lng`) VALUES ($last_inserted_id, $lat, $lng)";
        $conn->query($pos_sql);
        //return TRUE;

    //}else{
        //return FALSE;
    //}
    $data['new'] = $last_inserted_id;
    echo json_encode($data);
}