?
Solved

Show default image if database is null

Posted on 2012-03-27
3
Medium Priority
?
346 Views
Last Modified: 2012-03-27
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
Comment
Question by:BrighteyesDesign
3 Comments
 
LVL 36

Accepted Solution

by:
gr8gonzo earned 2000 total points
ID: 37771398
<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
 
LVL 10

Expert Comment

by:Tobias
ID: 37771402
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
 

Author Closing Comment

by:BrighteyesDesign
ID: 37771553
Perfect, thanks!
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In this article, we’ll look at how to deploy ProxySQL.
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
The viewer will learn how to count occurrences of each item in an array.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question