Sashi, pls read the following chapter http://www.php.net/manual/en/book.image.php Cheers JP -----Original Message----- From: Sashikanth Gurram <sashi34u@xxxxxx> To: Joao Gomes Madeira <jpcg.mad@xxxxxxxxx> Cc: php-db@xxxxxxxxxxxxx Subject: Re: Storing Image Location in MySQL Date: Sun, 22 Feb 2009 22:56:55 -0500 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? -Sashi 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: > > <?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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
