sqlpage.uploaded_file_name(name)
Introduced in SQLPage 0.23.0.
Returns the filename
value in the content-disposition
header.
Example: saving uploaded file metadata for later download
Making a form
select 'form' as component, 'handle_file_upload.sql' as action;
select 'myfile' as name, 'file' as type, 'File' as label;
Handling the form response
Inserting an arbitrary file as a data URL into the database
In handle_file_upload.sql
, one can process the form results like this:
insert into uploaded_files (fname, content, uploaded) values (
sqlpage.uploaded_file_name('myfile'),
sqlpage.read_file_as_data_url(sqlpage.uploaded_file_path('myfile')),
CURRENT_TIMESTAMP
);
Note: Data URLs are larger than the original file, so it is not recommended to use them for large files.
Downloading the uploaded files
The file can be downloaded by clicking a link like this:
select 'button' as component;
select name as title, content as link from uploaded_files where name = $file_name limit 1;
Note: because the file is ecoded as a data uri, the file is transferred to the client whether or not the link is clicked
Large files
See the sqlpage.uploaded_file_path
function.
See the sqlpage.persist_uploaded_file
function.
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