<?php // Database credentials $servername = "localhost"; $username = "FIKHRI"; $password = "abc123"; $dbname = "Test"; // Create a connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } // Get the user ID from the URL if (isset($_GET['id'])) { $user_id = $_GET['id']; // Fetch the user details for editing $stmt = $conn->prepare("SELECT id, name FROM users WHERE id = ?"); $stmt->bind_param("i", $user_id); $stmt->execute(); $result = $stmt->get_result(); $user = $result->fetch_assoc(); if (!$user) { echo "User not found."; exit(); } $stmt->close(); } // Handle the form submission to update the user's name if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['update_name'])) { $new_name = $_POST['name']; // Update the user name in the database $stmt = $conn->prepare("UPDATE users SET name = ? WHERE id = ?"); $stmt->bind_param("si", $new_name, $user_id); if ($stmt->execute()) { echo "Name successfully updated!"; header("Location: index.php"); // Redirect back to the main page exit(); } else { echo "Error: " . $stmt->error; } $stmt->close(); } $conn->close(); ?> <!DOCTYPE html> <html> <head> <title>Edit Name</title> </head> <body> <h1>Edit Name</h1> <form method="post" action=""> <label for="name">Name:</label> <input type="text" id="name" name="name" value="<?php echo htmlspecialchars($user['name']); ?>" required> <button type="submit" name="update_name">Update</button> </form> <a href="index.php"> <button>Back to List</button> </a> </body> </html>