connect_error) { die("Connection failed: " . $conn->connect_error); } // SQL query to fetch data from your table $sql = "SELECT id, dist_id, district, mandal_id, mandal, school_id, school_name, grants_project, grant_name, scheme_component, amount FROM school_grants"; $result = $conn->query($sql); ?> School Grants Data
Records - of
reset
num_rows > 0) { // Loop through each row of data while($row = $result->fetch_assoc()) { // Output a table row with data from the database echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // Assuming amount is a number echo ""; } } else { echo ""; } // Close the database connection $conn->close(); ?>

ID

District

Mandal

School Name

Grant Name

Project

Amount
" . htmlspecialchars($row["id"]) . "" . htmlspecialchars($row["district"]) . "" . htmlspecialchars($row["mandal"]) . "" . htmlspecialchars($row["school_name"]) . "" . htmlspecialchars($row["grant_name"]) . "" . htmlspecialchars($row["grants_project"]) . "$" . number_format($row["amount"], 2) . "
No results found
Entries Per Page
Page of