Imbedding and viewing images

AlGale

HI. I want to embed some images (PNG, GIF or JPEG) into a database and them pull them from it to view via PhP. I need to actually put the image in, rather than the path to it, as it is for a friend, and the idea is to make things as simple as possible for him (i.e. all done by an Access front end, not FTPing an image to a location, the making sure the relevant path is correct etc).

I have tried the following code:

echo "<img src=\"mysql.mysite.co.uk".$row['pic']."\">";

But my browser just hangs.

Any ideas? Thanks

AlGale

OK, even looking at the referenced way of doing things, I need some help with some code please.

while ( $row = mysql_fetch_array($cursor) )
{
echo("<TR><TD>" . $row["Make"] . "</TD><TD>" . $row["Model"] . "</TD><TD>" . $row["CC"] . "</TD>
<TD>" . $row["Colour"] . "</TD><TD>" . $row["Year"] . "</TD>
<TD>" . $row["_Desc"] . "</TD><TD>" . $row["pic"] . "</TD></TR>");

}

This works fine. Obviously the last bit displays the actual path to the images at the moment, just to check that it is pulling it through OK. I now need to replace that with:

echo "<img src=\"".$row['pic']."\"><br>";

But for some reason all my attempts have met with parse errors. The line on its own works fine, I just can`t tailor it to fit in to relaced the path with the actual picture.

nnichols

You cannot output image files directly in the page like that. You need to have a separate script to return the image and then access that image_script from the img src. If you search on here you will find lots of examples of this.

http://codewalkers.com/tutorials/35/1.html

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10228800&highlight=image

Hope this helps 😉

AlGale

Hi.

Thanks for the reply. I am confused though, as this part works fine:

echo "<img src=\"".$row['pic']."\"><br>";

I just can`t get it to fit into the table.

nnichols

Sorry. In your original post you said you wanted to store the image in the db, not just the path.

Try this -

while ( $row = mysql_fetch_array($cursor) ) { 

echo '<TR>
  <TD>' . $row['Make'] . '</TD>
  <TD>' . $row['Model'] . '</TD>
  <TD>' . $row['CC'] . '</TD> 
  <TD>' . $row['Colour'] . '</TD>
  <TD>' . $row['Year'] . '</TD> 
  <TD>' . $row['_Desc'] . '</TD>
  <TD><img src="' . $row['pic'] . '"></TD>
</TR>'; 

}

Hope this helps 😉

AlGale

Hi.

I`m not at my machine with Dreamweaver on to try that, but it looks like it will work to me - I obviously still have a problem with " and '

Can you explain something to me? What does the \ do in this line:

echo "<img src=\"".$row['pic']."\"><br>";

Many thanks for your help!

nnichols

The "\" is being used as the escape character. It is needed so that the double-quote in the string is part of the string and not the end of the string.

Hope that makes sense.

AlGale

Doh! I remember reading about that in my PhP manual now. Funny how you never put 2 and 2 together until you see an example. Thanks for the explanation! Cheers.