displaying images from database

Anon

I want to be able to display images from a database. How do I do this?
I've tried using IMG SRC = "<?php echo /uploads/images/$image?>" but it does'nt display the image.

Anon

It's not a good idea to save image to database.

You can save a image with a image file.
and save the file name to database.

then you can use <img src="XXX">

Good lucky.

Anon

I didn't actually save the file to the database. It's in an ftp directory. My problem is I don't know how to display the image. I'm not even sure that using IMG SRC actually works. Would someone please tell me how to do this?

Anon

Did you save the image location to the database? If so, just query (mysql or postgres or oracle) for the corresponding row and field and then create a var called like $imagename and then just create the following line in your PHP code:

echo "<img src=\"http://www.yourdomain.com/path/to/image/$imagename\">;

Anon

Well, they're 3 senarios as I can think of for your case.
1) You save your image filename into a database
2) You don't save the filename into a database and the image file is sitting at the same server as the scripts( you can use a direct referencing in this case by using either absolute URL or relative URL of the image filename. )
3) Your image file is actually on another server which you need to ftp and get it and load into a page.

What I have done for storing the image filename into the database and to display that particular image file into a html, I get the file name from the database and display it.

A piece of example code:

<?php
$imagename = "something.gif";

$link=mysql_connect($localhost,$user,$pass);
$query="SELECT * FROM imgtable WHERE image=\"$imagename\";";
$result=mysql_query($query);
$getrow=mysql_fetch_array($result);
$IMAGE = $getrow["image"];

// If your real image file is sits in a particular path, set it
$image = "../images/something/$IMAGE";
?>

// Display in html

For senario 3, you can use system() function to execute a ftp program and get your data on the ftp site. By the way, if someone has tried that, please kindly let me know. Thanks!

It should be something like this:
system( "ncftpget -f login.cfg <host> <dir path> <filename>" );

try to read the manual of ncftpget or ftp or ... etc.
Hope this help. =)

Just K.

Anon

Thanks for your comments however I didn't save any image in DataBase.
So, I shows you my all source...

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>

<BODY BGCOLOR="#FFFFFF" link=black vlink=blue>
<?
$connect=mysql_connect("localhost","root","111111");
mysql_select_db=("teldevel",$connect);
$result=mysql_query("select emp_name,dept,position,sex,hobby,birth_year,birth_month,birth_day,birth_chk from employee
order by emp_name asc,
emp_no asc",$connect);

$total=mysql_num_rows($result);
$totalid=$total;
$pagemax=15;

$pagecount=$total/$pagemax;

$pagecount2=(int)$pagecount;
if($pagecount2!=$pagecount)$pagecount=pagecount2+1
if(!$total)
echo("<center><h1> ÇöÀç ÀÔ·ÂµÈ ÀÎ»çÁ¤º¸°¡ ¾ø½À´Ï´Ù.</h1></center>");

else

{
echo("
<table width=600 border=0 align=center>
<tr>
<td width=300 align=left>

<a href=hrm.html><B><FONT SIZE=\"2\" COLOR=\"red\">ÀÎ»ç¸¶½ºÅ¸</FONT></B></a>
<a href=search.html><B><FONT SIZE=\"2\" COLOR=\"red\">»ç¿ø°Ë»ö</FONT></B></a> ");

	if($pagenum!=1)
	{
	$pagenum=$pagenum-1;
	echo(" 
	     <a href=list.php?pagenum=$pagenum><B><FONT SIZE=\"2\" COLOR=\"black\">ÀÌÀüÆäÀÌÁö·Î</FONT></B></a>
		 ");
	$pagenum=$pagenum+1;  
	}
	else
	{
	echo("<B><FONT SIZE=\"2\" COLOR=\"black\">ÀÌÀüÆäÀÌÁö·Î</FONT></B>;}


	if($pagenum!=$pagecount)
	{
	$pagenum=$pagenum+1;
	echo("
	      <a href=list.php?pagenum=$pagenum><B><FONT SIZE=\"2\" COLOR=\"black\">´ÙÀ½ÆäÀÌÁö·Î</FONT></B></a>
		  ");
	$pagenum=$pagenum-1
	}

	else
	{
	echo("
	      <B><FONT SIZE=\"2\" COLOR=\"black\">´ÙÀ½ÆäÀÌÁö·Î</FONT></B></a>
		 ");
	}

	echo(" </td>
	      <td width=300>
		   <div align=right>
		   <font size=2> ÇöÀç ÀÎ»çÁ¤º¸ ÃÑ $totalid°³ Áß $pagenum/$pagecount ÆäÀÌÁö</font></div></td>
	</tr>
	</table>




	<table width=600 border=0 align=center>
	<tr>
	<td colspan=5>
	<hr>
	</td>
	</tr>
	<tr bgcolor=#475790>
	<td width=70 height=\"30\">
		<div align=center><font size='2' color='white'>ÀÌ¸§</font></div>
	</td>
	<td width=70 height=\"30\">
		<div align=center><font size='2' color='white'>ºÎ¼</font></div>
	</td>
	<td width=60 height=\"30\">
		<div align=center><font size='2' color='white'>Á÷À§</font></div>
	</td>
	<td width=50 height=\"30\">
		<div align=center><font size='2' color='white'>¼ºº°</font></div>
	</td>
	<td width=130 height=\"30\">
		<div align=center><font size='2' color='white'>Ãë¹Ì</font></div>
	</td>
	<td width=70 height=\"30\">
		<div align=center><font size='2' color='white'>»ý³â</font></div>
	</td>
	<td width=50 height=\"30\">
		<div align=center><font size='2' color='white'>»ý¿ù</font></div>
	</td>
	<td width=50 height=\"30\">
		<div align=center><font size='2' color='white'>»ýÀÏ</font></div>
	</td>
	<td width=50 height=\"30\">
		<div align=center><font size='2' color='white'>À½/¾ç</font></div>
	</td>
	</tr>

	");


	$counter=($pagenum-1)*$pagemax;
	$j=0;
	$uncounter=$total-(($pagenum-1)*$pagemax);
	while($counter<$total)
	{
			if($j<$pagemax)
			{$emp_name=mysql_result($result,$counter,"emp_name");
			 $dept=mysql_result($result,$counter,"dept");
			 $position=mysql_result($result,$counter,"position");
			 $sex=mysql_result($result,$counter,"sex");
			 $hobby=mysql_result($result,$counter,"hobby");
			 $birth_year=mysql_result($result,$counter,"birth_year");
			 $birth_month=mysql_result($result,$counter,"birth_month");
			 $birth_day=mysql_result($result,$counter,"day");
			 $birth_chk=mysql_result($result,$counter,"birth_chk");

			echo("
			<tr bgcolor=#dddddd>
			   <td>
			     <div align=center>
			     <font size=2 color='black'>$uncounter</font>
			     </div>
			   </td>
			   <td>
			     <div align=center>
			     <font size=2><a href=content.php3>$emp_name</font>  
			     </div>                                              
			   </td>                                                 
			   <td>
			     <div align=center>
			     <font size=2>$dept</font>
			     </div>
			   </td>
			   <td>
			     <div align=center>
			     <font size=2>$position</font>
			     </div>
			   </td>
			   <td>
			     <div align=center>
			     <font size=2>$sex</font>
			     </div>
			   </td>
			   <td>
			     <div align=center>
			     <font size=2>$hobby</font>
		         </div>
			   </td>
			   <td>
			     <div align=center>
			     <font size=2>$birth_year</font>
			   </div>
			   </td>
			  <td>
			     <div align=center>
				  <font size=2>$birth_month</font>
				  </div>
			 </td>
			 <td>
			   <div align=center>
			   <font size=2>$birth_day</font>
			     </div>
			   </td>
			   <td>
			     <div align=center>
			     <font size=2>$birth_chk</font>
			     </div>
			   </td>
		    </tr>
			");
			$j=j+1;
			$uncounter=uncounter-1;                    
			}                                         


		$counter=$counter+1;                          
	}

}

           echo("<tr>
		           <td colspan=\"5\" align=middle>");            
				   for($i=1;$i<=$pagecount;)
				     {
					   if($pagenum!=$i)
					       { 
						     echo("
							       <a href=list.php3?pagenum=$i>
								   <font size=1>[$i]</font>
								   </a>
								  ");
                            }
						else
						    {echo(" <font size=1 [$i]</font>");}
                       $i=$i+1;
					   }

		   echo("</td></tr></table>");

echo("
<table width=600 border=0 align=center>
<tr>
<td align=right>
<div align=center>
<form method="\post\" action=\"hrsearch.php?pagenum=1\">
<INPUT TYPE=\"radio\" NAME=\"msearch\" value=\"emp_name\" checked>

<font size=2 color=black>ÀÌ¸§</font>
<INPUT TYPE=\"radio\" NAME=\"msearch\" value=\"dept>

<font size=2 color=black>ºÎ¼</font>
<INPUT TYPE=\"radio\" NAME=\"msearch\" value=\"position\">

<font size=2 color=black>Á÷À§</font>
<input type=text name=search>
<input type=submit name=submit value=Ã£±â>
</form>

</BODY>

Anon

This is what I'm trying to do after opening up an ftp connection using ftp functions.

    $slash = "/";
    echo $list[$i];  
    $path = $slash.$list[$i];
    echo $path;
    $size = ftp_size($ftp, $list [$i]);
    echo $size;
    ?>
    <img src = "<?php echo $path?>">

I included the echo statements to show that I have tested the script. If my path is wrong, I'd like to know what the correct path is. The echo $path statement displays /uploads/images/filename. The file is in there. The problem is I don't know if my img src = "URL" is correct.

Anon

try using echo with "

i.e.

otherwise php tries to interpret the aritmetic formula "uploads / images / filename" and this will result in a "division by zero"-error.

You can also look at the html-source your script is producing and check what's in the img-tag after the server parsed your code...

(sorry for my poor english)

Anon

That doesn't work. PHP only interprets the last to quotation marks and displays ?> on the page.

Anon

Has any one here actually done what I\'m trying. None of your answers work in my case.
By the way I\'m using PHP 3.