How to view file in webpage

maryjiel

Hello, can anyone help me? Im having a problem in viewing a blob file.

I'm trying to view a file on webpage with pdf, doc, docx, xls, xlsx format but when i try to open the file it always download. what is wrong with it?

Here is that code.

<?php
if(isset($_GET['id']))
{
include("db.php");
$id    = $_GET['id'];
$query = "SELECT name, type, size, content " .
         "FROM upload WHERE id = '$id'";
$result = mysql_query($query) or die('Error, query failed');
list($name, $type, $size, $content)=mysql_fetch_array($result);
header("Content-length: $size");
header("Content-type: $type");
echo $content;
exit;
}
?>

😕

(Changed [noparse]

tags to

[/noparse] tags -- MOD)

dagon

nothing is wrong with it, a browser only understands a limited number of file types(no program understands every file type), if you try to read a file of a type the browser does not understand it parses it to the OS that will usually try launch the application associated wit that file type.

maryjiel

then what could be the problem with the code? Do i have to add something or do i have to remove a line?

I want something like this http://lerdorf.com/veracruz.pdf

wherein I can view the pdf file in the browser.

I need a code to view the pdf file to be display in the HTML webpage where the PDF file is stored in MYSQL Database.

Do you know how to do this?

dagon

no browser on the market can read a pdf file

maryjiel

then how can this link --> http://lerdorf.com/veracruz.pdf be viewed in a webpage?

do you know how to do this?

dagon

depending on the user, you\they probably have something like adobe reader plug-in installed

maryjiel

do you know some code on how to do this or some tutorial that works?

johanafm

The thing is that as long as you set an appropriate content type, such as 'application/pdf/ for a pdf file, the browser will - IF it is capable (due to a plugin) - let the user see it inside the browser.

If the browser doesn't recognize the content type or does not know how to display it, it will offer a download option instead, since the user may very well know what application to use with a particular file type.

So, assuming you allready use correct content types, there is NOTHING you can do. If you are not using correct content types, then the answer is to correct them.