To add and delete users from your database, you can modify the code I provided earlier as follows:
Code:
<?php
$conn = mysqli_connect('localhost', 'root', '', 'user_login');
// Add a new user to the database
if (isset($_POST['add_user'])) {
$username = $_POST['username'];
$email = $_POST['email'];
$password = $_POST['password'];
$query = "INSERT INTO users (username, email, password) VALUES ('$username', '$email', '$password')";
mysqli_query($conn, $query);
}
// Delete a user from the database
if (isset($_GET['delete_user'])) {
$id = $_GET['delete_user'];
$query = "DELETE FROM users WHERE id=$id";
mysqli_query($conn, $query);
}
// Retrieve all users from the database
$query = "SELECT * FROM users";
$result = mysqli_query($conn, $query);
// Display the users in a table
echo "<table>";
echo "<tr><th>ID</th><th>Username</th><th>Email</th><th></th></tr>";
while ($row = mysqli_fetch_array($result)) {
echo "<tr>";
echo "<td>" . $row['id'] . "</td>";
echo "<td>" . $row['username'] . "</td>";
echo "<td>" . $row['email'] . "</td>";
echo "<td><a href='?delete_user=" . $row['id'] . "'>Delete</a></td>";
echo "</tr>";
}
echo "</table>";
// Add a form to add a new user
echo "<h2>Add User</h2>";
echo "<form method='POST' action=''>";
echo "<label>Username: </label><input type='text' name='username' required><br>";
echo "<label>Email: </label><input type='email' name='email' required><br>";
echo "<label>Password: </label><input type='password' name='password' required><br>";
echo "<input type='submit' name='add_user' value='Add User'>";
echo "</form>";
// Close the database connection
mysqli_close($conn);
?>
This code adds functionality to add and delete users from the "users" table.
When the "Add User" form is submitted, the code retrieves the values from the form, constructs an INSERT statement, and executes it using mysqli_query.
When the "Delete" link is clicked, the code retrieves the ID of the user to be deleted from the URL, constructs a DELETE statement, and executes it using mysqli_query.
The rest of the code is the same as before, retrieving and displaying all users from the "users" table in an HTML table.
Note that this code only provides basic functionality and may not be suitable for production environments. You should consider adding additional security measures, such as input validation and authentication, to your code before deploying it to a production environment.
