How to retrieve pdf from mysql and display using php

Asked Nov 18 '20 at 11:03

Active Nov 19 '20 at 04:38

Viewed 12 times

I have an retrieving pdf from mysql. I have successfully retrieved the content of pdf from mysql but not able to display it on the website. Its giving me warning on header function I'm using to display it. Here is the code.

<?php
    ob_start();

    //to get unique name
    $fileName = time().".pdf";
    //to display as pdf
    header( "Content-type: application/pdf" );
    header( "Content-disposition: attachment; filename=".$fileName );
    echo $pdf;
    ob_end_flush();
?>

but I'm constantly getting this error.

Warning: Cannot modify header information - headers already sent by (output started at C:\wamp64\www\SRFRS\Project-page.php:176) in C:\wamp64\www\SRFRS\Project-page.php on line 212

I have looked for many solutions online but nothing worked for me. If you could give me a solution or any other way to display pdf on my website.

code around line 176

  echo '<img name="new_picture" src="data:image/jpeg;base64,'.base64_encode( $data['image'] ).'"   />';

edited Nov 19 '20 at 04:38

asked Nov 18 '20 at 11:03

Samist

1

[How to fix “Headers already sent” error in PHP](https://stackoverflow.com/questions/8028957/how-to-fix-headers-already-sent-error-in-php) – KIKO Software Nov 18 '20 at 11:09
How is `mysql` related to this? – brombeer Nov 18 '20 at 11:14
There's another reason we cannot answer your question: The code in your question is incomplete. Where does `$pdf` come from? All details matter. This could be a simple space in the wrong place, or a UTF-8 BOM. – KIKO Software Nov 18 '20 at 11:17
Already checked that post but nothing worked for me. – Samist Nov 18 '20 at 11:17
Have a close look at `Project-page.php` line 176. – KIKO Software Nov 18 '20 at 11:18
$pdf is the content of pdf file retrieved from database – Samist Nov 18 '20 at 11:18
commented that as well but not working. – Samist Nov 18 '20 at 11:20
Can you put the code, around line 176 in your question? – KIKO Software Nov 18 '20 at 11:21
Sorry, I waited 15 minutes, now I've got to go. – KIKO Software Nov 18 '20 at 11:37

How to retrieve pdf from mysql and display using php

0 Answers0