Notes

<?php
// Database connection parameters
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "productform";

// Create a connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check the connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

// Prepare the SQL query to fetch data
$sql = "SELECT * FROM productinfo";
$result = $conn->query($sql);

// Start output buffering
ob_start();

// Check if any results are returned
if ($result->num_rows > 0) {
echo "<table id='productTable' style='width: 100%; border-collapse: collapse; margin-top: 20px;'>";
echo "<thead>
<tr>
<th>ID</th>
<th>Name</th>
<th>Price</th>
<th>Description</th>
<th>Available</th>
<th>Category</th>
<th>Date Purchased</th>
</tr>
</thead>";
echo "<tbody>";

// Output data for each row
while ($row = $result->fetch_assoc()) {
echo "<tr>
<td>" . htmlspecialchars($row['ID']) . "</td>
<td>" . htmlspecialchars($row['Name']) . "</td>
<td>" . htmlspecialchars($row['Price']) . "</td>
<td>" . htmlspecialchars($row['Description']) . "</td>
<td>" . htmlspecialchars($row['Available']) . "</td>
<td>" . htmlspecialchars($row['Category']) . "</td>
<td>" . htmlspecialchars($row['DatePurchased']) . "</td>
</tr>";
}

echo "</tbody>";
echo "</table>";
} else {
echo "<p>No records found.</p>";
}

// End output buffering and get the contents
$table_html = ob_get_clean();

// Close the connection
$conn->close();

// Output the table HTML
echo $table_html;
?>