Please help - PHP/Apache issue

[John C]

Hello all,
First off thanks for reading this...

The following code works fine on my redhat linux box at home, however
it does not work when running on my webhost, whose server is also
apache.
I realize that they have some aspects of the server disabled for
security, but
after looking at my code, their representative said it should work
fine.

The idea of the code is to upload images from the client, store them
as strings in the mysql db then return them upon request.
As I mentioned, this works fine at home (with no restrictions from my
apache)
but will not work on my hosts server.
The images render fine at home, but they do not display when running
from hostica host.

What could I be overlooking?

thanks, the code is below...

===============================================
Here is the storing logic:
($eflag is the picture data)

$ffile = fopen($_FILES['form_data']['tmp_name'],"rb");
$contents = fread($ffile,$_FILES['form_data']['size']);
$eflag = mysql_escape_string($contents);
$sql = "INSERT INTO items(itemId, itemName, itemDesc, itemPrice,
item_key_words, photo_data)" ."VALUES
('','$name','$form_description','$price','$keyword s','$eflag') ";
===============================================
Here is the retrieval logic:

header("Content-type: image/jpg");

$sql = "SELECT photo_data FROM items WHERE itemId ='$dns'";
$result = mysql_query($sql);
$nrows = mysql_num_rows($result);

if($nrows == 1) {
$row = mysql_fetch_array($result);
echo $row['photo_data'];
}
===============================================

[Justin Koivisto]

John C wrote:

The following code works fine on my redhat linux box at home, however
it does not work when running on my webhost, whose server is also
apache.

<snip>

Here is the storing logic:
($eflag is the picture data)

$ffile = fopen($_FILES['form_data']['tmp_name'],"rb");
$contents = fread($ffile,$_FILES['form_data']['size']);
$eflag = mysql_escape_string($contents);
$sql = "INSERT INTO items(itemId, itemName, itemDesc, itemPrice,
item_key_words, photo_data)" ."VALUES
('','$name','$form_description','$price','$key words','$eflag') ";
============================================== =
Here is the retrieval logic:

header("Content-type: image/jpg");

$sql = "SELECT photo_data FROM items WHERE itemId ='$dns'";
$result = mysql_query($sql);
$nrows = mysql_num_rows($result);

if($nrows == 1) {
$row = mysql_fetch_array($result);
echo $row['photo_data'];
}

The problem may be the field type for photo_data. When I *used* to use
mysql for storing binary images, I found that some images would cut off
and/or not render unless I was using the LONGBLOB field type.

Since then, I've wised up and stored the file names in the database and
the files in a directory. ;)

--
Justin Koivisto - sp**@koivi.com
PHP POSTERS: Please use comp.lang.php for PHP related questions,
alt.php* groups are not recommended.

[Justin Koivisto]

Justin Koivisto wrote:

John C wrote:

The following code works fine on my redhat linux box at home, however
it does not work when running on my webhost, whose server is also
apache.

<snip>

> Here is the storing logic:
> ($eflag is the picture data)
>
> $ffile = fopen($_FILES['form_data']['tmp_name'],"rb");
> $contents = fread($ffile,$_FILES['form_data']['size']);
> $eflag = mysql_escape_string($contents);
> $sql = "INSERT INTO items(itemId, itemName, itemDesc, itemPrice,
> item_key_words, photo_data)" ."VALUES
> ('','$name','$form_description','$price','$keyword s','$eflag') ";
> ===============================================
> Here is the retrieval logic:
>
> header("Content-type: image/jpg");
>
> $sql = "SELECT photo_data FROM items WHERE itemId ='$dns'";
>
>
> $result = mysql_query($sql);
> $nrows = mysql_num_rows($result);
>
> if($nrows == 1) {
> $row = mysql_fetch_array($result);
> echo $row['photo_data'];
> }

The problem may be the field type for photo_data. When I *used* to use
mysql for storing binary images, I found that some images would cut off
and/or not render unless I was using the LONGBLOB field type.

Since then, I've wised up and stored the file names in the database and
the files in a directory. ;)

One other thing that I seem to remember... you may want to check the
settings for magic_quotes_gpc and magic_quotes_runtime on both servers
to see if you are using equal systems...

--
Justin Koivisto - sp**@koivi.com
PHP POSTERS: Please use comp.lang.php for PHP related questions,
alt.php* groups are not recommended.