prepare("SELECT * FROM Debtors WHERE debtor_name = :debtorName"); $stmt->execute(['debtorName' => $debtorName]); $debtor = $stmt->fetch(PDO::FETCH_ASSOC); if ($debtor) { // 获取还款记录 $repaymentStmt = $pdo->prepare("SELECT * FROM Repayments WHERE debtor_name = :debtorName ORDER BY repayment_date DESC"); $repaymentStmt->execute(['debtorName' => $debtorName]); $repayments = $repaymentStmt->fetchAll(PDO::FETCH_ASSOC); // 获取视图中的欠款信息 $viewStmt = $pdo->prepare("SELECT * FROM DebtStatus WHERE 姓名 = :debtorName"); $viewStmt->execute(['debtorName' => $debtorName]); $viewData = $viewStmt->fetch(PDO::FETCH_ASSOC); // 更新后的输出格式 echo "

"; echo "

{$debtor['debtor_name']}

"; echo "

当前欠款余额: ¥{$viewData['剩余欠款金额']}

"; echo "

还款记录

"; if ($repayments) { echo "

"; foreach ($repayments as $repayment) { echo "

"; echo "

{$repayment['repayment_date']}

"; echo "

¥{$repayment['repayment_amount']}

"; echo "

{$repayment['repayment_method']}

"; if (!empty($repayment['comments'])) { echo "

{$repayment['comments']}

"; } echo "

"; echo "

"; } echo "

"; } else { echo "

暂无还款记录

"; } echo "

"; } else { echo "

未找到相关记录

"; } } else { echo "

请输入姓名进行查询

"; } ?>