Phpster wrote:
On Feb 22, 2009, at 5:17, Joao Gomes Madeira <jpcg.mad@xxxxxxxxx> 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:
<?php
... get the record from the database using query string and then ...
$err=1;
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');
imagejpeg($img);
imagedestroy($img);
}
...
Cheers
JP
-----Original Message-----
From: Sashikanth Gurram <sashi34u@xxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject: 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.
Thanks,
Sashi
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
Note that the image needs to be accessible by apache. You may want to
store those images in a folder in or just above the web root and
perhaps create an image upload routine
Bastien
Hi Bastien,
I did not quite get what you have said. Does it really matter where we
store the image? I mean, we can always retrieve the location and display
it as long as we feed the db with the correct path. And what is meant by
a image upload routine?
-Sashi
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
