Re: [PHP-DB] Storing Image Location in MySQL
[email protected] (Phpster)
| Newsgroups | php.db |
|---|---|
| Message-ID | <[email protected]> |
On Feb 22, 2009, at 5:17, Joao Gomes Madeira <[email protected]> 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 <[email protected]> > To: [email protected] > 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. > > 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