upload jpg into mysql then display jpg on browser

micaencephalon

ok. I have searched and searched. I need help getting a picture uploaded and stored in a mysql db and then query it and display the pic as a jpeg in a browser. I have been able to upload and run through everything but when I try and display the jpeg again from the db it comes out with binary garbage. I will include my scripts below. I got this script off of phpbuilder code library. I have found some syntax errors and corrected them but I can't get the jpeg to come out on a browser correctly. Please help!!!!!!! I think its the way that the picture is being uploaded to mysql and then dumped back down but I can't get my finger on it. The db field is a mediumblob and the field does report the correct size for the image when I upload it. Could it be something to do with "\" escapes?

--------------comm.inc -----------------------------------
<?
function connectdb(){
mysql_connect("localhost","user","password") or die(mysql_error());
mysql_select_db("db") or die(mysql_error());
}

---------------------index.php------------------------------
<?

if (!isset($submit)) {

?>

<?
// tests to see if addslashes() is needed. 0 is needed 1 is not
echo ("addslashes status");
echo get_magic_quotes_gpc(); ?>
<form method="POST" action="" enctype=multipart/form-data>

<table>

<tr><td>Type</td><td><select name="imgtype"><option value="image/gif">GIF</option><option

value="image/jpeg">JPEG</option></select></td></tr>

<tr><td>File</td><td><input type="file" name="imgfile"></td></tr>

<tr><td></td><td><input type="submit" name="submit" value="upload"><input type="reset" value="reset"></td></tr>

</table>

</form>

<?

} else {

include "comm.inc";
connectdb();
$hndl=fopen($imgfile,"rb");

$imgdata='';
while(!feof($hndl)){
$imgdata.=fread($hndl, 2048);

}

    $imgdata=addslashes($imgdata);
   $sql = "INSERT INTO tblimage VALUES(NULL,'". $imgtype ."','".$imgdata."')";  

    @mysql_query($sql) or die(mysql_error());  

    fclose($hndl);  

    echo "<a href=\"view.php\">view image</a>";

};
?>
--------------post.php--------------------------

<?
include "comm.inc";
connectdb();

$sql = "SELECT * FROM tblimage WHERE imgid=". $imgid;

$result = @($sql) or exit("QUERY FAILED!");

$row=mysql_fetch_object($result);

$contenttype = @mysql_result($result,0,"imgtype");

$image = @mysql_result($result,0,"imgdata");

header("Content-type: $row->imgtype");

echo $row->imgdata;

?>

---------------view.php------------------------
<?

include "comm.inc";
connectdb();
$sql = "SELECT imgid,imgtype, imgdata FROM tblimage ORDER BY imgid";

$result = @($sql) or die(mysql_error());

echo "<table border=1>n";

echo "<tr><th>imgid</th><th>imgtype</th><th>imgdata</th></tr>n";

while ($rs=mysql_fetch_array($result)) {

echo "<tr><td>".$rs[0]."</td>";

echo "<td>".$rs[1]."</td>";

$stripped = stripslashes($rs[2]);
echo "<td><img src=\"post.php?imgid=".$stripped."\" width=100 height=100></td></tr>n";

};

echo "</table>n";

?>

MrPixel

You need to use the GD library functions in post.php.

micaencephalon

MrPixel your a lifesaver. Could you elaborate more on how to use the GD Library? I followed your link to php.net but I didn't see much help there.

I did a page with this code:
<?php
var_dump(gd_info());
?>

I got this response
array(11) { ["GD Version"]=> string(27) "bundled (2.0.23 compatible)" ["FreeType Support"]=> bool(true) ["FreeType Linkage"]=> string(13) "with freetype" ["T1Lib Support"]=> bool(false) ["GIF Read Support"]=> bool(true) ["GIF Create Support"]=> bool(false) ["JPG Support"]=> bool(true) ["PNG Support"]=> bool(true) ["WBMP Support"]=> bool(true) ["XBM Support"]=> bool(true) ["JIS-mapped Japanese Font Support"]=> bool(false) }

I just need to know what the code is that I need to include in post.php in order for this to work. AGAIN THANKS!!!!!!!!!!!!!!!!!!

MrPixel

You might be interested in a couple of tutorials, then ...

http://www.devarticles.com/c/a/PHP/Generating-Images-on-the-Fly-With-PHP/
http://www.phpfreaks.com/tutorials/105/0.php

Those were found with this search.

suepahfly

For simple storing / retrieving images from a databse you don't need GD at all.

Here's some sample code

<?php
mysql_connect('localhost','root','1') or die('unable to connect'); 
mysql_select_db('test') or die('no databse selected');


if(isset($_GET['store']))
{
	$image = base64_encode(file_get_contents("image.jpg")); //Also could be uploaded pic, then you need t get the content-type aswell
	$sql = 'INSERT INTO `table` ( `image` ) VALUES (\''.$image.'\')';
	mysql_query($sql) or die(mysql_error() . "<br>". $sql);
	echo "image stored";
}
else
{
	$result = mysql_query("SELECT image FROM `table`") or die(mysql_error());
	list($image) = mysql_fetch_row($result);
	header("Content-type: image/jpeg");
	echo base64_decode($image);
}
?>

Remeber that the 'image' field in the 'test' table is defined as a 'long_blob'. You could also use gzcompress /gzuncompress to save table space

zeb

I may be missing something here, but as it is now, there are some syntax errors in your code for post.php and view.php.

First of all, you don't need to select the imgdata in view.php, because post.php does that. Secondly, shouldn't you pass the imgid to the post.php page instead of the large $stripped data? The SELECT statement in the post.php page is trying to select everything from the tblimage where the imgid is equal to the passed $stripped string. That should return nothing.

Maybe something got mixed up when you posted the code here... if so, you can just ignore my comments.

micaencephalon

Found the answer to my prayers:
http://www.phpbuilder.com/columns/florian19991014.php3
This worked great. The only thing is make sure you use char not varchar for the field params. Char handles the field differently and I learned this the hard way. I have even added more fields so that I can have more then one picture at a time. Jpeg's and PNG's work with this. If someone was feeling spunky they could post a suggestion on how to retrieve all the pic's and display them using getdata.php if the db is storing multiple pictures.

And thanks to everyone who posted suggestions!