header()

[plapeyre]

        $query   = "SELECT filename, filetype, filesize, filepath FROM artist WHERE id = '$id'";
        $result  = mysql_query($query) or die('Error, query failed');

    list($filename, $filetype, $filesize, $filePath) = mysql_fetch_array($result);

    header("Content-Disposition: attachment; filename=Image");
    header("Content-length: $filesize");
    header("Content-type: $filetype");

    readfile($filePath);

    mysql_close();

    exit;

Code works fine, if thats what I want to do, however is there a change to the Content-Disposition that will allow the file to be VIEWED in the page, and not prompted to download it...? the true name of the image is a unique number that i dont want people to know and it's behind other directories NOT in public_html thus, introducing the headers, but i want the website to produce this image in the code with that ;filename=Image filename...

hope you can help

Phill

[edcellgavin]

try to comment that line.

[plapeyre]

comment what line?

eg:

<img src="<?php echo $filePath; ?>" />

or ?
sorry im new to php .. i know basics 🙂

[edcellgavin]

sorry bout that.
try to comment this line

header("Content-Disposition: attachment; filename=Image");

better yet, try to google what content-disposition does.
you can start here

[Rodney_H_]

I would suggest changing this line:

header("Content-Disposition: attachment; filename=Image");

To one of the the following (depending on the specific file-type):

header("Content-type: image/png"); // if it is a png

//OR, to 

header("Content-type: image/jpeg"); // if it is a jpeg

//OR...

header("Content-type: image/gif"); // if it is a gif

[plapeyre]

it's there 🙂
header("Content-type: $filetype");

it refers back to the database 🙂

[plapeyre]

Okay here we go:

Page 1

<?php
include '../library/include.php'; // connect to db

$query  = "SELECT id, fullname, receipt, height, width, filename, date FROM artist";
$result = mysql_query($query) or die('Error, query failed');

if(mysql_num_rows($result) == 0)
{
    echo "No Contributors <br>";
}
else
{
    while(list($id, $fullname, $receipt, $height, $width, $filename, $date) = mysql_fetch_array($result))
    {
    if ($saved == '1') { $saved = YES; } else { $saved = NO; } // dont worry about this :)
?>
    <table>
        <tr>
            <td>
                <a href="javascript:void(0);" onclick="javascript:window.open('...address..../view_image.php?id=<?php echo $id; ?>','_new','width=<?php echo $width; ?>, height=<?php echo $height; ?>');" title="Contribution Image">Image</a>
            </td>
        </tr>
    </table>
<?
    }
}
mysql_close();
?>

Creates a popup widow to the size of the image (image sizes are in the db as height and width - irrelevant)

This is the code to the page that pops up:

<?php

$id = $_GET['id'];

include '../library/include.php';

$query  = "SELECT id, receipt, filepath, filename FROM artist WHERE id='$id'";
$result = mysql_query($query) or die('Error, query failed');

if(mysql_num_rows($result) == 0)
{
    echo "No Image Selected <br />\n";
    echo "<a href=\"javascript:window.close();\">Close</a>";
}
else
{
        $query   = "SELECT filename, filetype, filesize, filepath FROM artist WHERE id = '$id'";
        $result  = mysql_query($query) or die('Error, query failed');

    list($filename, $filetype, $filesize, $filePath) = mysql_fetch_array($result);

    header("Content-Disposition: unspecified; filename=TwoDollarArt");
    header("Content-length: $filesize");
    header("Content-type: $filetype");

    readfile($filePath);

    mysql_close();

    exit;
}
?>

the directory of this code is
/www/<username>/public_html/theart/

the directory of the image is
/www/<username>/tmp/theart/

so that is why im using headers, to get to the image... that code there works, but it DOWNLOADS it, i just want it to view.. and if they do "save it" they wont get the name of the image, because it is named as a unique and important number... eg a receipt number or something...