使用foreach循环PHP在表中打印值

Question

Hi i want to print out the values of $row in a table, i already have something but the output is not great. This is the code i have so far:

<?php
$sql = 'SELECT Titel FROM Algemeen ORDER BY Titel';
    foreach ($pdo->query($sql) as $row) {
        echo "
        <table border='1'>
           <tr>
              <td>".$row['Titel']. "</td>"

         "</tr>
        </table>";
    }
?>

So the table needs to be like this with a border

• Value 1
• Value 2
• Value 3

Answer 1

You should use it like below

<?php
$sql = 'SELECT Titel FROM Algemeen ORDER BY Titel';
echo "<table border='1'>";
foreach ($pdo->query($sql) as $row){
    echo "<tr><td>".$row['Titel']. "</td></tr>";    
}
echo "</table>";