Thread: graphics display

Hi

I want to make a table with one field containing graphics. How can I display
them?   I have  followed 2 directions,  either with some problems:

(1) in one table I used blobs, with success but how to display the figures ?

(2) in another I used a field to link to existing figures and outputting the
query as a html file. I type something like <img
src="/home/nogueira/fig1.gif" >. But,  the html file comes out without the
html tags (" <>" ) and then I have to edit the file and type the tags  to see
the figures.

Thank for your attention and any help

Eduardo
-------------------------------------------------

Eduardo  A. Nogueira, MD, PhD
Cardiac Catheterization Laboratory
University of Campinas School of Medicine
Campinas, Sao Paulo
Brazil

You didn't say, but I'll assume you are using PHP.  This was given to me by
someone on the forum:

<?php
include('common_db.inc');

// getimagedata.php3 - by Florian Dittmer <dittmer@gmx.net>
// Example php script to demonstrate the direct passing of binary data
// to the user. More infos at http://www.phpbuilder.com
// Syntax: getdata.php3?id=<id>
$id = $_GET["id"];
if($id) {
     $db = db_connect();
     $results = pg_query($db,"Select someimage from tblimage7");
    $row =  pg_fetch_array($results);

    echo stripcslashes($row[0]);

}
?>

Patrick Hatcher
Macys.Com
Legacy Integration Developer





                         
                    Eduardo Nogueira
                         
                    <nogueira@hc.unicamp.br       To:     novice-postgres <pgsql-novice@postgresql.org>
                         
                    >                             cc:
                         
                    Sent by:                      Subject:     [NOVICE] graphics display
                         
                    pgsql-novice-owner@post
                         
                    gresql.org
                         

                         

                         
                    11/24/2002 06:56 PM
                         
                    Please respond to
                         
                    nogueira
                         

                         




Hi

I want to make a table with one field containing graphics. How can I
display
them?   I have  followed 2 directions,  either with some problems:

(1) in one table I used blobs, with success but how to display the figures
?

(2) in another I used a field to link to existing figures and outputting
the
query as a html file. I type something like <img
src="/home/nogueira/fig1.gif" >. But,  the html file comes out without the
html tags (" <>" ) and then I have to edit the file and type the tags  to
see
the figures.

Thank for your attention and any help

Eduardo
-------------------------------------------------

Eduardo  A. Nogueira, MD, PhD
Cardiac Catheterization Laboratory
University of Campinas School of Medicine
Campinas, Sao Paulo
Brazil

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)