php+mysql實現微信公眾號回覆關鍵詞新聞列表

<?php
// 連線資料庫
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

try {
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
die("Connection failed: " . $e->getMessage());
}

// 獲取微信公眾平臺傳遞的引數
$keyword = $_GET['keyword'];

// 查詢資料庫，獲取相關新聞
$stmt = $conn->prepare("SELECT * FROM news WHERE title LIKE :keyword");
$stmt->bindParam(':keyword', $keyword);
$stmt->execute();

// 解析查詢結果，構造回覆訊息
$xml = '<xml>';
if ($stmt->rowCount() > 0) {
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$title = $row["title"];
$link = $row["link"];
$content = $row["content"];
$xml .= '<item>';
$xml .= '<Title><![CDATA[' . $title . ']]></Title>';
$xml .= '<Description><![CDATA[' . $content . ']]></Description>';
$xml .= '<PicUrl><![CDATA[]]></PicUrl>';
$xml .= '<Url><![CDATA[' . $link . ']]></Url>';
$xml .= '</item>';
}
} else {
$xml .= '<item>';
$xml .= '<Title><![CDATA[沒有找到相關新聞]]></Title>';
$xml .= '<Description><![CDATA[]]></Description>';
$xml .= '<PicUrl><![CDATA[]]></PicUrl>';
$xml .= '<Url><![CDATA[]]></Url>';
$xml .= '</item>';
}
$xml .= '</xml>';

// 輸出回覆訊息
echo $xml;

// 關閉資料庫連線
$conn = null;
?>
```