CODEWITHSUNDEEP
javascriptphpprogressblockui
ntalekt
ntalekt

Reputation: 852

PHP script status bar

I have created a php script that submits a query and downloads the results in a CSV. I have created a bootstrap button where users can click to download the file. Some of the reports take longer to create and I wanted to show the user some sort of status that the script is running in the background.

I tried something simple like BlockUI from inside the PHP script. Using echo '<script type="text/javascript">$.blockUI();</script>'; in the beginning of the script and echo '<script type="text/javascript">$.unblockUI();</script>'; at the end but it didn't work.

Can someone help? I don't need a progress bar or anything fancy. I just need to show some type of status while the php script is running.

HTML:

...
<td class="pull-right"><a type="button" href="report1_download_csv.php" class="btn">Download</a></td>
...

PHP:

<?php
/* Set up and execute the query. */
$sql = "SELECT 
FROM   TABLE ";
$stmt = sqlsrv_query( $conn, $sql);

while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) )  {
 foreach($row AS $key => $value){
        $pos = strpos($value, '"');
        if ($pos !== false) {
            $value = str_replace('"', '\"', $value);
        }
        $out .= '"'.$value.'",';
    }
    $out .= "\n";
}
sqlsrv_free_stmt($results);
sqlsrv_close($conn);
// Output to browser with the CSV mime type
header("Content-type: text/x-csv");
$date = date('m-d-Y-His');
header("Content-Disposition: attachment; filename=Report1_{$date}_UTC.csv");
echo "Column1, Column2\n";
echo $out;
?>

Upvotes: 0

Views: 585

Answers (1)

Arash Younesi
Arash Younesi

Reputation: 1760

use ajax to send request to server to do operation then show a spinner or any thing else untill server give you response.

Upvotes: 0

Related Questions