$stmt = $pdo->prepare('SELECT * FROM users WHERE username = :username'); $stmt->bindParam(':username', $username); $stmt->execute();
$stmt = $pdo->prepare('UPDATE users SET password = :password WHERE id = :id'); $stmt->bindParam(':password', $newPassword); $stmt->bindParam(':id', $userId); $stmt->execute();In this example, a prepared statement is created to update the "password" column of a user in the "users" table where the "id" column matches a specified value. The value of `$newPassword` is bound to the `:password` parameter and `$userId` is bound to the `:id` parameter using the `bindParam` function. Finally, the statement is executed using the `execute` method. Package Library: PDO (PHP Data Objects)