Does anyone have a working example of upload retaining original filename and delete file?

asle

I am working to customize the upload example for Editor. I have problems that maybe others have solved:
1) I want to retain the uploaded file name. Now it is 1.png, 2.png etc. I want the uploaded file to retain the orignal filename.
2) I want the attachment file to be deleted when I clear it. Now the file info in DB is cleared but the file still remains on the server.

Here is the example I am trying to customize:
https://editor.datatables.net/examples/advanced/upload.html

allan

1) I want to retain the uploaded file name. Now it is 1.png, 2.png etc. I want the uploaded file to retain the orignal filename.

You'll quickly run into an issue with different users (or even the same users) uploading different files with the same name I reckon. However, what you want is possible - use the __NAME__ option - see the docs here.

2) I want the attachment file to be deleted when I clear it. Now the file info in DB is cleared but the file still remains on the server.

That's called an "orphaned file" in Editor terminology. See the docs for that here.

Allan

asle

Thanks Allan, thanks for the quick reply and I got it to work straight away!
I am aware of the danger of similar file name but if I later want to export the PDF files (this is a reports database) the user can not see where it came from. "Project Oslo 2025.pdf" is easier to understand what is instead of "32.pdf". I have a link to see the PDF in a new window. I now have the original filename in the "files" DB so I would have to do some mapping if I want to save the files. Or am I thinking too complicated?

asle

In case someone would like to see the complete uploads.php from the upload example for Editor:

<?php
/*
 * Example PHP implementation used for the index.html example
 */
// DataTables PHP library
include( "../lib/DataTables.php" );

// Alias Editor classes so they are easy to use
use
    DataTables\Editor,
    DataTables\Editor\Field,
    DataTables\Editor\Format,
    DataTables\Editor\Mjoin,
    DataTables\Editor\Options,
    DataTables\Editor\Upload,
    DataTables\Editor\Validate,
    DataTables\Editor\ValidateOptions;

// Build our Editor instance and process the data coming from _POST
Editor::inst( $db, 'users' )
    ->fields(
        Field::inst( 'first_name' ),
        Field::inst( 'last_name' ),
        Field::inst( 'phone' ),
        Field::inst( 'city' ),
        Field::inst( 'image' )
            ->setFormatter( Format::ifEmpty( null ) )
            ->upload( Upload::inst( $_SERVER['DOCUMENT_ROOT'].'/uploads/__NAME__' )
                ->db( 'files', 'id', array(
                    'filename'    => Upload::DB_FILE_NAME,
                    'filesize'    => Upload::DB_FILE_SIZE,
                    'web_path'    => Upload::DB_WEB_PATH,
                    'system_path' => Upload::DB_SYSTEM_PATH
                ) )
                ->validator( Validate::fileSize( 500000, 'Files must be smaller that 500K' ) )
                ->validator( Validate::fileExtensions( array( 'png', 'jpg', 'jpeg', 'gif' ), "Please upload an image" ) )
                ->dbClean( function ( $data ) {
                    // Remove the files from the file system
                    for ( $i=0, $ien=count($data) ; $i<$ien ; $i++ ) {
                        unlink( $data[$i]['system_path'] );
                    }
                    // Have Editor remove the rows from the database
                    return true;
                } )
            )
    )
    ->process( $_POST )
    ->json();

allan

The way to handle unique filenames, but having the file download with the original name is to store them in the file system using the primary key as the file name, and then have a single common download script (e.g. download?id=32) which would set the correct content type and file name headers for the download, and then have it read and echo out the file.

Allan