Re: uploaded images display
| From: | Phil Jackson | Date: | Sun, 22 Apr 2001 07:56:49 +0000 |
| Subject: | Re: uploaded images display | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-8790@lists.php.net to get a copy of this message | ||
In the last part of a script that loads the image into the database:
$qs = "FetchImage.php3?nbr=".$lastone;
echo "<center>";
echo "<image src='".$qs."'>";
Where $lastone is a reference to the image just inserted into the DB:
$lastone = mysql_insert_id($someonnection);
Notice that the <img> src is a php file - we have to change gears here and fetch
the image from the DB and set the content type accordingly to a binary type
from FetchImage.php3:
$db = mysql_select_db("fractalv", $someonnection) or die ("db");
$sql = "SELECT * FROM pictures WHERE picturesID =".$nbr;
$sql_result = mysql_query($sql,$someonnection) or die ("no result");
$RecordCount = mysql_num_rows($sql_result);
$row = mysql_fetch_array($sql_result);
$thisphoto = $row[picture];
$contenttype = $row[pictureType];
mysql_close($fvconnection);
header("Content-type: $contenttype");
echo $thisphoto;
?>
Make sense? Follow the link I gave to the previous post for more extensive
info...
Phil J.
Sharmad Naik wrote:
> I have written a small script having connectivity with postgresql which
> can upload an image and display the already uploaded images.
> But it doesn't display the uploaded images. I guess the problem lies somewhere
> in $file_url.
> Pls help me
>
> <HTML>
> <HEAD>
> <TITLE></TITLE>
> </HEAD>
> <?
>
> $database=pg_connect("dbname=testdb user=postgres")
>
> ?>
> <?
> if ($submit) {
>
> $result = pg_Exec($database,"INSERT INTO ".
> "images (mem_id,mem_image) VALUES(NULL,'$fupload_name')");
>
> $file_dir = "/tmp";
>
> $file_url = "http://sanico.sharmad.org";
> if (isset($fupload ))
> {
> if ($fupload_type == "image/jpg" ||$fupload_type == "image/jpeg")
> {
> copy ($fupload, "$file_dir/$fupload_name") or die ("Couldn't
> copy");
> echo("$file_dir/$fupload_name");
> }
> }
> }
>
> $result=pg_Exec($database,"SELECT mem_image from images");
> for($i=0;$i<pg_NumRows($result);$i++){
> $images=pg_Result($result,$i,0);
> copy ("$file_dir/$images",$ftupload);
> echo ( $images);
> echo ( $ftupload);
> echo ("<IMG SCR= $ftupload>");
> }
>
> ?>
> <BODY BGCOLOR="#FFFFFF">
> <FORM action="<? print $PHP_SELF?>" method="post"
> enctype="multipart/form-data">
> <!-- <INPUT TYPE="hidden" name="MAX_FILE_SIZE"
> VALUE="51200"> -->
> <INPUT TYPE="hidden" NAME="$fupload_name" VALUE="<? echo
> $fupload_name ?>">
> <INPUT TYPE=file name="fupload" VALUE=""><BR>
> <INPUT TYPE="submit" NAME="submit" VALUE="Send File to Web
> Server">
> </FORM>
> <A HREF="index.php" CLASS="content">Home page</A>
> </BODY>
> </HTML>
>
>
> -thanks
> --
> The secret of the universe is @*&í!'ñ^#+ NO CARRIER
> __ _ _ _ _
> |_|_||_||_||\/||_|| \
> _|| || || \| || ||_/
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net