Emiel_DK
/
Database


			
				
					
						
						
							1234567891011121314151617181920212223242526272829303132333435
							<html>
<head>
</head>
<body>

<?php
$dataBase = new SQLite3("Northwind_large.sqlite");
$result = $dataBase->query('SELECT * FROM Category');

$numColumns = $result->numColumns();
?>

<table>
<tr>

<?php
for($y =0; $y < $numColumns; ++$y)
{
    echo "<th>" . $result->ColumnName($y) . "</th>"; 
}
?>

</tr>
<?php
while($row = $result->fetchArray()){
    echo "<tr>";
    for($i = 0; $i < sizeof($row); $i++)
    {
        echo "<td>" . $row[$i] . "</td>";
    }
    echo "</tr>";
}
?>
</body>
</html>