<?php // Replace with your database credentials $servername = "your_servername"; $username = "your_username"; $password = "your_password"; $dbname = "your_database"; // Create connection using MySQLi $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } // Delete record if delete button is clicked if (isset($_GET['delete_id'])) { $delete_id = $_GET['delete_id']; $sql_delete = "DELETE FROM users WHERE id = $delete_id"; if ($conn->query($sql_delete) === TRUE) { // Deleted successfully, you can redirect or show a message header("Location: your_page.php"); // Redirect to your page exit(); } else { echo "Error deleting record: " . $conn->error; } } // SQL query to select data from the users table $sql = "SELECT id, username, email, age FROM users"; $result = $conn->query($sql); ?> <!DOCTYPE html> <html> <head> <title>User Data Table</title> <style> /* Your CSS styles for the table */ </style> </head> <body> <h2>User Data Table</h2> <table> <thead> <tr> <th>ID</th> <th>Username</th> <th>Email</th> <th>Age</th> <th>Edit</th> <th>Delete</th> </tr> </thead> <tbody> <?php if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { echo "<tr>"; echo "<td>" . $row["id"] . "</td>"; echo "<td>" . $row["username"] . "</td>"; echo "<td>" . $row["email"] . "</td>"; echo "<td>" . $row["age"] . "</td>"; echo "<td><a href='edit.php?id=" . $row["id"] . "'>Edit</a></td>"; // Link to edit.php with ID echo "<td><a href='?delete_id=" . $row["id"] . "' onclick='return confirm(\"Are you sure?\")'>Delete</a></td>"; // Delete link with confirmation echo "</tr>"; } } else { echo "<tr><td colspan='6'>No data found</td></tr>"; } ?> </tbody> </table> </body> </html> <?php // Close connection $conn->close(); ?>