Displaying and hiding field data

Riceman

Aloha,

I am pretty new to php, and have some code that is working, but I want to only echo a field if there is data present in the MySQL field.

The database connection is set, and I am connecting to a particular row in a that a table. A number of fields (from that row) are echo'ed throughout the page...with this item "$youtube_url" I want to display the code below, if there is data in the database field....but if there is no data in the field i want none of the code to be displayed, including the html. I am pretty sure this will involve an "if-else" statement...right?

What I have:

<div class="module">
<h3>Video</h3>
<div>
<p><b>Watch the <a href="<?php echo $youtube_url; ?>">Video Tour</a></p>
</div>
</div>

laserlight

Riceman wrote:
I am pretty sure this will involve an "if-else" statement...right?

Yes. In this case, you would be using PHP as a template language.

Riceman

Right, the page is php, with html5 code for layout. But all DB functionality is through a php/mysql query. As i said I have the page working, and it is pulling about 15 different fields from a particular row in an table in the DB. I was assuming I can wrap this section of html in php to give it the functionality i want. As the code I attached is now, it echo's the "$youtube_url". My problem is it is just blank if there is no information in the field. I want the whole "div" to not be there too.

laserlight

Riceman wrote:
I was assuming I can wrap this section of html in php to give it the functionality i want. As the code I attached is now, it echo's the "$youtube_url". My problem is it is just blank if there is no information in the field. I want the whole "div" to not be there too.

That is what I mean by using PHP as a template language, e.g.,

<?php if (strlen($youtube_url) > 0): ?>
<div class="module">
<h3>Video</h3>
<div>
<p><b>Watch the <a href="<?php echo $youtube_url; ?>">Video Tour</a></p>
</div>
</div>
<?php endif; ?>

(I've chosen to use the alternative syntax for control structures as the matching of if with endif, etc, can help readability when using PHP as a template language, but the alternative syntax is not required.)

Riceman

Thanks....that is great! Works just like I wanted.