php while loop database data

Question

the below while loop statement loops mysqli query result(text and image from database). A row can contain text only or image and text. I'm trying to display text only if the image field is empty and display both image and text when they both exist in a row. However, i tried using the if statement in the while loop statement below, the problem is that when it suppose to display only text,it displays text with image tag with no src value,kindly help fix this. Thanks.

while($row = mysqli_fetch_assoc($query)){
    $id = $row["id"];
    $text = $row["texts"];
    $image =$row['images']; 
    if(!empty($text) && !empty($image)){
        echo '<img src='.$image.'/>';
        echo '<div>'.$text.'</div>';
    }elseif( !empty($text) && empty($image) ){
        echo '<div>'.$text.'</div>';
    }
}

We cannot help here, since we do not know the data you are working with. — arkascha
– arkascha, Commented May 9, 2017 at 21:14
If this is echo'ing the <img> tag, $image is not empty. If you var_dump($image); what does it say for those cases where it's now echo'ing an empty <img> tag? — rickdenhaan
– rickdenhaan, Commented May 9, 2017 at 21:17

Barmar · Accepted Answer · 2017-05-09 21:45:54Z

0

$row['images'] might contain spaces, try trimming it. Also, you can simplify the if:

while($row = mysqli_fetch_assoc($query)){
    $id = $row["id"];
    $text = trim($row["texts"]);
    $image = trim($row['images']); 
    if(!empty($image)){
        echo '<img src='.$image.'/>';
    }
    if(!empty($text)){
        echo '<div>'.$text.'</div>';
    }
}

answered May 9, 2017 at 21:45

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

Comments

Amir Helmy · Accepted Answer · 2017-05-09 21:48:34Z

0

while($row = mysqli_fetch_assoc($query)){
   $id = $row["id"];
   $text = $row["texts"];
   $image =$row['images']; 

   if($image)
      echo "<img src='{$image}' />";
   if($text)
      echo "<div>{$text}</div>";

}

answered May 9, 2017 at 21:48

Amir Helmy

1192 silver badges3 bronze badges

Collectives™ on Stack Overflow

php while loop database data

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related