Hi JP,

Can you please let me know what is a GD? I have not installed Apache separately. I am using the WAMP server currently. Do I have to install any additional stuff before I can retrieve the image location from the db and display it in my browser?


Joao Gomes Madeira wrote:
Hey Sashi

You want something similar to this:
(you must have GD installed on Apache)

you can have this working by doing something like this in HTML:

<img src="picture.php?&qry=123">

and having as picture.php:

... get the record from the database using query string and then ...

if ($img = file_get_contents('/yourpath/yourfile.jpg', FILE_BINARY)) {
  if ($img = imagecreatefromstring($img)) $err = 0;
if ($err) {
  header('Content-Type: text/html');
  echo '<html><body><p style="font-size:9px">Error getting
image...</p></body></html>'; } else {
  header('Content-Type: image/jpeg');


-----Original Message-----
From: Sashikanth Gurram <sashi...@vt.edu>
To: php-db@lists.php.net
Subject: [PHP-DB] Storing Image Location in MySQL
Date: Sun, 22 Feb 2009 03:43:06 -0500

Dear All,

I am trying to store the location of a image into MySQL database, so that I can call it back from PHP to display it in a browser. For this purpose, I have created a table with two columns (BuildingCode, Location), where building is the primary key and location is the location where my picture is stored on my PC. My image is stored at /C:\Users\Sashikanth\Desktop\burruss.jpg/ on my PC.
The following table is an output from MySQL.
| BuildingCode   | Location                                                |
| 176                 | c:/users/sashikanth/desktop/burruss.jpg   |

Considering my original Image Location on my PC, will the above table be of any help if I try to retrieve the image using PHP? Is there any mistake in what I have done till now? I know that this may be a very basic question and i have searched through the internet quite extensively but could not find a solid answer. Would appreciate it greatly if anyone can help.


Sashikanth Gurram
Graduate Research Assistant
Department of Civil and Environmental Engineering
Virginia Tech
Blacksburg, VA 24060, USA

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to