Re: [PHP-DB] Retrieving Image Location in MySQL
[email protected] (Sashikanth Gurram)
| Newsgroups | php.db |
|---|---|
| Message-ID | <[email protected]> |
Hi,
Yes. But I assign the location of the image (
C:\Users\Sashikanth\Desktop\Bldgs_lots\Burruss.jpg) to the $location
variable by using the mysqli_fetch_array($data) command. I send a query
to the db and the result is obtained and the image location is stored
into $location. So it is pretty straightforward. But I cannot understand
why is it not displaying the picture after retrieving the image. Should
I use any other additional commands to display the picture? Or do I need
any changes in my PHP configuration file? I have checked the Config
file and the ; sign infront of extension=php_gd2.dll has been removed.
Thanks,
Sashi
> Hello,
>
> Does something like this work on your php script?
>
> $location="..\..\Bldgs_lots\Burruss.jpg"
>
> OR
>
> $location="..\Bldgs_lots\Burruss.jpg"
>
>
>
>
> GR
> Muhsin
>
>
>
> Sashikanth Gurram wrote:
>
>> This is the location where I have saved my images.
>> /C:\Users\Sashikanth\Desktop\Bldgs_lots\Burruss.jpg
>> /I have loaded the above location exactly into my database. But when I
>> call it using
>>
>> /echo "<img src='$location' border='1' height='150' width='200'
>> alt='$build' >";/
>>
>> It is simply giving me some blank empty space, with the name of the
>> picture in the blank space (Since I am using alt). So, as I see it,
>> the retrieval part is working fine, but the displaying of the image is
>> not functioning properly. I am using a WAMP server. Any kind of
>> suggestions are welcome.
>>
>> Thanks,
>> Sashi
>>
>> PS: For Reference, I am posting my entire code below again. The image
>> retrieval part is towards the end of the code.
>>
>> /<html>
>> <body>
>> <form action="mysqli.php" method="post">
>> <br>
>> <div align="center">
>> Building Name:<select name="name">
>> <option value=""> Select a Building</option>
>> <option value="Military Building">Military Building</option>
>> <option value="Monteith Hall">Monteith Hall</option>
>> <option value="New Residence Hall-Career Services Site">New
>> Residence Hall-Career Services Site</option>
>> <option value="Williams Hall">Williams Hall</option>
>> <option value="Women's Softball Field">Women's Softball
>> Field</option>
>> <option value="Wright House">Wright House</option>
>> </select>
>> </div>
>> <input type="submit" />
>> </form>
>> <img src="mysqli.php?">
>>
>> <?php
>> // Connects to your Database
>> $host="******";
>> $user="*******";
>> $password="********";
>> $dbname="*********";
>> $cxn=mysqli_connect($host, $user, $password, $dbname) ;
>> if (!$cxn=mysqli_connect($host, $user, $password, $dbname))
>> {
>> $error=mysqli_error($cxn);
>> echo "$error";
>> die();
>> }
>> else
>> {
>> echo "Connection established successfully";
>> }
>> //Define the variables for Day and Month
>> $Today=date("l");
>> $Month=date("F");
>> $build=$_POST["name"];
>> $low_speed=2.5;
>> $high_speed=4;
>> $hour=date("G");
>> $minute=date("i");
>> if ($minute>=00 && $minute<=14)
>> {
>> $minute=00;
>> }
>> elseif ($minute>=15 && $minute<=29)
>> {
>> $minute=15;
>> }
>> elseif ($minute>=30 && $minute<=44)
>> {
>> $minute=30;
>> }
>> else
>> {
>> $minute=45;
>> }
>> $times="10:$minute";
>> $sql="SELECT buildingname, parking_lot_name, empty_spaces, distance,
>> round(distance/($low_speed*60),1) AS low_time,
>> round(distance/($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
>> parkinglots.parking_lot_code=buildings_lots.parking_lot_code AND
>> parkinglots.parking_lot_code=occupancy2.parking_lot AND
>> Buildings.BuildingCode=Image.BuildingCode) AND buildingname='$build'
>> AND month='$Month' AND day='Monday' AND Time='$times'";
>> $data = mysqli_query($cxn,$sql);
>> if (!$data=mysqli_query($cxn,$sql))
>> {
>> $error=mysqli_error($cxn);
>> echo "$error";
>> die();
>> }
>> else
>> {
>> echo "<br>";
>> echo "Query sent successfully";
>> }
>> echo "<br>";
>> echo "<h1> PARKING LOT INFORMATION <h1>";
>> echo "<table border='1' cellspacing='5' cellpadding='2'>";
>> echo "<tr>\n
>> <th>Building</th>\n
>> <th>Parking Lot</th>\n
>> <th>Estimated Number of Empty Spaces</th>\n
>> <th>Distance (Feet)</th>\n
>> <th>Estimated walking time to the building</th>\n
>> </tr>\n";
>> while ($row=mysqli_fetch_array($data))
>> {
>> extract($row);
>> $building = $row[0];
>> $parking_lot = $row[1];
>> $Number_of_Empty_Spaces = $row[2];
>> $Distance = $row[3];
>> $time_l = $row[4];
>> $time_h=$row[5];
>> $location=$row[6]; echo "<tr>\n
>> <td>$building</td>\n
>> <td>$parking_lot</td>\n
>> <td>$Number_of_Empty_Spaces</td>\n
>> <td>$Distance</td>\n
>> <td>$time_h - $time_l mins</td>\n
>> <td>$location</td>\n
>> </tr>\n";
>> }
>> echo "</table>\n";
>> echo "<img src='$location' border='1' height='150' width='200'
>> alt='$build' >";
>> ?>
>> </body>
>> </html>/
>>
>>
>> mrfroasty wrote:
>>
>>> Hello,
>>>
>>> It might be something with location where the script is located and the
>>> image.I think is normally the case if they arent on the same
>>> directory...
>>> If not you might want to try saving your image locations with something
>>> like ../../image_folder/image.jpg
>>>
>>> I am not sure though as I have seen this issue on one application but
>>> it runs on LAMP
>>>
>>> P:S
>>> ../ One step back from the script location
>>>
>>>
>>> GR
>>> Muhsin
>>>
>>>
>>> Sashikanth Gurram wrote:
>>>
>>>
>>>> Hi,
>>>> Thanks a lot for the suggestion. It is working fine but there is some
>>>> problem. When I introduced the piece of code you have suggested into
>>>> my code, I am getting a space for the picture but nothing is there in
>>>> that space. It is just blank. I do not know the reason for this. I am
>>>> just attaching a picture just in case it might give you a better idea.
>>>> Further, this is the piece of code I have written to display the pic.
>>>>
>>>> /echo "<img src='$location' border='1' height='150' width='200'
>>>> alt='$build' >";/
>>>>
>>>> Any help would be greatly appreciated.
>>>> Thanks,
>>>> Sashi
>>>>
>>>> mrfroasty wrote:
>>>>
>>>>
>>>>> Hello,
>>>>>
>>>>> Storing only location of the image in dB wouldnt be any different than
>>>>> other string/data retrieved from the dB.That means if you have
>>>>> something
>>>>> like this in html documents whereby $image_location comes from the dB
>>>>> It should work without ....header stuffs
>>>>>
>>>>> Example
>>>>> <img src="$image_location" border="1" height="150" width="200"
>>>>> alt="Image" ISMAP>
>>>>> P:S
>>>>> Replace $image_location with image location from your dB.
>>>>>
>>>>>
>>>>> GR
>>>>> Muhsin
>>>>>
>>>>>
>>>>>
>>>>> Sashikanth Gurram wrote:
>>>>>
>>>>>
>>>>>
>>>>>> 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 purpose. All I am getting in my browser after using
>>>>>> the code is a long set of ASCII characters with the following warning
>>>>>> *Warning*: Cannot modify header information - headers already sent by
>>>>>> (output started at C:\wamp\www\mysqli.php:65) in
>>>>>> *C:\wamp\www\mysqli.php* on line *237
>>>>>> *
>>>>>> I am herewith attaching my code. If anyone can point out the
>>>>>> error or
>>>>>> give some kind of advice that would be really great. The location of
>>>>>> the image is stored in a table by the name IMAGE under the column
>>>>>> name
>>>>>> Location and here in the code, the location is retrieved under the
>>>>>> varibale name $Location.
>>>>>>
>>>>>> thanks,
>>>>>> Sashi
>>>>>>
>>>>>> /<html>
>>>>>> <body>
>>>>>> <form action="mysqli.php" method="post">
>>>>>> <br>
>>>>>> <div align="center">
>>>>>> Building Name:<select name="name">
>>>>>> <option value=""> Select a Building</option>
>>>>>> <option value="Agnew Hall">Agnew Hall</option>
>>>>>> <option value="Rector Field House">Rector Field House</option>
>>>>>> <option value="Richard B. Talbot Educational Resources
>>>>>> Center">Richard B. Talbot Educational Resources Center</option>
>>>>>> <option value="Robeson Hall">Robeson Hall</option>
>>>>>> <option value="Sandy Hall">Sandy Hall</option>
>>>>>> <option value="Saunders hall">Saunders hall</option>
>>>>>> <option value="Seitz Hall">Seitz Hall</option>
>>>>>> <option value="Shanks Hall">Shanks Hall</option>
>>>>>> <option value="Shultz Hall">Shultz Hall</option>
>>>>>> <option value="Skelton Conference Center">Skelton Conference
>>>>>> Center</option>
>>>>>> <option value="Williams Hall">Williams Hall</option>
>>>>>> <option value="Women's Softball Field">Women's Softball
>>>>>> Field</option>
>>>>>> <option value="Wright House">Wright House</option>
>>>>>> </select>
>>>>>> </div>
>>>>>> <input type="submit" />
>>>>>> </form>
>>>>>> <img src="mysqli.php?">
>>>>>>
>>>>>> <?php
>>>>>> // Connects to your Database
>>>>>> $host="*******";
>>>>>> $user="*****";
>>>>>> $password="******";
>>>>>> $dbname="*******";
>>>>>> $cxn=mysqli_connect($host, $user, $password, $dbname) ;
>>>>>> if (!$cxn=mysqli_connect($host, $user, $password, $dbname))
>>>>>> {
>>>>>> $error=mysqli_error($cxn);
>>>>>> echo "$error";
>>>>>> die();
>>>>>> }
>>>>>> else
>>>>>> {
>>>>>> echo "Connection established successfully";
>>>>>> }
>>>>>> //Define the variables for Day and Month
>>>>>> $Today=date("l");
>>>>>> $Month=date("F");
>>>>>> $build=$_POST["name"];
>>>>>> $low_speed=2.5;
>>>>>> $high_speed=4;
>>>>>> $hour=date("G");
>>>>>> $minute=date("i");
>>>>>> if ($minute>=00 && $minute<=14)
>>>>>> {
>>>>>> $minute=00;
>>>>>> }
>>>>>> elseif ($minute>=15 && $minute<=29)
>>>>>> {
>>>>>> $minute=15;
>>>>>> }
>>>>>> elseif ($minute>=30 && $minute<=44)
>>>>>> {
>>>>>> $minute=30;
>>>>>> }
>>>>>> else
>>>>>> {
>>>>>> $minute=45;
>>>>>> }
>>>>>> $times="$hour:$minute";
>>>>>> $sql="SELECT buildingname, parking_lot_name, empty_spaces, distance,
>>>>>> round(distance/($low_speed*60),1) AS low_time,
>>>>>> round(distance/($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
>>>>>> parkinglots.parking_lot_code=buildings_lots.parking_lot_code AND
>>>>>> parkinglots.parking_lot_code=occupancy2.parking_lot AND
>>>>>> Buildings.BuildingCode=Image.BuildingCode) AND buildingname='$build'
>>>>>> AND month='$Month' AND day='$Today' AND Time='$times'";
>>>>>> $data = mysqli_query($cxn,$sql);
>>>>>> if (!$data=mysqli_query($cxn,$sql))
>>>>>> {
>>>>>> $error=mysqli_error($cxn);
>>>>>> echo "$error";
>>>>>> die();
>>>>>> }
>>>>>> else
>>>>>> {
>>>>>> echo "<br>";
>>>>>> echo "Query sent successfully";
>>>>>> }
>>>>>> echo "<br>";
>>>>>> echo "<h1> PARKING LOT INFORMATION <h1>";
>>>>>> echo "<table border='1' cellspacing='5' cellpadding='2'>";
>>>>>> echo "<tr>\n
>>>>>> <th>Building</th>\n
>>>>>> <th>Parking Lot</th>\n
>>>>>> <th>Estimated Number of Empty Spaces</th>\n
>>>>>> <th>Distance (Feet)</th>\n
>>>>>> <th>Estimated walking time to the building</th>\n
>>>>>> </tr>\n";
>>>>>> while ($row=mysqli_fetch_array($data))
>>>>>> {
>>>>>> extract($row);
>>>>>> $building = $row[0];
>>>>>> $parking_lot = $row[1];
>>>>>> $Number_of_Empty_Spaces = $row[2];
>>>>>> $Distance = $row[3];
>>>>>> $time_l = $row[4];
>>>>>> $time_h=$row[5];
>>>>>> $location=$row[6]; echo "<tr>\n
>>>>>> <td>$building</td>\n
>>>>>> <td>$parking_lot</td>\n
>>>>>> <td>$Number_of_Empty_Spaces</td>\n
>>>>>> <td>$Distance</td>\n
>>>>>> <td>$time_h - $time_l mins</td>\n
>>>>>> <td>$location</td>\n
>>>>>> </tr>\n";
>>>>>> }
>>>>>> echo "</table>\n";
>>>>>> $err=1;
>>>>>> if ($img = file_get_contents($location, 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);
>>>>>> }
>>>>>> ?>
>>>>>> </body>
>>>>>> </html>/
>>>>>>
>>>>>> 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.
>>>>>>>
>>>>>>> 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 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
>>>>>>>> flame my note so no one attempts it.
>>>>>>>>
>>>>>>>> Be Well,
>>>>>>>> A-
>>>>>>>>
>>>>>>>> -----Original Message-----
>>>>>>>> From: Mattyasovszky Janos [mailto:[email protected]] Sent: Monday,
>>>>>>>> March
>>>>>>>> 02, 2009 9:29 AM
>>>>>>>> To: [email protected]
>>>>>>>> Subject: 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 say with sprintf()...
>>>>>>>>
>>>>>>>> Regards,
>>>>>>>> Matya
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>> ------------------------------------------------------------------------
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>
>
>
>
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Sashikanth Gurram
Graduate Research Assistant
Department of Civil and Environmental Engineering
Virginia Tech
Blacksburg, VA 24060, USA