Struggling with images...

[dynamic_desi]

Hi,

After trying the header thing which looks like this
[<?php

if(isset($GET['id']))
{
$id=$GET['id'];
$connection = mysql_connect('localhost', 'root', 'passwordl');
$dbselect = mysql_select_db('images');

$query = "select bin_data, filetype from binary_data where id=$id";
$result = mysql_query($query);

$data = mysql_result($result, 0, "bin_data");
$type = mysql_result($result, 0, "filetype");

header("content-type: $type");
echo $data;
}
?>

]

However if i use the same as a module in this script....it displays junk... Crying or Very sad

[function showItems($subcatid)
{
if (!$subcatid || $subcatid=='')
return false;

$query = "select * from items where subcatid = '$subcatid'";
$result = mysql_query($query) or die('Error, query failed');
//$row = mysql_fetch_array($result);
$connection = mysql_connect('localhost', 'root', 'password');
$dbselect = mysql_select_db('images');

$query = "select bin_data, filetype from binary_data where id=8";
$result = mysql_query($query);

$data = mysql_result($result, 0, "bin_data");
$type = mysql_result($result, 0, "filetype");

//header("content-type: $type");
//echo $data;

?>
<table border="0" cellspacing="1" cellpadding="1">
<?
while ($row = mysql_fetch_array($result))
{
extract($row)
?>
<tr>
<td width="100" height="120" align="center"><?php header("content-type: $type"); echo $data;
?>
<br><?php echo $row[1]; ?></td>
<td width="430"><?php echo $row[4]; ?><br>$<?php echo $row[2]; ?></td>
</tr>
<?
}
?>
</table>
<?
}]

I wonder what am i doing wrong.....any help will be a great favor....

thanks

dynamic desi

[drew010]

you have no choice but to keep that image script as its own file. when you try to do it inside a regular php script outputtingh html its going to show the html and then the binary data of an image. you cant use html, then change the content type and output binary, you have to call the image via <img> tags.
simply use <img src="script.php?id=xxx"> and it will display the image as if it were an actual file on the system.

[dynamic_desi]

Hi,

I've thought about it. But it won't work properly if i want to display my images in a picture gallery as thumbnails.

Is there some way to store the images from mysql to a folder and then use the path to that folder in the <img src="path" >

or i would like to upload the image directly to the folder using an upload script and store the path to that file in mysql. In the image gallery if i want to display that image, will i be able to do it if i use the path stored in mysql that points to the image stored in the folder????

if that is possible....are there going to be permissions and ownership issues??

please help

dynamic_desi

[drew010]

yes its possible to store images in a folder and keep the path in mysql for retrieval later.
permissions most likely wont be a problem in this case. you can either implement an upload for or its possible to make a small script to take the binary image data from mysql and save it to a file locally.

[dynamic_desi]

Hi,

I think it will be a mess if i try and display binary data to HTML webpage. Now instead of uploading the image to mysql, i am trying to upload it to a folder and i save the path to that uploaded file on the server.

The upload part works fine, plus the query saves the path to the server too. But it has some troubles retreving the image. Seems like i am not saving the path in a right format on the mysql server. I've defined the pathname coloumn as"VARCHAR".

Is that correct??? If not what would be the best way to do it??

[$doc_directory = "/var/www/html/";
$my_file ="images/".$fileName;
1
$copy_path = $doc_directory.$my_file;

if(!copy($tempName, $copy_path))
{
echo "file upload failed";
}

else{ echo"file uploaded at $fileName";}

$query = "insert into product (itemName, itemPrice, subcatid, imagepath, description)".
"values ('$itemName', '$itemPrice', '$subcatid', '$fileName', '$itemdesc')";
]

That is my upload query.

And here's my retrive query

[$query = "select * from product where subcatid = '$subcatid'";
$result = mysql_query($query) or die('Error, query failed');
//$row = mysql_fetch_array($result);

?>
<table border="0" cellspacing="1" cellpadding="1">
<?
while ($row = mysql_fetch_row($result))
{
extract($row)
echo $row[5];
?>
<tr>
<td width="150" height="120" align="center"><?php echo '<img src="/images/$row[5]" width="150" height="150" >'; ]

Please Help!!

This time i've tried using the PHP tags from the menu, i hope it works...lol

dynamic_desi