Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 344
  • Last Modified:

Show default image if database is null

I have a product website where my client uploads details ie name, image etc.

If no image is uploaded (which means no filepath entry in the 'image' column of the database) I want to display a generic 'No image available' image. How would I do this?

Here's the code which displays the image...

<a href="detail.php?id=<?php echo $row_product['id']; ?>"><img src="uploads/thumb_<?php echo $row_product['image']; ?>" alt="" border="0" /></a>

Open in new window

0
BrighteyesDesign
Asked:
BrighteyesDesign
1 Solution
 
gr8gonzoConsultantCommented:
<a href="detail.php?id=<?php echo $row_product['id']; ?>"><?php
if($row_product['image'])
{
  echo '<img src="uploads/thumb_' . $row_product['image'] . '" alt="" border="0" />';
}
else
{
  echo '<img src="http://thegarageblog.com/garage/wp-content/uploads/noimageavailable.jpg" alt="" border="0" />';
}
?></a>

Just replace http://thegarageblog.com/garage/wp-content/uploads/noimageavailable.jpg with the correct URL to your own "no image available" image.
0
 
TobiasCommented:
Dear,

Something like that :

<?php
if (empty($row_product['image'])) 
{
?>
<a href="detail.php?id=<?php echo $row_product['id']; ?>"><img src="uploads/thumb_<?php echo $row_product['image']; ?>" alt="" border="0" /></a>
<?php
}
else
	{
	print "No image available";
	}
?>

Open in new window


Regards
0
 
BrighteyesDesignAuthor Commented:
Perfect, thanks!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now