Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines
Hi
I struggle to report a file like a PDF or a MS-Office file (xlsx, docx) in a tabular report. The report should either display the file (in case of a PDF) or offer a mechanism ( eg. url ) to download the file.
The files are stored in a mysql database as blob/clob. Are there any examples I could check for this.
Thank you Patrick
Hi Patrick,
I would suggest listing the files in a table (or a list depending on your preference). Each item would be a link to page with a file id. For example:
<a href="path/to/getFile.php?fileID=fileID1">File ID 1</a>
Then in getFile.php you could retrieve the file content (blob) from your database and echo it to client:
<?php
$fileID = $_GET['fileID'];
list($name, $type, $size, $content) = getFileInfo($fileID);
header("Content-length: $size");
header("Content-type: $type");
header("Content-Disposition: attachment; filename=$name");
echo $content;
exit;
Let us know if you need further information. Thanks!
Let KoolReport help you to make great reports. It's free & open-source released under MIT license.
Download KoolReport View demo