Cart
Log out
connect_error) { die("Connection failed: " . $mysqli->connect_error); } $query = "SELECT * FROM receipt"; $result = $mysqli->query($query); // Process query result, for example, output data if ($result->num_rows > 0) { echo '
'; echo '
'; // Center the table echo '
'; // Reduced height echo '
Date
'; echo '
Total Price
'; echo '
'; while ($row = $result->fetch_assoc()) { echo '
'; // Reduced height echo '
' . $row['book_date'] . '
'; echo '
' . $row['total_price'] . '
'; echo '
'; } echo '
'; echo '
'; } else { echo 'No records found'; } // Close database connection $mysqli->close(); ?>