$sql_update = 'UPDATE accounts SET data = ?, encrypted = 1 WHERE account_id = ?'; $qry_update = $dbh->prepare($sql_update); $qry_update->execute($data, $account_id);