Going Loony!!!!!

Antithesis

I DESPERATELY need assistance here!!!

Ok. From all of the searching of these threads and Googling on the subject, I have found out how to retrieve an image stored as BLOB in MySQL and display it in a web browser as a picture by itself...

... but HOW on EARTH do I incorporate that picture in with a freaking web page????? Say if I have a picture stored in the DB, and I want to display that picture with some text info, then display another picture with some text info... etc etc, the output as a .php file. I can retrieve and display with the output as a .JPG file but I want the picture to display in a normal every day web page!!! PLEASE HELP ME!!!!!

tekky

write a php script to display the image by itself (which I believe you have done already) then do this...

<img src=yourimgdispalyscript.php?img=yourimagetodisplay>

complicated right? 😃

(took me a bit to figure it out too when I started playing with that kinda stuff too 🙂

Antithesis

WHEW!!! Thanks a LOT!!! That's such a simple concept though I would have probably not thought of it by myself at this point. I really appreciate the help... I will try it out in a bit and let you know how it works out.

Antithesis

You just don't know how frustrated all this can make me sometimes...

I'm building my mom a site so she can sell her craft stuff online. Anyway, after that last piece of advice you gave me, everything was working beautifully (or so I thought)...

Now this does NOT make any sense to me at all. As I was writing the scripts and everything, I was using Mozilla to preview it all. Everything was working peachy. I had a preview version ready to show my mom, so we hooked up via VNC and voila! No pictures displaying on her side using Mozilla OR Internet Explorer.

Upon a little investigation, I noticed that IE was not loading the site properly on my site, but Mozilla would. So I figured if I could get IE to show right on my side, it should work fine on hers.

Now here's the problem...

that snippet of code you gave me above will work for me in an HTML file but not in a PHP file. I need it to work in a PHP file! Is there something wrong with using that snippet above in a PHP file? Can it be modified to work properly?

Now don't ask me why, but this all works PERFECTLY FINE in Mozilla ON MY SIDE... my mom has the same ver of Mozilla and the pictures wouldn't show on her side, nor using Internet explorer.

AAAAAAAARRRRRRRRGGGGGGGGHHHHHHH!!!!!!

Why is it always these INEXPLICABLE things that happen to me??? You guys don't know how appreciative I would be with any advice / help!

Thanks!
Antithesis

ultraslacker

Compare the php generated html code with the html page that works in both mozilla and ie, look for header tags.

tekky

Various methods this will work in a PHP file

<?
//code here
?>
<img src=yourimgdispalyscript.php?img=yourimagetodisplay>
<?
//more code here
?>

<?
//code here
echo "<img src='yourimgdispalyscript.php?img=yourimagetodisplay'>";
//more code to follow
?>

Antithesis

But the thing is it's NOT working!!!

The problem must be with my .php script that gets the picture. PLEASE help! I am SO losing my marbles over this. I am still a newbie to PHP but I love the feeling once I've solved these problems, especially with help from others. I am pasting that script here. This script is called thumbnail.php, and is used in another PHP script as follows:

echo "<img src='thumbnail.php?id=3'>";

THUMBNAIL.PHP:
<?php

// getdata.php3 - by Florian Dittmer <dittmer@gmx.net>
// Example php script to demonstrate the direct passing of binary data
// to the user. More infos at http://www.phpbuilder.com
// Syntax: getdata.php3?id=<id>

if($id) {

// you may have to modify login information for your database server:
@MYSQL_CONNECT("omitted");

@mysql_select_db("omitted");

$query = "select tbin_data,tfiletype from binary_data where id=$id";
$result = @MYSQL_QUERY($query);

$data = @MYSQL_RESULT($result,0,"tbin_data");
$type = @MYSQL_RESULT($result,0,"tfiletype");

Header( "Content-type: $type");
echo $data;

};
?>

tekky

THUMBNAIL.PHP:

<?php

// getdata.php3 - by Florian Dittmer <dittmer@gmx.net>
// Example php script to demonstrate the direct passing of binary data
// to the user. More infos at [url]http://www.phpbuilder.com[/url]
// Syntax: getdata.php3?id=<id>

$id = $_GET['id'];
if($id) {

// you may have to modify login information for your database server:
@MYSQL_CONNECT("omitted");

@mysql_select_db("omitted");

$query = "select tbin_data,tfiletype from binary_data where id=$id";
$result = @MYSQL_QUERY($query);

$data = @MYSQL_RESULT($result,0,"tbin_data");
$type = @MYSQL_RESULT($result,0,"tfiletype");

Header( "Content-type: $type");
echo $data;

};
?>

dont rely on REGISTER_GLOBALS being enabled, assign $id from the $_GET superglobal array and everything should work fine 😉

Antithesis

That did not fix it. I think maybe I have not explained myself clearly. Often times when I post here my thinking is so cluttered that it should be easy to explain myself incoherently. And I also keep from using correct PHP terminology because of my ignorance on it.

Ok, I'll try to explain a bit differently...

... let's say I type the following line into the URL bar:

http://www.myserver.com/myfolder.com/thumbnail.php?id=3

The script has always functioned properly just like that.

What that particular script does as I'm sure you can tell by the name is loads only the thumbnail image from a MySQL database. I need to be able to display all the thumbnails in the database on a 'main' php page. These thumbnails are for various products for sell and include description, cost, etc displayed next to them.

Anyway, as I said above, if you type the url of the script it works correctly. However, if I incorporate this:

into the 'main' php page, it will not display the thumbnails properly. Weird thing is that it WILL display them if the above line is in an HTML page with no PHP on it. I need it in PHP though!

Am I making myself any clearer? I think I am not communicating very well here sometimes. Oh well 🙂

I appreciate the help you've given me so far and desperately look forward to any other help you may have to offer. I really don't want to have to store just the URLS for the files in the db, then the pictures in a folder... i'd much rather store the binary file in the DB if possible, and I know it is, just gotta figure out how to get the 'main' script worked out!

Thanks!
Antithesis

Antithesis

Hmmmm... strange something here that may trigger something for you...

In IE, the images show up as little red x's as broken images do... however, if I right-click the red x and say 'Show Picture', the picture loads!?! What in the world? Images load on all other sites using IE (at least all I've come across though I mainly use Mozilla for browsing)... but I know it's not just mine, I've seen this not work on 2 different pc's with IE. Really strange thing is it displays properly on MY machine with Mozilla, but not IE... and on ANOTHER machine it will not display with either.

I hope this may help give you a clue and not confusion... because I sure know I'm confused! 🙂

Thanks again,
Antithesis

tekky

could be the php script taking too long to send the image to the browser? dunno.... and so it skips it and moves on... then the show image loads it because it just pulls the cached info from the server that the browser skipped?

crazy idea... could be wrong... though 🙂

chriskl

Are you actually sending the content-type in the script that generates the picture?

eg:

header('Content-type: image/jpeg');

Chris

Antithesis

Yep.

FoTo50

Creating images via PHP gave me also quite some sleepless nights and let me say words I better dont repeat here ... 😉

Failing loading images sometimes even can result out of a warning in the thumbnail script that makes the header sent after it unusable ... :mad:

During developing it helped me a lot to include a special error reporting script to the thumbnail to find out, where the problem is located. Let me paste this script here for you in hope it might help to locate the problem:

<?
define(FATAL,E_USER_ERROR);
define(ERROR,E_USER_WARNING);
define(WARNING,E_USER_NOTICE); // set the error reporting level for this script
error_reporting(FATAL + ERROR + WARNING); // error handler function
function myErrorHandler ($errno, $errstr) {
switch ($errno) {
case FATAL:
echo "FATAL [$errno] $errstr \n";
echo " Fatal error in line ".LINE." of file ".FILE;
echo ", PHP ".PHP_VERSION." (".PHP_OS.") \n";
echo "Aborting... \n";
exit -1;
break;
case ERROR:
echo "ERROR [$errno] $errstr \n";
break;
case WARNING:
echo "WARNING [$errno] $errstr \n";
break;
default:
echo "Unkown error type: [$errno] $errstr \n";
break;
}
} // function to test the error handling
function scale_by_log ($vect, $scale) {
if ( !is_numeric($scale) || $scale <= 0 )
trigger_error("log(x) for x <= 0 is undefined, you used: scale = $scale",
FATAL);
if (!is_array($vect)) {
trigger_error("Incorrect input vector, array of values expected", ERROR);
return null;
}
for ($i=0; $i<count($vect); $i++) {
if (!is_numeric($vect[$i]))
trigger_error("Value at position $i is not a number, using 0 (zero)",
WARNING);
$temp[$i] = log($scale) * $vect[$i];
}
return $temp;
} // set to the user defined error handler

$old_error_handler = set_error_handler("myErrorHandler"); // trigger some errors, first define a mixed array with a non-numeric item
?>

I usually save it somewhere and include() it at the first line of the thumbnail.php and when calling the thumbnail script directly in the browser (rather than displying it with <img src=... >) I get (most of time) some useful error lines to know where to continue.