How to display PHP variables in a proper HTML table

Question

Hey guys its my first question here I think.

So I'm using MyBB Forum software.

I have a PHP code that fetches some data from a database no issues in there its working properly.

$query = $db->query("SELECT * FROM housing");
while($result = $db->fetch_array($query))
{    
    $housingvar .= "<td>". $result['username']. "</td>";
    $price .= "<td>". $result['Price']. "</td>";
    $city .= "<td>". $result['City']. "</td>";
    $tax .= "<td>". $result['Tax']. "</td>"; 
    $adrz .= "<td>". $result['Adress']. "</td>";
}

This is the code. I'm using. These variables are then plugged in an HTML table on the forum but everything is in the same column and I dont know how to make a new row for every data. I'm sure this is possible but dont know how.

I cant use echo in my PHP code either. Since I'm using these variables in a pure HTML template.

<tr>
    {$housingvar}
         {$price} 
          {$city}
            {$adrz}
            {$tax}
    </tr>

Does your templating software provide its own looping mechanism? You can't collect each row's value into a single variable, because they have to be split onto different rows of the table. — Barmar
– Barmar, Commented May 1, 2017 at 21:36
If it doesn't, then there doesn't seem to be a way to do what you want. If the variables all have to be between a single <tr> and </tr>, there's no way to get multiple rows. Surely the designers of your template provided a way to generate tables of data from PHP arrays. — Barmar
– Barmar, Commented May 1, 2017 at 21:40
@Barmar How would you normally loop in PHP. Can you give me a small example if you don't mind? — Freakz0r
– Freakz0r, Commented May 1, 2017 at 22:12
The answers show the normal way to loop over the results of a query. But they won't work for the way you're templating this. — Barmar
– Barmar, Commented May 1, 2017 at 22:15

Abdulrahman Hashem · Accepted Answer · 2017-05-01 21:55:48Z

1

<tr> for table row and <td> for table data.
However you have to wrap your while statement with table tag:

$output = "";
$output .= "<table>";
while ($result = $db->fetch_array($query)) {
     // Starting a new table row
     $output .= "<tr>";
        $output .= "<td>".htmlentities($result['username']). "</td>";
        /* Append the rest of the fields */
     // End of row
     $output .= "</tr>";
}
$output .= "</table>";
{ $output }

edited May 1, 2017 at 21:55

answered May 1, 2017 at 21:42

Abdulrahman Hashem

1,9891 gold badge19 silver badges22 bronze badges

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

3 Comments

Brad Over a year ago

This answer doesn't escape any of the data being output, and can lead to invalid HTML and security issues. Use htmlspecialchars() or similar.

Freakz0r Over a year ago

Hey so the thing is I cant use PHP on my HTML file. So I did this but what variable would I call from my HTML file exactly? @AbdAlrahmanHashem

Abdulrahman Hashem Over a year ago

@Brad The concern was not about escaping, but I just edited it thanks.

Frosty619 · Accepted Answer · 2017-05-01 21:31:35Z

0

To create a new row in an HTML table, you use the <tr> tag. I would try the following:

echo "<tr>";
   $price = $result['Price'];
   echo "<td> $price </td>";
    //other code here
echo "</tr>";

answered May 1, 2017 at 21:31

Frosty619

1,5194 gold badges24 silver badges37 bronze badges

1 Comment

Freakz0r Over a year ago

I cant use echo. I'm using these variables directly on my templates which has a pure HTML structure. <tr> {$housingvar} {$price} {$city} {$adrz} {$tax} </tr>

Collectives™ on Stack Overflow

How to display PHP variables in a proper HTML table

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related