PHP Decode

?><?php
session_start();

// Check if user is logged in
if (!isset($_SESSION['user_id'])) {
    header("Location: ../login.php"); // Redirect to login page if not logged in
    exit();
}

require_once "config.php"; // Include your database connection file

$newUsername = $_POST['newUsername'];
$userId = $_SESSION['user_id'];

// Update the username in the database
$sql = "UPDATE users SET username = ? WHERE id = ?";
$stmt = $conn->prepare($sql);
if ($stmt) {
    $stmt->bind_param("si", $newUsername, $userId);
    if ($stmt->execute()) {
        $successMessage = "Username updated successfully.";
    } else {
        $errorMessage = "Failed to update username. Error: " . $stmt->error;
    }
    $stmt->close();
} else {
    $errorMessage = "Database error. Please try again later.";
}

// Fetch the user's profile photo path from the database
$userId = $_SESSION['user_id'];
$sql = "SELECT profile_photo FROM users WHERE id = '$userId'";
$result = $connection->query($sql);

if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    $_SESSION['profile_photo'] = $row['profile_photo']; // Update the session variable
}

$conn->close();
?><?