PHP code inside of an echo statement

Question

I have a page where the logged in user can see a list of different links, but only if the links match an entry in a MySQL database, something like this:

<li>
                <?php
                        require ("scripts/connect.php");
                        $query = mysql_query("SELECT * FROM files WHERE subject='consulting' AND active='1'");
                        $numrows = mysql_num_rows($query);
                        if ($numrows > 0) 
                            echo "      
                            <a class='atags' href=\"javascript:showonlyone('consulting', this)\">Consulting</a>";
                        if ($numrows == 0)
                            echo "";
                ?>
                </li>
                <li>
                <?php
                        require ("scripts/connect.php");
                        $query = mysql_query("SELECT * FROM files WHERE subject='Projects' AND active='1'");
                        $numrows = mysql_num_rows($query);
                        if ($numrows > 0) 
                            echo "<li><a class='atags' href=\"javascript:showonlyone('projects', this)\">Projects</a></li>";
                        if ($numrows == 0)
                            echo "";
                ?>
                </li>

ETC...

However, I just realized that if the $username in my session_start(); has 1 in the moderator field I want to show something different. How can I do this? Theoretically what I am looking for is something like this:

if ($username && $moderator == 1) {
   echo "You can edit this.";
}
else
    echo "<li>
                <?php
                        require ("scripts/connect.php");
                        $query = mysql_query("SELECT * FROM files WHERE subject='art' AND active='1'");
                        $numrows = mysql_num_rows($query);
                        if ($numrows > 0) 
                            echo "      
                            <a class='atags' href=\"javascript:showonlyone('art', this)\">Art</a>";
                        if ($numrows == 0)
                            echo "";
                ?>
                </li>
                <li>
                <?php
                        require ("scripts/connect.php");
                        $query = mysql_query("SELECT * FROM files WHERE subject='computer' AND active='1'");
                        $numrows = mysql_num_rows($query);
                        if ($numrows > 0) 
                            echo "<li><a class='atags' href=\"javascript:showonlyone('computer', this)\">Computer</a></li>";
                        if ($numrows == 0)
                            echo "";
                ?>
                </li>
                <li>
                <?php
                        require ("scripts/connect.php");
                        $query = mysql_query("SELECT * FROM files WHERE subject='critical reading' AND active='1'");
                        $numrows = mysql_num_rows($query);
                        if ($numrows > 0) 
                            echo "<li><a class='atags' href=\"javascript:showonlyone('criticalreading', this)\">Critical Reading</a></li>";
                        if ($numrows == 0)
                            echo "";
                ?>
                </li>
                <li>
                <?php
                        require ("scripts/connect.php");
                        $query = mysql_query("SELECT * FROM files WHERE subject='french' AND active='1'");
                        $numrows = mysql_num_rows($query);
                        if ($numrows > 0) 
                            echo "<li><a class='atags' href=\"javascript:showonlyone('french', this)\">French</a></li>";
                        if ($numrows == 0)
                            echo "";
                ?>
                </li>";

Is this possible? Thanks.

why do you have so many 'require' statements? You only need them once for 'scripts/connect.php' — Jakub
– Jakub, Commented Jul 6, 2012 at 5:01

David Harkness · Accepted Answer · 2012-07-06 05:02:35Z

3

You can freely switch back and forth between PHP and HTML code. Sometimes it helps to use the alternate colon-and-end syntax for control-flow statements rather than braces.

<?php if ($username && $moderator == 1): ?>
    You can edit this.
<?php else: ?>
    <li>
        ...
        <?php
            ...
            if ($numrows > 0):
        ?>
        <a class='atags' href="javascript:showonlyone('art', this)">Art</a>
        <?php
            endif;
        ?>
<?php endif ?>

This is a lot easier than using echo because you don't have to escape quotes and HTML reads more naturally.

answered Jul 6, 2012 at 5:02

David Harkness

36.6k11 gold badges119 silver badges136 bronze badges

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

1 Comment

mais-oui Over a year ago

Would up vote if I had enough rep. Perfect! EXACTLY what I was looking for! THANKS! Sorry, I have to wait 2 minutes to accept...

Daniel Li · Accepted Answer · 2012-07-06 05:01:48Z

1

Rather than including a php tag within the echo statement, handle the database work before the actual print (set up all the variables you are about to output).

This way, you can include any information you need by following this pattern:

// database stuff here

echo '...'

if ($moderator == 1) echo '...'

echo '...'

An even better option is to handle all of this within the MVC pattern. You may find more information here: http://en.wikipedia.org/wiki/Model%E2%80%93view%E2%80%93controller

answered Jul 6, 2012 at 5:01

Daniel Li

15.6k6 gold badges45 silver badges60 bronze badges

Collectives™ on Stack Overflow

PHP code inside of an echo statement

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related