Inserting php if statement within php code?

Question

I have a php script that is basically querying my database and providing details about each store, and including an image. The code pulls in the image fine, but currently if no image exists in the database, I have spacer image being inserted instead. Instead of using a spacer image though, is there a way for me to use a PHP 'if' statement inside of the php code to not render an image if the database has no image listed? Here is the basic query code:

<?php   
   if(strlen($query) >= $min_length){$query = htmlspecialchars($query); 
   $query = mysql_real_escape_string($query); 
   $raw_results = mysql_query("SELECT * FROM stores WHERE `TRAVEL` = '1' AND `STATE` = '$query'") or die(mysql_error());                                  
   if(mysql_num_rows($raw_results) > 0){
   while($results = mysql_fetch_array($raw_results)){

   echo "<table width='150' border='3'>
   <tbody><tr>
   <td>".$results['NAME']."<br>
   <img  align='left' src='images/images/".$results['IMAGE']."'> 
   </td>
   </tr></tbody>
   </table>";            
   }          
   }    else{ echo "No results were found";

   }           
   }    else{ echo " ".$min_length; }
?>

For the php if statement, I was thinking something along these lines:

<?php if ($results['IMAGE'] != '') {  ?>
<img src='images/icons/".$results['IMAGE']."' height="100" width="auto">
<?php }?>

Please stop using mysql functions - read here stackoverflow.com/q/12859942/5006692 — frankle
– frankle, Commented Mar 30, 2016 at 15:47

Mulan · Accepted Answer · 2022-01-24 15:34:23Z

2

You're pretty close. Just use one more <?php ... ?> block in the img

<?php if ($results['IMAGE'] != '') {  ?>
  <img src='images/icons/<?php echo $results['IMAGE'] ?>' height="100" width="auto">
<?php }?>

You can use the alternative control flow syntax too. It reads a little nicer than spanning the { and } across multiple <?php tags

<?php if ($results['IMAGE'] != ''):  ?>
  <img src='images/icons/<?php echo $results['IMAGE'] ?>' height="100" width="auto">
<?php endif ?>

Shameless plug:

Generating HTML with PHP gets really ugly. At least in my opinion. To make the job a little nicer/easier, I made htmlgen, mirrored on packagist.

edited Jan 24, 2022 at 15:34

answered Mar 30, 2016 at 15:30

Mulan

136k35 gold badges240 silver badges276 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

honerlawd Over a year ago

heredoc syntax works "okay" as well for generating HTML if you don't want to include another library.

user5472010 Over a year ago

Thanks, but it does not seem to be working. Do I need to wrap the <?php if... ?> in quotes, or modify it since it is inside of the other php code?

KubiRoazhon · Accepted Answer · 2016-03-30 15:31:55Z

1

Simply like this :

if(isset($results['IMAGE'])){

  echo "<table width='150' border='3'>
  <tbody><tr>
  <td>".$results['NAME']."<br>
  <img  align='left' src='images/images/".$results['IMAGE']."'>
 </td>";

}

answered Mar 30, 2016 at 15:31

KubiRoazhon

1,8393 gold badges25 silver badges53 bronze badges

1 Comment

user5472010 Over a year ago

Wouldn't this however not post the table if an image is non-existent, I actually want to keep the table even if the image is not in the table.

Collectives™ on Stack Overflow

Inserting php if statement within php code?

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related