Re: Storing Image Location in MySQL
| From: | Chris | Date: | Sun, 22 Feb 2009 21:47:10 +0000 |
| Subject: | Re: Storing Image Location in MySQL | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-45991@lists.php.net to get a copy of this message | ||
Sashikanth Gurram wrote:
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 |Don't store the full path to the image, just store the relative path. If you move your app to a new folder, then you have to go through and update all database records to point to the new path. If you store the relative path, you can set a config variable (or work it out yourself), and add the relative path to the end. So in your config: $cfg['folder_name'] = 'c:/apps/my_app_name/'; in the db location will be 'images/image.jpg'; Put the two together to get the full path: $image_path = $cfg['folder_name'] . $db['location']; -- Postgresql & php tutorials http://www.designmagick.com/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.