如何在PDO中使用绑定参数进行模糊搜索？

<?php
// 连接数据库
$dsn = 'mysql:host=localhost;dbname=test';
$username = 'username';
$password = 'password';
$pdo = new PDO($dsn, $username, $password);

// 准备SQL查询语句
$query = "SELECT * FROM users WHERE name LIKE :searchTerm";

// 准备预处理语句
$stmt = $pdo->prepare($query);

// 绑定参数
$searchTerm = '%' . $_POST['searchTerm'] . '%';
$stmt->bindParam(':searchTerm', $searchTerm, PDO::PARAM_STR);

// 执行查询
$stmt->execute();

// 获取查询结果
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);

// 输出查询结果
foreach ($results as $row) {
    echo $row['name'] . '<br>';
}
?>