PDO查询不起作用

Question

I've tested it, the SESSION ID is giving out a valid id, and so is all the other parameters. Help me.

$sql = 'UPDATE users SET firstname = :firstname, lastname = :lastname WHERE id = :id'; 
$records->bindParam(':id',$_SESSION['user_id']);

        $stmt = $conn->prepare($sql);
        list($firstname, $lastname) = explode(' ', $nn);

        $stmt->bindParam(':firstname', $firstname);
        $stmt->bindParam(':lastname', $lastname);

        if($stmt->execute()) {



        } else {

            die("An error adapted during changes.");

        }

Answer 1

I thought your query should be like this.

$sql = 'UPDATE users SET firstname = :firstname,      lastname = :lastname WHERE id = :id' ;
$stmt = $conn->prepare($sql);
list($firstname, $lastname) = explode(' ', $nn);
$stmt->bindParam(':id',$_SESSION['user_id']); 
$stmt->bindParam(':firstname', $firstname);
$stmt->bindParam(':lastname', $lastname); 
if($stmt->execute()) {



    } else {

        die("An error adapted during changes.");

    }