PHP echo-ing a block of HTML but receiving unexpected result

Question

   <div class="content">
        <h1>User Information</h1>
        <p>hi</p>

        <?php
            session_start();
            require_once 'dbconnect.php';
            $query = $DBcon->query("SELECT username, email, password, admin FROM tbl_users ");
            while($row=$query->fetch_array()){
                echo'
                    <div id="box">
                        <div class="box-top">$row['username']</div>
                        <div class="box-panel">
                            <p>$row['email']</p>
                            <p>$row['password']</p>
                            <p>$row['admin']</p>
                        </div>
                    </div>
                ';
            }
        ?>
    </div>

This is my code to echo a block of html.

What i am doing is that i am trying to connect this php to mysql database and print out the record in appropriate place. The dbconnect.php is for database connection which has been checked to be working fine.

I am getting this in my localhost website (I dismissed all css style and other appearance setting here).

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

User Information

hi

query("SELECT username, email, password, admin FROM tbl_users "); while($row=$query->fetch_array()){ echo <<< EOT $row['username'] $row['email']

$row['password']

$row['admin']

EOT; } ?>

Try this way you have issue with quotes. Replace my echo code to yours - echo " <div id='box'> <div class='box-top'>$row['username']</div> <div class='box-panel'> <p>$row['email']</p> <p>$row['password']</p> <p>$row['admin']</p> </div> </div> "; — Manthan Dave
– Manthan Dave, Commented Nov 23, 2016 at 11:08

Antony Thompson · Accepted Answer · 2016-11-23 11:10:39Z

1

You can't echo like that. Try this:

<?php
while($row=$query->fetch_array()){
    ?>
    <div id="box">
        <div class="box-top"><?php echo $row['username']; ?></div>
        <div class="box-panel">
            <p><?php echo $row['email']; ?></p>
            <p><?php echo $row['password']; ?></p>
            <p><?php echo $row['admin']; ?></p>
        </div>
    </div>
    <?php 
}

edited Nov 23, 2016 at 11:10

answered Nov 23, 2016 at 11:09

Antony Thompson

1,6481 gold badge13 silver badges22 bronze badges

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

2 Comments

TszKin Anthony Over a year ago

I thought I can echo a block of html like that way. Thanks a lot

Antony Thompson Over a year ago

Koen's answer would work too, just a matter of preference.

Koen Hollander · Accepted Answer · 2016-11-23 11:10:20Z

0

You don't use the quotes right.

Try the following:

<div class="content">
        <h1>User Information</h1>
        <p>hi</p>

        <?php
            session_start();
            require_once 'dbconnect.php';
            $query = $DBcon->query("SELECT username, email, password, admin FROM tbl_users");
            while($row=$query->fetch_array()){
                echo"
                    <div id='box'>
                        <div class='box-top'>".$row['username']."</div>
                        <div class='box-panel'>
                            <p>".$row['email']."</p>
                            <p>".$row['password']."</p>
                            <p>".$row['admin']."</p>
                        </div>
                    </div>
                ";
            }
        ?>
    </div>

answered Nov 23, 2016 at 11:10

Koen Hollander

1,7116 gold badges28 silver badges42 bronze badges

1 Comment

Koen Hollander Over a year ago

What did you get?

Blinkydamo · Accepted Answer · 2016-11-23 11:10:21Z

0

while( $row=$query->fetch_array() ) { ?>
<div id="box">
  <div class="box-top"><?php echo $row['username']; ?></div>
  <div class="box-panel">
    <p><?php echo $row['email']; ?></p>
    <p><?php echo $row['password']; ?></p>
    <p><?php echo $row['admin']; ?></p>
  </div>
</div>
<?php } ?>

Try this, it is a little cleaner and doesn't have issues with the quotes.

answered Nov 23, 2016 at 11:10

Blinkydamo

1,5649 silver badges22 bronze badges

Comments

Stuart · Accepted Answer · 2016-11-23 11:19:46Z

0

You need to use double quoted strings if PHP variables are to be interpolated.

answered Nov 23, 2016 at 11:19

Stuart

6,7692 gold badges29 silver badges42 bronze badges

Collectives™ on Stack Overflow

PHP echo-ing a block of HTML but receiving unexpected result

4 Answers 4

2 Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related