How to download the content blob in php

Question

I have xml files stored in a blob field of a mysql table, I would like to know how to download these files on the local user disk automatically using php.

Create a low function on the server and not on the local disk.

function baixarArquivos($res) {
    while ($arq = mysqli_fetch_array($res)) {       
        $nomearquivo = $arq['CHAVEXML'];
        $arquivoxml  = $arq['XML'];        
        
        $path = 'c:\Temp\\xml\\'.$nomearquivo.'xml';
        file_put_contents($path, $arquivoxml);      
        
    }
}

Answer 1

You cannot do this on the user’s computer. What you have to do is provide the file download. Example:

<?php
    $path = 'c:\Temp\\xml\\'.$nomearquivo.'xml';
    $nomearquivo = 'seu_arquivo.xml';
    header('Content-Description: File Transfer');
    header('Content-Disposition: attachment; filename="'.$novoNome.'"');
    header('Content-Type: application/octet-stream');
    header('Content-Transfer-Encoding: binary');
    header('Content-Length: ' . filesize($path));
    header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
    header('Pragma: public');
    header('Expires: 0');
    // Envia o arquivo para o cliente
    readfile($path);