default image

chrisefenn

I'm completely new to php and am building a catalogue for a company online.

I have alot of images but where no image is available I'd like the code to pick up a default image and display that instead of the default broken image link with a red cross. I've tried the following code

which doesn't work.

If anyone has any ideas on how to do this in php or in the MySQL database I really would appreciate the help!

swallace

Hi, try this:

chrisefenn

Thanks for the advice Swallace, however I couldn't get this going.

The client has created the database and the image values have all been entered, so the DB is returning a value to the image field. Could this be the reason why the NULL query isn't working?

If so have you any tips on how to get around this so that when the database returns a value the php can determine true/false and throw up the image or the default image maybe.

Any tips well appreciated!

swallace

What is stored in the db if there is no image? If something is always stored, then the if statement of ==NULL will not work.

Can you give a little more detail on what is stored in the db? 🙂

chrisefenn

Thanks for the reply!

What I've got in the MySQL DB is the path to an image eg"../images/2612.jpg" in the column 'image'. A lot of images are missing so I'm getting nasty red crosses in boxes and would like to replace them with a default "image unavailable" type jpg.

Its a massive catalogue and the client has entered all the data including image paths.

If there is a workaround (to return true and false values from the image maybe) it would make the whole thing a lot simpler to implement.

If not looks like a long job on the DB!

swallace

Well, there are probably neater ways to do this but :rolleyes:

$size = @getimagesize("imageName.gif");

echo("size = $size<BR>");

if( empty($size))
echo "change image around";
else
echo "use image";

This will see if the image has a size...if it doesn't exist, swap the image with the default, else keep it there.

This works, but it's not the prettiest...

chrisefenn

Thanks for this Swallace!

Sorry if this is a dumb question but as I'm a php newbie is this how I'd set this up?

<img src="<?php $size = @getimagesize("images/default.jpg");

echo("size = $size<BR>");

if( empty($size))
echo "change image around";
else
echo "use image"; ?> ">

Thanks again

r3n

Looks right to me 🙂

swallace

Sorry chrisefenn, my dinner was calling me and I never had time to write out a 'proper' solution for you...

<?php
$size = @getimagesize("$row_rsCaroli[image]");

if(empty($size))
$image = "Images/other.gif";
else
$image = "$row_rsCaroli[image]";

good luck
🙂

chrisefenn

Hi Swallace

Thanks so much for all the help with this, I'm still having problems though.

I've put the following code into the page and it pulls up default.gif for every image (some of them have jpegs linked to the 'image' info and the others don't).

<?php
$size = @getimagesize("$row_rsCaroli['image']");

	if(empty($size))
	$image = "images/default.gif";

	else
	$image = "$row_rsCaroli['image']"; 

	?>

<IMG SRC="<?php echo "$image"?>" border="1">

Do you reckon it might be past to just update the whole database and use the NULL code you posted earlier.

Would really appreciate your views on this!

swallace

Right, I'm starting to want this to work as much as you do now 😉

Have you tried using a 'hardcoded' image to test it out?e.g not use ("$row_rsCaroli['image']");

Try using something that is there for sure as a test.

In your table, the column heading is called 'image'? How many rows/images do you have?

chrisefenn

Hi Swallace

thanks for getting back on this,

I've tried a hardcoded image "images/2161.jpg" (is this OK), this seems to work picking up 2161.jpg in all pic boxes.

But when I replace it with the original code its as you were & the default image is repeated instead of picking up the image info from the DB.

The table has a repeat region behavior (i'm using dreamweaver mx) on the image column.

swallace

What is the output from the table?

e.g.
echo ("Image is = $row_rsCaroli['image']");

Does it include the full image path? Or just the image name?

chrisefenn

Sorry about the sporadic replies, I'm trying to fit this one in around the dayjob!

the table output is

in internet explorer

netizen

This is under the assumption that the image index in your database has the full path to the image location.


<?php

if(is_file($row_rsCaroli['image']))
    $displayImage = $row_rsCaroli['image'];
else
    $displayImage = "images/2161.jpg";
?>

<IMG SRC="<?php echo "$displayImage"?>" border="1">

If the items are stored as binary, then you will have to do it differently than this. My guess however is that you just need to check the path.

swallace

Sorry chrisefenn, I meant what is stored in your db table? Is the full image path there? Because if not, we have found the problem ...