The sqlpage.uploaded_file_mime_type function
Introduced in SQLPage 0.18.0.
Returns the MIME type of an uploaded file.
Example: handling a picture upload
When letting the user upload a picture, you may want to check that the uploaded file is indeed an image.
select 'redirect' as component,
'invalid_file.sql' as link
where sqlpage.uploaded_file_mime_type('myfile') not like 'image/%';
In invalid_file.sql
, you can display an error message to the user:
select 'alert' as component, 'Error' as title,
'Invalid file type' as description,
'alert-circle' as icon, 'red' as color;
Example: white-listing file types
You could have a database table containing the allowed MIME types, and check that the uploaded file is of one of those types:
select 'redirect' as component,
'invalid_file.sql' as link
where sqlpage.uploaded_file_mime_type('myfile') not in (select mime_type from allowed_mime_types);
Parameters
name
Name of the file input field in the form.
basic_auth_password
basic_auth_username
cookie
current_working_directory
environment_variable
exec
fetch
hash_password
header
link
path
persist_uploaded_file
protocol
random_string
read_file_as_data_url
read_file_as_text
request_method
run_sql
uploaded_file_mime_type
uploaded_file_name
uploaded_file_path
url_encode
variables
version