Its not src='id=$id'> that will defnintely blow up....
echo '<img src="./path/to/image.php?id=$id">';
where $id is the id of the record you are trying to get the image to...
Bastien
From: Chip Wiegand <chip.wiegand@xxxxxxxxxx> To: bastien_k@xxxxxxxxxxx CC: php-db@xxxxxxxxxxxxx Subject: RE: storing images in database Date: Tue, 25 Jan 2005 12:37:15 -0800
Thanks Bastien, In testing this I have added the code samples to a page and have it working except the path statement is not correct. For now, I've just added all the code to one page, rather than including a second page. The statement - echo '<img src="id=$id">'; is resulting in this error - The requested URL /id=$id was not found on this server. Any suggestions? Thanks, Chip
"Bastien Koert" <bastien_k@xxxxxxxxxxx> wrote on 01/25/2005 09:45:39 AM:
> the best way to do this is to move the image processing code to a separate > page and include it like this > > echo '<img src="./path/to/image.php?id=$id">'; > > then the image page looks like this: > <?php > > if($_GET['id']) { > $id = $_GET['id']; > // you may have to modify login information for your database server: > @MYSQL_CONNECT("localhost","root","password"); > > @mysql_select_db("binary_data"); > > $query = "select bin_data,filetype from binary_data where id=$id"; > $result = @MYSQL_QUERY($query); > > $data = @MYSQL_RESULT($result,0,"bin_data"); > $type = @MYSQL_RESULT($result,0,"filetype"); > > Header( "Content-type: $type"); > echo $data; > > }; > ?> > > bastien > > > > >From: Chip Wiegand <chip.wiegand@xxxxxxxxxx> > >To: "PHP DB" <php-db@xxxxxxxxxxxxx> > >Subject: storing images in database > >Date: Tue, 25 Jan 2005 09:11:07 -0800 > > > >I have stored a .jpg image in a database, then when I make a sql statement > >to display that image on a web page all I get is the cryptic code in place > >of the image. I am storing it in a row configured as a blob, mime type > >image/jpeg and binary (using phpMyAdmin). What am I doing wrong? > >Regards, > >Chip > > > >-- > >PHP Database Mailing List (http://www.php.net/) > >To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
