php echo database row results into a card

Question

I am trying to echo my database results into a bootstrap 4 card, each row result will be in its own bootstrap card.

I have been able to show the results in a table

Echo to table - THIS WORKS

<table class="table table-striped">

  <?php echo "<table class='table table-striped mb-none'>";

// table header
echo "<tr><th>Company Name</th><th>Date Requested</th><th>Request By</th><th>Graphic Type</th><th>Double Sided</th><th>Design Info</th><th>Purpose</th><th>Approved</th><th>Approval Date</th></tr>";

// output data of each row
while($row=mysqli_fetch_assoc($designresult)) {

    echo "<tr><td>".$row["companyName"]."</td><td>".$row["dateReq"]."</td><td>".$row["yourName"]."</td><td>".$row["graphicType"]."</td><td>".$row["doubleS"]."</td><td>".$row["info"]."</td><td>".$row["purpose"]."</td><td>".$row["approved"]."</td><td>".$row["appDate"]."</td></tr>";
}

// table footer

echo "</table>";

?>

My attempt at echoing into cards

<?php 
// output data of each row
while($row=mysqli_fetch_assoc($designresult)) {

echo "
<div class="card mb-4 box-shadow"> div class="card-header">
            <h4 class="my-0 font-weight-normal">Track Design</h4>
          </div>
          <div class="card-body">
            <p> Company Name ".$row["companyName"]."; </p>
          </div>
        </div>";

}
?>

Yeah, the php script just loads error, when I add the card php attempt, meaning there is a code error to start with in the card echo — fantasiaa123, Mar 21 '20 at 21:23

davidev · Answer 1 · 2020-03-21T21:26:58.553

0

In the first solution you are escaping " in using ' quotes.

In the second one, you are using " in your HTML code. As you echo that and your echo starts with " aswell, you are ending the echo.

echo "<div class=" <-- Ending the echo, not starting the class name

You have to change it to this:

echo "<div class='card mb-4 box-shadow'>"

You can also close the PHP tag:

<?php 
// output data of each row
while($row=mysqli_fetch_assoc($designresult)) {

?>

<div class="card mb-4 box-shadow"> 
    <div class="card-header">
        <h4 class="my-0 font-weight-normal">Track Design</h4>
    </div>
    <div class="card-body">
        <p> Company Name <?php echo $row["companyName"]; ?> </p>
    </div>
</div>

<?php

}
?>

edited Mar 21 '20 at 21:26

answered Mar 21 '20 at 21:23

davidev

7,694
5
21
56

1

Maybe just closing php tag `?>` is __simpler__? – u_mulder Mar 21 '20 at 21:24
@u_mulder Yeah, another good solution. Let me add this .. – davidev Mar 21 '20 at 21:25
I have fixed the error above, however the page is 500 error, meaning their is a error in the code – fantasiaa123 Mar 21 '20 at 21:26
@fantasiaa123 Which error do you get? – davidev Mar 21 '20 at 21:27
fixed and thanks both, your guidance has worked – fantasiaa123 Mar 21 '20 at 21:30

php echo database row results into a card

1 Answers1