Re: [PHP-DB] Retrieving Image Location in MySQL

t;>>>>> >>>>>>>>>> thanks, >>>>>>>>>> Sashi >>>>>>>>>> >>>>>>>>>> / >>>>>>>>>> >>>>>>>>>> >>

Re: [PHP-DB] Retrieving Image Location in MySQL

teps and get back to you if I encounter more problems. Thanks, Sashi Fortuno, Adam wrote: Matya, Ha, ha, ha! Thank you good friend. I did say I didn't try the code :-) AF> Please note, I haven't tried this. It just seems plausible. I apologize if I confused anyone. I j

Re: [PHP-DB] Retrieving Image Location in MySQL

no, Adam wrote: Matya, Ha, ha, ha! Thank you good friend. I did say I didn't try the code :-) AF> Please note, I haven't tried this. It just seems plausible. I apologize if I confused anyone. I just meant to show how the parameter could help retrieve a picture. I wasn't too

Re: [PHP-DB] Retrieving Image Location in MySQL

Hi JP, Thanks for chipping in again. I have been using the following code (after retrieving the local location of my image to the variable $location. I am not really looking to host the pictures onto a site as of now), which u have earlier provided me with / $err=1; if ($img = file_get_content

Re: [PHP-DB] Retrieving Image Location in MySQL

Hello again Sashi The answer provided by Mushin won't work because images are not acessible from the outside. You can't have because that's not a valid URL... You can have something like which when interpreted by the browser will become something like http://yoursite/Bldgs_lots/Burruss.jpg

Re: [PHP-DB] Retrieving Image Location in MySQL

atya, Ha, ha, ha! Thank you good friend. I did say I didn't try the code :-) AF> Please note, I haven't tried this. It just seems plausible. I apologize if I confused anyone. I just meant to show how the parameter could help retrieve a picture. I wasn't too conc

Re: [PHP-DB] Retrieving Image Location in MySQL

high_speed*60),1) AS high_time, Location FROM >>>>> buildings, buildings_lots, parkinglots, occupancy2, Image where >>>>> (buildings.buildingcode=occupancy2.building AND >>>>> buildings.buildingcode=buildings_lots.building_code AND >>>>> parkin

Re: [PHP-DB] Retrieving Image Location in MySQL

Fortuno, Adam wrote: Matya, Ha, ha, ha! Thank you good friend. I did say I didn't try the code :-) AF> Please note, I haven't tried this. It just seems plausible. I apologize if I confused anyone. I just meant to show how the parameter could help retrieve a picture.

Re: [PHP-DB] Retrieving Image Location in MySQL

t try the code :-) AF> Please note, I haven't tried this. It just seems plausible. I apologize if I confused anyone. I just meant to show how the parameter could help retrieve a picture. I wasn't too concerned with the particulars. Hopefully the concept is sound. If not, please

Re: [PHP-DB] Retrieving Image Location in MySQL

e: image/jpeg'); > imagejpeg($img); > imagedestroy($img); > } > ?> > > / > > Sashikanth Gurram wrote: >> Hello guys, >> >> Thanks to you all for your kind replies. I will try the steps and get >> back to you if I encounter more problems. >&

Re: [PHP-DB] Retrieving Image Location in MySQL

kanth Gurram To: php-db@lists.php.net Subject: Re: [PHP-DB] Retrieving Image Location in MySQL Date: Fri, 06 Mar 2009 12:23:31 -0500 Dear all, I have been trying to retrieve the location of a image from database and display the image in the browser using PHP. I have written a sort of code for the pu

Re: [PHP-DB] Retrieving Image Location in MySQL

gt; JP > > -Original Message- > From: Sashikanth Gurram > To: php-db@lists.php.net > Subject: Re: [PHP-DB] Retrieving Image Location in MySQL > Date: Fri, 06 Mar 2009 12:23:31 -0500 > > Dear all, > > I have been trying to retrieve the location of a image from databa

Re: [PHP-DB] Retrieving Image Location in MySQL

haven't tried this. It just seems plausible. >> >> I apologize if I confused anyone. I just meant to show how the >> parameter could help retrieve a picture. I wasn't too concerned with >> the particulars. Hopefully the concept is sound. If not, please do >> flam

Re: [PHP-DB] Retrieving Image Location in MySQL

the particulars. Hopefully the concept is sound. If not, please do flame my note so no one attempts it. Be Well, A- -Original Message- From: Mattyasovszky Janos [mailto:m...@matya.hu] Sent: Monday, March 02, 2009 9:29 AM To: php-db@lists.php.net Subject: Re: [PHP-DB] Retrieving Image Loca

Re: [PHP-DB] Retrieving Image Location in MySQL

Message- From: Mattyasovszky Janos [mailto:m...@matya.hu] Sent: Monday, March 02, 2009 9:29 AM To: php-db@lists.php.net Subject: Re: [PHP-DB] Retrieving Image Location in MySQL Fortuno, Adam írta: //Write a query to pull out the picture's path $sql =

RE: [PHP-DB] Retrieving Image Location in MySQL

th the particulars. Hopefully the concept is sound. If not, please do flame my note so no one attempts it. Be Well, A- -Original Message- From: Mattyasovszky Janos [mailto:m...@matya.hu] Sent: Monday, March 02, 2009 9:29 AM To: php-db@lists.php.net Subject: Re: [PHP-DB] Retrieving Image

Re: [PHP-DB] Retrieving Image Location in MySQL

Fortuno, Adam írta: //Write a query to pull out the picture's path $sql = "SELECT path FROM Image WHERE ID = %s"; mysql_real_escape_string($value); Sorry, but this won't work, since you don't map the value of the escaped $value to the %s, lets s

RE: [PHP-DB] Retrieving Image Location in MySQL

Sashi, This (likely) means you have a some generic page (i.e., picture.php) that displays some picture. The picture it displays depends on the parameter passed when the page is called (i.e., 123). Sashi's Test Page ", $row['firstname']);