Ignore echo function if database cell is empty (MySQL/PHP)

I am using Bootstrap cards with MySQL/PHP to echo data from a database/ table.

I have a column in the database "Favourite", this field is either empty or contains a path to an image.

If the corresponding database field is empty for a particular record, I would like to echo nothing. Right now, it is echoing a broken icon (probably because I'm using the img tag?).

Here is the first part of the code:

<?php
            include_once("conn.php");
            $sql = "SELECT * FROM table ORDER BY id ASC";
            $result = mysqli_query($conn, $sql);
            if(mysqli_num_rows($result) > 0)
            {
                while($row = mysqli_fetch_array($result))
                {
            ?>

Here is the echo function;

<img alt="Favourite" title="Favourite" src="http://localhost/Test/Images/Icons/<?php echo $row["Favourite"]; ?>" width="12.5%" height="12.5%"/>

I'm an amateur.. so would ideally like to make the solution as simple as possible.

Thanks in advance!

<?php if(!empty($row["Favourite"])) { ?>
    <img alt="Favourite" title="Favourite" src="http://localhost/Test/Images/Icons/<?php echo $row["Favourite"]; ?>" width="12.5%" height="12.5%"/>
<?php } ?>

More on empty function: https://www.php.net/manual/en/function.empty.php

Ignore echo function if database cell is empty (MySQL/PHP)

Related

Recent Posts