1#@!#!123s

: / home / schoolcampuserp / erp.nationalacademykotwa.com / api / app_api1 /
Filename : update_username_pass.php
back
<?php
include 'connection.php';

if ($_SERVER["REQUEST_METHOD"] === "POST") {
    $userId = $_POST["user_id"];
    $newUsername = $_POST["username"];
    $newPassword = $_POST["password"];

    // Check if the user with the provided user_id exists
    $checkUserQuery = "SELECT * FROM users WHERE user_id = $userId";
    $checkUserResult = $con->query($checkUserQuery);

    if ($checkUserResult->num_rows > 0) {
        // User with the provided user_id exists, update the username and password
        $updateQuery = "UPDATE users SET username = '$newUsername', password = '$newPassword' WHERE user_id = $userId LIMIT 1";

        $updateResult = $con->query($updateQuery);

        if ($updateResult) {
            $response = array("status" => "1", "message" => "Username and password updated successfully");
        } else {
            $response = array("status" => "0", "message" => "Failed to update username and password");
        }
    } else {
        $response = array("status" => "0", "message" => "User with user_id $userId does not exist");
    }
} else {
    $response = array("status" => "0", "message" => "Invalid request method. Please use POST.");
}

echo json_encode($response);
?>