PHP-如果数据库字段为空，如何删除逗号或图像 - PHP - How to remove comma or image if database field is empty

PHP - How to remove comma or image if database field is empty

我正试图找出如何从中删除逗号，比如['address_2']字段，如果此字段为空，并且如果未输入，则不显示['tel']电话号码的图标，在回声中工作似乎很困难。

          $numrows = mysql_num_rows($query);
                if ($numrows > 0){
                    while ($row = mysql_fetch_assoc($query)) {
                        echo "<div class='result-container'>
                                  <div class='result-wrap'>
                                        <div class='leftbox'> 
                                            <div class='titlebox'>
                                                <h2>" . $row['company_name'] . "</h2>
                                                <p><strong>" . $row['company_services'] . "</strong></p>
                                            </div>
                                            <div class='box'><strong> Address: </strong>" . $row['address_1'] . ",&nbsp" . $row['address_2'] . ",&nbsp" . $row['town'] . ",&nbsp" . $row['county'] . ",&nbsp" . $row['postcode'] . "</div>
                                            <div class='box'><strong> Telephone: </strong>" . $row['tel'] ."<strong> Mobile: </strong>". $row['mob'] . "</div>
                                                <div class='iconbox'>
                                                    <a href='" . $row['tel'] . "'><img src='img/icons/phone.png' class='hvr-push'></a>
                                                    <a href='" . $row['mob'] . "'><img src='img/icons/mobile.png' class='hvr-push'></a>
                                                    <a href='mailto:" . $row['email'] . "'><img src='img/icons/email.png' class='hvr-push'></a>
                                                    <a href='" . $row['web_url'] . "'><img src='img/icons/web.png' class='hvr-push'></a>
                                                </div>
                                            <div class='buttonwrap'><div class='buttonbox'><p>View Profile</p></div></div>          
                                        </div> 
                                        <div class='rightbox'>
                                        <div class='service-pic'>
                                                <img src='img/image1.png'>
                                            </div>
                                            <div class='mapbox'>
                                                " . $row['gmap_url'] . "
                                            </div>

                                       </div>
                        </div>
                        <br/>"; 
                    }
                }

    $numrows = mysql_num_rows($query);
                if ($numrows > 0){
                    while ($row = mysql_fetch_assoc($query)) {
                        ?>
<div class='result-container'>
<div class='result-wrap'>
<div class='leftbox'> 
<div class='titlebox'>
                                                
<h2><?=$row['company_name']?></h2>
                                                
<p><strong><?=$row['company_services']?></strong></p>
</div>
                                            <div class='box'><strong> Address: </strong><?=$row['address_1']?>,
    <?php
    if(!empty($row['address_2'])){
    ?>
    &nbsp <?=$row['address_2']?>,
    <?php
    }
    ?>
    &nbsp <?=$row['town']?>,&nbsp <?=$row['county']?>,&nbsp <?=$row['post code']?></div>
 <div class='box'><strong> Telephone: </strong><?=$row['tel']?><strong> Mobile: </strong><?=$row['mob']?></div><div class='iconbox'>
                                                        <a href='
    <?=$row['tel']?>'><img src='img/icons/phone.png' class='hvr-push'></a>
                                                        <a href='
    <?=$row['mob']?>'><img src='img/icons/mobile.png' class='hvr-push'></a>
                                                        <a href='mailto:"
    <?=$row['email']?>'><img src='img/icons/email.png' class='hvr-push'></a>
                                                        <a href='"
    <?=$row['web_url']?>'><img src='img/icons/web.png' class='hvr-push'></a>
                                                    </div>
                                                <div class='buttonwrap'><div class='buttonbox'><p>View Profile</p></div></div>          
                                            </div> 
                                            <div class='rightbox'>
                                            <div class='service-pic'>
                                                    <img src='img/image1.png'>
                                                </div>
                                                <div class='mapbox'>
                                                    <?=$row['map_url']?>
                                                </div>
                                           </div>

您可以使用Mysql，请在此处查看：http://php.net/manual/es/book.mysqli.php最后一个提示："不要在echo中输入HTML"