[tharu901]

how to retrieve a image from mysql database?using PHP..

[JackOfAllTrades]

Well, that would all depend on how you're SAVING the image in your database.

[tharu901]

tharu901, on 13 March 2011 - 07:05 AM, said:

how to retrieve a image from mysql database?using PHP..

<?php
$con=mysql_connect("localhost", "root", "");
mysql_select_db("mobile_hut",$con);
$query = "SELECT * FROM news";
$result = mysql_query($query);

while ($r=mysql_fetch_array($result))
{
$pic = $r['image'];
echo '<img src="$pic">'  ;
}
mysql_close($con);
?> 

that is code i use it for image retrieval but it does not show ihe image..

[JackOfAllTrades]

Again, I asked how you SAVED it in the DB, not how you're retrieving it!

[tharu901]

JackOfAllTrades, on 13 March 2011 - 07:28 AM, said:

Again, I asked how you SAVED it in the DB, not how you're retrieving it!

I stored it mysql database as a text format.as below...

Attached image(s)

• 

[JackOfAllTrades]

Are you storing the actual image as TEXT or are you saving the PATH to the image?

There are eleven billion tutorials on this available to you through Google. I would suggest you find one and use it.

[tharu901]

JackOfAllTrades, on 13 March 2011 - 08:55 AM, said:

Are you storing the actual image as TEXT or are you saving the PATH to the image?

There are eleven billion tutorials on this available to you through Google. I would suggest you find one and use it.

yes i stored the path of image as text....
ya definitely there are billions of tutorials i follow the few of these but i cant satisfy with it...please can you help me even give a simple tutorials as a link.....

[KingCuddles]

Are you storing the full path? Just the file name? What about extension?

What I mean is:

Suppose your image is called dream_in_code_rulez.jpg and is stored in /images/.

Are you storing:

• dream_in_code_rulez
  
• dream_in_code_rulez.jpg
  
• images/dream_in_code_rulez.jpg

If you are only storing the file name, with out an extension, you would need to modify your code like so:

echo "<img src=images/'$pic'.jpg />";

Also please note that I have closed the image tag correctly.

Also are you getting any errors?

This post has been edited by KingCuddles: 13 March 2011 - 03:49 PM

[Dormilich]

KingCuddles, on 13 March 2011 - 11:16 PM, said:

Also please note that I have closed the image tag correctly.

correctly in the sense that it is invalid HTML because you definitely do not use XHTML?

[LiDoNg_9_0]

maybe you got wrong with saving the image..which is the most important because how will u able to retrieve if it is not there or the file doesn't exist. please check if you include the directory name,file name, and also the extension,. u can get all of this at your upload script. be guided..

[KingCuddles]

Sorry my bad I thought it was valid for HTML as well as XHTML

I always validate XHTML Strict anyway

Thanks for spotting that Dormilich

This post has been edited by KingCuddles: 13 March 2011 - 03:52 PM

[neil_12s]

Well Thanks for all the suggestion. I have saved the image in a table named "children" in a mysql database. It is saved as a link (url) example

http://www.............ages/Childrens/sn3.jpg

What I want to know is how to retrieve this link either to a variabale or as the link itself and show the image in a web page. What I am trying to do is to show the images like in a slide show. I am working with PHP.

Hope you can help me.

Thanks
Wilfred.

This post has been edited by neil_12s: 20 April 2011 - 10:28 PM

[JackOfAllTrades]

neil_12s, you received an answer in your own topic. Please don't resurrect older topics with a "me too" post!