prepare('SELECT subscription_plan, subscription_expires_at FROM users WHERE id = ?'); $stmt->execute([$user_id]); $user = $stmt->fetch(PDO::FETCH_ASSOC); } catch (PDOException $e) { $error = "Database error: " . $e->getMessage(); $user = ['subscription_plan' => null, 'subscription_expires_at' => null]; } if ($_SERVER['REQUEST_METHOD'] === 'POST') { $password = $_POST['password'] ?? ''; $password_confirm = $_POST['password_confirm'] ?? ''; if (!empty($password) && $password === $password_confirm) { try { $hashed_password = password_hash($password, PASSWORD_DEFAULT); $stmt = $pdo->prepare('UPDATE users SET password = ? WHERE id = ?'); $stmt->execute([$hashed_password, $user_id]); $success = t('profile_updated_successfully'); } catch (PDOException $e) { $error = "Database error: " . $e->getMessage(); } } elseif (!empty($password)) { $error = t('passwords_do_not_match'); } } ?>