Welcome to WebmasterWorld Guest from 54.166.112.74

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

How to display external image link stored.

   
11:04 am on May 17, 2007 (gmt 0)

5+ Year Member



Hi... Everybody... i'm a beginner and learning everything online... just few days into it i've reached to this situation i donno... how to get outta this...

could you plz get me code on to display / list External Image Link (such as image from Yahoo.com) Stored in mysql using php...

[edited by: eelixduppy at 11:19 am (utc) on May 17, 2007]
[edit reason] no URLs, please [/edit]

11:18 am on May 17, 2007 (gmt 0)

5+ Year Member



Using HTML you can do the following:

<img src="http://www.yahoo.com/images/image.jpg">

11:35 am on May 17, 2007 (gmt 0)

WebmasterWorld Senior Member henry0 is a WebmasterWorld Top Contributor of All Time 10+ Year Member



Welcome to WebmasterWorld bgb!

Your images are stored in a MySQL DB.
it is better to store in your DB the img path rather than storing the actual img as "blob"

Since you are learning
you need to
START HERE
[webmasterworld.com]

11:50 am on May 19, 2007 (gmt 0)

5+ Year Member



Hi... Thanks colandy & Henry...

My problem is i'm not saving the image in mysql buy i'm saving the link of yahoo.com or anyother site image link text... so that my server or site get the traffic of showing up the image.

for exp table has stored data as follows:
--------------------------------------------
rno -----:----- 1245
name -----:----- Mercedec Benz
year -----:----- 2002
image -----:----- http://example.com/a/fo/ford/show_toyota_fjcruiser.jpg

but not the image

So... cud anyone plz help me with a CODE to show image use php with links in mysql on the page? PLZ...

[edited by: jatar_k at 1:16 pm (utc) on May 19, 2007]
[edit reason] no urls thanks [/edit]

1:07 pm on May 19, 2007 (gmt 0)

10+ Year Member



My problem is i'm not saving the image in mysql buy i'm saving the link of yahoo.com or anyother site image link text... so that my server or site get the traffic of showing up the image.

Could you just clarify that - you want to fetch the image from Yahoo and store it in your database, or you want the users web-browser to go and get the image from Yahoo so your web-server doesn't get the traffic?

8:12 am on May 21, 2007 (gmt 0)

5+ Year Member



Hi... Mr. NOBODY...
My TEXT

My problem is i'm not saving the image in mysql buy i'm saving the link of yahoo.com or anyother site image link text... so that my server or site get the traffic of showing up the image.


Mr. NOBODY'S TEXT
Could you just clarify that - you want to fetch the image from Yahoo and store it in your database, or you want the users web-browser to go and get the image from Yahoo so your web-server doesn't get the traffic?

Yes... the link of image from yahoo stored in mysql should fetch the image from yahoo.com

IMAGE IS NEIGHTER STORED IN SERVER OR SITE NOR MYSQL DB only the link of the image is stored in the table:column

12:03 pm on May 21, 2007 (gmt 0)

5+ Year Member



So if the link is stored in the db. Use the following:

<img src="<?php echo $row['imglink'];?>">

$row['imglink'] being the result form your query after the fetch. the imglin field would have to hold the fold http path ot the image.