function exec_query_params($link, $sql, $param, $param_type) 
   {
        $stmt = mysqli_stmt_init($link);
        
        if (mysqli_stmt_prepare($stmt, $sql)) {
            mysqli_stmt_bind_param($stmt, $param_type, $param);
            mysqli_stmt_execute($stmt);
            $res = mysqli_stmt_get_result($stmt);           
            while ($row = mysqli_fetch_array($res, MYSQLI_ASSOC)) {
                $arr[] = $row;
               }

            mysqli_free_result($res);
            mysqli_stmt_close($stmt);
        
            return $arr;
        }
   }